Bloodbank - Laravel Schema Designer

clients

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

blood_types

id increments
timestamps timestamps
name string

governments

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
government_id integer

categories

id increments
timestamps timestamps
name string

posts

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

donation_requests

id increments
timestamps timestamps
patient_name string
patient_age tinyInteger
blood_type_id ^FK integer
bags_number smallInteger
hospital_name string
hospital_address string
patient_phone string
details text
latitude decimal (10,8)
longitude decimal (10,8)
client_id ^FK integer
city_id ^FK integer

notifications

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

contacts

id increments
timestamps timestamps
subject string
message text
client_id ^FK integer
name string
email string
phone string

settings

id increments
timestamps timestamps
notification_settings_text string
about_app text
phone string
email string
fb_link string
tw_link string
insta_link string
you_link string

clientables

id increments
timestamps timestamps
client_id integer
clientable_id integer
clientable_type string

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