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