JSON DB Fields: Yay or Nay? Custom Fields. EAV: Entity-Attribute-Value Model

ENUMS, Foreign Keys, or Just String?

JSON DB Fields: Yay or Nay? Custom Fields. EAV: Entity-Attribute-Value Model

Course Content

Intro: Relationships Crash Course

01 BelongsTo, BelongsToMany or Polymorphic? Three Examples.

02 Rare Cases of HasOne Relationship

03 Database Normalization: 1/2/3 Normal Forms

04 HasMany: Delete Parent - What Happens with Children?

Examples of Open-Source Laravel Databases

05 October CMS: is_xxx VS xxx_at, and belongsTo/belongsToMany

06 Koel Music Streaming Service: Untypical Pivot Tables

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

08 Laravel.io: Polymorphic All the Things!

Exploring Different Structures and Elements

09 UUID instead of ID: When/How?

10 JSON DB Fields: Yay or Nay?

11 ENUMS, Foreign Keys, or Just String?

12 Custom Fields. EAV: Entity-Attribute-Value Model

13 Recursive Parent-Children - Part 1: Unlimited Subcategories

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

15 Invoice Numbers with Prefixes: How to Structure DB?

16 Order Statuses: Relationship or Same Table?

17 Column Indexes: when/why/how to Apply Them

18 How to Safely Change DB Relations in Live Laravel Project?

Getting Data from Larger DB: Practical Example Projects

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

20 Project 2. Eshop with Categories, Discounts and Similar Products