tea-apps - Laravel Schema Designer

Users

id increments
timestamps timestamps
nameFirst string
nameLast string
email string
district_id string (6)
password string
role string
blocked tinyInteger

Districts

id increments
timestamps timestamps
name string
region string (2)
mailing1 string
mailing2 string
state string
city string
zip string (5)

Schools

id increments
timestamps timestamps
district_id string (6)
name string
status string

Applications

id increments
timestamps timestamps
user_id integer
district_id string (6)
school_id string (9)

Scoresheets

id increments
timestamps timestamps
application_id integer
user_id integer

Answers

id increments
timestamps timestamps
answerable_id integer
answerable_type string
question_option_id integer
answer_numeric integer
answer_text text
answer_bool tinyInteger
answer_date date

Surveys

id increments
timestamps timestamps
name string
description text
year string
type enum

Sections

id increments
timestamps timestamps
name string
header string
subheading string
survey_id integer

Question_Section

id increments
timestamps timestamps
section_id integer

Questions

id increments
timestamps timestamps
name string
subtext string
required tinyInteger
input_type_id integer
option_group_id integer

Question_Options

id increments
timestamps timestamps
question_id integer
option_choice_id integer

Option_Groups

id increments
timestamps timestamps

Option_Choices

id increments
timestamps timestamps
name string
option_group_id string

Contacts

id increments
timestamps timestamps

Documents

id increments
timestamps timestamps

sectionables

id increments
timestamps timestamps
section_id integer
sectionable_type string
sectionable_id integer

Input_Types

id increments
timestamps timestamps
name string

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