A description of the structure of the database - including the structure of the tables, columns, constraints, views, etc, etc.
I've partitioned my table horizontally and I'd like to see how the rows are currently distributed. Searching the web didn't …
mysql database database-design database-schema partitioningEntity Framework Code First is a great framework for developing new projects. But what about extending an existing database? For …
entity-framework ef-code-first database-schema entity-framework-4.1I've seen SaaS applications hosted in many different ways. Is it a good idea to split features and modules across …
database-design architecture database-schema multi-tenant saasI am having a hard time trying to figure out when to use a 1-to-1 relationship in db design or …
database database-design database-schema one-to-oneI'm studying database concepts and there are 3 concepts that I don't understand: canonical cover, extraneous attribute and closure. I read …
database-design relational-database database-schema functional-dependencies canonical-formI am comparing database tables on a development server against a live server, looking for column name changes, new columns, …
mysql database-schemaFor my surprise, using the CreateDatabaseIfNotExists context initializer, the line context.Database.Initialize(true) doesn't throw an exception if the …
entity-framework ef-code-first database-schema initializerSo I have something called exports.create = function(projectJSON){ var project = new ProjectModel({ id : projectJSON.id, projectName : projectJSON.projectName , authorName : …
mongodb naming-conventions database-schemaI'm trying to execute the following changeSet in liquibase which should create an index. If the index doesn't exist, it …
sql database-schema database-migration liquibaseI am currently working on a mobile app that lets you ask friends for favourites, it's a HTML5 frontend and …
php mysql codeigniter database-design database-schema