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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_apply_charges_visa_id	BTREE	No	No	visa_id	0	A	Yes
idx_apply_charges_id_type	BTREE	No	No	id_type (768)	0	A	Yes
idx_apply_charges_id_approver	BTREE	No	No	id_provider	0	A	Yes
idx_apply_charges_cr_apply_charges	BTREE	No	No	cr_apply_charges	0	A	Yes
idx_apply_charges_dr_apply_charges	BTREE	No	No	dr_apply_charges	0	A	Yes
idx_apply_charges_id_receiver	BTREE	No	No	id_receiver	0	A	Yes
idx_apply_charges_description	BTREE	No	No	description	0	A	No
idx_apply_charges_post_date	BTREE	No	No	post_date	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_approved_visa_id	BTREE	No	No	visa_id	0	A	Yes
idx_approved_id_type	BTREE	No	No	id_type (768)	0	A	Yes
idx_approved_id_provider	BTREE	No	No	id_provider	0	A	Yes
idx_approved_id_receiver	BTREE	No	No	id_receiver	0	A	Yes
idx_approved_status	BTREE	No	No	status	0	A	No
idx_approved_post_date	BTREE	No	No	post_date	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	5	A	No
idx_approver_title	BTREE	No	No	title	5	A	Yes
idx_approver_Extension_Business	BTREE	No	No	Extension_Business	5	A	Yes
idx_approver_Extension_Family	BTREE	No	No	Extension_Family	5	A	Yes
idx_approver_Extension_Medical	BTREE	No	No	Extension_Medical	5	A	Yes
idx_approver_Extension_Study	BTREE	No	No	Extension_Study	2	A	Yes
idx_approver_Extension_Spouse	BTREE	No	No	Extension_Spouse	5	A	Yes
idx_approver_Extension_Other_Country	BTREE	No	No	Extension_Other_Country	5	A	Yes
idx_approver_Extension_Medical_ETA	BTREE	No	No	Extension_Medical_ETA	5	A	Yes
idx_approver_Exit_Tabligh	BTREE	No	No	Exit_Tabligh	2	A	Yes
idx_approver_Exit_Business	BTREE	No	No	Exit_Business	5	A	Yes
idx_approver_Exit_Afghan	BTREE	No	No	Exit_Afghan	5	A	Yes
idx_approver_Exit_Other_Country	BTREE	No	No	Exit_Other_Country	5	A	Yes
idx_approver_Entry_Study	BTREE	No	No	Entry_Study	5	A	Yes
idx_approver_Entry_Work	BTREE	No	No	Entry_Work	2	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_cash_details_title	BTREE	No	No	title (768)	0	A	Yes
idx_cash_details_cr	BTREE	No	No	cr	0	A	Yes
idx_cash_details_dr	BTREE	No	No	dr	0	A	Yes
idx_cash_details_description	BTREE	No	No	description (768)	0	A	Yes
idx_cash_details_post_date	BTREE	No	No	post_date	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_deleted_temp_approver_visa_id	BTREE	No	No	visa_id	0	A	Yes
idx_deleted_temp_approver_id_type	BTREE	No	No	id_type (768)	0	A	Yes
idx_deleted_temp_approver_status	BTREE	No	No	status	0	A	No
idx_deleted_temp_approver_id_approver	BTREE	No	No	id_approver	0	A	Yes
idx_deleted_temp_approver_cr_approver	BTREE	No	No	cr_approver	0	A	Yes
idx_deleted_temp_approver_id_receiver	BTREE	No	No	id_receiver	0	A	Yes
idx_deleted_temp_approver_post_date	BTREE	No	No	post_date	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_deleted_temp_provider_visa_id	BTREE	No	No	visa_id	0	A	Yes
idx_deleted_temp_provider_id_type	BTREE	No	No	id_type (768)	0	A	Yes
idx_deleted_temp_provider_status	BTREE	No	No	status	0	A	No
idx_deleted_temp_provider_id_provider	BTREE	No	No	id_provider	0	A	No
idx_deleted_temp_provider_id_approver	BTREE	No	No	id_approver	0	A	Yes
idx_deleted_temp_provider_cr_id_provider	BTREE	No	No	cr_id_provider	0	A	Yes
idx_deleted_temp_provider_id_receiver	BTREE	No	No	id_receiver	0	A	Yes
idx_deleted_temp_provider_post_date	BTREE	No	No	post_date	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_final_list_visa_id	BTREE	No	No	visa_id	0	A	Yes
idx_final_list_id_type	BTREE	No	No	id_type (768)	0	A	Yes
idx_final_list_id_provider	BTREE	No	No	id_provider	0	A	Yes
idx_final_list_cr_id_provider	BTREE	No	No	cr_id_provider	0	A	Yes
idx_final_list_id_approver	BTREE	No	No	id_approver	0	A	No
idx_final_list_cr_id_approver	BTREE	No	No	cr_id_approver	0	A	No
idx_final_list_id_receiver	BTREE	No	No	id_receiver	0	A	Yes
idx_final_list_post_date	BTREE	No	No	post_date	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	36	A	No
idx_id_provider_title	BTREE	No	No	title (768)	36	A	No
idx_id_provider_category_id	BTREE	No	No	category_id	9	A	No

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_payable_id_approver	BTREE	No	No	id_approver	0	A	Yes
idx_payable_cr_approver	BTREE	No	No	cr_approver	0	A	Yes
idx_payable_dr_approver	BTREE	No	No	dr_approver	0	A	Yes
idx_payable_id_payer	BTREE	No	No	id_payer	0	A	Yes
idx_payable_description	BTREE	No	No	description	0	A	No
idx_payable_post_date	BTREE	No	No	post_date	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	4	A	No
idx_rate_list_title	BTREE	No	No	title	4	A	Yes
idx_rate_list_Extension_Business	BTREE	No	No	Extension_Business	2	A	Yes
idx_rate_list_Extension_Family	BTREE	No	No	Extension_Family	4	A	Yes
idx_rate_list_Extension_Medical	BTREE	No	No	Extension_Medical	4	A	Yes
idx_rate_list_Extension_Study	BTREE	No	No	Extension_Study	2	A	Yes
idx_rate_list_Extension_Spouse	BTREE	No	No	Extension_Spouse	4	A	Yes
idx_rate_list_Extension_Other_Country	BTREE	No	No	Extension_Other_Country	2	A	Yes
idx_rate_list_Extension_Medical_ETA	BTREE	No	No	Extension_Medical_ETA	4	A	Yes
idx_rate_list_Exit_Tabligh	BTREE	No	No	Exit_Tabligh	4	A	Yes
idx_rate_list_Exit_Business	BTREE	No	No	Exit_Business	2	A	Yes
idx_rate_list_Exit_Afghan	BTREE	No	No	Exit_Afghan	4	A	Yes
idx_rate_list_Exit_Other_Country	BTREE	No	No	Exit_Other_Country	4	A	Yes
idx_rate_list_Entry_Study	BTREE	No	No	Entry_Study	4	A	Yes
idx_rate_list_Entry_Work	BTREE	No	No	Entry_Work	4	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_receivable_id_provider	BTREE	No	No	id_provider	0	A	Yes
idx_receivable_cr_id_provider	BTREE	No	No	cr_id_provider	0	A	Yes
idx_receivable_dr_id_provider	BTREE	No	No	dr_id_provider	0	A	Yes
idx_receivable_id_receiver	BTREE	No	No	id_receiver	0	A	Yes
idx_receivable_description	BTREE	No	No	description	0	A	No
idx_receivable_post_date	BTREE	No	No	post_date	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_tbl_admin_user_name	BTREE	No	No	user_name	0	A	No
idx_tbl_admin_pword	BTREE	No	No	pword	0	A	No
idx_tbl_admin_email	BTREE	No	No	email	0	A	Yes
idx_tbl_admin_phone	BTREE	No	No	phone	0	A	Yes
idx_tbl_admin_time_stamp	BTREE	No	No	time_stamp	0	A	No
idx_tbl_admin_status	BTREE	No	No	status	0	A	Yes
idx_tbl_admin_post_date	BTREE	No	No	post_date	0	A	Yes
idx_tbl_admin_post_time	BTREE	No	No	post_time	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_temp_approver_visa_id	BTREE	No	No	visa_id	0	A	Yes
idx_temp_approver_id_type	BTREE	No	No	id_type (768)	0	A	Yes
idx_temp_approver_status	BTREE	No	No	status	0	A	No
idx_temp_approver_id_approver	BTREE	No	No	id_approver	0	A	Yes
idx_temp_approver_cr_approver	BTREE	No	No	cr_approver	0	A	Yes
idx_temp_approver_post_date	BTREE	No	No	post_date	0	A	Yes

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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
idx_temp_provider_visa_id	BTREE	No	No	visa_id	0	A	Yes
idx_temp_provider_id_type	BTREE	No	No	id_type (768)	0	A	Yes
idx_temp_provider_status	BTREE	No	No	status	0	A	No
idx_temp_provider_id_provider	BTREE	No	No	id_provider	0	A	No
idx_temp_provider_id_approver	BTREE	No	No	id_approver	0	A	Yes
idx_temp_provider_cr_id_provider	BTREE	No	No	cr_id_provider	0	A	Yes
idx_temp_provider_id_receiver	BTREE	No	No	id_receiver	0	A	Yes
idx_temp_provider_post_date	BTREE	No	No	post_date	0	A	Yes

Open new phpMyAdmin window