exercise5
Tables (5)
BUYS (Untitled4)
- employeeCode (Key3) — char(8) — Foreign key → EMPLOYEE.code — NOT NULL
- customerCode (Key) — char(5) — Foreign key → CUSTOMER.code — NOT NULL
- date (Field) — date
- amount (Field2) — int
- shoesCode (Key2) — char(6) — Foreign key → SHOES.code — NOT NULL
- providerCode (Key22) — char(4) — Foreign key → SHOES.providerCode — NOT NULL
- fees (Field3) — int
- goal (Field4) — long text
CUSTOMER (Untitled3)
- code (Key) — char(5) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(50)
- phone (Field3) — int(11)
- purchaseType (Field4) — long text
EMPLOYEE (Untitled5)
- code (Key) — char(8) — Primary key — NOT NULL
- name (Field) — char(10)
- salary (Field2) — int
PROVIDER (Untitled2)
- code (Key) — char(4) — Primary key — NOT NULL
SHOES (Untitled)
- code (Key) — char(6) — Primary key — NOT NULL
- providerCode (Key2) — char(4) — Foreign key → PROVIDER.code — NOT NULL
- stock (Field) — int
- style (Field2) — char
- size (Field3) — char(1)
- color (Field4) — char