aas - Laravel Schema Designer

applications

id increments
course_id ^FK integer
user_id ^FK integer
online boolean
payment_option_id ^FK integer
admission_year string (255)
sponsor json
finance_letter binary
timestamps timestamps
softDeletes softDeletes

users

id increments
timestamps timestamps
softDeletes softDeletes

lookups

id increments
timestamps timestamps

courses

id increments
timestamps timestamps
softDeletes softDeletes

profiles

id increments
import_id string
user_id ^FK integer
gender_id ^FK integer
ethnicity_id ^FK integer
address json
postal_address json
alternative_address json
date_of_birth date
identification_type_id ^FK integer
id_number string (255)
nationality_id ^FK integer
permit_type_id ^FK integer
permit_number string (255)
study_permit_number string (255)
language_id ^FK integer
student_number string (255)
religion_id ^FK integer
title string (255)
marital_status_id ^FK integer
finance_id ^FK integer
sponsor_letter_file string (255)
sponsor_information json
school_id ^FK integer
school_record json
school_leaving_year integer
examination_authority ^FK integer
exemption_type_id ^FK integer
previous_studies json
next_of_kin_information json
employment_information json
activities json
personal_statements json
reference_contact json
timestamps timestamps
softDeletes softDeletes

schools

id increments
is_queryable boolean
name string (255)
address string (255)
primary_contact_number string (255)
timestamps timestamps
softDeletes softDeletes

tertiary_institutions

id increments
name string (255)
is_queryable boolean
timestamps timestamps
softDeletes softDeletes

user_studies

id increments
user_id ^FK integer
tertiary_institutions_id ^FK integer
qualification_name string (255)
is_complete boolean
timestamps timestamps
softDeletes softDeletes

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