somadb - Laravel Schema Designer

person

id increments
timestamps timestamps
email_address string (120)
password string (128)
password_change_required binary
first_name string (50)
last_name string (50)
birthday date
person_type enum
address1 string (80)
address2 string
address3 string (80)
city string (80)
state_province string (80)
zip_postcode string (10)
country string (80)
primary_phone_country_code string (3)
primary_phone_number string (10)
primary_phone_receives_SMS boolean
alternate_phone_country_code string (3)
alternate_phone_number string (10)
alternate_phone_receives_SMS boolean

members

id increments
timestamps timestamps
person_id ^FK integer
membership_type enum
membership_expiration date
primary_member_id ^FK integer

notes

id increments
timestamps timestamps
note_type enum
payment_id ^FK integer
person_id ^FK integer
text string (250)

payments

id increments
timestamps timestamps
payment_type enum
payment_currency string (3)
payment_amount decimal
paying_person ^FK integer

event

id increments
timestamps timestamps
event_type enum
event_name string (100)
description text
start_date date
start_time time
end_date date
end_time time
registration_required boolean
member_only boolean
maximum_attendees smallInteger

activity

id increments
timestamps timestamps
event_id ^FK integer
activity_name string (100)
description text
act_date date
act_start_time time
act_end_time time
registration_required boolean
maximum_attendees smallInteger

presenter

id increments
timestamps timestamps
person_id ^FK integer

volunteer

id increments
timestamps timestamps
person_id ^FK integer

activity_staffing_presenter

id increments
timestamps timestamps
activity_id ^FK integer
presenter_id ^FK integer

activity_staffing_volunteer

id increments
timestamps timestamps
activity_id ^FK integer
volunteer_id ^FK integer

event_attendees

id increments
timestamps timestamps
event_id ^FK integer
person_id ^FK integer

activity_attendees

id increments
timestamps timestamps
activity_id ^FK integer
person_id ^FK integer

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