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)