order

Tables (5)

address (주소)

  • id (주소id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • addr (주소) — varchar(255) — NOT NULL

order_detail (주문정보)

  • id (테이블id) — BIGINT — Primary key — NOT NULL
  • pro_id (상품ID) — BIGINT — Foreign key → products.id — NOT NULL
  • orderr_id (주문번호) — BIGINT — Foreign key → order_sheet.id — NOT NULL
  • qty (수량) — BIGINT — NOT NULL

order_sheet (주문지)

  • id — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • order_time (주문시각) — datetime — NOT NULL

products (상품)

  • id (상품ID) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • name (상품이름) — varchar(255) — NOT NULL
  • detail (상품설명) — varchar(3000)
  • price (가격) — BIGINT — NOT NULL
  • stock (재고) — BIGINT — NOT NULL

user (회원)

  • id (회원id) — BIGINT — Primary key — NOT NULL
  • name (이름) — varchar(255) — NOT NULL
  • phone (전화번호) — varchar(255) — NOT NULL
  • role (판매자구분) — enum — NOT NULL