Board Project

Tables (3)

Copy Of COMMENT (CopyOf댓글)

  • ID (댓글아이디) — BIGINT — Primary key — NOT NULL
  • USER_ID (사용자아이디2) — BIGINT — Foreign key → USER.ID — NOT NULL
  • POST_ID (게시글 아이디) — BIGINT — Foreign key → Posts.ID — NOT NULL
  • USER_NAME (작성자 이름) — VARCHAR — NOT NULL
  • COMMENT (내용) — VARCHAR — NOT NULL
  • CREATEDATE (생성일) — DATETIME — NOT NULL
  • MODIFIEDDATE (수정일) — DATETIME — NOT NULL

Posts (게시물)

  • ID (아이디) — BIGINT — Primary key — NOT NULL
  • USER_ID (사용자 아이디) — BIGINT — Foreign key → USER.ID — NOT NULL
  • TITLE (제목) — TEXT — NOT NULL
  • CONTENT (내용) — VARCHAR — NOT NULL
  • AUTHOR (작성자) — VARVHAR — NOT NULL
  • VIEW (조회수) — INTEGER — NOT NULL
  • ectDate (작성일) — VARCHAR — NOT NULL
  • CREATE_DATE (생성일) — DATETIME — NOT NULL
  • MODIFIED_DATE (수정일) — DATETIME — NOT NULL

USER (사용자)

  • ID (사용자아이디) — BIGINT — Primary key — NOT NULL
  • NAME (사용자이름) — VARCHAR — NOT NULL
  • EMAIL (이메일) — VARCHAR — NOT NULL
  • PICTURE (사진) — VARVHAR — NOT NULL
  • ROLE (권한) — VARCHAR — NOT NULL
  • CREATEDATE (생성일) — DATETIME — NOT NULL
  • MODIFIEDDATE (수정일) — DATETIME — NOT NULL