| permit_no |
int(11)
|
|
|
|
| permit_code |
varchar(100)
|
latin1_swedish_ci
|
|
|
| application_no |
int(11)
|
|
|
|
| issued_status |
varchar(255)
|
latin1_swedish_ci
|
|
|
| date_issued |
date
|
|
|
|
| bldg_official_id |
varchar(255)
|
latin1_swedish_ci
|
|
|
| bldg_official_name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| bldg_permit_no |
varchar(100)
|
latin1_swedish_ci
|
|
|
| or_no |
varchar(100)
|
latin1_swedish_ci
|
|
|
| or_date |
date
|
|
|
|
| applicant_name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| bp_id |
varchar(255)
|
latin1_swedish_ci
|
|
|
| issued_to |
varchar(255)
|
latin1_swedish_ci
|
|
|
| bldg_name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| issued_by |
varchar(255)
|
latin1_swedish_ci
|
|
|
| issued_id |
int(11)
|
|
|
|
| date_save |
date
|
|
|
|
| bns_id |
int(11)
|
|
|
|
| project_id |
int(11)
|
|
|
|
| project_name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| period_of |
varchar(255)
|
latin1_swedish_ci
|
|
|
| days_ |
varchar(25)
|
latin1_swedish_ci
|
|
|
| date_ |
date
|
|
|
|