|
id
|
int(4)
|
|
|
|
|
name
|
varchar(80)
|
latin1_swedish_ci
|
|
|
|
reg_id
|
varchar(15)
|
latin1_swedish_ci
|
|
|
|
app_no
|
int(10)
|
|
|
|
|
lib_id
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
dob
|
date
|
|
|
|
|
pumail
|
varchar(150)
|
latin1_swedish_ci
|
|
|
|
email
|
tinytext
|
latin1_swedish_ci
|
|
|
|
mobile
|
varchar(10)
|
latin1_swedish_ci
|
|
|
|
role
|
tinyint(4)
|
|
|
|
|
program_type
|
tinyint(4)
|
|
|
|
|
fee_type
|
int(11)
|
|
|
|
|
program_code
|
varchar(6)
|
latin1_swedish_ci
|
|
|
|
reg_number
|
varchar(15)
|
latin1_swedish_ci
|
|
|
|
year_joined
|
year(4)
|
|
|
|
|
program_id
|
int(3)
|
|
|
|
|
dept_id
|
int(3)
|
|
|
|
|
school_id
|
int(11)
|
|
|
|
|
password
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
finalized
|
tinyint(1)
|
|
|
|
|
created
|
datetime
|
|
|
|
|
date_modified
|
timestamp
|
|
|
|
|
modified
|
datetime
|
|
|
|
|
locked
|
int(1)
|
|
|
|
|
password_reset
|
int(1)
|
|
|
|
|
status
|
int(1)
|
|
|
|
|
student_type
|
int(2)
|
|
|
|
|
oauth_uid
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
oauth_provider
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
gpicture
|
varchar(255)
|
latin1_swedish_ci
|
|
|
