KotlinMVC

Tables (4)

Basket (Untitled4)

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

OrderTable (Untitled2)

  • orderId (Key) — Long — Primary key — NOT NULL
  • baskeId (Key2) — Long — Foreign key → Basket.baskeId — NOT NULL
  • userId (Key22) — Long — Foreign key → Basket.userId — NOT NULL
  • orderNum (Field) — String

Product (Untitled3)

  • productId (Key) — Long — Primary key — NOT NULL
  • baskeId (Key2) — Long — Foreign key → Basket.baskeId — NOT NULL
  • productName (Field) — String

User (Untitled)

  • userId (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • email (Field2) — String
  • pw (Field3) — String
  • phone (Field4) — Int
  • nickName (Field5) — String
  • gender (Field6) — String