gul
apply
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(255) | No | ||
| visa_id | varchar(200) | Yes | NULL | |
| id_type | text | Yes | NULL | |
| status | text | Yes | NULL | |
| id_provider | int(200) | Yes | NULL | |
| rate_provider | int(255) | No | ||
| gmail | text | Yes | NULL | |
| post_date | timestamp | Yes | NULL | |
| Sub_Name | varchar(200) | No | ||
| status_date | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 217 | A | No | |
| idx_apply_visa_id | BTREE | No | No | visa_id (191) | 217 | A | Yes |
applyrecord
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(200) | No | ||
| visa_id | varchar(200) | Yes | NULL | |
| id_type | text | Yes | NULL | |
| status | text | Yes | NULL | |
| id_provider | int(200) | Yes | NULL | |
| rate_provider | int(255) | No | ||
| gmail | text | Yes | NULL | |
| post_date | timestamp | Yes | NULL | |
| Sub_Name | varchar(200) | No | ||
| Extra_Comments | varchar(200) | No | ||
| status_date | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 437 | A | No | |
| idx_applyrecord_visa_id | BTREE | No | No | visa_id (191) | 437 | A | Yes |
approved
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(200) | No | ||
| visa_id | varchar(200) | Yes | NULL | |
| id_type | varchar(200) | Yes | NULL | |
| id_provider | int(200) | Yes | NULL | |
| rate_provider | int(200) | Yes | NULL | |
| id_approver | int(200) | Yes | NULL | |
| rate_approver | int(200) | Yes | NULL | |
| gmail | text | No | ||
| Sub_Name | text | No | ||
| description | text | No | ||
| Extra_Comments | varchar(200) | No | ||
| post_date | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2297 | A | No |
approver
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| Id (Primary) | int(200) | No | ||
| title | text | Yes | NULL | |
| Cell | varchar(255) | No | ||
| BusinessExtension | int(11) | Yes | NULL | |
| FamilyExtension | int(11) | Yes | NULL | |
| MedicalExtension | int(11) | Yes | NULL | |
| StudyExtension | int(11) | Yes | NULL | |
| SpouseExtension | int(11) | Yes | NULL | |
| WorkExtension | int(11) | Yes | NULL | |
| TouristExtension | int(11) | Yes | NULL | |
| OtherCountryExtension | int(11) | Yes | NULL | |
| MedicalETAExtension | int(11) | Yes | NULL | |
| TablighExtension | int(11) | Yes | NULL | |
| ReviewCharges | int(11) | Yes | NULL | |
| OfficialExtension | int(11) | Yes | NULL | |
| HumanitarianExtension | int(11) | Yes | NULL | |
| SportExtension | int(11) | Yes | NULL | |
| BusinessExit | int(11) | Yes | NULL | |
| FamilyExit | int(11) | Yes | NULL | |
| MedicalExit | int(11) | Yes | NULL | |
| StudyExit | int(11) | Yes | NULL | |
| SpouseExit | int(11) | Yes | NULL | |
| WorkExit | int(11) | Yes | NULL | |
| TouristExit | int(11) | Yes | NULL | |
| TablighExit | int(11) | Yes | NULL | |
| AfghanExit | int(11) | Yes | NULL | |
| OtherCountryExit | int(11) | Yes | NULL | |
| PDFCharges | int(11) | Yes | NULL | |
| OfficialExit | int(11) | Yes | NULL | |
| HumanitarianExit | int(11) | Yes | NULL | |
| SportExit | int(11) | Yes | NULL | |
| BusinessEntry | int(11) | Yes | NULL | |
| FamilyEntry | int(11) | Yes | NULL | |
| MedicalEntry | int(11) | Yes | NULL | |
| StudyEntry | int(11) | Yes | NULL | |
| SpouseEntry | int(11) | Yes | NULL | |
| WorkEntry | int(11) | Yes | NULL | |
| TouristEntry | int(11) | Yes | NULL | |
| OtherCountryEntry | int(11) | Yes | NULL | |
| TablighEntry | int(11) | Yes | NULL | |
| DiplomaticEntry | int(11) | Yes | NULL | |
| OfficialEntry | int(11) | Yes | NULL | |
| HumanitarianEntry | int(11) | Yes | NULL | |
| SportEntry | int(11) | Yes | NULL | |
| Cancellation | int(11) | Yes | NULL | |
| ApplyCharges | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | Id | 8 | A | No | |
| idx_approver_title | HASH | Yes | No | title | A | Yes | ||
| idx_business_extension | BTREE | No | No | BusinessExtension | 8 | A | Yes | |
| idx_family_extension | BTREE | No | No | FamilyExtension | 2 | A | Yes | |
| idx_medical_extension | BTREE | No | No | MedicalExtension | 4 | A | Yes | |
| idx_study_extension | BTREE | No | No | StudyExtension | 4 | A | Yes | |
| idx_spouse_extension | BTREE | No | No | SpouseExtension | 2 | A | Yes | |
| idx_work_extension | BTREE | No | No | WorkExtension | 2 | A | Yes | |
| idx_tourist_extension | BTREE | No | No | TouristExtension | 2 | A | Yes | |
| idx_other_country_extension | BTREE | No | No | OtherCountryExtension | 2 | A | Yes | |
| idx_medical_eta_extension | BTREE | No | No | MedicalETAExtension | 2 | A | Yes | |
| idx_tabligh_extension | BTREE | No | No | TablighExtension | 2 | A | Yes | |
| idx_diplomatic_extension | BTREE | No | No | ReviewCharges | 2 | A | Yes | |
| idx_official_extension | BTREE | No | No | OfficialExtension | 2 | A | Yes | |
| idx_humanitarian_extension | BTREE | No | No | HumanitarianExtension | 2 | A | Yes | |
| idx_sport_extension | BTREE | No | No | SportExtension | 2 | A | Yes | |
| idx_business_exit | BTREE | No | No | BusinessExit | 4 | A | Yes | |
| idx_family_exit | BTREE | No | No | FamilyExit | 2 | A | Yes | |
| idx_medical_exit | BTREE | No | No | MedicalExit | 2 | A | Yes | |
| idx_study_exit | BTREE | No | No | StudyExit | 2 | A | Yes | |
| idx_spouse_exit | BTREE | No | No | SpouseExit | 2 | A | Yes | |
| idx_work_exit | BTREE | No | No | WorkExit | 4 | A | Yes | |
| idx_tourist_exit | BTREE | No | No | TouristExit | 2 | A | Yes | |
| idx_tabligh_exit | BTREE | No | No | TablighExit | 2 | A | Yes | |
| idx_afghan_exit | BTREE | No | No | AfghanExit | 2 | A | Yes | |
| idx_other_country_exit | BTREE | No | No | OtherCountryExit | 4 | A | Yes | |
| idx_diplomatic_exit | BTREE | No | No | PDFCharges | 2 | A | Yes | |
| idx_official_exit | BTREE | No | No | OfficialExit | 2 | A | Yes | |
| idx_humanitarian_exit | BTREE | No | No | HumanitarianExit | 2 | A | Yes | |
| idx_sport_exit | BTREE | No | No | SportExit | 2 | A | Yes | |
| idx_business_entry | BTREE | No | No | BusinessEntry | 8 | A | Yes | |
| idx_family_entry | BTREE | No | No | FamilyEntry | 2 | A | Yes | |
| idx_medical_entry | BTREE | No | No | MedicalEntry | 2 | A | Yes | |
| idx_study_entry | BTREE | No | No | StudyEntry | 8 | A | Yes | |
| idx_spouse_entry | BTREE | No | No | SpouseEntry | 2 | A | Yes | |
| idx_work_entry | BTREE | No | No | WorkEntry | 4 | A | Yes | |
| idx_tourist_entry | BTREE | No | No | TouristEntry | 2 | A | Yes | |
| idx_other_country_entry | BTREE | No | No | OtherCountryEntry | 2 | A | Yes | |
| idx_tabligh_entry | BTREE | No | No | TablighEntry | 2 | A | Yes | |
| idx_diplomatic_entry | BTREE | No | No | DiplomaticEntry | 2 | A | Yes | |
| idx_official_entry | BTREE | No | No | OfficialEntry | 2 | A | Yes | |
| idx_humanitarian_entry | BTREE | No | No | HumanitarianEntry | 2 | A | Yes | |
| idx_sport_entry | BTREE | No | No | SportEntry | 2 | A | Yes | |
| idx_cancellation | BTREE | No | No | Cancellation | 8 | A | Yes |
deleted_provider
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(200) | No | ||
| visa_id | varchar(200) | Yes | NULL | |
| id_type | text | Yes | NULL | |
| status | text | Yes | NULL | |
| id_provider | int(200) | Yes | NULL | |
| rate_provider | int(200) | Yes | NULL | |
| id_approver | int(200) | Yes | NULL | |
| rate_approver | int(200) | Yes | NULL | |
| gmail | text | No | ||
| post_date | timestamp | Yes | NULL | |
| Sub_Name | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1522 | A | No | |
| idx_visa_id | BTREE | No | No | visa_id | 1522 | A | Yes | |
| idx_id_type | BTREE | No | No | id_type (768) | 32 | A | Yes | |
| idx_status | BTREE | No | No | status (768) | 152 | A | Yes | |
| idx_id_provider | BTREE | No | No | id_provider | 138 | A | Yes | |
| idx_rate_provider | BTREE | No | No | rate_provider | 69 | A | Yes | |
| idx_id_approver | BTREE | No | No | id_approver | 10 | A | Yes | |
| idx_rate_approver | BTREE | No | No | rate_approver | 34 | A | Yes | |
| idx_post_date | BTREE | No | No | post_date | 380 | A | Yes |
id_provider
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| Id (Primary) | int(200) | No | ||
| title | text | Yes | NULL | |
| Cell | varchar(255) | No | ||
| BusinessExtension | int(11) | Yes | NULL | |
| FamilyExtension | int(11) | Yes | NULL | |
| MedicalExtension | int(11) | Yes | NULL | |
| StudyExtension | int(11) | Yes | NULL | |
| SpouseExtension | int(11) | Yes | NULL | |
| WorkExtension | int(11) | Yes | NULL | |
| TouristExtension | int(11) | Yes | NULL | |
| OtherCountryExtension | int(11) | Yes | NULL | |
| MedicalETAExtension | int(11) | Yes | NULL | |
| TablighExtension | int(11) | Yes | NULL | |
| ReviewCharges | int(11) | Yes | NULL | |
| OfficialExtension | int(11) | Yes | NULL | |
| HumanitarianExtension | int(11) | Yes | NULL | |
| SportExtension | int(11) | Yes | NULL | |
| BusinessExit | int(11) | Yes | NULL | |
| FamilyExit | int(11) | Yes | NULL | |
| MedicalExit | int(11) | Yes | NULL | |
| StudyExit | int(11) | Yes | NULL | |
| SpouseExit | int(11) | Yes | NULL | |
| WorkExit | int(11) | Yes | NULL | |
| TouristExit | int(11) | Yes | NULL | |
| TablighExit | int(11) | Yes | NULL | |
| AfghanExit | int(11) | Yes | NULL | |
| OtherCountryExit | int(11) | Yes | NULL | |
| PDFCharges | int(11) | Yes | NULL | |
| OfficialExit | int(11) | Yes | NULL | |
| HumanitarianExit | int(11) | Yes | NULL | |
| SportExit | int(11) | Yes | NULL | |
| BusinessEntry | int(11) | Yes | NULL | |
| FamilyEntry | int(11) | Yes | NULL | |
| MedicalEntry | int(11) | Yes | NULL | |
| StudyEntry | int(11) | Yes | NULL | |
| SpouseEntry | int(11) | Yes | NULL | |
| WorkEntry | int(11) | Yes | NULL | |
| TouristEntry | int(11) | Yes | NULL | |
| OtherCountryEntry | int(11) | Yes | NULL | |
| TablighEntry | int(11) | Yes | NULL | |
| DiplomaticEntry | int(11) | Yes | NULL | |
| OfficialEntry | int(11) | Yes | NULL | |
| HumanitarianEntry | int(11) | Yes | NULL | |
| SportEntry | int(11) | Yes | NULL | |
| Cancellation | int(11) | Yes | NULL | |
| ApplyCharges | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | Id | 154 | A | No | |
| idx_Cancellation | BTREE | No | No | Cancellation | 4 | A | Yes | |
| idx_business_extension | BTREE | No | No | BusinessExtension | 8 | A | Yes | |
| idx_family_extension | BTREE | No | No | FamilyExtension | 12 | A | Yes | |
| idx_medical_extension | BTREE | No | No | MedicalExtension | 12 | A | Yes | |
| idx_study_extension | BTREE | No | No | StudyExtension | 8 | A | Yes | |
| idx_spouse_extension | BTREE | No | No | SpouseExtension | 4 | A | Yes | |
| idx_work_extension | BTREE | No | No | WorkExtension | 2 | A | Yes | |
| idx_tourist_extension | BTREE | No | No | TouristExtension | 4 | A | Yes | |
| idx_other_country_extension | BTREE | No | No | OtherCountryExtension | 8 | A | Yes | |
| idx_medical_eta_extension | BTREE | No | No | MedicalETAExtension | 8 | A | Yes | |
| idx_tabligh_extension | BTREE | No | No | TablighExtension | 2 | A | Yes | |
| idx_diplomatic_extension | BTREE | No | No | ReviewCharges | 2 | A | Yes | |
| idx_official_extension | BTREE | No | No | OfficialExtension | 2 | A | Yes | |
| idx_sport_extension | BTREE | No | No | SportExtension | 2 | A | Yes | |
| idx_humanitarian_extension | BTREE | No | No | HumanitarianExtension | 4 | A | Yes | |
| idx_business_exit | BTREE | No | No | BusinessExit | 6 | A | Yes | |
| idx_family_exit | BTREE | No | No | FamilyExit | 6 | A | Yes | |
| idx_medical_exit | BTREE | No | No | MedicalExit | 4 | A | Yes | |
| idx_study_exit | BTREE | No | No | StudyExit | 4 | A | Yes | |
| idx_spouse_exit | BTREE | No | No | SpouseExit | 4 | A | Yes | |
| idx_work_exit | BTREE | No | No | WorkExit | 4 | A | Yes | |
| idx_tourist_exit | BTREE | No | No | TouristExit | 2 | A | Yes | |
| idx_tabligh_exit | BTREE | No | No | TablighExit | 4 | A | Yes | |
| idx_afghan_exit | BTREE | No | No | AfghanExit | 10 | A | Yes | |
| idx_other_country_exit | BTREE | No | No | OtherCountryExit | 8 | A | Yes | |
| idx_diplomatic_exit | BTREE | No | No | PDFCharges | 4 | A | Yes | |
| idx_official_exit | BTREE | No | No | OfficialExit | 4 | A | Yes | |
| idx_sport_exit | BTREE | No | No | SportExit | 4 | A | Yes | |
| idx_business_entry | BTREE | No | No | BusinessEntry | 12 | A | Yes | |
| idx_family_entry | BTREE | No | No | FamilyEntry | 2 | A | Yes | |
| idx_medical_entry | BTREE | No | No | MedicalEntry | 2 | A | Yes | |
| idx_study_entry | BTREE | No | No | StudyEntry | 17 | A | Yes | |
| idx_spouse_entry | BTREE | No | No | SpouseEntry | 2 | A | Yes | |
| idx_work_entry | BTREE | No | No | WorkEntry | 6 | A | Yes | |
| idx_humanitarian_entry | BTREE | No | No | HumanitarianEntry | 2 | A | Yes | |
| idx_id_provider_title | BTREE | No | No | title (191) | 154 | A | Yes |
payable
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(200) | No | ||
| id_approver | int(200) | Yes | NULL | |
| cr_approver | decimal(10,2) | Yes | NULL | |
| dr_approver | decimal(10,2) | Yes | NULL | |
| id_payer | int(200) | Yes | NULL | |
| description | varchar(500) | No | ||
| post_date | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 634 | A | No | |
| idx_payable_id_approver | BTREE | No | No | id_approver | 12 | A | Yes | |
| idx_payable_cr_approver | BTREE | No | No | cr_approver | 158 | A | Yes | |
| idx_payable_dr_approver | BTREE | No | No | dr_approver | 317 | A | Yes | |
| idx_payable_id_payer | BTREE | No | No | id_payer | 10 | A | Yes | |
| idx_payable_description | BTREE | No | No | description | 634 | A | No | |
| idx_payable_post_date | BTREE | No | No | post_date | 634 | A | Yes |
receivable
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(200) | No | ||
| id_provider | int(200) | Yes | NULL | |
| cr_id_provider | decimal(10,2) | Yes | NULL | |
| dr_id_provider | decimal(10,2) | Yes | NULL | |
| id_receiver | int(200) | Yes | NULL | |
| description | varchar(500) | No | ||
| post_date | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1524 | A | No | |
| idx_receivable_id_provider | BTREE | No | No | id_provider | 304 | A | Yes | |
| idx_receivable_cr_id_provider | BTREE | No | No | cr_id_provider | 381 | A | Yes | |
| idx_receivable_dr_id_provider | BTREE | No | No | dr_id_provider | 381 | A | Yes | |
| idx_receivable_id_receiver | BTREE | No | No | id_receiver | 10 | A | Yes | |
| idx_receivable_description | BTREE | No | No | description | 1524 | A | No | |
| idx_receivable_post_date | BTREE | No | No | post_date | 1524 | A | Yes |
tbl_admin
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| user_name | varchar(255) | No | ||
| pword | varchar(255) | No | ||
| 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
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No | |
| idx_tbl_admin_user_name | BTREE | No | No | user_name | 3 | A | No | |
| idx_tbl_admin_pword | BTREE | No | No | pword | 3 | A | No | |
| idx_tbl_admin_email | BTREE | No | No | 3 | A | Yes | ||
| idx_tbl_admin_phone | BTREE | No | No | phone | 3 | A | Yes | |
| idx_tbl_admin_time_stamp | BTREE | No | No | time_stamp | 3 | A | No | |
| idx_tbl_admin_status | BTREE | No | No | status | 3 | A | Yes | |
| idx_tbl_admin_post_date | BTREE | No | No | post_date | 3 | A | Yes | |
| idx_tbl_admin_post_time | BTREE | No | No | post_time | 3 | A | Yes |
tmp_approver
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(200) | No | ||
| visa_id | varchar(2000) | Yes | NULL | |
| status | text | Yes | NULL | |
| post_date | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 60 | A | No | |
| idx_visa_id | BTREE | No | No | visa_id (768) | 60 | A | Yes | |
| idx_status | BTREE | No | No | status (768) | 60 | A | Yes | |
| idx_post_date | BTREE | No | No | post_date | 12 | A | Yes |
tmp_provider
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(200) | No | ||
| visa_id | varchar(2000) | Yes | NULL | |
| id_type | text | Yes | NULL | |
| status | varchar(500) | No | ||
| id_provider | int(200) | Yes | NULL | |
| rate_provider | int(200) | Yes | NULL | |
| id_approver | int(200) | Yes | NULL | |
| rate_approver | int(200) | Yes | NULL | |
| gmail | text | No | ||
| post_date | timestamp | Yes | NULL | |
| Sub_Name | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 200 | A | No | |
| idx_tmp_provider_id_provider_approver | BTREE | No | No | id_provider | 100 | A | Yes | |
| id_approver | 100 | A | Yes | |||||
| idx_tmp_provider_status_type | BTREE | No | No | status | 22 | A | No | |
| id_type (100) | 40 | A | Yes | |||||
| idx_tmp_provider_post_date | BTREE | No | No | post_date | 200 | A | Yes | |
| idx_tmp_provider_visa_id | BTREE | No | No | visa_id (768) | 200 | A | Yes | |
| idx_visa_id | BTREE | No | No | visa_id (768) | 200 | A | Yes | |
| idx_id_type | BTREE | No | No | id_type (768) | 18 | A | Yes | |
| idx_status | BTREE | No | No | status | 22 | A | No | |
| idx_id_provider | BTREE | No | No | id_provider | 100 | A | Yes | |
| idx_id_approver | BTREE | No | No | id_approver | 4 | A | Yes |