shop

Tables (5)

BUYER_LIST (구매자 리스트)

  • buyer_id (구매자) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(255)
  • email (이메일) — VARCHAR(255)
  • addr (주소) — VARCHAR(255)

ITEM_LIST (판매상품 리스트)

  • prod_id (판매상품 아이디) — BIGINT — Primary key — NOT NULL
  • seller_id (판매자) — BIGINT — Foreign key → SELLER_LIST.seller_id — NOT NULL
  • prod_name (상품이름) — VARCHAR(255)
  • price (가격) — INT, UNSIGNED
  • inventory (상품개수) — BIGINT, UNSIGNED
  • sell_yn (판매중) — BOOLEAN

ORDER_LIST (주문 리스트)

  • order_id (주문번호) — BIGINT — Primary key — NOT NULL
  • buyer_id (구매자) — BIGINT — Foreign key → BUYER_LIST.buyer_id — NOT NULL
  • order_date (주문일) — DATETIME

ORDER_LSIT_DETAIL (주문 상세정보)

  • order_detail_id (상세정보 id) — BIGINT — Primary key — NOT NULL
  • order_id (주문번호) — BIGINT — Foreign key → ORDER_LIST.order_id — NOT NULL
  • prod_id (판매상품 아이디) — BIGINT — Foreign key → ITEM_LIST.prod_id — NOT NULL
  • order_qty (주문개수) — BIGINT, UNSIGNED
  • price (당시 가격) — BIGINT, UNSIGNED

SELLER_LIST (판매자 리스트)

  • seller_id (판매자) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(255)
  • email (이메일) — VARCHAR(255)
  • warehousr_addr (창고) — VARCHAR(255)