hanghae
Tables (6)
Cart (장바구니)
- ID (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.ID — NOT NULL
CartItem (장바구니정보)
- ID (Key) — Long — Primary key — NOT NULL
- cart_id (Key2) — Long — Foreign key → Cart.ID — NOT NULL
- product_id (Key3) — Long — Foreign key → Product.ID — NOT NULL
- quantity (Field3) — int
Order (주문)
- ID (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.ID — NOT NULL
- total_amount (Field2) — int
- created_at (Field3) — datetime
OrderItem (주문정보)
- ID (Key) — Long — Primary key — NOT NULL
- order_id (Key2) — Long — Foreign key → Order.ID — NOT NULL
- product_id (Key3) — Long — Foreign key → Product.ID — NOT NULL
- quantity (Field3) — int
- price (Field4) — int
Product (상품정보)
- ID (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- price (Field2) — Long
- stock (Field3) — Long
User (유저)
- ID (Key) — Long — Primary key — NOT NULL
- balance (Field) — int