database-design
Doctrine 2 schema for Game Saves
I\'m looking for a sensible object relationship design for storing variations on default data for a given player in a single player game (save data stored for all players online).[详细]
2023-04-12 06:54 分类:问答Database Design: how to model a table?
Say I want each user of my application to be able to specify a number of columns and rows, then assign certain values within each cell. Basically, I want them to be able to create tabular data -- like[详细]
2023-04-12 05:31 分类:问答How should I record in the database that an item/product is visible by 'all' groups?
A user can be in groups. And an item/product is assigned groups that can see the item. Users can see that item if they are in one of the assigned groups.[详细]
2023-04-12 02:31 分类:问答SQLAlchemy: Efficient way of merging duplicate tags
Let\'s say I have a database full of Tag objects. Each Tag has an id and a name. In the beginning of making the database I allowed for case sensitive Tags, however, I later realized I didn\'t need/wan[详细]
2023-04-12 01:46 分类:问答How hard can it be maintaining only single table for users of different roles
If you get to design a Database table for users, will stuffing all users with different role be best option in long term maintainability, database programming, web development. Take this situation as[详细]
2023-04-11 22:41 分类:问答Query for creating database for a new project
I hope that if my question is out of context you guys will let me pass by.I am not good at all when it comes to DBMS and all i can till in my 7+ years of IT experience is able to write some basic quer[详细]
2023-04-11 20:07 分类:问答DeNormalize Many to Many but don’t want to store redundant data in SQL world
Say I have newsletters and then subscribers: Whenever a user subscribes to a newsletter we need to store this in a table - the subscribers list.[详细]
2023-04-11 14:35 分类:问答How to improve the fields name
I am trying to improve the fields name to be more obvious what it means..is the fields name ok? or what can be changed to make it more obvious?[详细]
2023-04-11 14:32 分类:问答Database Design for Rental Listings
I\'m designing a simple database for a rental listings website, sort of like classified ads but only for home/room rentals.This is what I\'ve come up with thus far:[详细]
2023-04-11 14:22 分类:问答Attendance Database with Excessive Absence Alert
I have a pretty standard attendance database design, but I want to be alerted when a student hits a certain number of absences.I was thinking to use a point system where each absence would accumulate[详细]
2023-04-11 14:04 分类:问答