database-schema
DB schema migration tool for CodeIgniter
Is there a good tool for managing changes to MySQL schemas? Either standalone, or integrating with the CodeIgniter 开发者_开发知识库framework.[详细]
2023-03-19 23:39 分类:问答Database schema - representing location
I\'ll need to represent location of some events and I am designing database schema for this application.[详细]
2023-03-19 02:39 分类:问答RDBMS best practices - autoid for association table?
I have two tables, let\'s say they are called table A and table B. An item from table B can be present in multiple instances of A, and each A can contain multiple Bs so I have a table called a_b which[详细]
2023-03-18 20:31 分类:问答TFS2010 Database Schema Explanation
By looking at the default, raw relational db schema of TFS2010 of its underlying team project collection sql database it is not necessarily self-explanatory how things work there and I was wondering w[详细]
2023-03-18 15:52 分类:问答Database Design: Trouble Connecting Ideas
I\'ve hit a bit of a wall ... here is my simplified schema: TABLE users id TABLE assets id userid TABLE presentations[详细]
2023-03-18 08:48 分类:问答Local Data Cache SyncTable Schema not copied, clientSyncProvider _ CreatingSchema does not fire
I am using the VS2008 Local Data Cache tool to synchronize a SqlServer 2008 Db with a local SQL CE 3.5. At the server I have a table with a PK with datatype uniqueIdentifier and defaultvalue newID().[详细]
2023-03-17 10:39 分类:问答What is meant by sparse data/ datastore/ database?
Have been reading up on Hadoop and HBase lately, and came across this term- HBase is an open-source, distributed, sparse, column-oriented store...[详细]
2023-03-17 05:57 分类:问答SQL Server metadata: How to get description for columns in views
SQL Server allows storing metadata like description for a table and its columns. The description for the columns can be retrieved from sys.extended_properties. There is also a way to set the descripti[详细]
2023-03-17 03:40 分类:问答Schema/Strategy and queries for ranking system
I\'ve got the following schema in my db: items | CREATE TABLE `items` ( `id` int(11) NOT NULL AUTO_INCREMENT,[详细]
2023-03-17 00:43 分类:问答How to structure database for combined storage of weekends + annual off/closing days?
Situation: A media screen that plays advertisements throughout an 开发者_C百科year would be closed on certain days in an year.[详细]
2023-03-16 23:09 分类:问答