bloodbank - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string
email string
phone string
password string
date_of_birth date
activated tinyInteger
api_token string
date_of_last_donation date
city_id integer
is_read boolean

cities

id increments
timestamps timestamps
name string
governorate_id integer

governorates

id increments
timestamps timestamps
name string

client_governorate

id increments
timestamps timestamps
client_id integer
governorate_id integer

posts

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

categories

id increments
timestamps timestamps
name string

client_post

id increments
timestamps timestamps
client_id integer
post_id integer

blood_types

id increments
timestamps timestamps
type string

blood_type_client

id increments
timestamps timestamps
client_id integer
blood_type_id integer

notifications

id increments
timestamps timestamps
title string
content string
donation_request_id integer

donation_requests

id increments
timestamps timestamps
patient_name string
patient_age string
hospital_name string
hospital_address string
latitude decimal (10,8)
longitude decimal (10,8)
bags_number integer
phone string
blood_type_id integer
client_id integer
city_id integer

client_notification

id increments
timestamps timestamps
client_id integer
notification_id integer

settings

id increments
timestamps timestamps
phone string
email string
facebook string
instagram string
google string
youtube string
whatsapp string
twitter string
linkedin string
about_app text

contacts

id increments
timestamps timestamps
title string
content text
client_id integer

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