PK
-
DB Study2 - AriticleDB 2018. 8. 10. 16:12
Board ERD Table 설계 CREATE TABLE ARTICLE( ARTICLE_ID INTEGER NOT NULL , SUBJECT VARCHAR2(2000 CHAR) NOT NULL , CONTENT VARCHAR2(4000 CHAR) NOT NULL , VIEW_COUNT INTEGER NOT NULL , WRITE_DATE TIMESTAMP NOT NULL , MEMBER_ID VARCHAR2(100 CHAR) NOT NULL ); CREATE UNIQUE INDEX XPK게시글 ON ARTICLE(ARTICLE_ID ASC); ALTER TABLE ARTICLE ADD CONSTRAINT XPK게시글 PRIMARY KEY (ARTICLE_ID); CREATE TABLE MEMBER( ME..