Student Discussions

Accounts

Messages

Faculties

New Student Checklist Table

Students

account_id is a foreign key to Accounts table

Research Areas

Graduate Applications

Field	Type	Other
id	int	unique
first_name	string
last_name	string
email	string
phone	string
dob	datetime
status	string
created_at	datetime
updated_at	datetime
account_id	int	unique

Graduate Application Evaluations

Field	Type	Other
id	int	unique
graduate_application_id	int	unique
account_id	int
score	int
comment	string
created_at	datetime
updated_at	datetime

Educations

Field	Type	Other
id	int	unique
graduate_application_id	int	unique
school_name	string
major	string
degree	string
currently_attending	boolean
state_date	datetime
end_date	datetime
gpa_value	float
gpa_Scale	float
created_at	datetime
updated_at	datetime

Documents

Field	Type	Other
id	int	unique
graduate_application_id	int	unique
name	string
description	string
file_ref	string
created_at	datetime
updated_at	datetime