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