squiblo Posted December 26, 2011 Share Posted December 26, 2011 Currently I am working on the front end of this project, but soon I know I will have to create a back end structure. The project is a story system where users can upload there own stories, users will be able to select what category the story fits into, users will also be able to insert related links into the story and also pictures and videos. The database will be mostly handling SELECT statements, so needs to be fully optimised to read the data as quick as possible. I have a few ideas of what the structure should be like, but I would also like my fellow "freaks" opinions. Thanks for the help in advance! Quote Link to comment https://forums.phpfreaks.com/topic/253829-structure-help/ Share on other sites More sharing options...
asmith Posted January 2, 2012 Share Posted January 2, 2012 Not trying to be rude or anything. But your question is way too general to get any specific answers. This kind of topics usually gets abandoned because in order to answer it, someone gotta explain a whole database which is ambitious in many ways. So they won't bother. Quote Link to comment https://forums.phpfreaks.com/topic/253829-structure-help/#findComment-1303348 Share on other sites More sharing options...
scootstah Posted January 3, 2012 Share Posted January 3, 2012 Why not give it your best effort and then post it for critique? Quote Link to comment https://forums.phpfreaks.com/topic/253829-structure-help/#findComment-1303787 Share on other sites More sharing options...
squiblo Posted January 3, 2012 Author Share Posted January 3, 2012 scootstah, I'll do that. It will take a few days, maybe a couple of weeks because time is an issue for me at the moment. I'll make sure to PM you when complete Quote Link to comment https://forums.phpfreaks.com/topic/253829-structure-help/#findComment-1303835 Share on other sites More sharing options...
squiblo Posted January 7, 2012 Author Share Posted January 7, 2012 I have spent some time to come up with a structure. Tell me what you think of it As a scenario, if a user searches for a story I want relevant images/videos/comments selected as quick as possible, with this current design I'm not sure if it is optimized as well as it could be. *Structure is attached* Quote Link to comment https://forums.phpfreaks.com/topic/253829-structure-help/#findComment-1305354 Share on other sites More sharing options...
squiblo Posted January 7, 2012 Author Share Posted January 7, 2012 Just realized "thumbUp/thumbDown" will have a table of its own, so users cannot abuse it and will only be able to select one and only once. Quote Link to comment https://forums.phpfreaks.com/topic/253829-structure-help/#findComment-1305360 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.