|
# This file is auto-generated from the current state of the database. Instead of editing this file,
|
|
# please use the migrations feature of ActiveRecord to incrementally modify your database, and
|
|
# then regenerate this schema definition.
|
|
#
|
|
# Note that this schema.rb definition is the authoritative source for your database schema. If you need
|
|
# to create the application database on another system, you should be using db:schema:load, not running
|
|
# all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations
|
|
# you'll amass, the slower it'll run and the greater likelihood for issues).
|
|
#
|
|
# It's strongly recommended to check this file into your version control system.
|
|
|
|
ActiveRecord::Schema.define() do
|
|
|
|
create_table "conditions", :force => true do |t|
|
|
t.string "name", :limit => 64, :null => false
|
|
t.integer "position", :null => false
|
|
end
|
|
|
|
add_index "conditions", ["name"], :name => "nom", :unique => true
|
|
|
|
create_table "exhibition_work", :force => true do |t|
|
|
t.integer "exhibition_id", :limit => 20, :null => false
|
|
t.integer "work_id", :limit => 20, :null => false
|
|
t.integer "position", :limit => 20, :null => false
|
|
end
|
|
|
|
add_index "exhibition_work", ["exhibition_id", "work_id"], :name => "exhibition_id", :unique => true
|
|
|
|
create_table "exhibitions", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
t.date "start", :null => false
|
|
t.date "end", :null => false
|
|
t.string "place", :limit => 128, :null => false
|
|
t.boolean "hidden", :default => false, :null => false
|
|
t.integer "work_id", :limit => 20, :null => false
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
end
|
|
|
|
add_index "exhibitions", ["name"], :name => "nom", :unique => true
|
|
add_index "exhibitions", ["name"], :name => "nom_2"
|
|
|
|
create_table "groups", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
t.integer "set_id", :null => false
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
end
|
|
|
|
add_index "groups", ["name"], :name => "nom", :unique => true
|
|
add_index "groups", ["name"], :name => "nom_2"
|
|
|
|
create_table "materials", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
end
|
|
|
|
add_index "materials", ["name"], :name => "nom", :unique => true
|
|
add_index "materials", ["name"], :name => "nom_2"
|
|
|
|
create_table "placereasons", :force => true do |t|
|
|
t.string "name", :limit => 64, :null => false
|
|
end
|
|
|
|
add_index "placereasons", ["name"], :name => "nom", :unique => true
|
|
|
|
create_table "sets", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
end
|
|
|
|
add_index "sets", ["name"], :name => "nom", :unique => true
|
|
add_index "sets", ["name"], :name => "nom_2"
|
|
|
|
create_table "sizes", :force => true do |t|
|
|
t.float "height", :null => false
|
|
t.float "width", :null => false
|
|
t.boolean "standard", :default => false, :null => false
|
|
end
|
|
|
|
add_index "sizes", ["height", "width"], :name => "proportion", :unique => true
|
|
|
|
create_table "steps", :force => true do |t|
|
|
t.string "image_filename", :limit => 256, :null => false
|
|
t.date "date", :null => false
|
|
t.integer "work_id", :limit => 20, :null => false
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
end
|
|
|
|
add_index "steps", ["image_filename"], :name => "image_filename", :unique => true
|
|
|
|
create_table "technique_work", :force => true do |t|
|
|
t.integer "technique_id", :limit => 10, :null => false
|
|
t.integer "work_id", :limit => 20, :null => false
|
|
end
|
|
|
|
add_index "technique_work", ["technique_id", "work_id"], :name => "technique_id", :unique => true
|
|
|
|
create_table "techniques", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
t.string "acronym", :limit => 8
|
|
end
|
|
|
|
add_index "techniques", ["name", "acronym"], :name => "nom", :unique => true
|
|
add_index "techniques", ["name"], :name => "nom_2"
|
|
|
|
create_table "works", :force => true do |t|
|
|
t.integer "set_id", :limit => 20
|
|
t.integer "group_id", :limit => 20
|
|
t.string "title", :limit => 256, :null => false
|
|
t.integer "material_id", :limit => 10, :null => false
|
|
t.integer "size_id", :limit => 10, :null => false
|
|
t.integer "condition_id", :limit => 10, :null => false
|
|
t.integer "placereason_id", :limit => 10
|
|
t.string "place", :limit => 256
|
|
t.date "placedate"
|
|
t.text "comment"
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
end
|
|
|
|
end
|