nurture hub's - Laravel Schema Designer

house

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
name_en string (255)
name_ar string (255)
phone string (20)
address_en string (255)
address_ar string (255)
establishment_date date
description_en text
description_ar text
number_of_children integer
average_age decimal (3,1)
activities text

orphan

id increments
timestamps timestamps
softDeletes softDeletes
house_id integer
name_en string (255)
name_ar string (255)
birth_date date
birth_place string (255)
orphan_condition string (255)
parents_condition string (255)
live_with_family tinyInteger
colleagues text

orphan_sibling

id increments
timestamps timestamps
softDeletes softDeletes
orphan_id integer
name_en string (255)
name_ar string (255)
relative_status string (255)

orphan_family

id increments
timestamps timestamps
softDeletes softDeletes
orphan_id integer
name_en string (255)
name_ar string (255)
relative_status string (255)

house_worker

id increments
timestamps timestamps
softDeletes softDeletes
house_id integer
name_en string (255)
name_ar string (255)
description_en text
description_ar text
position_id integer

position

id increments
timestamps timestamps
softDeletes softDeletes
name_en string (255)
name_ar string (255)

provider_request

id increments
timestamps timestamps
softDeletes softDeletes
name_en string (255)
name_ar string (255)
phone string (20)
email string (255)
address_en string (255)
address_ar string (255)
type string (255)
description_en text
description_ar text
additional_info_en text
additional_info_ar text

house_requirement

id increments
timestamps timestamps
softDeletes softDeletes
house_id integer
orphan_id integer
type enum
store_id integer
product_id integer
category_id integer
total_price decimal (10,2)
quantity integer

house_service

id increments
timestamps timestamps
softDeletes softDeletes
house_id integer
name_en string (255)
name_ar string (255)
description_en text
description_ar text
cost_min decimal (10,2)
cost_max decimal (10,2)
is_urgent tinyInteger

store

id increments
timestamps timestamps
softDeletes softDeletes
name_en string (255)
name_ar string (255)

store_product

id increments
timestamps timestamps
softDeletes softDeletes
store_id integer
name_en string (255)
name_ar string (255)
price decimal (10,2)
link string (255)
category_id integer

category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string (255)
name_ar string (255)

country

id increments
timestamps timestamps
softDeletes softDeletes
name_en string (255)
name_ar string (255)
code string (100)
flag string (255)

user

id increments
timestamps timestamps
softDeletes softDeletes
gender string (20)
id_number string (50)
country_id integer
phone string (20)
biography_en text
biography_ar text
house_id integer
join_date date
username string (255)

wishlist

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
requirement_id integer

user_goal

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
from_date date
to_date date
amount decimal (10,2)
general_requirements_amount decimal (10,2)
individual_requirement_amount decimal (10,2)
service_amount decimal (10,2)

user_donation

id increments
timestamps timestamps
softDeletes softDeletes
donation decimal (10,2)
user_id integer
requirement_id integer
service_id integer

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