blood_bank - Laravel Schema Designer

clients

id increments
name string (255)
email string (50)
phone string (255)
password string (255)
date_of_birth date
last_donation date
timestamps timestamps

donation_requests

id increments
timestamps timestamps
name string (255)
age integer
phone string (255)
hospital_name string (255)
amount integer
hospital_address mediumText
notes mediumText
latitude decimal (10,8)
longitude decimal (10,8)
blood_type_id integer
client_id ^FK integer
city_id ^FK integer

posts

id increments
timestamps timestamps
title string
body text
image string (255)
published_at date

client_favorite_post

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

contact_us

id increments
timestamps timestamps
message_title string (255)
message_body text
client_id ^FK integer

catogories

id increments
timestamps timestamps
name string (255)

governorates

id increments
timestamps timestamps
name string (255)

cities

id increments
timestamps timestamps
name string (255)
governorate_id ^FK integer

client_governorate

id increments
timestamps timestamps
governorate_id ^FK integer
client_id ^FK integer

notifications

id increments
timestamps timestamps
title string (255)
body text
donation_request_id ^FK integer

blood_types

id increments
timestamps timestamps
name string (50)

blood_type_client

id increments
timestamps timestamps
blood_type_id ^FK integer
client_id ^FK integer

client_notification

id increments
timestamps timestamps
client_id ^FK integer
notification_id ^FK integer

settings

id increments
timestamps timestamps
phone string (255)
email string (255)
facebook_url string (255)
youtube_url string (255)
googlePlus_url string (255)
instagram_url string (255)
whatsapp_url string (255)
app_url text
using_instructions text

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