shoppingmall
테이블 (6)
Product (product)
- product_id — int — 기본 키 — NOT NULL
- product_name — varchar(20)
- price — int
- stock_quantity — varchar(10)
- cateogory (category) — varchar(10)
User (user)
- user_id — int — 기본 키 — NOT NULL
- user_name — varchar(20)
- password — varchar(20)
- email — varchar(20)
- phone_number — varchar(20)
cart
- cart_id — int — 기본 키
- product_id — int
- user_id — int — 외래 키 → User.user_id — NOT NULL
cart_item
- cart_item_id — int — 기본 키 — NOT NULL
- product_id — int
- quantity — int
- Field
- cart_id — int — 외래 키 → cart.cart_id
- product_id (product_id2) — int — 외래 키 → Product.product_id — NOT NULL
category
- category_id — int — 기본 키 — NOT NULL
- category_name — varchar(10)
상품 (Untitled)
- product_id — int — 기본 키 — NOT NULL
- sex — boolean
- kids (kids_id) — int
- Sports (Sports_id) — int