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