ex_5

Tables (8)

COMPENSATION (Untitled6)

  • compensationID (Key) — char(10) — Primary key — NOT NULL
  • accountNumber (Field) — char(20)
  • employeeNumber (Key2) — char(30) — Foreign key → EMPLOEE.employeeNumber — NOT NULL

CUSTOMER (Untitled)

  • CustomerNumber (Key) — char(5) — Primary key — NOT NULL
  • CustomerName (Field) — char(10)
  • CustomerAddress (Field2) — char(30)
  • CustomerPhone (Field3) — char(11)
  • BuyingHabites (Field4) — char(15)

DEPARTMENT (Untitled8)

  • departCode (Key) — char(10) — Primary key — NOT NULL
  • ProductCode (Key3) — char(20) — Foreign key → SHOES.ProductCode — NOT NULL
  • SupCode (Key2) — char(10) — Foreign key → SUPPLIER.SupCode — NOT NULL

EMPLOEE (Untitled4)

  • employeeNumber (Key) — char(30) — Primary key — NOT NULL
  • employeeName (Field) — char(20)
  • sales quota (Field2) — int
  • compensation (Field3) — char(50)
  • sales commission (Field4) — char(20)
  • position (Field5) — char(10)

ORDER (Untitled2)

  • OredrNumber (Key) — char(10) — Primary key — NOT NULL
  • DateOfPurchas (Field) — date
  • QuantityOfPurchas (Field2) — int
  • PriceOfPurchas (Field3)
  • CustomerNumber (Key4) — char(5) — Foreign key → CUSTOMER.CustomerNumber — NOT NULL
  • employeeNumber (Key2) — char(30) — Foreign key → EMPLOEE.employeeNumber — NOT NULL
  • ProductCode (Key3) — char(20) — Foreign key → SHOES.ProductCode — NOT NULL

SHIPPING (Untitled3)

  • ShippingNumber (Key) — char(20) — Primary key — NOT NULL
  • OredrNumber (Key2) — char(10) — Foreign key → ORDER.OredrNumber — NOT NULL
  • shippingdate (Field) — date
  • shippingAddress (Field2) — char(30)
  • shippingPhone (Field3) — char(11)

SHOES (Untitled5)

  • ProductCode (Key) — char(20) — Primary key — NOT NULL
  • style (Field) — char(10)
  • size (Field2) — char(30
  • color (Field3) — char(5)
  • price (Field4) — int
  • Quantity (Field5) — int
  • departCode (Key2) — char(10) — Foreign key → DEPARTMENT.departCode — NOT NULL
  • ProductCode (Key3) — char(20) — Foreign key → DEPARTMENT.ProductCode — NOT NULL

SUPPLIER (Untitled7)

  • SupCode (Key) — char(10) — Primary key — NOT NULL
  • supName (Field3) — char(20)
  • supAddress (Field) — char(30)
  • supPhone (Field2) — char(11)
  • supEmail (Field5) — char(20)
  • supGrade (Field4) — text
  • departCode (Key2) — char(10) — Foreign key → DEPARTMENT.departCode — NOT NULL
  • ProductCode (Key3) — char(20) — Foreign key → DEPARTMENT.ProductCode — NOT NULL