| application_no |
int(11)
|
|
|
|
| application_code |
varchar(20)
|
latin1_swedish_ci
|
|
|
| trans_date |
date
|
|
|
|
| date_filed |
date
|
|
|
|
| date_issued |
date
|
|
|
|
| applicant_id |
int(11)
|
|
|
|
| applicant_address |
varchar(200)
|
latin1_swedish_ci
|
|
|
| applicant_tel_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| name_of_project |
varchar(100)
|
latin1_swedish_ci
|
|
|
| location_st |
varchar(200)
|
latin1_swedish_ci
|
|
|
| for_sale |
varchar(20)
|
latin1_swedish_ci
|
|
|
| subdivision_among_heirs |
varchar(20)
|
latin1_swedish_ci
|
|
|
| others |
varchar(200)
|
latin1_swedish_ci
|
|
|
| decision |
varchar(100)
|
latin1_swedish_ci
|
|
|
| remarks |
varchar(100)
|
latin1_swedish_ci
|
|
|
| condition |
text
|
latin1_swedish_ci
|
|
|
| location_brgy_id |
int(11)
|
|
|
|
| applicant_type |
varchar(20)
|
latin1_swedish_ci
|
|
|
| tct_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| area |
double
|
|
|
|
| no_of_lots |
int(11)
|
|
|
|
| no_of_blocks |
int(11)
|
|
|
|
| preliminary_fee |
double
|
|
|
|
| final_fee |
double
|
|
|
|
| inspection_fee |
double
|
|
|
|
| total_fee |
double
|
|
|
|
| application_count |
varchar(50)
|
latin1_swedish_ci
|
|
|
| app_status |
varchar(10)
|
latin1_swedish_ci
|
|
|
| cad_lot_no |
varchar(100)
|
latin1_swedish_ci
|
|
|
| location_brgy |
varchar(150)
|
latin1_swedish_ci
|
|
|
| dept_head |
int(11)
|
|
|
|
| or_no |
varchar(100)
|
latin1_swedish_ci
|
|
|
| or_date |
date
|
|
|
|
| savedate |
timestamp
|
|
|
|
| land_use |
varchar(200)
|
latin1_swedish_ci
|
|
|
| status |
varchar(50)
|
latin1_swedish_ci
|
|
|