test
Tables (6)
ARTICLE (Untitled2)
- ID — int — Primary key — NOT NULL
- USER_ID — int — Foreign key → USER.ID — NOT NULL
- 제목 (TITLE) — VARCHAR(100) — NOT NULL
- 본문 (CONTENT) — VARCHAR(500) — NOT NULL
- 조회수 (VIEW_COUNT) — int — NOT NULL
- 생성 시간 (CREATE_AT) — DATE — NOT NULL
- 수정 시간 (MODIFIED_AT) — DATE — NOT NULL
ARTICLE_COMMENT (Untitled3)
- Commnet_ID (ID) — int — Primary key — NOT NULL
- Article_ID (ARTICLE_ID) — int — Foreign key → ARTICLE.ID — NOT NULL
- USER_ID — int — Foreign key → USER.ID — NOT NULL
- Content (CONTENT) — VARCHAR(200)
- 생성 시간 (CREATE_AT) — DATE — NOT NULL
- 수정 시간 (MODIFIED_AT) — DATE — NOT NULL
COMMENT_COMMENT (CopyOfUntitled3)
- CC_ID (ID) — int — Primary key — NOT NULL
- Commnet_ID (COMMENT_ID) — int — Foreign key → ARTICLE_COMMENT.Commnet_ID — NOT NULL
- Article_ID (ARTICLE_ID) — int — Foreign key → ARTICLE_COMMENT.Article_ID — NOT NULL
- USER_ID — int — Foreign key → USER.ID — NOT NULL
- Content (CONTENT) — VARCHAR(200)
- 생성 시간 (CREATE_AT) — DATE — NOT NULL
- 수정 시간 (MODIFIED_AT) — DATE — NOT NULL
LEVEL_INFO (Untitled5)
- 회원등급 (LEVEL) — VARCHAR(30) — NOT NULL
- Field
LIKE (Untitled4)
- ID — int — Foreign key → ARTICLE.ID — NOT NULL
- USER_ID — int — Foreign key → ARTICLE.USER_ID — NOT NULL
USER (Untitled)
- ID — int — Primary key — NOT NULL
- pw (PASSWORD) — VARCHAR(20) — NOT NULL
- 닉네임 (NICKNAME) — VARCHAR(10)
- 가입일 (JOINED_AT) — DATE — NOT NULL
- 회원등급 (LEVEL) — VARCHAR(100) — NOT NULL