Blood_Bank - Laravel Schema Designer

clients

id increments
timestamps timestamps
phone string
email string
password string
name string
d_o_b date
blood_type_id ^FK integer
last_donation_data date
city_id ^FK integer
pin_code string

blood_types

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

governorates

id increments
timestamps timestamps
name string

posts

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

client_post

id increments
timestamps timestamps
client_id ^FK integer
post_id ^FK integer

donation_requests

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

notifications

id increments
timestamps timestamps
title string
content text
donation_request_id ^FK integer

client_notification

id increments
timestamps timestamps
client_id ^FK integer
notification_id ^FK integer
is_read boolean

settings

id increments
timestamps timestamps
notification_settings_text text
about_app text
tw_link string
fb_link string
insta_link string

blood_type_client

id increments
timestamps timestamps
blood_type_id ^FK integer
client_id ^FK integer

client_governorate

id increments
timestamps timestamps
client_id ^FK integer
governorate_id ^FK integer

contacts

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

categories

id increments
timestamps timestamps
name string

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