product

Tables (5)

buyer (구매자)

  • id (구매자ID) — BIGINT — Primary key — NOT NULL
  • name (구매자이름) — VARCHAR(255)
  • email (구매자EMAIL) — VARCHAR(255)
  • address (구매자주소) — VARCHAR(255)

orderlist (Untitled)

  • list (Key) — BIGINT — Primary key — NOT NULL
  • order_num (Key2) — BIGINT — Foreign key → ordernum.num — NOT NULL
  • product_num (상품ID) — BIGINT — Foreign key → product.num — NOT NULL
  • qty (Field2) — BIGINT

ordernum (Untitled2)

  • num (Key) — BIGINT — Primary key — NOT NULL
  • buyer_id (구매자ID) — BIGINT — Foreign key → buyer.id — NOT NULL
  • order_date (Field) — DATETIME

product (상품)

  • num (상품ID) — BIGINT — Primary key — NOT NULL
  • seller_id (판매자ID) — BIGINT — Foreign key → seller.id — NOT NULL
  • list (상품) — VARCHAR(255)
  • price (상품가격) — BIGINT
  • stock (상품재고) — BIGINT

seller (판매자)

  • id (판매자ID) — BIGINT — Primary key — NOT NULL
  • name (판매자이름) — VARCHAR(255)
  • email (판매자email) — VARCHAR(255)
  • warehouse (물류창고) — VARCHAR(255)