personal

Tables (4)

BuyList (Untitled)

  • id — Long — Primary key — NOT NULL
  • userId — Long — Foreign key → User.id — NOT NULL
  • productId — Long — Foreign key → Product.id — NOT NULL
  • delivered_date (deliveredDate) — LOCALDATETIME

Product

  • id — Long — Primary key — NOT NULL
  • productname — String
  • price — int
  • imageurl — String
  • stock — int
  • bIsDisplayed — boolean
  • description — String
  • Field

User

  • id — Long — Primary key — NOT NULL
  • email — String
  • username — String
  • phone — String
  • address — String
  • password — String

WishList

  • id — Long — Primary key — NOT NULL
  • userId — Long — Foreign key → User.id — NOT NULL
  • productId — Long — Foreign key → Product.id — NOT NULL
  • count — int