Video views database structure
Posted 15 February 2013 - 02:53 PM
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 | type | name | etc.
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
account | video |
Thanks for any assistance.
Posted 15 February 2013 - 03:05 PM
Should I create a view databases
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 - 03:06 PM.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users