logical ERD exercise
Tables (5)
board
- id — INT — Primary key — NOT NULL
- subject — VARCHAR(20)
- content — VARCHAR(200)
- update_time — DATETIME
- create_time — DATETIME
- author_id — INT — Foreign key → user.id — NOT NULL
comment
- id — INT — Primary key
- content — VARCHAR(100)
- update_date — DATETIME
- create_date — DATETIME
- author_id — INT — Foreign key → user.id — NOT NULL
- board_id — INT — Foreign key → board.id — NOT NULL
role
- id — INT — Primary key — NOT NULL
- update_date — DATETIME
- create_date — DATETIME
- title — VARCHAR(20)
user
- id — INT — Primary key — NOT NULL
- username — VARCHAR(20)
- pwd — VARCHAR(20)
- update_date — DATETIME
- create_date — DATETIME
user_role
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- role_id — INT — Foreign key → role.id — NOT NULL
- create_date — DATETIME