DataModeling
Tables (3)
board
- idx (IDX) — AUTO_INCREMENT — Primary key — NOT NULL
- id (userID) — NOT NULL — Foreign key → user.id — NOT NULL
- title (TITLE) — NOT NULL
- content (CONTENT) — NOT NULL
- time (TIME) — NOT NULL
- sawCount (SAWCOUNT) — NOT NULL
- Field
comment
- idx (IDX) — AUTO_INCREMENT — Primary key — NOT NULL
- id (boardID) — NOT NULL — Foreign key → board.idx — NOT NULL
- id (userID) — NOT NULL — Foreign key → board.id — NOT NULL
- content (CONTENT) — NOT NULL
- time (TIME) — NOT NULL
user
- id (ID) — NOT NULL — Primary key — NOT NULL
- name (NAME) — NOT NULL