project
Tables (11)
cart_items (Untitled9)
- cart_item_id (장바구니ID) — PK — Primary key — NOT NULL
- Field
categories (Untitled7)
- categories_id (카테고리ID) — PK — Primary key — NOT NULL
- Field
likes (Untitled8)
- like_id (관심상품) — PK — Primary key — NOT NULL
- Field
option_groups (Untitled6)
- option_groups_id (옵션그룹ID) — PK — Primary key — NOT NULL
- Field
order_items (Untitled11)
- order_item_id (상세주문상품ID) — PK — Primary key — NOT NULL
- Field
orders (Untitled10)
- order_id (주문ID) — PK — Primary key — NOT NULL
- Field
product_options (Untitled5)
- option_id (옵션ID) — PK — Primary key — NOT NULL
- Field
product_vendors (Untitled3)
- product_vendor_id (상품판매ID) — PK — Primary key — NOT NULL
- base_price (판매가격)
- stock_quantity (재고량)
products (Untitled4)
- product_id (상품ID) — PK — Primary key — NOT NULL
- Field
users (Untitled)
- user_id (유저ID) — PK — Primary key — NOT NULL
- email (이메일) — NOT NULL
- password (비밀번호) — NOT NULL
- name (이름) — NOT NULL
- role (역할) — NOT NULL
vendors (Untitled2)
- vendor_id (판매자ID) — PK — Primary key — NOT NULL
- store_name (상호명) — NOT NULL