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