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