mutsa_14th_week1

Tables (5)

Cart (Untitled4)

  • cartId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL

Order (Untitled3)

  • orderedItemId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL
  • productId (Key3) — Foreign key → Product.productId — NOT NULL

OrderItem (Untitled5)

  • orderItemId (Key) — Primary key — NOT NULL

Product (Untitled2)

  • productId (Key) — Primary key — NOT NULL
  • productName (Field)
  • productPrice (Field2)

User (Untitled)

  • userId (Key) — Primary key — NOT NULL
  • nickname (Field)
  • password (Field2)