blood_bank - Laravel Schema Designer

clients

id increments
timestamps timestamps
phone string
email string
d_o_b date
blood_type_id ^FK integer
last_donnation_date date
city_id ^FK integer
password 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
name string
category_id ^FK integer

categories

id increments
timestamps timestamps
name string

client_post

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

donnation_requests

id increments
timestamps timestamps
patient_name string
patient_phone string
hospital_name string
blood_type_id ^FK integer
bags_num string
details text
longitude decimal (10,8)
lattitude decimal (10,8)
client_id ^FK integer

notifications

id increments
timestamps timestamps
title string
content string
donnation_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
notifaction string
setting_text text
about_app text
phone string
emai string
facebook_link string
twitter_link string
instagram_link string

client_governorate

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

blood_type_client

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

blood_type_notification

id increments
timestamps timestamps
blood_type_id ^FK integer
notification_id ^FK integer

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