laravel-daily-how-to-structure-databases-in-laravel-2021-4

00:00:00 - 1. BelongsTo, BelongsToMany or Polymorphic- Three Examples. 00:08:02 - 2. Rare Cases of HasOne Relationship 00:11:00 - 3. Database Normalization- 1_2_3 Normal Forms 00:15:43 - 4. HasMany- Delete Parent - What Happens with Children- 00:26:37 - 5. October CMS- is_xxx VS xxx_at, and belongsTo_belongsToMany 00:28:51 - 6. Koel Music Streaming Service- Untypical Pivot Tables 00:31:35 - 7. Attendize- Large Tables, Accounts_Users and Pivots on Steroids 00:36:17 - 8. - Polymorphic All the Things! 00:39:16 - 9. UUID instead of ID- When_How- 00:44:22 - 10. JSON DB Fields- Yay or Nay- 00:51:08 - 11. ENUMS, Foreign Keys, or Just String- 00:59:08 - 12. Custom Fields. EAV- Entity-Attribute-Value Model 01:07:29 - 13. Recursive Parent-Children - Part 1- Unlimited Subcategories 01:12:36 - 14. Recursive Parent-Children - Part 2- Nested Set Model with Package 01:16:48 - 15. Invoice Numbers with Prefixes- How to Structure DB- 01:26:14 - 16. Order Statuses- Relationship or Same Table- 01:30:26 - 17. Column Indexes- when_why_how to Apply Them 01:37:37 - 18. How to Safely Change DB Relations in Live Laravel Project- 01:48:58 - 19. Project 1. Tournament with Places- TOP 100 Tournaments_Prizes 01:57:08 - 20. Project 2. Eshop with Categories, Discounts and Similar Products