exercise5

Tables (5)

BUYS (Untitled4)

  • employeeCode (Key3) — char(8) — Foreign key → EMPLOYEE.code — NOT NULL
  • customerCode (Key) — char(5) — Foreign key → CUSTOMER.code — NOT NULL
  • date (Field) — date
  • amount (Field2) — int
  • shoesCode (Key2) — char(6) — Foreign key → SHOES.code — NOT NULL
  • providerCode (Key22) — char(4) — Foreign key → SHOES.providerCode — NOT NULL
  • fees (Field3) — int
  • goal (Field4) — long text

CUSTOMER (Untitled3)

  • code (Key) — char(5) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(50)
  • phone (Field3) — int(11)
  • purchaseType (Field4) — long text

EMPLOYEE (Untitled5)

  • code (Key) — char(8) — Primary key — NOT NULL
  • name (Field) — char(10)
  • salary (Field2) — int

PROVIDER (Untitled2)

  • code (Key) — char(4) — Primary key — NOT NULL

SHOES (Untitled)

  • code (Key) — char(6) — Primary key — NOT NULL
  • providerCode (Key2) — char(4) — Foreign key → PROVIDER.code — NOT NULL
  • stock (Field) — int
  • style (Field2) — char
  • size (Field3) — char(1)
  • color (Field4) — char