BloodBank - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string
email string
date_of_birth date
last_day_of_donation date
city_id integer
phone_number integer
password string
pin_code integer
blood_type_id integer

posts

id increments
timestamps timestamps
title string
content string
image string
category_id integer

donation_requests

id increments
timestamps timestamps
name string
age integer
blood_bags integer
hospital_name string
latitude decimal (10.8)
longatitude decimal (10.8)
city_id integer
phone_number integer
comments string
client_id ^FK integer
blood_type_id string

blood_type_client

id increments
timestamps timestamps
client_id integer
blood_type_id integer

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id integer

blood_types

id increments
timestamps timestamps
type string

notifications

id increments
timestamps timestamps
title string
donation_request_id integer

client_post

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

client_notification

id increments
timestamps timestamps
client_id integer
notification_id integer
is_read boolean

categories

id increments
timestamps timestamps
name string

configs

id increments
timestamps timestamps
about string
phone string
email string
facebook_url string
twitter_url string
youtube_url string
instagram_url string
whatsapp_url string
google_plus_url string
image string

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