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