How to properly organize table architecture for Eloquent?

Question

Laravel

Hello!

Please give advice on how to organize tables for a bundle using Eloquent Laravel .

I'm sure I did something wrong, since I have to write SQL Query myself and use foreach to get data from another model, which is supposed to be related. hasManyThoughtwon't help either. Post

table

• id
  
• title
  

Content table

• id
  
• post_id (foreign)
  
• video_id
  
• test_id
  
• article_id
  

There are also tables videos, tests , articles .

Content can be of three types, so I decided to do so.

video has a field that contains data on how much the video file weighs.

Can you please give me advice on how to organize this all correctly?

How, for example, would it be possible to link everything so that through the Post model I could get the total amount of memory used by this post from the videos ...

THANK YOU!

Answer 1

Welcome to Documentation

Answer 2

The contents table is not needed. Linking to videos via the ManyToMany post_video table. With the rest as well, but it is not clear why the article cannot be removed from the post and what tests are