Problem with tables

Question

I’m trying to make a series site, only I’m suffering to hit the logic of the tables, first I’ll explain how I want it to work, the person enters the site, there are the series that pulls the following information from the bank id(int), id_temp(int, id_temporada), nome_serie, lancamento, audio, thumb_serie so far so good, then my link that gives access to the chosen series is like this <a href="seriado.php?id=1&id_temp=1">Ver Série</a>, ai on the page seriado.php I created two more tables in the bank, which are episodios and temporadas, on the table episodios I have the following fields id(int), id_temp(int), nome_episodio, sinopse, link_video and in the table temporadas I have the following fields id(int), id_temp(int), nome_temporada(int)

my select are like this (series) select * from series, (episodios) select * from episodios where id = $id or id_temp = $id_temp, (temporadas) select * from temporadas where id = $id or id_temp = $id_temp

Answer 1

Best Normalize the Bank As Follows:

Table Series : Idserie Nome

As the spisodium is of the season, so:

Time Table: Idtemporada, Idserie(FK)

The episode is linked to the season, so:

Table Episodios: Idepisodios, Idtemporada(FK)

So if you want to select could use the example innerJoins:

Select s.* from series as Inner Join temporadas t ON s.Idserie = t.Idserie left Join Episodios E on t.Idtemporada = e.Idtemporada.

I used left Join at the end due to the possibility of a series with season but no episodes yet.

That’s one way to do it.