2 replies to this topic

[AnalyzeThis]

Good morning,

I am working on the database structure of a video system (basically ). This system would keep track of clients views of a video and list who watched the video.

Accounts Database
=========================
Accounts | type | name | etc.

Video Database
=========================
Name | title | type | etc.

Only videos and viewers of the same time will have access to the video. I want to be able to see if a viewer has watch a video and list all viewers. What what I am wondering is where to put the views records? Should I create a view databases

Views database
=========================
account | video |

Thanks for any assistance.

[Barand]

Should I create a view databases

Definitely.

You have a many-to-many relationship where a video is viewed by many users and a user can view many videos. Therefore you need the view table.

Edited by Barand, 15 February 2013 - 10:06 AM.

[AnalyzeThis]

Thank you!