database-design

相关标签：javascript jquery android 多少钱 iPhone

What is an efficient MongoDB schema design for a multilingual e-commerce site?

I\'m designing a multilingual e-commerce site. Products have different properties. Some properties are different for each language (like color), other properties are the same for all languages (like S[详细]

2023-04-07 04:16 分类：问答
How to Determine Optimal MySQL Table Indexes, When Contents of WHERE Clause Vary?

I have the following 2 mysql_queries: Query 1 (this query is repeated twice more for imgClass, and imgGender):[详细]

2023-04-07 00:44 分类：问答
Using "varchar" as the primary key? bad idea? or ok?

开发者_StackOverflow中文版Is it really that bad to use \"varchar\" as the primary key? (will be storing user documents, and yes it can exceed 2+ billion documents)It totally depends on the data. Ther[详细]

2023-04-06 21:27 分类：问答
StateMachine flow in a master-detail model

I need to ask a complicated scenario, so I\'ll try to explain by example. Consider the following model :[详细]

2023-04-06 17:29 分类：问答
PHP/MySQL: Handling Questionnaire Input

I have a questionnaire for users to be matched by similar interests: 40 categories, each with 3 to 10 subcategories. Each of the subcategories has a 0 - 5 value related to how interested they are in t[详细]

2023-04-06 15:09 分类：问答
Good idea to resolve User roles in the application layer?

The reason I need a role-based system: Restrict access to pages. Restrict access to certain features on pages.[详细]

2023-04-06 14:54 分类：问答
Designing table index

In a table with an id, several key values and several other \"data\" columns: T1 : id , k1 , k2 , k3 , data1, data2, ...[详细]

2023-04-06 14:45 分类：问答
When to use comma-separated values in a DB Column?

OK, I know the technical answer is NEVER. BUT, there are times when it seems to make things SO much easier with less code and seemingly few downsides, so please here me out.[详细]

2023-04-06 14:43 分类：问答
How to Structure a Table where *some* Columns can have Multiple Values? [duplicate]

This question already has answers here: Closed 11 years ago. 开发者_运维问答Possible Duplicate: How to Store Multiple Options selected by User in a Table[详细]

2023-04-06 12:58 分类：问答
References Tables: all in one or separate table?

I have a group table - should option_id or extras_id should be in separate tables 开发者_C百科or all in one table? See below what I meant:[详细]

2023-04-06 11:42 分类：问答