blood bank - Laravel Schema Designer

clients

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

blood_types

id increments
timestamps timestamps
name string (50)

cities

id increments
timestamps timestamps
name string (255)
governorate_id ^FK integer

governorates

id increments
timestamps timestamps
name string (255)

posts

id increments
timestamps timestamps
name string (50)
image string (255)
content string (255)
category_id ^FK integer

categories

id increments
timestamps timestamps
name string (50)

donation_requests

id increments
timestamps timestamps
patient_name string (50)
patient_phone string (11)
patient_age integer
bags_num integer
hospital_name string (255)
hospital_address string (255)
details string (255)
city_id ^FK integer
client_id ^FK integer
longtude decimal (10.8)
latitude decimal (10.8)
blood_type_id ^FK integer

clientables

timestamps timestamps
clientable_id integer
clientable_type string (255)
client_id ^FK integer
is_read boolean

settings

id increments
timestamps timestamps
about_app string (255)
phone string (11)
email string (255)
notification_settings_text string (255)
fb_link string (255)
x_link string (255)
insta_link string (255)
yt_link string (255)

contacts

id increments
timestamps timestamps
name string (255)
email string (255)
phone string (11)
subject string (255)
message string (255)

notifiactions

id increments
timestamps timestamps
title string (255)
contact string (255)
donation_request_id ^FK integer

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