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