bloodbank - Laravel Schema Designer

clients

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

cities

id increments
name string
governorate_id ^FK bigInteger
timestamps timestamps

governorates

id increments
name string
timestamps timestamps

blood_types

id increments
name string
timestamps timestamps

categories

id increments
name string
timestamps timestamps

posts

id increments
title text
img string
content text
category_id ^FK bigInteger
timestamps timestamps

notifications

id increments
title text
date date
donation_request_id ^FK bigInteger
timestamps timestamps

contacts

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

settings

id increments
phone string
email string
about_us text
fb_link string
tw_link string
in_link string
yt_link string
notification_setting_message text
timestamps timestamps

donation_requests

id increments
patient_name string
patient_age integer
patient_phone string
hospital string
address text
bags_quantity integer
latitude decimal (10,8)
longitude decimal (10,8)
notes text
city_id ^FK bigInteger
blood_type_id ^FK bigInteger
client_id ^FK bigInteger
timestamps timestamps

client_notification

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

client_post

id increments
client_id ^FK bigInteger
post_id ^FK bigInteger
timestamps timestamps

client_governorate

id increments
client_id ^FK bigInteger
governorate_id ^FK bigInteger
timestamps timestamps

blood_type_client

id increments
blood_type_id ^FK bigInteger
client_id ^FK bigInteger
timestamps timestamps

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