database-design

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

Structuring mySQL

I have a table with contacts and another one with message. In the message table I have a cell where I keep a serialized string of IDs of those members that the message was sent to.[详细]

2023-04-13 09:19 分类：问答
Database schema with categories, subcategories and products [closed]

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time,or an extraordinarily narrow situation that i开发者_运维问答s not g[详细]

2023-04-13 06:54 分类：问答
Working with complex SQL Server database schemas

I have a database, I have to maintain compatibility with SQL Server 2005 and I\'ve been thinking about ways to reduce complexity and deal with performance issues.[详细]

2023-04-13 06:47 分类：问答
Adjust prices in dates

I have a main pricelist which is defined something like periodstart periodendprice 2011/01/012011/05/3050[详细]

2023-04-13 05:39 分类：问答
How to define empty polygon for spatial column in MySQL?

I\'m trying to create spatial开发者_JS百科 index over table column (bbox polygon default NULL) but get error: All parts of a SPATIAL index must be NOT NULL.[详细]

2023-04-13 05:31 分类：问答
MongoDB: Modeling likes, mutual friends etc

I\'m building a streaming music service that will have features like: Follow users Like songs Create and manage playlists[详细]

2023-04-13 04:43 分类：问答
Are there performance advantages by splitting a Django model/table into two models/tables?

In SO question 7531153, I asked the proper way to split a Django model into two—either using Django\'s Multi-table Inheritance or explicitly defining a OneToOneField.[详细]

2023-04-13 01:52 分类：问答
Refactoring a One-to-many relation to a Many-to-Many in MySQL: How to formulate the query?

In the initial \'version\' of the application that I\'m working on, a design consideration wasn\'t taken into account - no one thought of it.[详细]

2023-04-13 01:39 分类：问答
Date Format in Query

Need to store date as \'20111013152623\'(yyyyMMddHH开发者_如何转开发mmss)format in database. Which datatype should I use for column and let me know the simple insert query for the datatype.[详细]

2023-04-12 22:31 分类：问答
One-to-many or many-to-many?

This is BestPractice question (or at least I hope it is). EDIT: This example is just to clarify the problem. It could be Person, Office, ContactInformation.[详细]

2023-04-12 21:30 分类：问答