exercise5
Tables (6)
customer (Untitled4)
- code (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
- phone (Field3)
- purchasetype (Field4)
department (Untitled)
- code (Key) — Foreign key → shoes.code — NOT NULL
- quantity (Field)
- buydate (Field2)
- amount (Field3)
- fees (Field4)
- goal (Field5)
employee (Untitled6)
- id (Key) — Primary key — NOT NULL
- salary (Field)
- code (Key2) — Foreign key → department.code — NOT NULL
provider (Untitled3)
- id (Key) — Primary key — NOT NULL
- code (Key2) — Foreign key → customer.code — NOT NULL
provider-shoestype (Untitled5)
- id (Key) — Foreign key → provider.id — NOT NULL
- code (Key2) — Foreign key → shoes.code — NOT NULL
shoes (Untitled2)
- code (Key) — Primary key — NOT NULL
- stock (Field)
- style (Field2)
- size (Field3)