blood_bank - Laravel Schema Designer

clients

id increments
name string
email string
date_of_birth string
blood_type_id integer
phone string
city_id integer
activated tinyInteger
last_date_donated string
verification_code integer
password string
timestamps timestamps

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps integer
governorate_id integer

blood_types

id increments
timestamps timestamps
name string

blood_type_client

id increments
timestamps timestamps
client_id integer
blood_type_id integer

posts

id increments
timestamps timestamps
title string
article longText
image string
category_id integer

client_post

id increments
timestamps timestamps
client_id integer
post_id integer

donation_requests

id increments
client_id integer
timestamps timestamps
name string
age integer
blood_type_id integer
number_bags integer
hospital_name string
hospital_address string
town_id integer
phone string
latitude decimal (10,8)
longitude decimal (10,8)
notes longText
governorate_id integer

settings

id increments
timestamps timestamps
phone string
email string
google_plus string
whatsapp string
instagram string
youtube string
facebook string
app_store string
play_store string
about longText

contacts

id increments
timestamps timestamps
name string
email string
phone string
title string
message longText
client_id integer

categories

id increments
timestamps timestamps
name string

notifications

id increments
timestamps timestamps
title string
donation_request_id integer
content longText

client_notification

id increments
timestamps timestamps
client_id integer
notification_id integer
read double

client_governorate

id increments
timestamps timestamps
client_id integer
governorate_id integer

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