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