solidcodes — 2013-09-08T00:59:17-04:00 — #1
What can you say about the relationships of my database model,
Please disregard the datatypes, I'm only interested to hear from you guys regarding the relationships of the tables.
For example on 'Classes' table It is a FK on 'Parts' and 'Media' tables is this fine?
One parent table two children tables is this okay.
Also any improvements you can suggest like the look-up table or junction table.
Or flaws that you will notice?
Thanks in advance.
r937 — 2013-09-08T06:34:47-04:00 — #2
yes, it's absolutely fine
i was surprised that classes and lessons have related media, but the media are not related to the class parts
solidcodes — 2013-09-08T10:09:04-04:00 — #3
Parts is just a temporary folder...
r937 — 2013-09-08T10:25:43-04:00 — #4
solidcodes — 2013-09-08T11:46:32-04:00 — #5
It's a folder as a table.
The rest are true tables.
Or perhaps the right term for that is lookup table?