| id |
int(11)
|
|
|
|
| ref_no |
varchar(255)
|
latin1_swedish_ci
|
|
|
| app_date |
date
|
|
|
|
| effective_date |
date
|
|
|
|
| project_id |
int(11)
|
|
|
|
| projectName |
varchar(255)
|
latin1_swedish_ci
|
|
|
| projectLoc |
varchar(255)
|
latin1_swedish_ci
|
|
|
| resumeNo |
varchar(100)
|
latin1_swedish_ci
|
|
|
| suspensionOrderNo |
varchar(100)
|
latin1_swedish_ci
|
|
|
| contractor_id |
int(11)
|
|
|
|
| contractor |
varchar(255)
|
latin1_swedish_ci
|
|
|
| contract_type |
varchar(100)
|
latin1_swedish_ci
|
|
|
| daysUsedtoDate |
varchar(11)
|
latin1_swedish_ci
|
|
|
| revisedDueDate |
date
|
|
|
|
| NTPDate |
date
|
|
|
|
| ContractDate |
date
|
|
|
|
| ContractDuration |
varchar(100)
|
latin1_swedish_ci
|
|
|
| days_remaining |
varchar(100)
|
latin1_swedish_ci
|
|
|
| Subject |
text
|
latin1_swedish_ci
|
|
|
| Remarks |
text
|
latin1_swedish_ci
|
|
|
| issue_by |
int(11)
|
|
|
|
| project_in_charge |
varchar(255)
|
latin1_swedish_ci
|
|
|
| project_in_chargeID |
int(11)
|
|
|
|
| stat |
varchar(100)
|
latin1_swedish_ci
|
|
|
| ts |
timestamp
|
|
|
|