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