Top "Schema" questions

Load a structure.sql into a rails database via rake

rake db:schema:load will load a schema.rb file into a rails database. Is there a way to load …

ruby-on-rails schema

MongoDB Schema Design - Many small documents or fewer large documents?

Background I'm prototyping a conversion from our RDBMS database to MongoDB. While denormalizing, it seems as if I have two …

database-design schema mongodb

How to manage multiple JSON schema files?

I'm trying to validate my JSON API using node.js + json-schema.js from commonjs-utils. Just single validation was easy but …

json node.js schema jsonschema

Mongoose schema optional fields

I have a user schema with mongoose in nodejs like this userschema = mongoose.Schema({ org: String, username: String, fullname: String, …

node.js mongodb mongoose schema

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

Cannot alter schema name in MYSQL 5.5 w/ MYSQL Workbench

Why I cannot alter my schema name from the MYSQL Workbench? Am i missing something? :( As you can the name …

mysql database schema mysql-workbench

What are the JPA @Table annotation "catalog" and "schema" variables used for?

Why are these important, what effect do they have on the database at hand? Isn't the "schema" already decided at …

mysql hibernate jpa schema catalog

Show procedure/function code in MySql

Is there any options to view stored procedure/function code in MySql same as like "sp_helptext procedurename" in sql?

mysql function schema show procedure

How to update a database schema without losing your data with Hibernate?

Imagine you are developing a Java EE app using Hibernate and JBoss. You have a running server that has some …

database hibernate schema migrate

How to view current database schema for Heroku app in Terminal?

I am trying to view my Heroku app's schema in Terminal (Mac OS X Lion) and stumbled upon a command …

ruby-on-rails heroku terminal schema