| Table | Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| any_lu_parks | id | int(10) unsigned | NO | PRI | auto_increment | |
| any_lu_parks | name | varchar(100) | NO | |||
| any_lu_parks | address | varchar(100) | NO | |||
| any_lu_parks | city | varchar(45) | YES | Canton | ||
| any_lu_parks | state | varchar(5) | YES | OH | ||
| any_lu_parks | zip | varchar(15) | YES | |||
| any_lu_parks | notes | varchar(200) | YES | |||
| any_lu_str_dir | id | int(10) unsigned | NO | PRI | auto_increment | |
| any_lu_str_dir | name | varchar(45) | NO | |||
| any_lu_str_type | id | int(10) unsigned | NO | PRI | auto_increment | |
| any_lu_str_type | name | varchar(45) | NO | |||
| any_prop_use | id | int(10) unsigned | NO | PRI | auto_increment | |
| any_prop_use | name | varchar(45) | NO | |||
| any_systeminfo | id | int(10) unsigned | NO | PRI | auto_increment | |
| any_systeminfo | dept | varchar(100) | NO | |||
| any_systeminfo | track_role | varchar(100) | NO | |||
| any_systeminfo | track_dept | varchar(100) | NO | |||
| any_systeminfo | track_user | varchar(100) | NO | |||
| city_control | id | int(10) unsigned | NO | PRI | auto_increment | |
| city_control | invoice_no | varchar(45) | NO | |||
| city_control | year | varchar(4) | NO | |||
| city_control | reciept_no | varchar(45) | NO | |||
| city_control | permit_no | varchar(45) | NO | |||
| city_export | id | int(10) unsigned | NO | PRI | auto_increment | |
| city_export | dept | varchar(45) | NO | |||
| city_export | invoice_no | varchar(45) | NO | |||
| city_export | code | varchar(45) | NO | |||
| city_export | amount | decimal(10,2) | NO | 0.00 | ||
| city_export | receipt_date | datetime | NO | |||
| city_export | reciept_no | varchar(45) | NO | |||
| city_export | payment_method | varchar(45) | NO | |||
| city_export | receipt_amount | decimal(10,2) | NO | |||
| city_export | item | varchar(100) | NO | |||
| city_export | username | varchar(100) | NO | |||
| city_export | user_date | datetime | NO | |||
| city_invoices | id | int(10) unsigned | NO | PRI | auto_increment | |
| city_invoices | invoice_no | varchar(20) | NO | 0 | ||
| city_invoices | invoice_name | varchar(100) | NO | |||
| city_invoices | item | varchar(100) | NO | |||
| city_invoices | dept | varchar(45) | NO | |||
| city_invoices | bill_date | datetime | YES | |||
| city_invoices | due_date | datetime | YES | |||
| city_invoices | invoice_total | decimal(10,2) | YES | |||
| city_invoices | invoice_owed | decimal(10,2) | YES | |||
| city_invoices | type | varchar(45) | YES | |||
| city_log | id | int(10) unsigned | NO | PRI | auto_increment | |
| city_log | invoice_no | varchar(45) | NO | |||
| city_log | date | datetime | NO | |||
| city_log | user | varchar(100) | NO | |||
| city_log | dept | varchar(45) | NO | |||
| city_log | log | mediumtext | NO | |||
| city_lu_export | id | int(10) unsigned | NO | PRI | auto_increment | |
| city_lu_export | dept | varchar(45) | NO | |||
| city_lu_export | mb_name | varchar(100) | NO | |||
| city_lu_export | nw_code | varchar(45) | NO | |||
| city_lu_export | nw_name | varchar(100) | NO | |||
| city_lu_lnreturn | id | int(10) unsigned | NO | PRI | auto_increment | |
| city_lu_lnreturn | date | datetime | YES | |||
| city_lu_lnreturn | lnkey | mediumtext | YES | |||
| city_lu_lnreturn | lnval | mediumtext | YES | |||
| city_lu_lnreturn | information | mediumtext | YES | |||
| city_payments | id | int(10) unsigned | NO | PRI | auto_increment | |
| city_payments | invoice_no | varchar(45) | NO | |||
| city_payments | dept | varchar(45) | NO | |||
| city_payments | date | datetime | NO | |||
| city_payments | amount | decimal(10,2) | NO | 0.00 | ||
| city_payments | pay_method | varchar(45) | NO | |||
| city_payments | card_type | varchar(45) | YES | |||
| city_payments | check_no | varchar(45) | YES | |||
| city_payments | ln_client_order | varchar(45) | YES | |||
| city_payments | ln_order | varchar(45) | YES | |||
| city_payments | source | varchar(45) | YES | |||
| city_payments | verified | varchar(45) | YES | |||
| city_payments | reciept_no | varchar(45) | YES | |||
| city_payments | status | varchar(45) | NO | |||
| city_refer_invoices | id | int(10) unsigned | NO | PRI | auto_increment | |
| city_refer_invoices | invoice_no | varchar(20) | NO | 0 | ||
| city_refer_invoices | invoice_name | varchar(100) | NO | X | ||
| city_refer_invoices | rfr_sign | varchar(100) | NO | X | ||
| city_refer_invoices | dept | varchar(45) | NO | X | ||
| city_refer_invoices | refer_date | datetime | YES | |||
| city_refer_invoices | law_reason | mediumtext | YES | |||
| code_invoices | id | int(10) unsigned | NO | PRI | auto_increment | |
| code_invoices | invoice_no | varchar(20) | NO | |||
| code_invoices | owner | varchar(50) | YES | |||
| code_invoices | parcel | varchar(10) | YES | |||
| code_invoices | lot | varchar(35) | YES | |||
| code_invoices | enter_date | date | YES | |||
| code_invoices | sentto_name | varchar(50) | YES | |||
| code_invoices | sentto_addr | varchar(50) | YES | |||
| code_invoices | sentto_city | varchar(50) | YES | |||
| code_invoices | sentto_state | varchar(50) | YES | |||
| code_invoices | sentto_zip | varchar(11) | YES | |||
| code_invoices | location | varchar(40) | YES | |||
| code_invoices | total_cost | decimal(10,2) | YES | |||
| code_invoices | entered_by | varchar(50) | YES | |||
| code_invoices | due_date | date | YES | |||
| code_invoices | work_date | date | YES | |||
| code_invoices | terms | varchar(20) | YES | |||
| code_invoices | type | varchar(45) | YES | |||
| code_invoices | lien | date | YES | |||
| code_invoices | invsent | date | YES | |||
| code_invoices | certsent | date | YES | |||
| code_invoices | unit_price | decimal(10,2) | YES | |||
| code_invoices | comments | mediumtext | YES | |||
| code_invoices_detail | id | int(10) unsigned | NO | PRI | auto_increment | |
| code_invoices_detail | invoice_no | varchar(45) | NO | |||
| code_invoices_detail | item | varchar(100) | NO | |||
| code_invoices_detail | rate | decimal(10,2) | NO | 0.00 | ||
| code_invoices_detail | qty | decimal(10,2) | NO | 0.00 | ||
| code_invoices_detail | total | decimal(10,2) | NO | 0.00 | ||
| code_invoices_detail | comments | mediumtext | YES | |||
| code_log | id | int(10) unsigned | NO | PRI | auto_increment | |
| code_log | invoice_no | varchar(45) | NO | |||
| code_log | date | datetime | NO | |||
| code_log | user | varchar(100) | NO | |||
| code_log | dept | varchar(45) | NO | |||
| code_log | log | mediumtext | NO | |||
| code_lu_items | id | int(10) unsigned | NO | PRI | auto_increment | |
| code_lu_items | name | varchar(100) | YES | |||
| code_lu_items | rate | decimal(10,2) | YES | |||
| code_lu_items | notes | mediumtext | YES | |||
| code_lu_items | reason | varchar(45) | YES | |||
| engineer_app_row | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_app_row | invoice_no | varchar(20) | YES | |||
| engineer_app_row | permit_no | varchar(20) | YES | |||
| engineer_app_row | date_recd | varchar(45) | NO | |||
| engineer_app_row | permit_type | varchar(45) | NO | |||
| engineer_app_row | site_info | varchar(200) | YES | |||
| engineer_app_row | app_type_nd | varchar(5) | YES | |||
| engineer_app_row | app_type_sda | varchar(5) | YES | |||
| engineer_app_row | app_type_c | varchar(5) | YES | |||
| engineer_app_row | app_type_uc | varchar(5) | YES | |||
| engineer_app_row | app_type_ue | varchar(5) | YES | |||
| engineer_app_row | app_type_ug | varchar(5) | YES | |||
| engineer_app_row | app_type_us | varchar(5) | YES | |||
| engineer_app_row | app_type_uw | varchar(5) | YES | |||
| engineer_app_row | app_type_o | varchar(5) | YES | |||
| engineer_app_row | app_type_o_list | varchar(200) | YES | |||
| engineer_app_row | project_id | varchar(60) | YES | |||
| engineer_app_row | city_plan | varchar(60) | YES | |||
| engineer_app_row | owner_first | varchar(60) | YES | |||
| engineer_app_row | owner_last | varchar(60) | YES | |||
| engineer_app_row | owner_business | varchar(100) | YES | |||
| engineer_app_row | owner_phone | varchar(60) | YES | |||
| engineer_app_row | owner_email | varchar(100) | YES | |||
| engineer_app_row | rep_first | varchar(60) | YES | |||
| engineer_app_row | rep_last | varchar(60) | YES | |||
| engineer_app_row | rep_phone | varchar(60) | YES | |||
| engineer_app_row | rep_business | varchar(100) | YES | |||
| engineer_app_row | rep_email | varchar(100) | YES | |||
| engineer_app_row | rep_house_no | varchar(60) | YES | |||
| engineer_app_row | rep_street | varchar(60) | YES | |||
| engineer_app_row | rep_street_type | varchar(60) | NO | |||
| engineer_app_row | rep_quadrant | varchar(60) | YES | |||
| engineer_app_row | rep_city | varchar(50) | YES | |||
| engineer_app_row | rep_st | varchar(30) | YES | |||
| engineer_app_row | rep_zip | varchar(10) | YES | |||
| engineer_app_row | cont_first | varchar(60) | YES | |||
| engineer_app_row | cont_last | varchar(60) | YES | |||
| engineer_app_row | cont_phone | varchar(60) | YES | |||
| engineer_app_row | cont_business | varchar(100) | YES | |||
| engineer_app_row | cont_email | varchar(100) | YES | |||
| engineer_app_row | cont_house_no | varchar(60) | YES | |||
| engineer_app_row | cont_street | varchar(60) | YES | |||
| engineer_app_row | cont_street_type | varchar(60) | NO | |||
| engineer_app_row | cont_quadrant | varchar(60) | YES | |||
| engineer_app_row | cont_city | varchar(50) | YES | |||
| engineer_app_row | cont_st | varchar(30) | YES | |||
| engineer_app_row | cont_zip | varchar(10) | YES | |||
| engineer_app_row | work_desc | mediumtext | YES | |||
| engineer_app_row | date_start | date | YES | |||
| engineer_app_row | date_end | date | YES | |||
| engineer_app_row | date_duration | varchar(45) | YES | |||
| engineer_app_row | project_duration | varchar(45) | YES | |||
| engineer_app_row | app_agree | varchar(5) | YES | |||
| engineer_app_row | app_phone | varchar(60) | YES | |||
| engineer_app_row | app_date | datetime | YES | |||
| engineer_app_row | app_sign | varchar(100) | YES | |||
| engineer_app_row | te_signed | varchar(100) | YES | |||
| engineer_app_row | te_date | datetime | YES | |||
| engineer_app_row | ce_signed | varchar(100) | YES | |||
| engineer_app_row | ce_date | datetime | YES | |||
| engineer_app_row | dir_signed | varchar(100) | YES | |||
| engineer_app_row | dir_date | datetime | YES | |||
| engineer_app_row | reject_reason | mediumtext | YES | |||
| engineer_app_row | city_notes | mediumtext | YES | |||
| engineer_app_row | upload_file_name | varchar(45) | YES | |||
| engineer_app_row | upload_file | longblob | YES | |||
| engineer_app_sewerconnect | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_app_sewerconnect | invoice_no | varchar(20) | YES | |||
| engineer_app_sewerconnect | permit_no | varchar(20) | YES | |||
| engineer_app_sewerconnect | permit_type | varchar(45) | YES | |||
| engineer_app_sewerconnect | site_house_no | varchar(60) | YES | |||
| engineer_app_sewerconnect | site_street | varchar(60) | YES | |||
| engineer_app_sewerconnect | site_street_type | varchar(60) | YES | |||
| engineer_app_sewerconnect | site_quadrant | varchar(60) | YES | |||
| engineer_app_sewerconnect | site_lot_no | varchar(60) | YES | |||
| engineer_app_sewerconnect | site_parcel_no | varchar(45) | YES | |||
| engineer_app_sewerconnect | site_subdivision | varchar(60) | YES | |||
| engineer_app_sewerconnect | site_property_use | varchar(60) | YES | |||
| engineer_app_sewerconnect | site_no_units | varchar(60) | YES | |||
| engineer_app_sewerconnect | owner_first | varchar(60) | YES | |||
| engineer_app_sewerconnect | owner_last | varchar(60) | YES | |||
| engineer_app_sewerconnect | contact_name | varchar(60) | YES | |||
| engineer_app_sewerconnect | contact_phone | varchar(60) | YES | |||
| engineer_app_sewerconnect | contact_email | varchar(100) | YES | |||
| engineer_app_sewerconnect | business_name | varchar(60) | YES | |||
| engineer_app_sewerconnect | business_type | varchar(60) | YES | |||
| engineer_app_sewerconnect | app_contractor | varchar(60) | YES | |||
| engineer_app_sewerconnect | app_date | datetime | YES | |||
| engineer_app_sewerconnect | app_sign | varchar(100) | YES | |||
| engineer_app_sewerconnect | wrf_reason | varchar(60) | YES | |||
| engineer_app_sewerconnect | wrf_estgdfeff | varchar(60) | YES | |||
| engineer_app_sewerconnect | wrf_auth_date | datetime | YES | |||
| engineer_app_sewerconnect | wrf_auth_sign | varchar(60) | YES | |||
| engineer_app_sewerconnect | wrf_remarks | mediumtext | YES | |||
| engineer_app_sewerconnect | sewer_type_nw | varchar(5) | YES | |||
| engineer_app_sewerconnect | sewer_type_rc | varchar(5) | YES | |||
| engineer_app_sewerconnect | sewer_type_rp | varchar(5) | YES | |||
| engineer_app_sewerconnect | sewer_type_st | varchar(5) | YES | |||
| engineer_app_sewerconnect | sewer_type_sa | varchar(5) | YES | |||
| engineer_app_sewerconnect | sewer_main_loc | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_main_size_ft | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | sewer_main_size_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | sewer_main_type | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_main_deep_ft | int(10) unsigned | YES | 0 | ||
| engineer_app_sewerconnect | sewer_main_deep_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | sewer_wye_loc_ft | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | sewer_wye_loc_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | sewer_wye_measurefrom | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_lat_loc_ft | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | sewer_lat_loc_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | sewer_lat_loc_deep | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_lat_loc_deep_ft | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | sewer_lat_loc_deep_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | sewer_conn_bk | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_conn_pg | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_asbilt_bk | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_asbilt_pg | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_atlas | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_storm_cbasin_loc | varchar(60) | YES | |||
| engineer_app_sewerconnect | sewer_xref_permit_no | varchar(60) | YES | |||
| engineer_app_sewerconnect | date_work_sched | date | YES | |||
| engineer_app_sewerconnect | date_work_start | date | YES | |||
| engineer_app_sewerconnect | date_work_compl | date | YES | |||
| engineer_app_sewerconnect | te_signed | varchar(100) | YES | |||
| engineer_app_sewerconnect | te_date | datetime | YES | |||
| engineer_app_sewerconnect | ce_signed | varchar(100) | YES | |||
| engineer_app_sewerconnect | ce_date | datetime | YES | |||
| engineer_app_sewerconnect | dir_signed | varchar(100) | YES | |||
| engineer_app_sewerconnect | dir_date | datetime | YES | |||
| engineer_app_sewerconnect | reject_reason | mediumtext | YES | |||
| engineer_app_sewerconnect | upload_file_name | varchar(45) | YES | |||
| engineer_app_sewerconnect | upload_file | longblob | YES | |||
| engineer_app_sewerconnect | ci_address | varchar(100) | YES | |||
| engineer_app_sewerconnect | ci_work_start | date | YES | |||
| engineer_app_sewerconnect | ci_work_compl | date | YES | |||
| engineer_app_sewerconnect | ci_road_compl | date | YES | |||
| engineer_app_sewerconnect | ci_road_permit | varchar(60) | YES | |||
| engineer_app_sewerconnect | ci_curb_compl | date | YES | |||
| engineer_app_sewerconnect | ci_curb_permit | varchar(60) | YES | |||
| engineer_app_sewerconnect | ci_walk_compl | date | YES | |||
| engineer_app_sewerconnect | ci_walk_permit | varchar(60) | YES | |||
| engineer_app_sewerconnect | ci_main_loc | varchar(60) | YES | |||
| engineer_app_sewerconnect | ci_main_size_ft | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_main_size_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_main_type | varchar(60) | YES | |||
| engineer_app_sewerconnect | ci_main_deep_ft | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_main_deep_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_wye_loc_ft | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_wye_loc_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_wye_measurefrom | varchar(60) | YES | |||
| engineer_app_sewerconnect | ci_lat_loc_ft | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_lat_loc_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_lat_loc_deep_ft | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_lat_loc_deep_in | int(10) unsigned | YES | |||
| engineer_app_sewerconnect | ci_storm_cbasin_loc | varchar(60) | YES | |||
| engineer_app_sewerconnect | ci_upload | longblob | YES | |||
| engineer_app_smallcell | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_app_smallcell | invoice_no | varchar(20) | YES | |||
| engineer_app_smallcell | permit_no | varchar(20) | NO | |||
| engineer_app_smallcell | permit_type | varchar(45) | NO | |||
| engineer_app_smallcell | date_recd | varchar(45) | NO | |||
| engineer_app_smallcell | app_type_mp | varchar(5) | YES | |||
| engineer_app_smallcell | app_type_sp | varchar(5) | YES | |||
| engineer_app_smallcell | app_type_ws | varchar(5) | YES | |||
| engineer_app_smallcell | app_type_co | varchar(5) | YES | |||
| engineer_app_smallcell | owner_business | varchar(100) | YES | |||
| engineer_app_smallcell | owner_first | varchar(60) | YES | |||
| engineer_app_smallcell | owner_last | varchar(60) | YES | |||
| engineer_app_smallcell | owner_house_no | varchar(60) | YES | |||
| engineer_app_smallcell | owner_street | varchar(60) | YES | |||
| engineer_app_smallcell | owner_street_type | varchar(60) | YES | |||
| engineer_app_smallcell | owner_quadrant | varchar(60) | YES | |||
| engineer_app_smallcell | owner_city | varchar(50) | YES | |||
| engineer_app_smallcell | owner_st | varchar(30) | YES | |||
| engineer_app_smallcell | owner_zip | varchar(10) | YES | |||
| engineer_app_smallcell | owner_phone | varchar(60) | YES | |||
| engineer_app_smallcell | owner_email | varchar(100) | YES | |||
| engineer_app_smallcell | rep_business | varchar(100) | YES | |||
| engineer_app_smallcell | rep_first | varchar(60) | YES | |||
| engineer_app_smallcell | rep_last | varchar(60) | YES | |||
| engineer_app_smallcell | rep_house_no | varchar(60) | YES | |||
| engineer_app_smallcell | rep_street | varchar(60) | YES | |||
| engineer_app_smallcell | rep_street_type | varchar(60) | NO | |||
| engineer_app_smallcell | rep_quadrant | varchar(60) | YES | |||
| engineer_app_smallcell | rep_city | varchar(50) | YES | |||
| engineer_app_smallcell | rep_st | varchar(30) | YES | |||
| engineer_app_smallcell | rep_zip | varchar(10) | YES | |||
| engineer_app_smallcell | rep_phone | varchar(60) | YES | |||
| engineer_app_smallcell | rep_email | varchar(100) | YES | |||
| engineer_app_smallcell | scf_project_name | varchar(60) | YES | |||
| engineer_app_smallcell | scf_project_number | varchar(60) | YES | |||
| engineer_app_smallcell | scf_project_location | varchar(200) | YES | |||
| engineer_app_smallcell | antenna_id | varchar(30) | YES | |||
| engineer_app_smallcell | pal_northing | varchar(60) | YES | |||
| engineer_app_smallcell | pal_easting | varchar(60) | YES | |||
| engineer_app_smallcell | pal_latitude | varchar(60) | YES | |||
| engineer_app_smallcell | pal_longitude | varchar(45) | YES | |||
| engineer_app_smallcell | pal_elevation | varchar(60) | YES | |||
| engineer_app_smallcell | pal_navd | varchar(60) | YES | |||
| engineer_app_smallcell | app_sign | varchar(100) | YES | |||
| engineer_app_smallcell | app_date | datetime | YES | |||
| engineer_app_smallcell | te_signed | varchar(100) | YES | |||
| engineer_app_smallcell | te_date | datetime | YES | |||
| engineer_app_smallcell | ce_signed | varchar(100) | YES | |||
| engineer_app_smallcell | ce_date | datetime | YES | |||
| engineer_app_smallcell | dir_signed | varchar(100) | YES | |||
| engineer_app_smallcell | dir_date | datetime | YES | |||
| engineer_app_smallcell | reject_reason | mediumtext | YES | |||
| engineer_app_smallcell | datafile_rfca_name | varchar(45) | YES | |||
| engineer_app_smallcell | datafile_rfca | longblob | YES | |||
| engineer_app_smallcell | datafile_ralpr_name | varchar(45) | YES | |||
| engineer_app_smallcell | datafile_ralpr | longblob | YES | |||
| engineer_app_smallcell | datafile_aowss_name | varchar(45) | YES | |||
| engineer_app_smallcell | datafile_aowss | longblob | YES | |||
| engineer_app_smallcell | datafile_spsc_name | varchar(45) | YES | |||
| engineer_app_smallcell | datafile_spsc | longblob | YES | |||
| engineer_app_smallcell | datafile_ees_name | varchar(45) | YES | |||
| engineer_app_smallcell | datafile_ees | longblob | YES | |||
| engineer_app_smallcell | datafile_soi_name | varchar(45) | YES | |||
| engineer_app_smallcell | datafile_soi | longblob | YES | |||
| engineer_app_smallcell | datafile_borp_name | varchar(45) | YES | |||
| engineer_app_smallcell | datafile_borp | longblob | YES | |||
| engineer_app_spechaul | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_app_spechaul | invoice_no | varchar(20) | YES | |||
| engineer_app_spechaul | permit_no | varchar(20) | NO | |||
| engineer_app_spechaul | date_recd | datetime | YES | |||
| engineer_app_spechaul | bond_no | varchar(45) | YES | |||
| engineer_app_spechaul | bond_code | varchar(45) | YES | |||
| engineer_app_spechaul | insurance_bond | varchar(1) | YES | |||
| engineer_app_spechaul | bond_amount | varchar(30) | YES | 0.00 | ||
| engineer_app_spechaul | app_name | varchar(100) | YES | |||
| engineer_app_spechaul | app_addr | varchar(100) | YES | |||
| engineer_app_spechaul | app_city | varchar(50) | YES | |||
| engineer_app_spechaul | app_state | varchar(30) | YES | |||
| engineer_app_spechaul | app_zip | varchar(10) | YES | |||
| engineer_app_spechaul | app_email | varchar(100) | YES | |||
| engineer_app_spechaul | app_phone | varchar(15) | YES | |||
| engineer_app_spechaul | app_fax | varchar(15) | YES | |||
| engineer_app_spechaul | legal_weights | varchar(1) | YES | |||
| engineer_app_spechaul | various_trailers | varchar(1) | YES | |||
| engineer_app_spechaul | veh_power_make | varchar(100) | YES | |||
| engineer_app_spechaul | veh_power_axle | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | veh_power_license | varchar(10) | YES | |||
| engineer_app_spechaul | veh_power_state | varchar(30) | YES | |||
| engineer_app_spechaul | veh_t1_make | varchar(100) | YES | |||
| engineer_app_spechaul | veh_t1_axle | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | veh_t1_license | varchar(10) | YES | |||
| engineer_app_spechaul | veh_t1_state | varchar(30) | YES | |||
| engineer_app_spechaul | veh_t2_make | varchar(100) | YES | |||
| engineer_app_spechaul | veh_t2_axle | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | veh_t2_license | varchar(10) | YES | |||
| engineer_app_spechaul | veh_t2_state | varchar(30) | YES | |||
| engineer_app_spechaul | veh_t3_make | varchar(100) | YES | |||
| engineer_app_spechaul | veh_t3_axle | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | veh_t3_license | varchar(10) | YES | |||
| engineer_app_spechaul | veh_t3_state | varchar(30) | YES | |||
| engineer_app_spechaul | load_make | varchar(100) | YES | |||
| engineer_app_spechaul | load_model | varchar(100) | YES | |||
| engineer_app_spechaul | load_owner | varchar(100) | YES | |||
| engineer_app_spechaul | load_length_ft | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | load_length_in | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | load_width_ft | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | load_width_in | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | load_height_ft | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | load_height_in | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | load_weight | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | load_description | mediumtext | YES | |||
| engineer_app_spechaul | max_overall_length_ft | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_length_in | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_width_ft | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_width_in | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_height_ft | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_height_in | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_weight | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_deck_height_ft | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_deck_height_in | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_min_underclear_ft | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | max_overall_min_underclear_in | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | routing_from | varchar(100) | YES | |||
| engineer_app_spechaul | routing_to | varchar(100) | YES | |||
| engineer_app_spechaul | routing_path | mediumtext | YES | |||
| engineer_app_spechaul | routing_length | varchar(20) | YES | 0.00 | ||
| engineer_app_spechaul | date_start | date | YES | |||
| engineer_app_spechaul | date_end | date | YES | |||
| engineer_app_spechaul | permit_type | varchar(45) | YES | |||
| engineer_app_spechaul | app_sign | varchar(100) | YES | |||
| engineer_app_spechaul | app_date | datetime | YES | |||
| engineer_app_spechaul | te_signed | varchar(100) | YES | |||
| engineer_app_spechaul | te_date | datetime | YES | 0000-00-00 00:00:00 | ||
| engineer_app_spechaul | ce_need | varchar(1) | YES | |||
| engineer_app_spechaul | ce_signed | varchar(100) | YES | |||
| engineer_app_spechaul | ce_date | datetime | YES | |||
| engineer_app_spechaul | dir_signed | varchar(100) | YES | |||
| engineer_app_spechaul | dir_date | datetime | YES | |||
| engineer_app_spechaul | reject_reason | mediumtext | YES | |||
| engineer_app_spechaul | axle_number | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_1 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_1 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_1 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_1 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_1 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_1 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_2 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_2 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_2 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_2 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_2 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_2 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_3 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_3 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_3 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_3 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_3 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_3 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_4 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_4 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_4 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_4 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_4 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_4 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_5 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_5 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_5 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_5 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_5 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_5 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_6 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_6 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_6 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_6 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_6 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_6 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_7 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_7 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_7 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_7 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_7 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_7 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_8 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_8 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_8 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_8 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_8 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_8 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_9 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_9 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_9 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_9 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_9 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_9 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_10 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_10 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_10 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_10 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_10 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_10 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_11 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_11 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_11 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_11 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_11 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_11 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_12 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_12 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_12 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_12 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_12 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_12 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_13 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_13 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_13 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_13 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_13 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_13 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_14 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_14 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_14 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_14 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_14 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_14 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_15 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_15 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_15 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_15 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_15 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_15 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_16 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_16 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_16 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_16 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_16 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_16 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_17 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_17 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_17 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_17 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_17 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_17 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_18 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_18 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_18 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_18 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_18 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_18 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_19 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_19 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_19 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_19 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_19 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_19 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_20 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_20 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_20 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_20 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_20 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_20 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_21 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_21 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_21 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_21 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_ft_21 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_space_in_21 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_weight_22 | decimal(10,2) | YES | 0.00 | ||
| engineer_app_spechaul | axle_tire_no_22 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_ft_22 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_tire_wide_in_22 | int(10) unsigned | YES | 0 | ||
| engineer_app_spechaul | axle_total_weight | decimal(10,2) | YES | 0.00 | ||
| engineer_app_specialhhaul_legal | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_app_specialhhaul_legal | bond_no | varchar(45) | NO | |||
| engineer_app_specialhhaul_legal | code | varchar(20) | NO | |||
| engineer_app_specialhhaul_legal | owner | varchar(100) | NO | |||
| engineer_app_specialhhaul_legal | ins_co | varchar(100) | NO | |||
| engineer_app_specialhhaul_legal | ins_addr | varchar(100) | NO | |||
| engineer_app_specialhhaul_legal | eff_date | date | NO | 0000-00-00 | ||
| engineer_app_specialhhaul_legal | approved | varchar(45) | YES | |||
| engineer_app_specialhhaul_legal | datafile_fr | longblob | YES | |||
| engineer_app_specialhhaul_legal | datafile_lf | longblob | YES | |||
| engineer_invoices | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_invoices | invoice_no | varchar(20) | NO | 0 | ||
| engineer_invoices | invoice_name | varchar(100) | NO | |||
| engineer_invoices | bill_date | datetime | YES | |||
| engineer_invoices | due_date | date | YES | |||
| engineer_invoices | permit_no | varchar(20) | NO | 0 | ||
| engineer_invoices | vender_name | varchar(100) | YES | |||
| engineer_invoices | vender_addr1 | varchar(100) | YES | |||
| engineer_invoices | vender_addr2 | varchar(100) | YES | |||
| engineer_invoices | vender_city | varchar(100) | YES | |||
| engineer_invoices | vender_st | varchar(100) | YES | |||
| engineer_invoices | vender_zip | varchar(100) | YES | |||
| engineer_invoices | invoice_total | decimal(10,2) | YES | |||
| engineer_invoices | contact_name | varchar(100) | YES | |||
| engineer_invoices | contact_email | varchar(100) | YES | |||
| engineer_invoices | contact_phone | varchar(10) | YES | |||
| engineer_invoices | contact_phone_ext | varchar(5) | YES | |||
| engineer_invoices_detail | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_invoices_detail | invoice_no | varchar(45) | NO | |||
| engineer_invoices_detail | item | varchar(100) | NO | |||
| engineer_invoices_detail | rate | decimal(10,2) | NO | 0.00 | ||
| engineer_invoices_detail | qty | decimal(10,2) | NO | 0.00 | ||
| engineer_invoices_detail | total | decimal(10,2) | NO | 0.00 | ||
| engineer_invoices_detail | comments | mediumtext | YES | |||
| engineer_log | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_log | invoice_no | varchar(45) | NO | |||
| engineer_log | date | datetime | NO | |||
| engineer_log | user | varchar(100) | NO | |||
| engineer_log | dept | varchar(45) | NO | |||
| engineer_log | log | mediumtext | NO | |||
| engineer_lu_contractors | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_lu_contractors | name | varchar(45) | NO | |||
| engineer_lu_contractors | address | varchar(45) | NO | |||
| engineer_lu_contractors | city | varchar(45) | NO | |||
| engineer_lu_contractors | state | varchar(45) | NO | |||
| engineer_lu_contractors | zip | varchar(45) | NO | |||
| engineer_lu_contractors | phone | varchar(45) | NO | |||
| engineer_lu_contractors | varchar(45) | NO | ||||
| engineer_lu_contractors | type | varchar(45) | NO | |||
| engineer_lu_items | id | int(10) unsigned | NO | PRI | auto_increment | |
| engineer_lu_items | name | varchar(100) | YES | |||
| engineer_lu_items | rate | decimal(10,2) | YES | |||
| engineer_lu_items | notes | mediumtext | YES | |||
| engineer_lu_items | reason | varchar(45) | YES | |||
| fire_invoices | id | int(10) unsigned | NO | PRI | auto_increment | |
| fire_invoices | invoice_no | varchar(20) | NO | 0 | ||
| fire_invoices | invoice_name | varchar(100) | NO | |||
| fire_invoices | bill_date | datetime | YES | |||
| fire_invoices | due_date | date | YES | |||
| fire_invoices | vender_id | int(10) unsigned | YES | |||
| fire_invoices | vender_name | varchar(100) | YES | |||
| fire_invoices | vender_addr1 | varchar(100) | YES | |||
| fire_invoices | vender_addr2 | varchar(100) | YES | |||
| fire_invoices | vender_city | varchar(100) | YES | |||
| fire_invoices | vender_st | varchar(100) | YES | |||
| fire_invoices | vender_zip | varchar(100) | YES | |||
| fire_invoices | invoice_total | decimal(10,2) | YES | |||
| fire_invoices | contact_name | varchar(100) | YES | |||
| fire_invoices | contact_email | varchar(100) | YES | |||
| fire_invoices | contact_phone | varchar(10) | YES | |||
| fire_invoices | contact_phone_ext | varchar(5) | YES | |||
| fire_invoices_detail | id | int(10) unsigned | NO | PRI | auto_increment | |
| fire_invoices_detail | invoice_no | varchar(45) | NO | |||
| fire_invoices_detail | item | varchar(100) | NO | |||
| fire_invoices_detail | rate | decimal(10,2) | NO | 0.00 | ||
| fire_invoices_detail | qty | decimal(10,2) | NO | 0.00 | ||
| fire_invoices_detail | total | decimal(10,2) | NO | 0.00 | ||
| fire_invoices_detail | comments | mediumtext | YES | |||
| fire_log | id | int(10) unsigned | NO | PRI | auto_increment | |
| fire_log | invoice_no | varchar(45) | NO | |||
| fire_log | date | datetime | NO | |||
| fire_log | user | varchar(100) | NO | |||
| fire_log | dept | varchar(45) | NO | |||
| fire_log | log | mediumtext | NO | |||
| fire_lu_items | id | int(10) unsigned | NO | PRI | auto_increment | |
| fire_lu_items | name | varchar(100) | YES | |||
| fire_lu_items | rate | decimal(10,2) | YES | |||
| fire_lu_items | notes | mediumtext | YES | |||
| fire_lu_items | reason | varchar(45) | YES | |||
| fire_lu_venders | id | int(10) unsigned | NO | PRI | auto_increment | |
| fire_lu_venders | name | varchar(100) | YES | |||
| fire_lu_venders | contact | varchar(100) | YES | |||
| fire_lu_venders | address | varchar(100) | YES | |||
| fire_lu_venders | address2 | varchar(100) | YES | |||
| fire_lu_venders | city | varchar(25) | YES | |||
| fire_lu_venders | state | varchar(5) | YES | |||
| fire_lu_venders | zip | varchar(15) | YES | |||
| fire_lu_venders | varchar(100) | YES | ||||
| fire_lu_venders | phone | varchar(10) | YES | |||
| fire_lu_venders | phone_ext | varchar(5) | YES | |||
| fire_lu_venders | notes | mediumtext | YES | |||
| fire_lu_venders_add | id | int(10) unsigned | NO | PRI | auto_increment | |
| fire_lu_venders_add | v_id | int(10) unsigned | NO | |||
| fire_lu_venders_add | name | varchar(45) | YES | |||
| fire_lu_venders_add | contact | varchar(45) | YES | |||
| fire_lu_venders_add | address | varchar(45) | YES | |||
| fire_lu_venders_add | city | varchar(45) | YES | |||
| fire_lu_venders_add | state | varchar(45) | YES | |||
| fire_lu_venders_add | zip | varchar(45) | YES | |||
| fire_lu_venders_add | varchar(45) | YES | ||||
| fire_lu_venders_add | phone | varchar(45) | YES | |||
| fire_lu_venders_add | phone_ext | varchar(45) | YES | |||
| mayor_invoices | id | int(10) unsigned | NO | PRI | auto_increment | |
| mayor_invoices | invoice_no | varchar(20) | NO | 0 | ||
| mayor_invoices | invoice_name | varchar(100) | NO | |||
| mayor_invoices | bill_date | date | YES | |||
| mayor_invoices | due_date | date | YES | |||
| mayor_invoices | entry_date | date | YES | |||
| mayor_invoices | vender_name | varchar(100) | YES | |||
| mayor_invoices | vender_addr1 | varchar(100) | YES | |||
| mayor_invoices | vender_addr2 | varchar(100) | YES | |||
| mayor_invoices | vender_city | varchar(100) | YES | |||
| mayor_invoices | vender_st | varchar(100) | YES | |||
| mayor_invoices | vender_zip | varchar(100) | YES | |||
| mayor_invoices | contact_name | varchar(100) | YES | |||
| mayor_invoices | contact_email | varchar(100) | YES | |||
| mayor_invoices | contact_phone | varchar(10) | YES | |||
| mayor_invoices | contact_phone_ext | varchar(5) | YES | |||
| mayor_invoices_detail | id | int(10) unsigned | NO | PRI | auto_increment | |
| mayor_invoices_detail | invoice_no | varchar(45) | NO | |||
| mayor_invoices_detail | item | varchar(100) | NO | |||
| mayor_invoices_detail | rate | decimal(10,2) | NO | 0.00 | ||
| mayor_invoices_detail | qty | decimal(10,2) | NO | 0.00 | ||
| mayor_invoices_detail | total | decimal(10,2) | NO | 0.00 | ||
| mayor_invoices_detail | comments | mediumtext | YES | |||
| mayor_log | id | int(10) unsigned | NO | PRI | auto_increment | |
| mayor_log | invoice_no | varchar(45) | NO | |||
| mayor_log | date | datetime | NO | |||
| mayor_log | user | varchar(100) | NO | |||
| mayor_log | dept | varchar(45) | NO | |||
| mayor_log | log | mediumtext | NO | |||
| mayor_lu_items | id | int(10) unsigned | NO | PRI | auto_increment | |
| mayor_lu_items | name | varchar(100) | YES | |||
| mayor_lu_items | rate | decimal(10,2) | YES | |||
| mayor_lu_items | notes | mediumtext | YES | |||
| mayor_lu_items | reason | varchar(45) | YES | |||
| mayor_lu_venders | id | int(10) unsigned | NO | PRI | auto_increment | |
| mayor_lu_venders | name | varchar(100) | YES | |||
| mayor_lu_venders | contact | varchar(100) | YES | |||
| mayor_lu_venders | address | varchar(100) | YES | |||
| mayor_lu_venders | address2 | varchar(100) | YES | |||
| mayor_lu_venders | city | varchar(25) | YES | |||
| mayor_lu_venders | state | varchar(5) | YES | |||
| mayor_lu_venders | zip | varchar(15) | YES | |||
| mayor_lu_venders | varchar(100) | YES | ||||
| mayor_lu_venders | phone | varchar(10) | YES | |||
| mayor_lu_venders | phone_ext | varchar(5) | YES | |||
| mayor_lu_venders | notes | mediumtext | YES | |||
| recreation_lu_items | id | int(10) unsigned | NO | PRI | auto_increment | |
| recreation_lu_items | name | varchar(100) | YES | |||
| recreation_lu_items | rate | decimal(10,2) | YES | |||
| recreation_lu_items | notes | mediumtext | YES | |||
| recreation_lu_items | reason | varchar(45) | YES | |||
| zone_lu_items | id | int(10) unsigned | NO | PRI | auto_increment | |
| zone_lu_items | name | varchar(100) | YES | |||
| zone_lu_items | rate | decimal(10,2) | YES | |||
| zone_lu_items | notes | mediumtext | YES | |||
| zone_lu_items | reason | varchar(45) | YES | |||
40 Tables : 718 Fields
.