order
Tables (5)
category (카테고리)
- 카테고리id (category_id) — bigint — Primary key — NOT NULL
- 품목 (category) — varchar(10) — NOT NULL
order (주문)
- 주문ID (order_id) — Primary key — NOT NULL
- 구매자ID (buyer_id) — bigint — Foreign key → user.유저ID — NOT NULL
- 주문날짜 (order_date) — datetime — NOT NULL
order_detail (주문상세정보)
- 상품ID (product_id) — bigint — Foreign key → product.상품ID — NOT NULL
- 주문ID (order_id) — Foreign key → order.주문ID — NOT NULL
- 수량 (amount) — bigint — NOT NULL
product (상품)
- 상품ID (product_id) — bigint — Primary key — NOT NULL
- 상품이름 (product_name) — VARCHAR(255) — NOT NULL
- 판매자ID (seller_id) — bigint — Foreign key → user.유저ID — NOT NULL
- 카테고리id (category_id) — bigint — Foreign key → category.카테고리id — NOT NULL
- 재고 (inventory) — bigint — NOT NULL
- 가격 (price) — bigint — NOT NULL
user (유저)
- 유저ID (user_id) — bigint — Primary key — NOT NULL
- 이름 (name) — varchar(255) — NOT NULL
- 나이 (age) — bigint — NOT NULL
- 성별 (gender) — ENUM('M', 'W') — NOT NULL
- 이용분류 (type) — ENUM('Seller', 'Buyer') — NOT NULL
- 주소 (address) — varchar(255) — NOT NULL