test1

Tables (5)

comments

  • id — INT — Primary key — NOT NULL — 댓글아이디
  • content — TEXT — NOT NULL — 댓글 본문
  • created — DATETIME — NOT NULL — 작성일
  • content_id — INT — Foreign key → content.id — NOT NULL — 글아이디
  • user_id — INT — Foreign key → user.id — NOT NULL — 저자아이디

content

  • id — INT — Primary key — NOT NULL — 글아이디
  • content — TEXT — NOT NULL — 내용
  • title — VARCHAR(45) — NOT NULL — 제목
  • created — DATETIME — NOT NULL — 작성일

dormant

  • created — datetime — NOT NULL — 저자아이디
  • id — INT — Foreign key → user.id — NOT NULL — 저자아이디

user

  • id — INT — Primary key — NOT NULL — 저자아이디
  • name — VARCHAR(45) — NOT NULL — 이름
  • introduction — VARCHAR(45) — NOT NULL — 자기소개

write

  • user_id — INT — Foreign key → user.id — NOT NULL — 저자아이디
  • content_id — INT — Foreign key → content.id — NOT NULL — 글아이디