shopping
Tables (7)
Cart (장바구니)
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL
- created_at (Field) — DATETIME
- updated_at (Field2) — DATETIME
CartItem (카트 속 상품)
- product_id (Key) — BIGINT — Foreign key → Product.product_id — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → Cart.user_id — NOT NULL
- quantity (Field) — INT
- unit_price (Field2) — INT
- added_at (Field3) — DATETIME
Order (주문)
- order_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → User.user_id — NOT NULL
- order_status (Field) — VARCHAR
- shipping_address (Field2) — VARCHAR
- shipping_request (Field3) — VARCHAR
- total_price (Field4) — INT
- ordered_at (Field5) — DATETIME
- updated_at (Field6) — DATETIME
OrderItem (주문 속 상품)
- product_id (Key4) — BIGINT — Foreign key → Product.product_id — NOT NULL
- order_id (Key) — BIGINT — Foreign key → Order.order_id — NOT NULL
- quantity (Field) — INT
- unit_price (Field2) — INT
- item_total_price (Field3) — INT
Payment (결제)
- payment_id (Key) — BIGINT — Primary key — NOT NULL
- order_id (Key3) — BIGINT — Foreign key → Order.order_id — NOT NULL
- payment_method (Field) — VARCHAR
- payment_status (Field2) — VARCHAR
- amount (Field3) — INT
- paid_at (Field4) — DATETIME
- cancelled_at (Field5) — DATETIME
Product (상품)
- product_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR
- price (Field2) — INT
- stock (Field3) — INT
- created_at (Field5) — DATETIME
- status (Field4) — VARCHAR
User (유저)
- user_id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR
- password (Field2) — VARCHAR
- name (Field3) — VARCHAR
- phone (Field4) — VARCHAR
- address (Field5) — VARCHAR
- created_at (Field6) — DATETIME
- status (Field7) — VARCHAR