order
Tables (7)
address (주소)
- address_id (주소ID) — bigint — Primary key — NOT NULL
- member_id (사용자ID) — bigint — Foreign key → member.member_id — NOT NULL
- country (국가) — varchar(255) — NOT NULL
- city (도시) — varchar(255)
- street (상세주소) — varchar(255)
business (판매자)
- business_id (판매자ID) — bigint — Primary key — NOT NULL
- business_number (사업자번호) — varchar(255) — NOT NULL
- business_name (상호명) — varchar(255)
- call_number (대표번호) — varchar(255)
category (카테고리)
- category_id (카테고리) — bigint — Primary key — NOT NULL
- super_category (대분류) — varchar(255) — NOT NULL
- base_category (중분류) — varchar(255)
- sub_category (소분류) — varchar(255)
detail_order (주문상세)
- detail_order_id (주문상세ID) — bigint — Primary key — NOT NULL
- order_id (주문ID) — bigint — Foreign key → order.order_id — NOT NULL
- product_id (상품ID) — bigint — Foreign key → product.product_id — NOT NULL
- product_name (상품명) — bigint — NOT NULL
- quantity (수량) — bigint — NOT NULL
- price (단가) — bigint — NOT NULL
member (일반사용자)
- member_id (사용자ID) — bigint — Primary key — NOT NULL
- name (사용자이름) — varchar(255) — NOT NULL
- email (사용자메일) — varchar(255) — NOT NULL
order (주문)
- order_id (주문ID) — bigint — Primary key — NOT NULL
- member_id (사용자ID) — bigint — Foreign key → member.member_id — NOT NULL
- member_address (사용자주소) — varchar(255) — NOT NULL — 국가+도시+상세주소
- total_price (주문금액) — bigint — NOT NULL
- order_date (주문일자) — datetime — NOT NULL
product (상품)
- product_id (상품ID) — bigint — Primary key — NOT NULL
- business_id (판매자ID) — bigint — Foreign key → business.business_id — NOT NULL
- category_id (카테고리) — bigint — Foreign key → category.category_id — NOT NULL
- product_name (상품명) — varchar(255) — NOT NULL
- inventory (재고) — bigint — NOT NULL
- price (단가) — bigint — NOT NULL