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)