1
Tables (4)
Board (my_board)
- Board Id (board_id) — INT(11) — Primary key — NOT NULL
- Board Name (board_name) — VARCHAR(255)
- Created Date (created_date) — CHAR(8)
Member (my_member)
- Member Id (member_id) — INT(11) — Primary key — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birthdat) — CHAR(8)
Post (my_post)
- Post Id (post_id) — INT(11) — Primary key — NOT NULL
- Member Id (member_id) — INT(11) — Foreign key → Member.Member Id — NOT NULL
- Board Id (board_id) — INT(11) — Foreign key → Board.Board Id — NOT NULL
- Post Name (post_name) — VARCHAR(255)
- Title (title) — VARCHAR(100)
- Content (content)