커뮤니티 게시판 Lv.1 - 데이터모델링

CREATE TABLE "users" ( "no" NUMBER NOT NULL, "username" VARCHAR2(100) NOT NULL, "password" VARCHAR2(100) NOT NULL, "name" VARCHAR2(50) NOT NULL, "email" VARCHAR2(200) NOT NULL, "reg_date" DATE DEFAULT sysdate NOT NULL, "upd_date" DATE DEFAULT sysdate NOT NULL ); CREATE TABLE "posts" ( "no" NUMBER NOT NULL, "user_no" NUMBER NOT NULL, "title" VARCHAR2(200) NOT NULL, "content" CLOB NULL, "reg_date" DATE DEFAULT sysdate NOT NULL, "upd_date" DATE DEFAULT sysdate NOT NULL ); CREATE TABLE "files" ( "no" NUMBER NOT NULL, "post_no" NUMBER NOT NULL, "file_name" VARCHAR2(100) NOT NULL, "file_path" VARCHAR2(2000) NOT NULL, "reg_date" DATE DEFAULT sysdate NOT NULL, "upd_date" DATE DEFAULT sysdate NOT NULL ); CREATE TABLE "comments" ( "no" NUMBER NOT NULL, "post_no" VARCHAR2(255) NOT NULL, "user_no" NUMBER NOT NULL, "content" CLOB NOT NULL, "reg_date" DATE DEFAULT sysdate NOT NULL, "upd_date" DATE DEFAULT sysdate NOT NULL ); ALTER TABLE "users" ADD CONSTRAINT "PK_USERS" PRIMARY KEY ( "no" ); ALTER TABLE "posts" ADD CONSTRAINT "PK_POSTS" PRIMARY KEY ( "no" ); ALTER TABLE "files" ADD CONSTRAINT "PK_FILES" PRIMARY KEY ( "no" ); ALTER TABLE "comments" ADD CONSTRAINT "PK_COMMENTS" PRIMARY KEY ( "no" );