blood_bank - Laravel Schema Designer

clients

id increments
name string (255)
phone string (255)
email string (255)
password string (255)
d_o_b date
last_donation_date date
code smallInteger
city_id ^FK integer
timestamps timestamps

blood_types

id increments
name string (5)
timestamps timestamps

cities

id increments
name string
governorate_id ^FK integer
timestamps timestamps

governorates

id increments
name string
timestamps timestamps

posts

id increments
title string
photo string
content text
category_id ^FK integer
timestamps timestamps

categories

id increments
name string
timestamps timestamps

donations

id increments
name string
age smallInteger
bags_num smallInteger
phone string
hospital_address string
longitude decimal (10,8)
latitude decimal (10,8)
details text
client_id ^FK integer
blood_type_id ^FK integer
city_id ^FK integer
timestamps timestamps

client_post

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

contacts

id increments
phone string
email string
fac_link string
insta_link string
tweet_link string
tube_link string
timestamps timestamps

client_notification

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

notifications

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

settings

id increments
notification_setting_text text
about_app text
fac_link string
insta_link string
tweet_link string
tube_link string
timestamps timestamps

client_governorate

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

blood_type_client

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

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