중고거래 최신
테이블 (8)
ChatMessage
- message_num — INT — 기본 키 — NOT NULL
- chat_room_num — INT — 외래 키 → ChatRoom.chat_room_num — NOT NULL
- sender_num — INT — NOT NULL
- message — TEXT — NOT NULL
- timestamp — DATETIME — NOT NULL
ChatRoom
- chat_room_num — INT — 기본 키 — NOT NULL
- seller_num — INT — 외래 키 → Member.member_num — NOT NULL
- buyer_num — INT — 외래 키 → Member.member_num — NOT NULL
Main_Category
- main_category_num — INT — 기본 키 — NOT NULL
- main_category_name — VARCHAR(255) — NOT NULL
Member
- member_num — INT — 기본 키 — NOT NULL
- member_name — VARCHAR(255) — NOT NULL
- member_email — VARCHAR(255) — NOT NULL
- member_id — VARCHAR(255) — NOT NULL
- member_password — VARCHAR(255) — NOT NULL
- member_tel — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- state — INT
Product
- product_num — INT — 기본 키 — NOT NULL
- member_num — INT — 외래 키 → Member.member_num — NOT NULL
- main_category_num — INT — 외래 키 → Main_Category.main_category_num — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
- product_description — VARCHAR(255) — NOT NULL
- product_condition — VARCHAR(255) — NOT NULL
- product_status — VARCHAR(255) — NOT NULL — 판매중, 예약중, 판매완료 등
ProductImage
- image_num — INT — 기본 키 — NOT NULL
- product_num — INT — 외래 키 → Product.product_num — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- image_sequence — INT — NOT NULL — 상품 이미지 순서
Rating
- rating_num — INT — 기본 키 — NOT NULL
- rated_member_num — INT — 외래 키 → Member.member_num — NOT NULL
- rating_member_num — INT — 외래 키 → Member.member_num — NOT NULL
- rating — INT — NOT NULL
- rating_comment — VARCHAR(255)
- rating_date — DATETIME — NOT NULL
Transaction
- transaction_num — INT — 기본 키 — NOT NULL
- seller_num — INT — 외래 키 → Member.member_num — NOT NULL
- buyer_num — INT — 외래 키 → Member.member_num — NOT NULL
- product_num — INT — 외래 키 → Product.product_num — NOT NULL
- transaction_date — DATETIME — NOT NULL
- transaction_status — VARCHAR(255) — NOT NULL — 진행중, 완료, 취소 등