blood_bank - Laravel Schema Designer

donation_requests

id increments
timestamps timestamps
client_id integer
patient_name string
patient_age integer
blood_type enum
bags_num integer
hospital_name string
hospital_address string
city_id integer
phone string
notes text
latitude double (8,10)
longitude double (8,10)

clients

id increments
timestamps timestamps
name string
email string
birth_date date
city_id integer
phone string
donation_last_date date
passwoed string
blood_type enum
is_active boolean
api_token string (60)

posts

id increments
timestamps timestamps
client_id integer
title string
thumbnail string
content text
publish_date date
category_id integer

categories

id increments
timestamps timestamps
name string

reports

id increments
timestamps timestamps
client_id integer
message text

article_client

id increments
timestamps timestamps
client_id integer
post_id integer

contacts

id increments
timestamps timestamps
client_id integer
title string
message text

settings

id increments
timestamps timestamps
phone string
email string
about_app text
facebook_url string
twitter_url string
youtube_url string
whatsapp string
instagram_url string
google_url string

blood_types

id increments
timestamps timestamps
name string

governorates

id increments
timestamps timestamps
name string (50)

cities

id increments
timestamps timestamps
name string
governorate_id integer

notifications

id increments
timestamps timestamps
title string
content text
donation_request_id integer

city_client

id increments
timestamps timestamps
city_id integer
client_id integer

blood_type_client

id increments
timestamps timestamps
client_id integer
blood_type_id integer

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