exe7

Tables (8)

ABC development corp (Untitled)

  • commercial building (Key) — int — Primary key — NOT NULL
  • project number (Field) — char(10)

Heating (Untitled7)

  • ID (Key) — int — Primary key — NOT NULL
  • name (Field) — char(5)
  • phone (Field2) — char(5)
  • work no (Key3) — int — Foreign key → Work category.work no — NOT NULL

Loan (Untitled5)

  • loan number (Key) — int — Primary key — NOT NULL
  • loan amount (Field) — char(10)
  • loan payment (Field2) — char(10)
  • project no (Key2) — int — Foreign key → Project.project no — NOT NULL

Plumping (Untitled8)

  • ID (Key) — int — Primary key — NOT NULL
  • name (Field) — char(5)
  • pdone (Field2) — char(5)
  • work no (Key3) — int — Foreign key → Work category.work no — NOT NULL

Projecrt manager (Untitled2)

  • employee ID (Key2) — int — Primary key — NOT NULL
  • manager name (Field) — char(10)
  • manager phone (Field2) — char(10)
  • manager add (Field3) — char(10)
  • project no (Key) — int — Foreign key → Project.project no — NOT NULL

Project (Untitled6)

  • project no (Key) — int — Primary key — NOT NULL
  • project name (Field) — char(20)
  • description (Field2) — text
  • commercial building (Key2) — int — Foreign key → ABC development corp.commercial building — NOT NULL

Subcontactor (Untitled3)

  • subcontractor ID (Key) — int — Primary key — NOT NULL
  • subcontractor item (Field2) — int — Primary key
  • subcontractor name (Field) — char(20)
  • subcontractor phone (Field3) — char(20)
  • subcontractor add (Field4) — char(20)
  • project no (Key2) — int — Foreign key → Project.project no — NOT NULL
  • employee ID (Key22) — int — Foreign key → Projecrt manager.employee ID — NOT NULL

Work category (Untitled4)

  • work no (Key3) — int — Primary key — NOT NULL
  • project no (Key) — int — Foreign key → Project.project no — NOT NULL
  • employee ID (Key2) — int — Foreign key → Projecrt manager.employee ID — NOT NULL