exe5
Tables (5)
SUPPLIER (Untitled2)
- supID (Key) — cha(20) — Primary key — NOT NULL
- supName (Field) — char(20)
- phone (Field2) — char(20)
- description (Field3) — text
customer (Untitled3)
- customer ID (Key) — char(50) — Primary key — NOT NULL
- customer name (Field) — char(50)
- add (Field2) — char(50)
- phone (Field3) — char(50)
- buying habbit (Field5) — text
employee (Untitled5)
- emplyee ID (Key) — char(20) — Primary key — NOT NULL
- sales commission (Field) — char(20)
- sales quota (Field2) — char(20)
- shoes ID (Key2) — char10) — Foreign key → shoes.shoes ID — NOT NULL
record (Untitled4)
- purchase date (Key) — date — Primary key — NOT NULL
- purchase quantity (Field) — int(20)
- emplyee ID (Key2) — char(20) — Foreign key → employee.emplyee ID — NOT NULL
- customer ID (Key3) — char(50) — Foreign key → customer.customer ID — NOT NULL
shoes (Untitled)
- shoes ID (Key) — char10) — Primary key — NOT NULL
- shoes name (Field) — char(10)
- shoes style (Field2) — char(10)
- shoes size (Field3) — char(10)
- shoes color (Field4) — char(10)
- discription (Field5) — text
- quantity (Field6) — int(30)
- supID (Key2) — cha(20) — Foreign key → SUPPLIER.supID — NOT NULL
- customer ID (Key3) — char(50) — Foreign key → customer.customer ID — NOT NULL