nurture hub's - Laravel Schema Designer

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