Stack Overflow
Stack Overflow

Questions tagged [database-schema]

A description of the structure of the database - including the structure of the tables, columns, constraints, views, etc, etc... that make up the database.Normally defined in the text, generally SQL in an RDBMS, the schema describes the complete blueprint for the database, defining everything about the database except that data itself.

2931 questions
11
votes
4 answers

Sequelize schema for PostgreSQL: How to accurately define a schema in a model?

I searched throughout the net and have not been able to determine how to add a schema to this sequelize model below. The following code does not kick back errors, however when I inspect the postgres DB, the only schema is the default one for public.…
Val
  • 1,260
  • 5
  • 23
  • 39
11
votes
1 answer

How to set default schema in Yii2

My Yii2 is setup with PostgreSQL. Instead of using separate database per project, I like to use schema for each project. Problem with later setup is that I can't figure out how to select default schema "defaultSchema" through configuration. I am…
hserge
  • 905
  • 1
  • 9
  • 12
11
votes
8 answers

Hibernate: Found: float, expected: double precision

I have a problem with the mapping of Oracle Float double precision datatype to Java Double datatype. The hibernate schema validator seems to fail when the Java Double datatype is used. org.hibernate.HibernateException: Wrong column type in DB.TABLE…
Frederic Morin
  • 8,733
  • 4
  • 28
  • 27
11
votes
1 answer

Upvote and Downvote with Backbone, Express and Mongoose

I am trying to implement a voting system similar to stackoverflow or reddit where a user would only be allowed to vote once on a given post. After following the advice given here storing upvotes/downvotes in mongodb I have created two schemas to…
s_curry_s
  • 3,332
  • 9
  • 32
  • 47
10
votes
1 answer

Genealogy Relationship Mapping why base on families

I am developing a geneaology application, and am currently at the stage of modelling relationships between individuals. Based on my research, I have noted that most of the mappings of relationships are based on families (father + mother) and so I…
Stephen Senkomago Musoke
  • 3,528
  • 2
  • 29
  • 27
10
votes
2 answers

How to model many-to-many relationships in MongoDB (for a MySQL user)

I come from a MySQL background and am trying to wrap my head around MongoDB. In particular, I'm struggling to conceptualize how I should model n:n relationships the "Mongo way." For this example, let's say we have two collections: users and…
Josh Smith
  • 14,674
  • 18
  • 72
  • 118
10
votes
2 answers

RailRoad is not working. Giving me issues ie /railroad-0.5.0/lib/railroad/app_diagram.rb:54:in `disable_stdout': uninitialized constant

Here is various outputs railroad -M | dot -Tsvg > models.svg /Users/me/.rvm/gems/ruby-1.9.2-p290/gems/railroad-0.5.0/lib/railroad/app_diagram.rb:54:in `disable_stdout': uninitialized constant AppDiagram::PLATFORM (NameError) from…
Mohit Jain
  • 43,139
  • 57
  • 169
  • 274
10
votes
1 answer

Using WebDeploy to deploy database updates

We have adopted WebDeploy for a new project and it seems to handle the deployment of our apps to our Dev and Test servers pretty well. Now we would like to extend the use of WebDeploy to make it deploy database changes too. Scott Gu's blogpost on…
dbruning
  • 5,042
  • 5
  • 34
  • 35
10
votes
4 answers

How can I create and access multiple databases in Oracle 11g?

I have bought a Oracle 11g recently and I wanted all my developers to use it. Obviously I can't buy different licenses for each. So is it possible for me to create one database for each of the developers?. By inference I know it is…
Sheldon
  • 101
  • 1
  • 1
  • 3
10
votes
0 answers

EF Core: Use multiple database schemas in DbContext object?

We have a database where the tables are organized in multiple schemas like Common.User and Product.Order. There are also tables with the same name in different schemas. Is it somehow possible to use this schemas to organize the DbSet objects within…
Rhopi
  • 101
  • 1
  • 6
10
votes
4 answers

Design users table for single sign in to use across sub domains

We have a site which has sub domains like: example.com - Main Site food.example.com fashion.example.com And each domain and sub domain has a different database, like this: exampleDB - Main DB with Users Table foodDB fashionDB What have you…
Shaiju T
  • 6,201
  • 20
  • 104
  • 196
10
votes
1 answer

Firebase: how to efficiently track user/record change history

[Lots of discussion about this on SO, but almost all dealing in SQL, so a lot of it is N/A to my question as far as I could tell] i'm writing a CRUD app with react/redux, a firebase backend, & AWS lambda functions where necessary. My users will be…
Brandon
  • 7,736
  • 9
  • 47
  • 72
10
votes
1 answer

Database schema design pattern for data that merges

We have a rather antiquated database that contains a large number of individuals along with a number of achievements that they have completed. There has historically been little done to discourage duplicated individual data so we've ended up in a…
Rob Forrest
  • 7,329
  • 7
  • 52
  • 69
10
votes
3 answers

Update Target Button is disabled in Sql Server Database Schema Comparison

I use Visual Studio 2013 Professional Update 4 in combination with multiple SQL Server 2012 Enterprise servers/instances. The Idea was to create a Version controlled deployment using a Visual Studio Solution with SQL Server Projects. However for…
Joel
  • 4,862
  • 7
  • 46
  • 71
10
votes
1 answer

How to display SQL Server table indexes?

I need to list/display all the clustered and non clustered indexes contained by a table. How can I do that using SQL Server 2008 R2?
Sarfaraz Makandar
  • 5,933
  • 16
  • 59
  • 84
1 2 3
…
99 100