Blood_Bank - Laravel Schema Designer

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
email string (255)
password string (255)
gender enum
birth_date date
city_id ^FK integer
blood_type_id ^FK integer
phone string (255)
last_donation date
status tinyInteger

governments

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
government_id ^FK integer

categories

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)

articles

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
content longText
image string (255)
category_id ^FK integer
status integer

fav_articles

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK integer
article_id ^FK integer

donations

id increments
timestamps timestamps
softDeletes softDeletes
blood string (255)
hospital_name string (255)
city_id integer
phone string (255)
name string (255)
age string (50)
bags_number string (255)
hospital_address text
notes text
lat decimal (10,8)
client_id ^FK integer
lng decimal (10,8)

notifications

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
content text
donation_id ^FK integer

client_notification

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK integer
notification_id ^FK integer

contacts

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK integer
message text
title string (255)

app_settings

id increments
timestamps timestamps
title string (255)
desc text
tags text
phone string (255)
email string (255)
facebook string (255)
twitter string (255)
youtube string (255)
instegram string (255)
whattsapp string (255)
google_plus string (255)
about text
status tinyInteger
textclose text
app_link1 string (255)
app_link2 string (255)

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
email string (255)
password string (255)
image string (255)
status tinyInteger

blood_types

id increments
timestamps timestamps
softDeletes softDeletes
type string (255)

client_government

id increments
timestamps timestamps
client_id ^FK integer
government_id ^FK integer

blood_client

id increments
timestamps timestamps
blood_type_id ^FK integer
client_id ^FK integer

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