id | int(11) |
|
|
|
user_id | int(11) |
|
|
|
first_name | varchar(100) |
|
|
|
added_by | int(11) |
|
|
|
research_area | text |
|
|
|
university | varchar(255) |
|
|
|
address | varchar(255) |
|
|
|
contact_email | varchar(100) |
|
|
|
contact_number | varchar(35) |
|
|
|
member_type | tinyint(2) |
|
|
|
country | varchar(100) |
|
|
|
nationality | tinyint(2) |
|
|
|
designation | varchar(50) |
|
|
|
dept_id | tinyint(2) |
|
|
|
student_id | varchar(20) |
|
|
|
date_created | datetime |
|
|
CURRENT_TIMESTAMP
|
date_modified | datetime |
|
|
CURRENT_TIMESTAMP
|