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