340
edits
Tomynocker (talk | contribs) (→Multi-level shadow-files: wrong place) |
No edit summary |
||
Line 150: | Line 150: | ||
<div style="text-align: right;">--[[User:Worf|Worf]] 00:56, 22 February 2006 (CET)</div> | <div style="text-align: right;">--[[User:Worf|Worf]] 00:56, 22 February 2006 (CET)</div> | ||
==Current DB Structure== | |||
Well, I thought it might benefit this topic to have a short description of the current DB structure. The relations look like this: (>-< N:M, -< 1:N, >- N:1) | |||
Anime -< Episode -< File -< Stream | |||
However, there are two additional relations as workarounds: | |||
File >-< File | |||
To allow things like File-to-Subtitle relations, Files which form a unit or files which represent a newer version of another file. | |||
Episode >-< File | |||
To allow files which span multiple episodes or files which span only part of an episode. The main relation remains Episode -< File mainly for performance reasons. Only a small subset of the files in the db belong to more than one ep. | |||
--[[User:Exp|Exp]] 03:56, 3 March 2006 (CET) |