I\'m working on a goal completion application, where there can be开发者_JAVA百科 Goals, Milestones, and Tasks. Milestones belong to goals, goals can have many milestones, and tasks can belong to eithe
I want to know if there is any typical approach to differenciate this kind of data I have to 开发者_开发问答listing devices (for example) in a db, ane everyone will have
I think I know what a domain table is (it basically contains all the possible values that some other column can contain), and I\'ve looked up dimension table in Wikipedia. Unfortunately, I\'m having a
Please let me开发者_运维问答 know if you have any ideas.
I\'m designing a project management site, The user needs to enter the hardware required for the project in addition to other details. For example,
We want to merge 2 set of data using the same model: we have 2 databases that have the same DDL, but containing different data.
I\'m a student learning SQL and PHP, I have been set a task to create a student feedback form using PHP and mySQLi, and im really stuck at getting my head around how to design the database for the pro
I need some advice on part of my model I am designing. As you can see in my Rfi entity, I have a collection of BaseImpact types. There will be several types of impacts that can be added to that collec
I have users as Redis Hashes and want to find similar users (given a particular user) based on salary and age.
What would be the best primary key for a 开发者_如何学Cvenue in my area? From performance point of view - a 4 byte integer, so a surrogate key.