Ex 7

Tables (5)

Associated (Untitled3)

  • ProjectID (Key) — Char(20) — Foreign key → Project.ProjectID — NOT NULL
  • HeatingID (Key2) — Char(20) — Foreign key → Subcontractor.HeatingID — NOT NULL
  • PlumbingID (Key22) — Char(20) — Foreign key → Subcontractor.PlumbingID — NOT NULL

Loan (Untitled5)

  • loanID (Key) — Char(20) — Primary key — NOT NULL
  • Amount (Field) — Int
  • PaymentAmount (Field2) — Int
  • ProjectID (Key2) — Char(20) — Foreign key → Project.ProjectID — NOT NULL

PM (Untitled2)

  • PMID (Key) — Char(20) — Primary key — NOT NULL
  • EmployeNumber (Field) — Int
  • Name (Field2) — Char(20)

Project (Untitled)

  • ProjectID (Key) — Char(20) — Primary key — NOT NULL
  • ProjectInfor1 (Field) — Char(20)
  • ProjectInfor2 (Field2) — Char(20)
  • PMID (Key2) — Char(20) — Foreign key → PM.PMID — NOT NULL

Subcontractor (Untitled4)

  • HeatingID (Key) — Char(20) — Primary key — NOT NULL
  • PlumbingID (Key2) — Char(20) — Primary key — NOT NULL