How to Structure Databases in Laravel

Custom Fields. EAV: Entity-Attribute-Value Model

Lesson 12/20 · 8:20 min

Autoplay

Previous: ENUMS, Foreign Keys, or Just String?

PawelGorowicz

1 year ago

Hello, unfortunately this package has been discontinued. https://github.com/rinvex/laravel-attributes/issues/173, abandoned and not supporting laravel 10.x

Sisifo

1 year ago

Hi Povilas,

What do you think about this EAV approach: https://medium.com/@ricardovergarawork/simplified-eav-laravel-implementation-7a54e9f89240?

Thanks for the answer.

How to Structure Databases in Laravel

Custom Fields. EAV: Entity-Attribute-Value Model

BelongsTo, BelongsToMany or Polymorphic? Three Examples.

Rare Cases of HasOne Relationship

Database Normalization: 1/2/3 Normal Forms

HasMany: Delete Parent - What Happens with Children?

October CMS: is_xxx VS xxx_at, and belongsTo/belongsToMany

Koel Music Streaming Service: Untypical Pivot Tables

Attendize: Large Tables, Accounts/Users and Pivots on Steroids

Laravel.io: Polymorphic All the Things!

UUID instead of ID: When/How?

JSON DB Fields: Yay or Nay?

ENUMS, Foreign Keys, or Just String?

Custom Fields. EAV: Entity-Attribute-Value Model

Recursive Parent-Children - Part 1: Unlimited Subcategories

Recursive Parent-Children - Part 2: Nested Set Model with Package

Invoice Numbers with Prefixes: How to Structure DB?

Order Statuses: Relationship or Same Table?

Column Indexes: when/why/how to Apply Them

How to Safely Change DB Relations in Live Laravel Project?

Project 1. Tournament with Places: TOP 100 Tournaments/Prizes

Project 2. Eshop with Categories, Discounts and Similar Products