ABC

Tables (6)

Hire (Untitled6)

  • pjCode (Key2) — char(10) — Foreign key → Project.pjCode — NOT NULL
  • subCode (Key3) — char(10) — Foreign key → Subcontractor.subCode — NOT NULL
  • friendliness (Field) — int(4)
  • LimNumSub (Field2) — int(3)
  • HireBudget (Field3) — float(10)
  • HireInfo (Field4) — char(20)

Loan (Untitled5)

  • loanCode (Key) — char(10) — Primary key — NOT NULL
  • loanAmount (Field) — int(15)
  • loanPayment (Field2) — float(10)
  • pjID (Key2) — char(10) — Foreign key → Project.pjCode — NOT NULL

PM (Untitled)

  • pmCode (Key) — Char(10) — Primary key — NOT NULL
  • pmName (Field) — Char(10)
  • pmDpt (Field2) — char(10)
  • pmTitle (Field3) — char(10)

Project (Untitled2)

  • pjCode (Key) — char(10) — Primary key — NOT NULL
  • pmCode (Key2) — Char(10) — Foreign key → PM.pmCode — NOT NULL
  • pjCategory (Field) — char(10)
  • pjName (Field2) — char(10)
  • pjDate (Field3) — date
  • PjEmployee (Field4) — char(10)
  • pjGoal (Field5) — char(10)

Specialization (Untitled4)

  • Code (Key) — char(10) — Primary key — NOT NULL
  • speName (Field) — char(10)
  • speCategory (Field2) — char(6)
  • minSubAmount (Field3) — int(3)

Subcontractor (Untitled3)

  • subCode (Key) — char(10) — Primary key — NOT NULL
  • subName (Field2) — char(10)
  • subPhone (Field3) — char(10)
  • subEmail (Field4) — char(10)
  • speCode (Key2) — char(10) — Foreign key → Specialization.Code — NOT NULL