Print view - phpMyAdmin 4.8.4

applicant_data

Table comments: VIEW

Column	Type	Null	Default	Links to	Comments	MIME
reg_id	int(11)	No
formNo	int(11)	No
Institute_name	varchar(22)	No
Post	varchar(100)	No
post_code	varchar(10)	No
firstName	varchar(100)	No
gender	varchar(15)	No
father_name	varchar(100)	No
mother_name	varchar(100)	No
nationality	varchar(6)	No
dob	date	No
telNo	varchar(50)	No
category	varchar(10)	No
marital_status	varchar(10)	No
email	varchar(200)	No
postalAdd1	varchar(500)	No
postalState	varchar(100)	No
postalPin	int(11)	No
permanentAdd1	varchar(500)	No
permanentState	varchar(100)	No
permanentPin	int(11)	No
photo_url	varchar(250)	Yes	NULL
pwd	varchar(9)	No

ci_sessions

Column	Type	Null	Default	Links to	Comments	MIME
id	varchar(40)	No	0
ip_address	varchar(45)	No	0
timestamp	int(10)	No	0
user_agent	varchar(120)	No
last_activity	int(10)	No	0
data	text	No

departments

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(2)	No
name	varchar(100)	No
school_id	int(2)	No
hod	int(2)	No
date_modified	timestamp	No	CURRENT_TIMESTAMP
office_intercom	varchar(10)	Yes	NULL
hod_intercom	varchar(10)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

education_details

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
user_id	int(11)	No
education	varchar(50)	No
education_type	varchar(50)	Yes	NULL
education_level	varchar(50)	Yes	NULL
study_mode	varchar(20)	Yes	NULL
subject	varchar(200)	Yes	NULL
education_board	varchar(200)	Yes	NULL
date_completion	varchar(50)	Yes	NULL
marks	varchar(5)	Yes	NULL
percentage	float	Yes	NULL
class	varchar(50)	Yes	NULL
title	varchar(500)	Yes	NULL
date_submission	varchar(25)	Yes	NULL
upload	varchar(250)	Yes	NULL
date_modified	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

experience_details

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
user_id	int(11)	No
experience_type	varchar(20)	Yes	NULL
institute	varchar(250)	Yes	NULL
designation	varchar(50)	Yes	NULL
service_from	varchar(20)	Yes	NULL
service_till	varchar(20)	Yes	NULL
service_period	varchar(20)	Yes	NULL
service_type	varchar(20)	Yes	NULL
employment_type	varchar(25)	Yes	NULL
pay_scale	varchar(25)	Yes	NULL
grade	varchar(25)	Yes	NULL
responsibility	varchar(500)	Yes	NULL
remarks	varchar(250)	Yes	NULL
upload	varchar(250)	No
data_modified	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

filters

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(4)	No
level	varchar(20)	No
type	varchar(50)	No
value	varchar(50)	No
title	varchar(250)	No
remarks	varchar(255)	No
remarks_na	varchar(255)	No
remarks_type_na	varchar(255)	No
description	varchar(255)	No
applied_to	varchar(255)	No
date_modified	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

jobs_registered

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
user_id	int(11)	No
reg_id	int(11)	No
app_no	int(11)	No
post_id	int(11)	No
app_status	varchar(2)	No
hardcopy_status	varchar(2)	No	N
year	varchar(4)	No
scrutiny_remarks	text	No
selection_status1	varchar(10)	No
scrutiny_remarks1	text	No
selection_status	varchar(10)	No
selection_remarks	varchar(100)	No
date_received	datetime	No
date_created	datetime	No	CURRENT_TIMESTAMP
date_modified	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

other_details

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
user_id	int(11)	No
col_type	varchar(50)	Yes	NULL
other_type	varchar(20)	Yes	NULL
col_value1	varchar(100)	Yes	NULL
col_value2	varchar(100)	Yes	NULL
col_value3	varchar(500)	Yes	NULL
col_value4	varchar(500)	Yes	NULL
col_value5	varchar(500)	Yes	NULL
upload	varchar(250)	No
date_modified	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

payment_bill_desk

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
user_id	int(11)	No
reg_id	varchar(12)	No
app_no	int(11)	No
post_id	int(11)	No
sams_trans_no	varchar(20)	No
sams_amount	varchar(10)	No
status	char(1)	No	F
fee_type	int(1)	No
year	int(4)	No
post_param	varchar(500)	No
MerchantID	varchar(20)	No
CustomerID	varchar(20)	No
TxnReferenceNo	varchar(30)	No
BankReferenceNo	varchar(30)	No
TxnAmount	varchar(10)	No
BankID	varchar(20)	No
BankMerchantID	varchar(30)	No
TxnType	varchar(10)	No
CurrencyName	varchar(5)	No
ItemCode	varchar(10)	No
SecurityType	varchar(10)	No
SecurityID	varchar(15)	No
SecurityPassword	varchar(30)	No
TxnDate	varchar(20)	No
AuthStatus	varchar(20)	No
SettlementType	varchar(20)	No
AdditionalInfo1	varchar(20)	No
AdditionalInfo2	varchar(20)	No
AdditionalInfo3	varchar(20)	No
AdditionalInfo4	varchar(20)	No
AdditionalInfo5	varchar(20)	No
AdditionalInfo6	varchar(20)	No
AdditionalInfo7	varchar(20)	No
ErrorStatus	varchar(10)	No
ErrorDescription	varchar(256)	No
response	varchar(500)	No
CheckSum	varchar(256)	No
amount_description	varchar(500)	No
date_modified	timestamp	No	CURRENT_TIMESTAMP
date_created_old	varchar(20)	No
date_created	timestamp	No	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

