Home
somadb
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
person
id
increments
timestamps
timestamps
email_address
string
(120)
password
string
(128)
password_change_required
binary
head_of_household
FK
integer
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
FK
integer
membership_type
enum
membership_expiration
date
notes
id
increments
timestamps
timestamps
note_type
enum
payment_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
activity
id
increments
timestamps
timestamps
event
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
activity_attendees
id
increments
timestamps
timestamps
activity_id
FK
integer
person_id
FK
integer
×
Exporting error!
There is an error with the foreign key contraints, please check if reference of column "event" in table "activity" is still correct.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01