Board_API
Tables (3)
USER (users)
- (user_id) — NOT NULL — Primary key — NOT NULL
- username — NOT NULL — NOT NULL
- password — NOT NULL
- role — NOT NULL — NOT NULL
board
- board_id — NOT NULL — Primary key — NOT NULL
- (user_id) — NOT NULL — Foreign key → USER.user_id — NOT NULL
- title — NOT NULL — NOT NULL
- contents — NOT NULL — NOT NULL
- create_date — NOT NULL — NOT NULL
comment
- comment_id — NOT NULL — Primary key — NOT NULL
- (user_id) — NOT NULL — Foreign key → USER.user_id — NOT NULL
- board_id — NOT NULL — Foreign key → board.board_id — NOT NULL
- comments — NOT NULL — NOT NULL
- create_date — NOT NULL — NOT NULL