Home
nurture hub's
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
client
id
increments
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
first_name
string
(50)
last_name
string
(50)
mobile_number
string
(20)
house
id
increments
timestamps
timestamps
softDeletes
softDeletes
name_en
string
(100)
name_ar
string
government_license_en
string
government_license_ar
string
address_en
text
address_ar
text
latitude
double
longitude
double
description_en
text
description_ar
text
current_child_count
integer
average_age
double
child_capacity
integer
responsible_name_en
string
(100)
responsible_name_ar
string
responsible_phone
string
(20)
phone
string
establishment_date
date
activity_program
text
email
string
biography_en
text
biography_ar
text
user_id
integer
house_gallery
id
increments
timestamps
timestamps
softDeletes
softDeletes
title_en
string
title_ar
string
house_id
integer
house_staff
id
increments
timestamps
timestamps
softDeletes
softDeletes
house_id
integer
type
string
name_en
string
name_ar
string
phone
string
email
string
join_date
date
biography_en
text
biography_ar
text
details_en
text
details_ar
text
status
string
departure_date
date
house_program_activity
id
increments
timestamps
timestamps
softDeletes
softDeletes
house_id
integer
name_en
string
name_ar
string
details_en
text
details_ar
text
house_support_method
id
increments
timestamps
timestamps
softDeletes
softDeletes
house_id
integer
name_en
string
name_ar
string
details_en
text
details_ar
text
house_special_need
id
increments
timestamps
timestamps
softDeletes
softDeletes
house_id
integer
orphan_id
integer
donation_category_id
integer
title_en
string
title_ar
string
description_en
text
description_ar
text
requested_date
date
fulfilled_date
date
status
string
(50)
expected_price
double
due_date
date
orphan
id
increments
timestamps
timestamps
softDeletes
softDeletes
house_id
integer
name_en
string
name_ar
string
first_name
string
(50)
last_name
string
(50)
date_of_birth
date
place_of_birth
text
orphan_status
string
(50)
parent_status
string
(50)
special_need
text
activity_program
text
challenge
text
financial_material_need
text
type
string
(50)
caretaker_details_en
text
caretaker_details_ar
text
orphan_sibling
id
increments
timestamps
timestamps
softDeletes
softDeletes
orphan_id
integer
first_name
string
(50)
last_name
string
(50)
date_of_birth
date
relationship
string
(50)
details_en
text
details_ar
text
service_category
id
increments
timestamps
timestamps
softDeletes
softDeletes
name_en
string
name_ar
string
description_en
text
description_ar
text
service_provider
id
increments
timestamps
timestamps
softDeletes
softDeletes
name_en
string
name_ar
string
provider_location
string
(100)
description_en
text
description_ar
text
email
string
(100)
mobile
string
(15)
phone
string
(15)
hotline
string
(15)
additional_info_en
text
additional_info_ar
text
responsible_person
string
(100)
service_category_id
integer
donation
id
increments
timestamps
timestamps
softDeletes
softDeletes
amount
double
donation_date
datetime
is_specific
boolean
payment_method
string
(50)
payment_reference
string
(100)
donation_type
string
(20)
user_id
integer
orphan_id
integer
house_id
integer
special_need_id
integer
donation_category_id
integer
donation_category
id
increments
timestamps
timestamps
softDeletes
softDeletes
name_en
string
name_ar
string
description_en
text
description_ar
text
user
id
increments
timestamps
timestamps
softDeletes
softDeletes
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01