gul

apply_charges

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
visa_id bigint(20) Yes NULL
id_type text Yes NULL
id_provider int(11) Yes NULL
cr_apply_charges decimal(10,2) Yes NULL
dr_apply_charges decimal(10,2) Yes NULL
id_receiver int(11) Yes NULL
Status varchar(200) No
description varchar(500) No
post_date date Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_apply_charges_visa_idBTREENoNovisa_id0AYes
idx_apply_charges_id_typeBTREENoNoid_type (768)0AYes
idx_apply_charges_id_approverBTREENoNoid_provider0AYes
idx_apply_charges_cr_apply_chargesBTREENoNocr_apply_charges0AYes
idx_apply_charges_dr_apply_chargesBTREENoNodr_apply_charges0AYes
idx_apply_charges_id_receiverBTREENoNoid_receiver0AYes
idx_apply_charges_descriptionBTREENoNodescription0ANo
idx_apply_charges_post_dateBTREENoNopost_date0AYes

approved

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
visa_id bigint(20) Yes NULL
id_type text Yes NULL
id_provider int(11) Yes NULL
id_receiver int(11) Yes NULL
status varchar(200) No
post_date date Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_approved_visa_idBTREENoNovisa_id0AYes
idx_approved_id_typeBTREENoNoid_type (768)0AYes
idx_approved_id_providerBTREENoNoid_provider0AYes
idx_approved_id_receiverBTREENoNoid_receiver0AYes
idx_approved_statusBTREENoNostatus0ANo
idx_approved_post_dateBTREENoNopost_date0AYes

approver

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(255) Yes NULL
Extension_Business int(11) Yes NULL
Extension_Family int(11) Yes NULL
Extension_Medical int(11) Yes NULL
Extension_Study int(11) Yes NULL
Extension_Spouse int(11) Yes NULL
Extension_Other_Country int(11) Yes NULL
Extension_Medical_ETA int(11) Yes NULL
Exit_Tabligh int(11) Yes NULL
Exit_Business int(11) Yes NULL
Exit_Afghan int(11) Yes NULL
Exit_Other_Country int(11) Yes NULL
Entry_Study int(11) Yes NULL
Entry_Work int(11) Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid5ANo
idx_approver_titleBTREENoNotitle5AYes
idx_approver_Extension_BusinessBTREENoNoExtension_Business5AYes
idx_approver_Extension_FamilyBTREENoNoExtension_Family5AYes
idx_approver_Extension_MedicalBTREENoNoExtension_Medical5AYes
idx_approver_Extension_StudyBTREENoNoExtension_Study2AYes
idx_approver_Extension_SpouseBTREENoNoExtension_Spouse5AYes
idx_approver_Extension_Other_CountryBTREENoNoExtension_Other_Country5AYes
idx_approver_Extension_Medical_ETABTREENoNoExtension_Medical_ETA5AYes
idx_approver_Exit_TablighBTREENoNoExit_Tabligh2AYes
idx_approver_Exit_BusinessBTREENoNoExit_Business5AYes
idx_approver_Exit_AfghanBTREENoNoExit_Afghan5AYes
idx_approver_Exit_Other_CountryBTREENoNoExit_Other_Country5AYes
idx_approver_Entry_StudyBTREENoNoEntry_Study5AYes
idx_approver_Entry_WorkBTREENoNoEntry_Work2AYes

cash_details

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title text Yes NULL
cr decimal(10,2) Yes NULL
dr decimal(10,2) Yes NULL
description text Yes NULL
post_date date Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_cash_details_titleBTREENoNotitle (768)0AYes
idx_cash_details_crBTREENoNocr0AYes
idx_cash_details_drBTREENoNodr0AYes
idx_cash_details_descriptionBTREENoNodescription (768)0AYes
idx_cash_details_post_dateBTREENoNopost_date0AYes

