0929_Workshop

Tables (4)

Exp_Date (Untitled4)

  • Prod_Date — DATE — Primary key — NOT NULL
  • Product_Code — TEXT — Foreign key → Product.Product_Code — NOT NULL
  • Remain — NUMBER

Member (Untitled3)

  • ID — NUMBER — Primary key — NOT NULL
  • Position — TEXT
  • Sal — NUMBER
  • Manager — TEXT
  • Emp_Date — DATE
  • Store_Code — TEXT — Foreign key → Store.Store_Code — NOT NULL

Product (Untitled2)

  • Product_Code — TEXT — Primary key — NOT NULL
  • Name — TEXT
  • Prod_Category — TEXT
  • Price — NUMBER
  • Stock — NUMBER
  • Store_Code — TEXT — Foreign key → Store.Store_Code — NOT NULL

Store (Untitled)

  • Store_Code — TEXT — Primary key — NOT NULL
  • Location — TEXT
  • Sales — NUMBER
  • Category — TEXT — Branch or Direct