test
Tables (5)
comment
- comment_num — int — Primary key — NOT NULL
- question_num — int — Foreign key → question.question_num — NOT NULL
- comment_content — varchar(1000) — NOT NULL
- comment_date — TIMESTAMP — NOT NULL
- comment_title — varchar(50)
customers
- member_code — int — Primary key — NOT NULL
- member_id — VARCHAR(15) — NOT NULL
- member_pw — VARCHAR(15) — NOT NULL
- member_name — VARCHAR(20) — NOT NULL
- member_addr — VARCHAR(60) — NOT NULL
- member_email — VARCHAR(12) — NOT NULL
- member_birth — DATE — NOT NULL
- member_gender — VARCHAR(5) — NOT NULL
- member_phone — VARCHAR(15) — NOT NULL
- member_level — VARCHAR(7) — NOT NULL
- member_join — TIMESTAMP
products
- product_code — int — Primary key — NOT NULL
- img_view — VARCHAR(50) — NOT NULL
- product_type — int — NOT NULL
- product_type_name — VARCHAR(20) — NOT NULL
- product_name — VARCHAR(50) — NOT NULL
- product_price — INT — NOT NULL
- product_read — INT — NOT NULL
- product_content — VARCHAR(1000) — NOT NULL
- product_count — INT — NOT NULL
- product_date — TIMESTAMP
- product_like — int — NOT NULL
question
- question_num — int — Primary key — NOT NULL
- member_code — int — Foreign key → customers.member_code — NOT NULL
- question_title — varchar(20)
- question_content — varchar(1000)
- question_date — TIMESTAMP — NOT NULL
review
- review_num — int — Primary key — NOT NULL
- product_code — int — Foreign key → products.product_code — NOT NULL
- member_code — int — Foreign key → customers.member_code — NOT NULL
- review_star — INT — NOT NULL
- review_title — varchar(20)
- review_content — varchar(1000) — NOT NULL
- review_date — TIMESTAMP — NOT NULL