shopping
Tables (4)
Order (CopyOfUntitled7)
- orderId (Key) — String — Primary key — NOT NULL
- userId (String) — String — Foreign key → User.userId — NOT NULL
- createTime (Field2) — DateTime
Product (Untitled2)
- productId (Key) — String — Primary key — NOT NULL
- productName (Field) — String
- description (Field2) — Text
- price (Field3) — BigInt
- quantity (Field4) — Integer
- registerDate (Field5) — Date
- startTimeDeal (Field6) — DateTime
- endTimeDeal (Field7) — DateTime
- status (Field8) — Enum
Product_Order (Untitled9)
- productId (Key) — String — Foreign key → Product.productId — NOT NULL
- orderId (Key2) — String — Foreign key → Order.orderId — NOT NULL
User (Untitled)
- userId (String) — String — Primary key — NOT NULL
- password (Field) — String
- userName (Field2) — String
- registerDate (Field6) — Date
- balance (Field5) — BigInt