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