AnalyzeThis Posted February 15, 2013 Share Posted February 15, 2013 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. Link to comment https://forums.phpfreaks.com/topic/274528-video-views-database-structure/ Share on other sites More sharing options...
Barand Posted February 15, 2013 Share Posted February 15, 2013 Quote 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. Link to comment https://forums.phpfreaks.com/topic/274528-video-views-database-structure/#findComment-1412626 Share on other sites More sharing options...
AnalyzeThis Posted February 15, 2013 Author Share Posted February 15, 2013 Thank you! Link to comment https://forums.phpfreaks.com/topic/274528-video-views-database-structure/#findComment-1412629 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.