Home
blood_bank_db
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (4)
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
×
Comments for blood_bank_db
abdurrahmanFaid . 04 December 2019
I will use laravel notifications table for handling clients notifications instead of creating the below two tables:.
notifications
client_notification
so the relation between users and notifications will be one to many instead of many to many this will be helpful because: 1) No need for many to many relationship // faster querying
2) Laravel notifications table uses polymorphic relationship so we can upgrade the app to send notifications to admins also if we want
3) save some time :) // Otherwise i will return back to the default solution if something went wrong.
abdurrahmanFaid . 04 December 2019
In
client_govornorate table & bood_type_client table
can be modified.
Instead of using to tables we can use just one table using polymorphic relationship.
abdurrahmanFaid . 04 December 2019
In site settings table: Instead of create 5 fields or more for every social link and it can be increased in the future of the application .
I will create one field
{social_links}
and it will contain a json data.
ex:
{ facebook: 'http://www.facebook.com/blood-bank', twitter: 'http://www.twitter.com/blood-bank' }
abdurrahmanFaid . 04 December 2019
Some relations we will not use it, so i did not implement it.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01