2022913002ERD5
Tables (6)
CUSTOMER (Untitled3)
- Key — char(10) — Primary key — NOT NULL
- Field — char(30)
- Field2 — char(13)
- Field3 — char(30)
- Field4 — char(30)
- Field5 — text
PURCHASE (Untitled6)
- Key — char(10) — Primary key — NOT NULL
- Field — date
- Field2 — int
- Key (Key2) — char(10) — Foreign key → CUSTOMER.Key — NOT NULL
SALESPERSON (Untitled4)
- Key — char(30) — Primary key — NOT NULL
- Field — int
- Field2 — int
- Key (Key2) — char(10) — Foreign key → PURCHASE.Key — NOT NULL
SHOES (Untitled)
- Key — char(30) — Primary key — NOT NULL
- Field — char(10)
- Field2 — char(30)
- Field3 — char(20)
- Field4 — int(10)
STORE (Untitled5)
- Field — int
- Key — char(30) — Foreign key → SHOES.Key — NOT NULL
- Key (Key2) — char(10) — Foreign key → SUPPLIER.Key — NOT NULL
- Key (Key3) — char(10) — Foreign key → PURCHASE.Key — NOT NULL
SUPPLIER (Untitled2)
- Key — char(10) — Primary key — NOT NULL
- Field — char(30)
- Field2 — char(13)
- Field3 — char(30)
- Field4 — char(30)