ex5
Tables (8)
color (Untitled6)
- colorid (Key) — char(5)_ — Primary key — NOT NULL
- description (Field) — text
customer (Untitled3)
- customerid (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(13)
- phone (Field2) — char(11)
- address (Field3) — text
- gender (Field4) — char(5)
- birth (Field5) — date
- description (Field6) — text
employee (Untitled4)
- employeeid (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(13)
- phone (Field2) — char(11)
sale (Untitled8)
- saleid (Key) — char(10) — Primary key — NOT NULL
- shoesid (Key2) — char(5) — Foreign key → shoes.shoesid — NOT NULL
- sizeid (Key22) — char(5) — Foreign key → shoes.sizeid — NOT NULL
- styleid (Key3) — char(5) — Foreign key → shoes.styleid — NOT NULL
- colorid (Key4) — char(5) — Foreign key → shoes.colorid — NOT NULL
- employeeid (Key5) — char(10) — Foreign key → employee.employeeid — NOT NULL
- customerid (Key6) — char(10) — Foreign key → customer.customerid — NOT NULL
- date (Field) — date
- quantity (Field2) — integer
shoes (Untitled)
- shoesid (Key) — char(5) — Primary key — NOT NULL
- sizeid (Key2) — char(5) — Foreign key → size.sizeid — NOT NULL
- styleid (Key3) — char(5) — Foreign key → style.styleid — NOT NULL
- colorid (Key4) — char(5)_ — Foreign key → color.colorid — NOT NULL
- supplierid (Key5) — char(10) — Foreign key → supplier.supplierid — NOT NULL
- stock (Field) — integer
size (Untitled5)
- sizeid (Key) — char(5) — Primary key — NOT NULL
- description (Field) — text
style (Untitled7)
- styleid (Key) — char(5) — Primary key — NOT NULL
- description (Field) — text
supplier (Untitled2)
- supplierid (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(13)
- phone (Field2) — char(11)
- quality (Field3) — char(5)
- description (Field4) — text