Project
Tables (4)
Copy Of comment (board)
- Key3 (board_id) — INT — Primary key — NOT NULL
- comment_content (board_content) — text
- Field (board_title) — VARCHAR(100)
- Field (board_score) — DECIMAL(3,1)
comment
- Key3 (comment_id) — INT — Primary key — NOT NULL
- comment_content — VARCHAR(500)
- comment_date — DATETIME — NOT NULL
- review_id — INT — Foreign key — NOT NULL
- member_id — INT — Foreign key — NOT NULL
- Key3 (board_id) — INT — Foreign key → review.Key3 — NOT NULL
member
- Key (member_id) — INT — Primary key — NOT NULL
- 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_id1 (review_id) — INT — Primary key — NOT NULL
- Key3 (board_id) — INT — Foreign key → Copy Of comment.Key3 — NOT NULL
- 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 — NOT NULL