blood_bank - Laravel Schema Designer

clients

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

blood_types

id increments
timestamps timestamps
name string

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id integer

categories

id increments
timestamps timestamps
name string

posts

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

client_post

id increments
timestamps timestamps
client_id integer
post_id integer

donation_requests

id increments
timestamps timestamps
patient_name string
patient_age integer
blood_type_id integer
bags_num integer
hospital_address string
hospital_name string
city_id integer
phone string
longitude float (10.8)
latitude float (10.8)
client_id integer

settings

id increments
timestamps timestamps
phone string
email string
about_app text
notification_text text
Facebook string
twitter string
Instagram string
play_store_url string
app_store_url string

contacts

id increments
timestamps timestamps
subject string
message text
client_id integer

notifications

id increments
timestamps timestamps
title string
content string
donation_request_id integer

client_notification

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

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