lv5

Tables (3)

carts (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • product_id (Key3) — Long — Foreign key → products.id — NOT NULL
  • user_id (Key2) — Long — Foreign key → users.id — NOT NULL
  • haveproductCount (Field) — Long

products (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • productCount (Field2) — Long
  • price (Field3) — Long
  • introduction (Field4) — String
  • category (Field5) — String

users (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • pw (Field2) — String
  • gender (Field3) — char
  • phoneNumber (Field4) — String
  • address (Field5) — String
  • authority (Field6) — Enum.String