ㅇㅇ
Tables (10)
Board
- board_num — INT — Primary key — NOT NULL
- board_title — VARCHAR(255) — NOT NULL
- board_contants — VARCHAR(255) — NOT NULL
- board_date — DATE — NOT NULL
- member_num — INT — Foreign key → Member.member_num — NOT NULL
Delivery
- Delivery_num — INT — Primary key — NOT NULL
- Delivery_address — VARCHAR(255) — NOT NULL
- Delivert_state — INT — NOT NULL
Inquiry
- inquiry_num — INT — Primary key — NOT NULL — 문의
- inquiry_title — VARCHAR(255) — NOT NULL
- inquiry_contant — VARCHAR(255) — NOT NULL
- inquiry_date — VARCHAR(255) — NOT NULL
- member_num — INT — Foreign key → Member.member_num — NOT NULL
Inquiry_Comment
- inqury_comment_num — INT — Primary key — NOT NULL
- inquiry_num — INT — Foreign key → Inquiry.inquiry_num — NOT NULL
- inquiry_comment_contants — VARCHAR(255) — NOT NULL
Main_Category
- main_category_num — INT — Primary key — NOT NULL
- main_category_name — VARCHAR(255) — NOT NULL
Member
- member_num — INT — Primary key — NOT NULL
- member_name — VARCHAR(255) — NOT NULL
- member_email — VARCHAR(255) — NOT NULL
- member_id — VARCHAR(255) — NOT NULL
- member_birthday — DATE — NOT NULL
- member_gender — VARCHAR(255) — NOT NULL
- member_password — VARCHAR(255) — NOT NULL
- member_tel — VARCHAR(255) — NOT NULL
- state — INT — NOT NULL
- address — VARCHAR(255) — NOT NULL
Prize
- prize_num — INT — Primary key — NOT NULL
- sub_category_num — INT — Foreign key → Sub_Category.sub_category_num — NOT NULL
- prize_name — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
- prize_comment — VARCHAR(255) — NOT NULL
- prize_number — INT — NOT NULL
Report
- report_num — INT — Primary key — NOT NULL
- board_num — INT — Foreign key → Board.board_num
- report_time — DATETIME — NOT NULL
Sub_Category
- sub_category_num — INT — Primary key — NOT NULL
- sub_category_name — INT — NOT NULL
- main_category_num — VARCHAR(255) — Foreign key → Main_Category.main_category_num — NOT NULL
prize_image
- prize_Image_num — INT — Primary key — NOT NULL
- prize_num — INT — Foreign key → Prize.prize_num — NOT NULL
- prize_image_url — VARCHAR(255) — NOT NULL
- prize_sequence — INT — NOT NULL — 상품 이미지 순서