posts

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
postcode	varchar(10)	No
dept_id	int(11)	No
department	varchar(250)	No
designation	varchar(100)	No
total_post	varchar(5)	No
UR	varchar(2)	No
OBC	varchar(1)	No
SC	varchar(1)	No
ST	varchar(1)	No
EWS	varchar(1)	No
LD	varchar(1)	No
VI	varchar(1)	No
Sci_Hum	varchar(1)	No
fee_type	int(11)	No
level	int(2)	No
specialization	text	No
weight	int(4)	No
date_created	datetime	No	CURRENT_TIMESTAMP
date_modified	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	48	A	No

posts_old

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
postcode	varchar(10)	No
dept_id	int(11)	No
department	varchar(250)	No
designation	varchar(100)	No
total_post	varchar(5)	No
UR	varchar(1)	No
OBC	varchar(1)	No
SC	varchar(1)	No
ST	varchar(1)	No
EWS	varchar(1)	No
LD	varchar(1)	No
VI	varchar(1)	No
Sci_Hum	varchar(1)	No
fee_type	int(11)	No
specialization	text	No
date_created	datetime	No	CURRENT_TIMESTAMP
date_modified	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	43	A	No

research_details

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
user_id	int(11)	No
research_type	varchar(50)	Yes	NULL
col_code	text	Yes	NULL
col_type	int(11)	Yes	NULL
col_value1	varchar(500)	Yes	NULL
col_value2	varchar(500)	Yes	NULL
col_value3	varchar(200)	Yes	NULL
col_value4	varchar(200)	Yes	NULL
col_value5	varchar(200)	Yes	NULL
col_value6	varchar(200)	Yes	NULL
col_value7	varchar(200)	Yes	NULL
col_value8	varchar(200)	Yes	NULL
col_value9	varchar(200)	Yes	NULL
claimed_score	float	Yes	NULL
upload	varchar(250)	No
date_modified	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

schools

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(2)	No
name	varchar(100)	No
dean	int(2)	No	0
date_modified	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

type_definition

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
table_id	varchar(20)	No
type	int(11)	No
code	varchar(20)	No
title	varchar(250)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

uploads

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
user_id	int(11)	No
link	varchar(250)	No
date_modified	datetime	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

users

Column	Type	Null	Default	Links to	Comments	MIME
id	int(11)	No
reg_id	int(11)	No
username	varchar(100)	Yes	NULL
name	varchar(100)	No
mobile	varchar(50)	No
email	varchar(200)	No
dob	date	No
role	int(11)	No
status	tinyint(2)	No	0
password	varchar(100)	No
photo	varchar(250)	Yes	NULL
sign	varchar(250)	Yes	NULL
idproof	varchar(250)	Yes	NULL
application_submission	tinyint(2)	No	0
parta_general_lock	int(11)	No	0
date_modified	timestamp	No	CURRENT_TIMESTAMP
date_created	timestamp	No	0000-00-00 00:00:00
oauth_provider	varchar(10)	No
oauth_uid	varchar(50)	No
glogin_id	varchar(255)	No
gpicture	varchar(255)	No
locale	varchar(10)	No
picture	varchar(255)	No
link	varchar(255)	No
modified	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
id	BTREE	Yes	No	id	2	A	No
id_2	BTREE	Yes	No	id	2	A	No

user_activity

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
user_id	varchar(50)	No
ip_address	varchar(20)	No
user_agent	varchar(50)	No
platform	varchar(20)	No
system_details	varchar(255)	Yes	NULL
login_time	int(10)	No
attempt	tinyint(1)	Yes	NULL
date_modified	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

user_details

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
user_id	int(11)	No
father_name	varchar(100)	No
mother_name	varchar(100)	No
spouse_name	varchar(50)	No
nationality	varchar(11)	No
nri_status	varchar(4)	No
nri_country	varchar(50)	No
religion	varchar(15)	No
other_religion	varchar(20)	No
gender	varchar(15)	No
marital_status	varchar(10)	No
comm_address	varchar(500)	No
comm_state	varchar(100)	No
comm_pincode	int(11)	No
perm_address	varchar(500)	No
perm_state	varchar(100)	No
perm_pincode	int(11)	No
phone_res	varchar(15)	No
phone_off	varchar(15)	No
category	varchar(10)	No
ex_servicemen	int(11)	No
sportsperson	int(11)	No
disability	varchar(5)	No
disability_type	varchar(4)	No
disability_percent	float	No
near_relative	varchar(5)	No
near_relative_name	varchar(50)	No
near_relative_designation	varchar(30)	No
near_relative_relationship	varchar(30)	No
other	varchar(300)	No
birth_proof	varchar(250)	No
category_proof	varchar(250)	No
pwd_proof	varchar(250)	No
phd_proof	varchar(250)	No
date_created	timestamp	No	CURRENT_TIMESTAMP
date_modified	timestamp	No	CURRENT_TIMESTAMP
email_alt	varchar(50)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

Open new phpMyAdmin window

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.