BB - Laravel Schema Designer

clients

id increments
name string
email string
dob date
last_donation_date date
phone integer
age smallInteger
password string
blood_type_id ^FK integer
city_id ^FK integer

blood_types

id increments
type string (3)

cities

id increments
name string
government_id ^FK integer

governments

id increments
name string

article_categories

id increments
name string

articles

id increments
article_category_id ^FK integer
title string
body longText
image string

donation_requests

id increments
client_id ^FK integer
client_name string
client_age string
blood_type_id ^FK integer
bags_count integer
hospital_latitude decimal (10,8)
hospital_longitude decimal (10,8)
city_id ^FK integer
client_phone string
comment string
hospital_name string
address string

about

id increments
phone integer
email string
about_app longText
fb_link string
instagram_link string
x_link string
youtube_link string

messages

id increments
title string
body string
client_id ^FK integer

notifications

id increments
body longText
timestamp timestamp

article_client

article_id ^FK integer
client_id ^FK integer

client_notification

client_id ^FK integer
notification_id ^FK integer
is_read boolean

blood_type_client

client_id ^FK integer
blood_type_id ^FK integer

client_government

government_id ^FK integer
client_id ^FK integer

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