database-design

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

Datatype/structure to store timezone offset in MySQL

Which would be the proper datatype/structure to store timezone offsets in MySQL? I just want to store the numeric value (the city and countr开发者_如何学Goy are obviously stored in other columns).[详细]

2023-04-09 17:27 分类：问答
Star schema modeling - many-to-many

I\'m building a data warehouse based on NFL statistics for educational purposes as I learn this paradigm - I have the following modelling problem[详细]

2023-04-09 17:12 分类：问答
Database Design: Categories in their own table?

I am redesigning a few databases into one encompassing database, and I have noticed the previous designer(s) of the old databases like to store categories in their own tables. For example, say that th[详细]

2023-04-09 17:06 分类：问答
Database cross table or one table is better

First, I have companies and their templates.templates in file table I related columns like this: FileTemplate[详细]

2023-04-09 16:44 分类：问答
How to get a set of values as a list when grouped by a pair of columns

I have a datatable with below values idNamedate 1a5/3/2011 开发者_开发知识库1a6/4/2011 I want to retrieve the values with a list of associated dates for each id/name pair. I would suggest you crea[详细]

2023-04-09 15:42 分类：问答
How to represent current state or status and maintain data/referential integrity? - Database Design

I have a table that maintains specific business transactions, let\'s call it LOANS. Each record can at any given time have one of several \"states\", for example \"in re-payment / open\", \"defaulted\[详细]

2023-04-09 08:15 分类：问答
What is the best way yo keep version on database?

I need to develop a web application. A web shop that sell different product in different package in different region ...[详细]

2023-04-09 02:37 分类：问答
Best way to design shopping cart domain model on C#?

Google can`t help me. I find only this link: http://flylib.com/books/en/2.522.1.56/1/ So, once there is the question - why开发者_StackOverflow中文版 do we need divide Product and Item?Product is too[详细]

2023-04-09 02:04 分类：问答
Database design for products and product variants

I\'m building an commerce site and I\'ve been researching different ways to show products with variants. I\'m trying to do this for contact lenses and wondering what the best way is.[详细]

2023-04-08 23:42 分类：问答
How to join multiple tables related by other tables

I\'m developing a site where people can publicate their houses for rent. I\'m using php 5.2.0 and MySQL 5+[详细]

2023-04-08 21:57 分类：问答