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)