Print view - phpMyAdmin 4.8.4

ci_sessions

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	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	63	A	No
id	BTREE	No	No	id	63	A	No
id	BTREE	No	No	school_id	63	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)	Yes	NULL
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	77262	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	37018	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	15	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_status	varchar(10)	No
scrutiny_remarks1	text	No
selection_status1	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	9633	A	No
reg_id	BTREE	No	No	reg_id	9633	A	No
app_no	BTREE	No	No	app_no	9633	A	No
job_id	BTREE	No	No	post_id	209	A	No
user_id	BTREE	No	No	user_id	9633	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(100)	Yes	NULL
col_value4	varchar(100)	Yes	NULL
col_value5	varchar(100)	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	152107	A	No
user_id	BTREE	No	No	user_id	19013	A	No
col_type	BTREE	No	No	col_type	4	A	Yes

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	10314	A	No
sams_trans_no	BTREE	Yes	No	sams_trans_no	10314	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(1)	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
merge_posts	int(11)	No
specialization	text	No
scrutiny_filter	varchar(255)	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	109	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
col_value10	varchar(200)	No
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	196864	A	No
user_id	BTREE	No	No	user_id	13124	A	No
user_id_2	BTREE	No	No	user_id	16405	A	No
col_type	BTREE	No	No	col_type	4	A	Yes

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	13	A	No
id	BTREE	No	No	id	13	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	44	A	No
table_id	BTREE	No	No	table_id	8	A	No
type	BTREE	No	No	type	14	A	No
code	BTREE	No	No	code	44	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 (Primary)	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
dept_id	int(11)	No
status	tinyint(2)	No	0
password	varchar(100)	No
photo	varchar(250)	Yes	NULL
application_submission	tinyint(2)	No	0
parta_general_lock	tinyint(4)	Yes	0
already_applied	int(11)	No
date_modified	timestamp	No	CURRENT_TIMESTAMP
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	13325	A	No
mobile_2	BTREE	Yes	No	mobile	13325	A	No
email	BTREE	Yes	No	email	13325	A	No
reg_id	BTREE	No	No	reg_id	13325	A	No
mobile	BTREE	No	No	mobile	13325	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	156842	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
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	13826	A	No
user_id	BTREE	No	No	user_id	13826	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.