NoticeBoard
Tables (3)
Comment (Untitled3)
- id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → Post.id — NOT NULL
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- create_data — DATETIME
- update_data — DATETIME
- content — STRING
Member (Untitled)
- member_id — INT — Primary key — NOT NULL
- email — VARCHAR(30)
- password — VARCHAR(30)
- nickname — VARCHAR(30)
- create_data — DATETIME
- update_date — DATETIME
Post (Untitled2)
- id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → Member.member_id — NOT NULL
- create_data — DATETIME
- update_data — DATETIME
- title — VARCHAR(20)
- content — STRING