deleted_temp_approver

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
visa_id bigint(20) Yes NULL
id_type text Yes NULL
status varchar(500) No
id_approver int(11) Yes NULL
cr_approver decimal(10,2) Yes NULL
id_receiver int(11) Yes NULL
post_date date Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_deleted_temp_approver_visa_idBTREENoNovisa_id0AYes
idx_deleted_temp_approver_id_typeBTREENoNoid_type (768)0AYes
idx_deleted_temp_approver_statusBTREENoNostatus0ANo
idx_deleted_temp_approver_id_approverBTREENoNoid_approver0AYes
idx_deleted_temp_approver_cr_approverBTREENoNocr_approver0AYes
idx_deleted_temp_approver_id_receiverBTREENoNoid_receiver0AYes
idx_deleted_temp_approver_post_dateBTREENoNopost_date0AYes

deleted_temp_provider

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
visa_id bigint(20) Yes NULL
id_type text Yes NULL
status varchar(500) No
id_provider int(200) No
id_approver int(11) Yes NULL
cr_id_provider decimal(10,2) Yes NULL
id_receiver int(11) Yes NULL
post_date date Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_deleted_temp_provider_visa_idBTREENoNovisa_id0AYes
idx_deleted_temp_provider_id_typeBTREENoNoid_type (768)0AYes
idx_deleted_temp_provider_statusBTREENoNostatus0ANo
idx_deleted_temp_provider_id_providerBTREENoNoid_provider0ANo
idx_deleted_temp_provider_id_approverBTREENoNoid_approver0AYes
idx_deleted_temp_provider_cr_id_providerBTREENoNocr_id_provider0AYes
idx_deleted_temp_provider_id_receiverBTREENoNoid_receiver0AYes
idx_deleted_temp_provider_post_dateBTREENoNopost_date0AYes

final_list

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
visa_id bigint(20) Yes NULL
id_type text Yes NULL
id_provider int(11) Yes NULL
cr_id_provider decimal(10,2) Yes NULL
id_approver int(11) No
cr_id_approver decimal(11,2) No
id_receiver int(11) Yes NULL
post_date date Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_final_list_visa_idBTREENoNovisa_id0AYes
idx_final_list_id_typeBTREENoNoid_type (768)0AYes
idx_final_list_id_providerBTREENoNoid_provider0AYes
idx_final_list_cr_id_providerBTREENoNocr_id_provider0AYes
idx_final_list_id_approverBTREENoNoid_approver0ANo
idx_final_list_cr_id_approverBTREENoNocr_id_approver0ANo
idx_final_list_id_receiverBTREENoNoid_receiver0AYes
idx_final_list_post_dateBTREENoNopost_date0AYes

id_provider

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) bigint(20) No
title text No
category_id int(11) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid36ANo
idx_id_provider_titleBTREENoNotitle (768)36ANo
idx_id_provider_category_idBTREENoNocategory_id9ANo

payable

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
id_approver int(11) Yes NULL
cr_approver decimal(10,2) Yes NULL
dr_approver decimal(10,2) Yes NULL
id_payer int(11) Yes NULL
description varchar(500) No
post_date date Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_payable_id_approverBTREENoNoid_approver0AYes
idx_payable_cr_approverBTREENoNocr_approver0AYes
idx_payable_dr_approverBTREENoNodr_approver0AYes
idx_payable_id_payerBTREENoNoid_payer0AYes
idx_payable_descriptionBTREENoNodescription0ANo
idx_payable_post_dateBTREENoNopost_date0AYes

