blood_bank - Laravel Schema Designer

clients

id increments
name string (255)
phone bigInteger
password string (255)
email string (255)
date_of_birth date
blood_type_id ^FK integer
last_donation_date date
city_id ^FK integer
timestamps timestamps

blood_types

id increments
name string
timestamps timestamps

governorates

id increments
name string (255)
timestamps timestamps

cities

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

posts

id increments
title string (255)
content mediumText
photo string
category_id ^FK integer
timestamps timestamps

categories

id increments
name string (255)
timestamps timestamps

client_post

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

donation_requests

id increments
patient_name string (255)
patient_age integer
blood_type_id ^FK integer
bags_number integer
hospital_name string (255)
latitude decimal (10,8)
longitude decimal (10,8)
city_id ^FK integer
client_id ^FK integer
patient_phone string
notes text
timestamps timestamps

settings

id increments
phone string
email string
fb_url string
x_url string
insta_url string
youtube_url string
about_app text
timestamps timestamps

contactus

id increments
subject string (255)
message text
client_id ^FK integer
timestamps timestamps

notifications

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

client_notification

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

blood_type_client

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

client_governorate

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

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