Board

Tables (3)

COMMENT

  • ID — NUMBER — Primary key — NOT NULL
  • ID (POSTID) — NUMBER — Foreign key → POST.ID — NOT NULL
  • ID (USERID) — NUMBER — Foreign key → USER.ID — NOT NULL
  • CONTENT — VARCHAR

POST

  • ID — NUMBER — Primary key — NOT NULL
  • ID (USERID) — NUMBER — Foreign key → USER.ID — NOT NULL
  • TITLE — VARCHAR
  • CONTENT — VARCHAR
  • CREATEAT — DATE
  • MODIFIEDAT — DATE
  • STATUS — CHAR

USER

  • ID — NUMBER — Primary key — NOT NULL
  • USERID — VARCHAR
  • PASSWORD — VARCHAR
  • NAME — VARCHAR