blood_bank - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string
password string
email string
date_of_birth date
blood_type_id ^FK integer
date_of_last_donation date
city_id ^FK integer
phone integer
code string
num_unreaded_notifications mediumInteger
api_token string (60)

blood_types

id increments
timestamps timestamps
name string

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id integer

articles

id increments
timestamps timestamps
header string
content text
img_path string

categories

id increments
timestamps timestamps
name string

donation_requests

id increments
timestamps timestamps
name string
age smallInteger
blood_type_id ^FK integer
num_of_bags smallInteger
latitudes decimal
longitude decimal
governorate_id ^FK integer
phone integer
notes text

contacts

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

configs

id increments
timestamps timestamps
android_app_url string
fb string
twitter string
inst string
whats string
google string
phone integer
about text
home text
notification_config text

article_client

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

article_category

id increments
timestamps timestamps
article_id ^FK integer
category_id ^FK integer

blood_type_client

id increments
timestamps timestamps
blood_type_id integer
client_id integer

client_governorate

id increments
timestamps timestamps
client_id integer
governorate_id integer

client_donation_request

id increments
timestamps timestamps
client_id integer
donation_request_id integer

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