blood bank - Laravel Schema Designer

clients

id increments
name string
email string
password string
phone string
date_of_birth date
blood_type_id integer
last_date_donation date
city_id integer
pin_code integer
timestamps timestamps

blood_types

id increments
name string
timestamps timestamps

cities

id increments
governorate_id integer
name string
timestamps timestamps

governorates

id increments
name string
timestamps timestamps

posts

id increments
category_id integer
title string
image string
text text
timestamps timestamps

categories

id increments
name string
timestamps timestamps

client_post

id increments
client_id integer
post_id integer
timestamps timestamps

donation_requests

id increments
client_id integer
patient_name string
patient_age string
blood_type_id integer
city_id integer
hospital_address string
bags_num integer
patient_phone string
hospital_name string
details text
latitude decimal (10,8)
longitude decimal (10,8)
timestamps timestamps

notifications

id increments
donation_requests_id integer
title string
content string
timestamps timestamps

client_notification

id increments
client_id integer
notification_id integer
is_read boolean
timestamps timestamps

settings

id increments
phone string
email string
fb_link string
tw_link string
insta_link string
notification_setting_text text
about_app text
timestamps timestamps

blood_type_client

id increments
blood_type_id integer
client_id integer
timestamps timestamps

client_governorate

id increments
client_id integer
governorate_id integer
timestamps timestamps

contacts

id increments
name string
mail string
phone string
subject string
message text
timestamps timestamps

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