dsis - Laravel Schema Designer

applicants

id increments
psu_id string (9)
first string
last string
email string
home_phone string
dob string
gender string
ethnicity string
timestamps timestamps
softDeletes softDeletes

programs

id increments
code string
name string
lp_code string
timestamps timestamps
softDeletes softDeletes

applications

id increments
applicant_id ^FK integer
semester string
program_id string
program_code string
gpa bigInteger
gre_v bigInteger
gre_q string
decision string
decision_date timestamp
employer_subsidy integer
experience integer
specialty string
specialty_other string
notes longText
timestamps timestamps
softDeletes softDeletes

application_files

id increments
application_id ^FK integer
file_name string
type string
description longText
timestamps timestamps
softDeletes softDeletes

universities

id increments
name string
state string
url string
timestamps timestamps
softDeletes softDeletes

applicant_university

applicant_id ^FK integer
university_id ^FK integer
timestamps timestamps
softDeletes softDeletes

rubrics

id increments
program_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

criteria

id increments
rubric_id ^FK integer
description longText
max_value integer
timestamps timestamps
softDeletes softDeletes

criteria_values

id increments
criteria_id ^FK integer
description string
possible_points integer
timestamps timestamps
softDeletes softDeletes

criteria_ratings

id increments
criteria_value_id ^FK integer
application_id ^FK integer
user_id integer
points integer
comment longText
timestamps timestamps
softDeletes softDeletes

applicant_employers

id increments
applicant_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01