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