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. Quote 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 (edited) 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 February 15, 2013 by Barand Quote 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! Quote Link to comment https://forums.phpfreaks.com/topic/274528-video-views-database-structure/#findComment-1412629 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.