lmvfrmember - Laravel Schema Designer

contact_information

id increments
user_id ^FK integer
middle_initial string (1)
firstname string (50)
lastname string (50)
street_address string
city string (50)
primary_phone_number string (10)
primary_phone_extension string (10)
primary_phone_type enum
secondary_phone_number string (10)
secondary_phone_extension string (10)
secondary_phone_type enum
emergency_full_name string
emergency_relationship string (30)
emergency_primary_phone_number string (10)
emergency_primary_phone_extension string (10)
emergency_primary_phone_type enum
emergency_secondary_phone_number string (10)
emergency_secondary_phone_extension string (10)
emergency_secondary_phone_type string
date_of_birth date
drivers_licence_number string (30)
drivers_licence_state string (2)
timestamps timestamps

shift

id increments
shiftable_id integer
shiftable_type string
Day string (10)
shift enum
timestamps timestamps

user

id increments
name string (50)
email string
password string (60)
timestamps timestamps
verified date
disabled date
remember_token string (100)
verify_token string (60)
verify_token_last_date date

rescue

id increments
user_id ^FK integer
junior boolean
active date
callsign integer
division_start_date date
life_member date
note text
positions string
timestamps timestamps

status

id increments
statusable_id integer
statusable_type string
status string (60)
status_effective_date date
current boolean
note text
timestamps timestamps

callsign

id increments
callsignable_id integer
callsignable_type string
name string (10)
reserved date
timestamps timestamps

attendance

id increments
attendable_id integer
attendable_type string
start datetime
end datetime
timestamps timestamps
activity string

background_information

id increments
user_id integer
fingerprint_card_submitted date
background_status enum
background_document string
driving_record_received timestamp
driving_record_document string
timestamps timestamps

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