mutsa_week5

Tables (7)

Address (Untitled5)

  • id (주소ID) — Long — Primary key — NOT NULL
  • id (유저ID) — Long — Foreign key → User.id — NOT NULL
  • addresName (주소지명) — String
  • address (주소지) — String
  • zipCode (우편번호) — String
  • phoneNumber (전화번호) — String

Cart (Untitled)

  • id (카트ID) — Long — Primary key — NOT NULL
  • user_id (유저ID) — Long — Foreign key → User.id — NOT NULL

CartItem (Untitled2)

  • id (아이템ID) — Long — Primary key — NOT NULL
  • quantity (수량) — Long
  • cart_id (카트ID) — Long — Foreign key → Cart.id — NOT NULL
  • product_id (상품ID) — Long — Foreign key → Product.id — NOT NULL

Order (Untitled6)

  • id (주문ID) — Long — Primary key — NOT NULL
  • id (유저ID) — Long — Foreign key → User.id — NOT NULL
  • id (주소ID) — Long — Foreign key → Address.id — NOT NULL

OrderItem (Untitled7)

  • id (주문아이템ID) — Long — Primary key — NOT NULL
  • id (주문ID) — Long — Foreign key → Order.id — NOT NULL
  • id (상품ID) — Long — Foreign key → Product.id — NOT NULL
  • orderPrice (주문가격) — Int
  • quantity (주문수량) — Int

Product (Untitled3)

  • id (상품ID) — Long — Primary key — NOT NULL
  • name (이름) — String
  • price (가격) — Int
  • stock (재고) — Int

User (Untitled4)

  • id (유저ID) — Long — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • name (이름) — String