ex5
Tables (4)
customer (Untitled4)
- customercode (Key) — char(16) — Primary key — NOT NULL
- salesamount (Field) — int(1000)
- style (Field2) — char(20)
- size (Field3) — int(3)
- color (Field4) — char(10)
- empnum (Key2) — char(10) — Foreign key → salesman.empnum — NOT NULL
producer (Untitled3)
- producercode (Key) — char(16) — Primary key — NOT NULL
- customercode (Field) — char(16)
- style (Field2) — char(20)
- color (Field3) — char(10)
- size (Field4) — int(3)
- inventory (Field5) — char(10)
- customercode (Key2) — char(16) — Foreign key → customer.customercode — NOT NULL
salesman (Untitled2)
- empnum (Key) — char(10) — Primary key — NOT NULL
- salesamount (Field) — int(1000)
- salesgoal (Field2) — int(1000)
- salary (Field3) — char(7)
- prod.code (Key2) — char(16) — Foreign key → shoes.prod.code — NOT NULL
shoes (Untitled)
- prod.code (Key) — char(16) — Primary key — NOT NULL
- style (Field) — char(20)
- size (Field2) — int(3)
- color (Field3) — char(10)
- salesamount (Field4) — int(1000)
- producercode (Key2) — char(16) — Foreign key → producer.producercode — NOT NULL