online_shop
Tables (6)
member (회원)
- ID (회원) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR(255) — NOT NULL
- role (구분) — ENUM('고객','판매자') — NOT NULL
- address (주소) — VARCHAR(255) — NOT NULL
orders (주문)
- ID (주문번호) — BIGINT — Primary key — NOT NULL
- customer_id (주문자) — BIGINT — Foreign key → member.ID — NOT NULL
- date (주문날짜) — DATETIME — NOT NULL
orders_product (주문_상품_목록)
- order_id (주문번호) — BIGINT — Foreign key → orders.ID — NOT NULL
- product_id (상품번호) — BIGINT — Foreign key → product.ID — NOT NULL
- quantity (주문수량) — BIGINT — NOT NULL
- price (주문금액) — BIGINT — NOT NULL
- size (사이즈) — enum — NOT NULL
- color (색상) — enum — NOT NULL
product (상품)
- ID (상품번호) — BIGINT — Primary key — NOT NULL
- seller_id (판매자id) — BIGINT — Foreign key → member.ID — NOT NULL
- name (상품이름) — VARCHAR(255) — NOT NULL
- total_quantity (재고) — BIGINT — NOT NULL
- price (가격) — BIGINT — NOT NULL
product_col (상품 색상)
- product_id (상품번호) — BIGINT — Foreign key → product.ID — NOT NULL
- seller_id (판매자id) — BIGINT — Foreign key → product.seller_id — NOT NULL
- color (색상) — ENUM — NOT NULL
- quantity (재고) — BIGINT — NOT NULL
product_size (상품사이즈)
- product_id (상품번호) — BIGINT — Foreign key → product.ID — NOT NULL
- seller_id (판매자id) — BIGINT — Foreign key → product.seller_id — NOT NULL
- size (사이즈) — ENUM — NOT NULL
- quantity (재고) — BIGINT — NOT NULL