ex7

Tables (4)

LOAN (Untitled4)

  • loanID (Key) — char(10) — Primary key — NOT NULL
  • amount (Field) — char(10)
  • paymentAmount (Field2) — char(10)
  • projectNo (Key2) — char(10) — Foreign key → PROJECT.projectNo — NOT NULL

MANAGER (Untitled2)

  • managerID (Key) — char(10) — Primary key — NOT NULL
  • managerPhone (Field) — char(10)
  • managerAddress (Field2) — char(20)

PROJECT (Untitled)

  • projectNo (Key) — char(10) — Primary key — NOT NULL
  • projectCode (Field) — char(10)
  • projectName (Field2) — char(10)
  • projectDate (Field3)
  • ID (Key2) — char(10) — Foreign key → SUBCONTRACTOR.ID — NOT NULL
  • managerID (Key3) — char(10) — Foreign key → MANAGER.managerID — NOT NULL

SUBCONTRACTOR (Untitled3)

  • ID (Key) — char(10) — Primary key — NOT NULL
  • No (Field) — char(10)
  • lineOfWork (Field2) — char(10)
  • managerID (Key2) — char(10) — Foreign key → MANAGER.managerID — NOT NULL