Project
Tables (4)
board
- board_id — INT
- board_title — VARCHAR(100) — NOT NULL
- board_content — TEXT — NOT NULL
comment
- comment_id — INT
- comment_content — VARCHAR(500)
- comment_date — DATETIME — NOT NULL
- review_id — INT — Foreign key → review.review_id — NOT NULL
- member_id — INT — Foreign key → member.member_id — NOT NULL
member
- member_id — INT
- member_loginid — VARCHAR(50) — NOT NULL
- member_nickname — VARCHAR(100) — NOT NULL
- member_email — VARCHAR(200) — NOT NULL
- member_pwd — VARCHAR(300) — NOT NULL
- member_phone — VARCHAR(20)
review
- review_id — INT
- review_title — VARCHAR(100) — NOT NULL
- review_content — TEXT — NOT NULL
- review_hit — INT — NOT NULL
- review_date — DATETIME — NOT NULL
- review_score — INT — NOT NULL
- member_id — INT — Foreign key → member.member_id — NOT NULL
- board_id — INT — Foreign key → board.board_id — NOT NULL