blood_bank_db - Laravel Schema Designer

clients

id bigIncrements
timestamps timestamps
name string
email string
dob date
last_donation_date date
phone_number string
password string
blood_type_id smallInteger
city_id integer

blood_types

id smallIncrements
timestamps timestamps
name string

governorates

id smallIncrements
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id smallInteger

posts

id increments
timestamps timestamps
softDeletes softDeletes
title string
body text
thumbnail string
cateory_id smallInteger

categories

id increments
timestamps timestamps
name string

donation_requests

id increments
timestamps timestamps
patient_name string
patient_age string
blood_type_id smallInteger
bags_count smallInteger
hospital_name string
lat decimal (8,6)
lng decimal (9.6)
city_id smallInteger
phone_number string
note text

notifications

id increments
timestamps timestamps
data text
type string
notifiable_type string
notifiable_id bigInteger
is datetimeTz
donation_request_id bigInteger

site_settings

mobile_store_urls text
notification_text string
about text
phone_number string
email string
social_links text

contacts

id increments
timestamps timestamps
name string
phone_number string
email string
subject string
message text

clientables

id increments
timestamps timestamps
client_id bigInteger
clientable_id integer
clientable_type string

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