BloodBank - Laravel Schema Designer

clients

id increments
name string (191)
email string
birthdate date
bloodtype_id ^FK integer
lastdonation_date date
city_id ^FK integer
phone string (191)
password string (191)
timestamps timestamps
softDeletes softDeletes

blood_types

id increments
name string (191)
timestamps timestamps

cities

id increments
name string (191)
governate_id ^FK integer
timestamps timestamps

posts

id increments
photo string
title string (191)
decription longText
category_id ^FK integer
timestamps timestamps
softDeletes softDeletes

governates

id increments
name string
timestamps timestamps

categories

id increments
name string
timestamps timestamps
softDeletes softDeletes

notifications

id increments
title string
content longText
donation_request_id ^FK integer
timestamps timestamps
softDeletes softDeletes

donation_requests

id increments
client_id ^FK integer
name string (191)
age float
bloodtype_id ^FK integer
num_of_bags integer
city_id ^FK integer
longtitude decimal (8,10)
latitude decimal (8,10)
phone string
notes longText
softDeletes softDeletes
timestamps timestamps

post_client

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

bloodtype_client

id increments
client_id ^FK integer
bloodtype_id ^FK integer
timestamps timestamps

notification_governate

id increments
timestamps timestamps
client_id ^FK integer
governate_id ^FK integer

client_notification

id increments
client_id ^FK integer
isread enum
notification_id ^FK integer
timestamps timestamps

app_settings

id increments
phone string
email string
facebook string
instagram string
youtube string
about_app longText
twitter string
timestamps timestamps
softDeletes softDeletes

contacts

id increments
client_id ^FK integer
title string
content longText
timestamps timestamps

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