shop - 2025-11-27 03:46:53
Tables (6)
BUYER_LIST (구매자 리스트)
- buyer_id (구매자) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR(255)
- email (이메일) — VARCHAR(255)
- addr (주소) — VARCHAR(255)
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 → PROD_LIST.prod_id — NOT NULL
- order_qty (주문개수) — BIGINT, UNSIGNED
- price (당시 가격) — BIGINT, UNSIGNED
PROD_LIST (판매상품 리스트)
- prod_id (판매상품 아이디) — BIGINT — Primary key — NOT NULL
- seller_id (판매자) — BIGINT — Foreign key → SELLER_LIST.seller_id — NOT NULL
- prod_name (상품이름) — VARCHAR(255)
- price (가격) — DECIMAL(12, 2), UNSIGNED
- inventory (상품개수) — INT, UNSIGNED
- sell_yn (판매중) — BOOLEAN
SELLER_LIST (판매자 리스트)
- seller_id (판매자) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR(255)
- email (이메일) — VARCHAR(255)
- warehousr_addr (창고) — VARCHAR(255)
WISHLIST (장바구니)
- wish_id (장바구니 id) — BIGINT — Primary key — NOT NULL
- buyer_id (Field) — BIGINT
- prod_id (Field2) — BIGINT
- purchase_yn (Field3) — TINYINT(1)