Top "Database-schema" questions

A description of the structure of the database - including the structure of the tables, columns, constraints, views, etc, etc.

What is the purpose of the ConcurrencyStamp column in the AspNetUsers table in the new ASP.NET MVC 6 identity?

What is the purpose of the ConcurrencyStamp column in the AspNetUsers table in the new ASP.NET MVC 6 identity? This …

asp.net-mvc concurrency database-schema identity asp.net-core-mvc
Designing a SQL schema for a combination of many-to-many relationship (variations of products)

I hope the title is somewhat helpful. I'm using MySQL as my database I am building a database of products …

sql schema e-commerce database-schema entity-attribute-value
Is it OK to update a production database with EF migrations?

According to this blog post most companies using EF Migrations are supposedly not updating the database schema of production databases …

c# entity-framework database-schema entity-framework-migrations
Using multiple PostgreSQL schemas with Rails models

I have a PostgreSQL database for my Rails application. In the schema named 'public' the main Rails models tables are …

ruby-on-rails postgresql models database-schema schema-design
Setting schema name for DbContext

I know how to set the schema for a table in my context but is there a way to set …

c# entity-framework entity-framework-6 database-schema
MongoDB Structure for message app

I am breaking my mind up thinking about a good document structure for handling a message app. I basically need …

mongodb database-schema bson
Database Design for storing Chat Messages between people

I am trying to build a messaging/chat system. which can store conversation between two people in a chronological order. …

mysql database database-design database-schema
SQL Server Compare Schema in Visual Studio 2017

I am attempting to compare schemas of two databases on the same server. The two databases are named benchmarkdb and …

sql-server database-schema visual-studio-2017 schema-compare
Sequelize: Changing model schema on production

We're using the orm sequelize.js and have defined a model as such: module.exports = function(sequelize, DataTypes) { var Source = …

javascript postgresql orm database-schema sequelize.js
Django and postgresql schemas

I've been trying to solve this one all week, help very much appreciated. I have various schemas in a postgres …

django postgresql schema database-schema