rate_list

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(255) Yes NULL
Extension_Business int(11) Yes NULL
Extension_Family int(11) Yes NULL
Extension_Medical int(11) Yes NULL
Extension_Study int(11) Yes NULL
Extension_Spouse int(11) Yes NULL
Extension_Other_Country int(11) Yes NULL
Extension_Medical_ETA int(11) Yes NULL
Exit_Tabligh int(11) Yes NULL
Exit_Business int(11) Yes NULL
Exit_Afghan int(11) Yes NULL
Exit_Other_Country int(11) Yes NULL
Entry_Study int(11) Yes NULL
Entry_Work int(11) Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid4ANo
idx_rate_list_titleBTREENoNotitle4AYes
idx_rate_list_Extension_BusinessBTREENoNoExtension_Business2AYes
idx_rate_list_Extension_FamilyBTREENoNoExtension_Family4AYes
idx_rate_list_Extension_MedicalBTREENoNoExtension_Medical4AYes
idx_rate_list_Extension_StudyBTREENoNoExtension_Study2AYes
idx_rate_list_Extension_SpouseBTREENoNoExtension_Spouse4AYes
idx_rate_list_Extension_Other_CountryBTREENoNoExtension_Other_Country2AYes
idx_rate_list_Extension_Medical_ETABTREENoNoExtension_Medical_ETA4AYes
idx_rate_list_Exit_TablighBTREENoNoExit_Tabligh4AYes
idx_rate_list_Exit_BusinessBTREENoNoExit_Business2AYes
idx_rate_list_Exit_AfghanBTREENoNoExit_Afghan4AYes
idx_rate_list_Exit_Other_CountryBTREENoNoExit_Other_Country4AYes
idx_rate_list_Entry_StudyBTREENoNoEntry_Study4AYes
idx_rate_list_Entry_WorkBTREENoNoEntry_Work4AYes

receivable

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
id_provider int(11) Yes NULL
cr_id_provider decimal(10,2) Yes NULL
dr_id_provider decimal(10,2) Yes NULL
id_receiver int(11) Yes NULL
description varchar(500) No
post_date timestamp Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_receivable_id_providerBTREENoNoid_provider0AYes
idx_receivable_cr_id_providerBTREENoNocr_id_provider0AYes
idx_receivable_dr_id_providerBTREENoNodr_id_provider0AYes
idx_receivable_id_receiverBTREENoNoid_receiver0AYes
idx_receivable_descriptionBTREENoNodescription0ANo
idx_receivable_post_dateBTREENoNopost_date0AYes

tbl_admin

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
user_name varchar(255) No
pword varchar(255) No
email varchar(255) Yes NULL
phone varchar(20) Yes NULL
time_stamp timestamp No current_timestamp()
status int(11) Yes NULL
post_date date Yes NULL
post_time time Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid3ANo
idx_tbl_admin_user_nameBTREENoNouser_name3ANo
idx_tbl_admin_pwordBTREENoNopword3ANo
idx_tbl_admin_emailBTREENoNoemail3AYes
idx_tbl_admin_phoneBTREENoNophone3AYes
idx_tbl_admin_time_stampBTREENoNotime_stamp3ANo
idx_tbl_admin_statusBTREENoNostatus3AYes
idx_tbl_admin_post_dateBTREENoNopost_date3AYes
idx_tbl_admin_post_timeBTREENoNopost_time3AYes

temp_approver

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
visa_id bigint(20) Yes NULL
id_type text Yes NULL
status varchar(500) No
id_approver int(11) Yes NULL
cr_approver decimal(10,2) Yes NULL
post_date date Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_temp_approver_visa_idBTREENoNovisa_id0AYes
idx_temp_approver_id_typeBTREENoNoid_type (768)0AYes
idx_temp_approver_statusBTREENoNostatus0ANo
idx_temp_approver_id_approverBTREENoNoid_approver0AYes
idx_temp_approver_cr_approverBTREENoNocr_approver0AYes
idx_temp_approver_post_dateBTREENoNopost_date0AYes

temp_provider

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
visa_id bigint(20) Yes NULL
id_type text Yes NULL
status varchar(500) No
id_provider int(200) No
id_approver int(11) Yes NULL
cr_id_provider decimal(10,2) Yes NULL
id_receiver int(11) Yes NULL
post_date date Yes NULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_temp_provider_visa_idBTREENoNovisa_id0AYes
idx_temp_provider_id_typeBTREENoNoid_type (768)0AYes
idx_temp_provider_statusBTREENoNostatus0ANo
idx_temp_provider_id_providerBTREENoNoid_provider0ANo
idx_temp_provider_id_approverBTREENoNoid_approver0AYes
idx_temp_provider_cr_id_providerBTREENoNocr_id_provider0AYes
idx_temp_provider_id_receiverBTREENoNoid_receiver0AYes
idx_temp_provider_post_dateBTREENoNopost_date0AYes