mealkit

Tables (7)

Member (Untitled)

  • Member_Code (Key) — number — Primary key — NOT NULL
  • x (Field7) — number
  • x (Field) — varchar(20)
  • x (Field2) — varchar(20)
  • x (Field3) — date
  • x (Field5) — varchar(40)
  • x (Field4) — varchar(150)
  • x (Field6) — varchar(25)
  • x (Field8) — boolean

OrderStatus (Untitled2)

  • Order_Number (Key) — number — Primary key — NOT NULL
  • Member_Code (Key2) — number — Foreign key → Member.Member_Code — NOT NULL
  • Product_Code (Key22) — number — Foreign key → Product.Product_Code — NOT NULL
  • x (Field) — varchar(30)
  • x (Field2) — number

PaymentRecord (Untitled7)

  • Key — Primary key — NOT NULL
  • Field

Product (Untitled5)

  • Product_Code (Key2) — number — Primary key — NOT NULL
  • x (Field) — number

ProductPage (Untitled3)

  • Product_Category (Key) — varchar(45) — Primary key — NOT NULL
  • Product_Code (Key2) — number — Foreign key → Product.Product_Code — NOT NULL
  • PrimaryKey (Key3) — number — Foreign key → Member.Member_Code — NOT NULL
  • x (Field4) — varchar(3000)
  • x (Field6) — varchar(45)
  • x (Field5) — number
  • x (Field) — varchar(80)
  • x (Field2) — varchar(80)
  • x (Field7) — number
  • x (Field3) — varchar(800)
  • x (Field8) — varchar(80)
  • x (Field9) — varchar(80)

PurchaseHistory (Untitled4)

  • Key — number — Primary key — NOT NULL
  • PrimaryKey (Key2) — number — Foreign key → Member.Member_Code — NOT NULL
  • x (Field) — number
  • x (Field2) — number
  • x (Field3) — number

SoldHistory (Untitled6)