blood-bank - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string
email string
blood_type_id integer
date_of_birth date
last_donation_date date
phone string
password string
city_id string
pin_code string

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
government_id integer

blood_types

id increments
timestamps timestamps
name string

blood_type_client

id increments
timestamps timestamps
blood_type_id integer
client_id integer

client_government

id increments
timestamps timestamps
client_id integer
government_id integer

posts

id increments
timestamps timestamps
title string
content text
photo string
category_id integer

client_post

id increments
timestamps timestamps
client_id integer
post_id integer
favorite_status tinyInteger

categories

id increments
timestamps timestamps
name string

donation_requests

id increments
timestamps timestamps
client string
blood_type_id string
age integer
bags_num integer
latitude decimal
longitude decimal
city_id integer
phone string
hospital string
notes text
client_id integer

contacts

id increments
timestamps timestamps
client_id integer
message text
message_title string

settings

id increments
timestamps timestamps
phone string
email string
insta_url string
facebook_url string
youtube string
appstore_url string

notifications

id increments
timestamps timestamps
client_id integer
title string
content text
donation_request_id integer

client_notification

id increments
timestamps timestamps
client_id integer
notification_id integer
is_read boolean

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