| id |
int(11)
|
|
|
|
| evaluation_id |
int(11)
|
|
|
|
| app_date |
date
|
|
|
|
| refno |
varchar(244)
|
latin1_swedish_ci
|
|
|
| appno |
varchar(255)
|
latin1_swedish_ci
|
|
|
| projID |
int(11)
|
|
|
|
| projname |
varchar(255)
|
latin1_swedish_ci
|
|
|
| projloc |
varchar(255)
|
latin1_swedish_ci
|
|
|
| to_id |
int(11)
|
|
|
|
| to_name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| to_position |
varchar(255)
|
latin1_swedish_ci
|
|
|
| total_area |
varchar(255)
|
latin1_swedish_ci
|
|
|
| total_lots |
varchar(255)
|
latin1_swedish_ci
|
|
|
| applicantID |
int(11)
|
|
|
|
| applicantName |
varchar(255)
|
latin1_swedish_ci
|
|
|
| app_address |
varchar(255)
|
latin1_swedish_ci
|
|
|
| app_tellno |
varchar(255)
|
latin1_swedish_ci
|
|
|
| res_no |
varchar(255)
|
latin1_swedish_ci
|
|
|
| approveby |
int(11)
|
|
|
|
| approve_by |
int(11)
|
|
|
|
| issue_by |
int(11)
|
|
|
|
| issued_date |
date
|
|
|
|
| approve_date |
date
|
|
|
|
| docno |
varchar(255)
|
latin1_swedish_ci
|
|
|
| pageno |
varchar(255)
|
latin1_swedish_ci
|
|
|
| bookno |
varchar(255)
|
latin1_swedish_ci
|
|
|
| seriesof |
varchar(255)
|
latin1_swedish_ci
|
|
|
| remarks |
varchar(500)
|
latin1_swedish_ci
|
|
|
| rightoverland |
varchar(500)
|
latin1_swedish_ci
|
|
|
| clearances |
varchar(500)
|
latin1_swedish_ci
|
|
|
| zone_class |
varchar(500)
|
latin1_swedish_ci
|
|
|
| proj_class |
varchar(500)
|
latin1_swedish_ci
|
|
|
| vicinity |
varchar(500)
|
latin1_swedish_ci
|
|
|
| evaluation |
varchar(500)
|
latin1_swedish_ci
|
|
|
| decision |
varchar(500)
|
latin1_swedish_ci
|
|
|
| conditions1 |
varchar(500)
|
latin1_swedish_ci
|
|
|
| conditions2 |
varchar(500)
|
latin1_swedish_ci
|
|
|
| conditions3 |
varchar(500)
|
latin1_swedish_ci
|
|
|
| conditions4 |
varchar(500)
|
latin1_swedish_ci
|
|
|
| subd_approved |
int(11)
|
|
|
|
| stat |
varchar(255)
|
latin1_swedish_ci
|
|
|
| timestamp |
timestamp
|
|
|
|