What relationship to use?

[Dicko]

I have a FactDossiers table

FactDossiers

id_dossier

...

Each dossier can have multiple timelines

Timelines

id_dossier

created_at

...

What relationship should exist between the two?

Now I have a FactDossiers 1 > * Timelines relationship, which seems incorrect to me.

Should I merge Timelines with the FactDossiers table, even if it means the number of rows in FactDossiers would multiply several times?

Or is there another way?

[amitchandak · Accepted solution]

@Dicko , two facts should not join. Better to merge and have a single table.

But do that if you do not have any other dimesions. if these are only two table, then you can manage with this