ex_7

Tables (6)

ABC DEVELOPMENT CORP (Untitled)

  • CorpId (Key) — char(12) — Primary key — NOT NULL

LOAN (Untitled6)

  • LoanId (Key) — char(8) — Primary key — NOT NULL
  • ProjectNo (Key2) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
  • PMId (Key22) — char(8) — Foreign key → PROJECT.PMId — NOT NULL
  • ProjectNo (Key222) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
  • numbers (Field) — char(6)
  • paymentAmount (Field2) — char(6)

PM (Untitled3)

  • PMId (Key) — char(8) — Primary key — NOT NULL
  • ProjectNo (Key2) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
  • PMId (Key22) — char(8) — Foreign key → PROJECT.PMId — NOT NULL
  • ProjectNo (Key222) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
  • PMName (Field) — char(4)

PROJECT (Untitled2)

  • ProjectNo (Key) — char(8) — Primary key — NOT NULL
  • PMId (Key2) — char(8) — Foreign key → PM.PMId — NOT NULL
  • ProjectNo (Key22) — char(8) — Foreign key → PM.ProjectNo — NOT NULL
  • CorpId (Key3) — char(12) — Foreign key → ABC DEVELOPMENT CORP.CorpId — NOT NULL

SPECIALIZATION (Untitled5)

  • SpecialId (Key) — char(8) — Primary key — NOT NULL
  • heating (Field) — char(4)
  • plumbing (Field2) — char(4)
  • SubId (Key2) — char(8) — Foreign key → SUBCONTRACTOR.SubId — NOT NULL

SUBCONTRACTOR (Untitled4)

  • SubId (Key) — char(8) — Primary key — NOT NULL
  • ProjectNo (Key2) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
  • PMId (Key22) — char(8) — Foreign key → PROJECT.PMId — NOT NULL
  • ProjectNo (Key222) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
  • CorpId (Key3) — char(12) — Foreign key → ABC DEVELOPMENT CORP.CorpId — NOT NULL