bloodbank-24 - Laravel Schema Designer

blood_types

id increments
timestamps timestamps
name string

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

clients

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

categories

id increments
timestamps timestamps
name string

posts

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

donation_requests

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

settings

id increments
timestamps timestamps
notification_settings_text longText
about longText
phone string
email string
fb_link string
insta_link string
tw_link string
youtube_link string
whatup_link string

contacts

id increments
timestamps timestamps
name string
email string
subject text
message longText
phone string

notifications

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

clientables

id increments
timestamps timestamps
client_id ^FK integer
clientable_id integer
clientable_type string
is_read boolean

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