bloodbank - Laravel Schema Designer

clients

id increments
name string
email string
phone string
password string
date_of_birth date
last_donation_date date
pin_code integer
timestamps timestamps
blood_type_id ^FK integer
city_id ^FK integer

blood_types

id increments
name string
timestamps timestamps

governorates

id increments
name string
timestamps timestamps

posts

id increments
title string
image binary
content text
category_id ^FK integer
timestamps timestamps

client_post

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

donation_requests

id increments
patient_name string
patient_phone string
hospital_name string
hospital_adress string
patient_age integer
bags_num integer
details text
blood_type_id ^FK integer
client_id ^FK integer
city_id ^FK integer
timestamps timestamps

notifications

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

client_notification

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

settings

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

contacts

id increments
subject string
message text
timestamps timestamps
client_id ^FK integer

cities

id increments
governorate_id ^FK integer
timestamps timestamps
name string

categories

id increments
timestamps timestamps
name 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

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