2 # This file is auto-generated from the current state of the database. Instead
3 # of editing this file, please use the migrations feature of Active Record to
4 # incrementally modify your database, and then regenerate this schema definition.
6 # Note that this schema.rb definition is the authoritative source for your
7 # database schema. If you need to create the application database on another
8 # system, you should be using db:schema:load, not running all the migrations
9 # from scratch. The latter is a flawed and unsustainable approach (the more migrations
10 # you'll amass, the slower it'll run and the greater likelihood for issues).
12 # It's strongly recommended to check this file into your version control system.
14 ActiveRecord::Schema.define(:version => 20130123174514) do
16 create_table "collections", :force => true do |t|
18 t.string "created_by_client"
19 t.string "created_by_user"
20 t.datetime "created_at"
21 t.string "modified_by_client"
22 t.string "modified_by_user"
23 t.datetime "modified_at"
24 t.string "portable_data_hash"
26 t.integer "redundancy"
27 t.string "redundancy_confirmed_by_client"
28 t.datetime "redundancy_confirmed_at"
29 t.integer "redundancy_confirmed_as"
30 t.datetime "updated_at"
34 add_index "collections", ["uuid"], :name => "index_collections_on_uuid", :unique => true
36 create_table "logs", :force => true do |t|
38 t.string "created_by_client"
39 t.string "created_by_user"
40 t.string "modified_by_client"
41 t.string "modified_by_user"
42 t.string "object_kind"
43 t.string "object_uuid"
48 t.datetime "created_at"
49 t.datetime "updated_at"
50 t.datetime "modified_at"
53 add_index "logs", ["event_at"], :name => "index_logs_on_event_at"
54 add_index "logs", ["event_type"], :name => "index_logs_on_event_type"
55 add_index "logs", ["object_kind"], :name => "index_logs_on_object_kind"
56 add_index "logs", ["object_uuid"], :name => "index_logs_on_object_uuid"
57 add_index "logs", ["summary"], :name => "index_logs_on_summary"
58 add_index "logs", ["uuid"], :name => "index_logs_on_uuid", :unique => true
60 create_table "metadata", :force => true do |t|
62 t.string "created_by_client"
63 t.string "created_by_user"
64 t.datetime "created_at"
65 t.string "modified_by_client"
66 t.string "modified_by_user"
67 t.datetime "modified_at"
70 t.integer "native_target_id"
71 t.string "native_target_type"
72 t.string "metadata_class"
76 t.datetime "updated_at"
80 add_index "metadata", ["head"], :name => "index_metadata_on_head"
81 add_index "metadata", ["head_kind"], :name => "index_metadata_on_head_kind"
82 add_index "metadata", ["tail"], :name => "index_metadata_on_tail"
83 add_index "metadata", ["tail_kind"], :name => "index_metadata_on_tail_kind"
84 add_index "metadata", ["uuid"], :name => "index_metadata_on_uuid", :unique => true
86 create_table "nodes", :force => true do |t|
88 t.string "created_by_client"
89 t.string "created_by_user"
90 t.datetime "created_at"
91 t.string "modified_by_client"
92 t.string "modified_by_user"
93 t.datetime "modified_at"
94 t.integer "slot_number"
98 t.datetime "first_ping_at"
99 t.datetime "last_ping_at"
101 t.datetime "updated_at"
104 add_index "nodes", ["hostname"], :name => "index_nodes_on_hostname", :unique => true
105 add_index "nodes", ["slot_number"], :name => "index_nodes_on_slot_number", :unique => true
106 add_index "nodes", ["uuid"], :name => "index_nodes_on_uuid", :unique => true
108 create_table "pipeline_invocations", :force => true do |t|
110 t.string "created_by_client"
111 t.string "created_by_user"
112 t.datetime "created_at"
113 t.string "modified_by_client"
114 t.string "modified_by_user"
115 t.datetime "modified_at"
116 t.string "pipeline_uuid"
120 t.boolean "active", :default => false
121 t.datetime "updated_at"
124 add_index "pipeline_invocations", ["uuid"], :name => "index_pipeline_invocations_on_uuid", :unique => true
126 create_table "pipelines", :force => true do |t|
128 t.string "created_by_client"
129 t.string "created_by_user"
130 t.datetime "created_at"
131 t.string "modified_by_client"
132 t.string "modified_by_user"
133 t.datetime "modified_at"
136 t.datetime "updated_at"
139 add_index "pipelines", ["uuid"], :name => "index_pipelines_on_uuid", :unique => true
141 create_table "projects", :force => true do |t|
143 t.string "created_by_client"
144 t.string "created_by_user"
145 t.datetime "created_at"
146 t.string "modified_by_client"
147 t.string "modified_by_user"
148 t.datetime "modified_at"
151 t.datetime "updated_at"
154 add_index "projects", ["uuid"], :name => "index_projects_on_uuid", :unique => true
156 create_table "specimens", :force => true do |t|
158 t.string "created_by_client"
159 t.string "created_by_user"
160 t.datetime "created_at"
161 t.string "modified_by_client"
162 t.string "modified_by_user"
163 t.datetime "modified_at"
165 t.datetime "updated_at"
168 add_index "specimens", ["uuid"], :name => "index_specimens_on_uuid", :unique => true
170 create_table "users", :force => true do |t|
172 t.string "created_by_client"
173 t.string "created_by_user"
174 t.datetime "created_at"
175 t.string "modified_by_client"
176 t.string "modified_by_user"
177 t.datetime "modified_at"
179 t.string "first_name"
181 t.string "identity_url"
184 t.datetime "updated_at"
187 add_index "users", ["uuid"], :name => "index_users_on_uuid", :unique => true