personal_project

Tables (8)

account (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • accountPassword (Field) — String
  • accountNumber (Field2) — String
  • Money (Field3) — Int
  • userId (Key2) — uuid — Foreign key → user.id — NOT NULL

card (Untitled4)

  • Key — Long — Primary key — NOT NULL
  • Field
  • userId (Key2) — uuid — Foreign key → user.id — NOT NULL
  • cardNumber (Field2) — Long
  • cardName (Field3) — String

owner (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • ownerId (Key2) — UUID — Primary key — NOT NULL
  • product (Field) — String
  • Field2
  • userId (Key3) — uuid — Foreign key → user.id — NOT NULL

payment (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — uuid — Foreign key → user.id — NOT NULL
  • productId (Key3) — Long — Foreign key → product.Key — NOT NULL
  • ownerId (Key22) — UUID — Foreign key → owner.ownerId — NOT NULL

product (Untitled5)

  • Key — Long — Primary key — NOT NULL
  • prouductName (Field) — Long
  • proudctPrice (Field2) — Integer
  • productType (Field3) — String
  • productReview (Field4) — String
  • productOwner (Field5) — String

reviews (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • productId (Key2) — Long — Foreign key → product.Key — NOT NULL
  • userId (Key3) — uuid — Foreign key → user.id — NOT NULL
  • reviewTitle (Field2) — String
  • reviewContent (Field3) — String

shopping basket (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • productId (Key2) — Long — Foreign key → product.Key — NOT NULL
  • id (Key3) — uuid — Foreign key → user.id — NOT NULL

user (Untitled)

  • id (Key) — uuid — Primary key — NOT NULL
  • password (Field2) — String
  • address (Field3) — String
  • accountNumber (Field4) — String
  • nickName (Field5) — String
  • phoneNumber (Field) — String
  • easyPassword (Field6) — String