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 => 20130320000107) do
16 create_table "api_client_authorizations", :force => true do |t|
17 t.string "api_token", :null => false
18 t.integer "api_client_id", :null => false
19 t.integer "user_id", :null => false
20 t.string "created_by_ip_address"
21 t.string "last_used_by_ip_address"
22 t.datetime "last_used_at"
23 t.datetime "expires_at"
24 t.datetime "created_at"
25 t.datetime "updated_at"
26 t.string "default_owner"
29 add_index "api_client_authorizations", ["api_client_id"], :name => "index_api_client_authorizations_on_api_client_id"
30 add_index "api_client_authorizations", ["api_token"], :name => "index_api_client_authorizations_on_api_token", :unique => true
31 add_index "api_client_authorizations", ["expires_at"], :name => "index_api_client_authorizations_on_expires_at"
32 add_index "api_client_authorizations", ["user_id"], :name => "index_api_client_authorizations_on_user_id"
34 create_table "api_clients", :force => true do |t|
37 t.string "modified_by_client"
38 t.string "modified_by_user"
39 t.datetime "modified_at"
42 t.datetime "created_at"
43 t.datetime "updated_at"
46 add_index "api_clients", ["created_at"], :name => "index_api_clients_on_created_at"
47 add_index "api_clients", ["modified_at"], :name => "index_api_clients_on_modified_at"
48 add_index "api_clients", ["uuid"], :name => "index_api_clients_on_uuid", :unique => true
50 create_table "collections", :force => true do |t|
53 t.datetime "created_at"
54 t.string "modified_by_client"
55 t.string "modified_by_user"
56 t.datetime "modified_at"
57 t.string "portable_data_hash"
59 t.integer "redundancy"
60 t.string "redundancy_confirmed_by_client"
61 t.datetime "redundancy_confirmed_at"
62 t.integer "redundancy_confirmed_as"
63 t.datetime "updated_at"
65 t.text "manifest_text"
68 add_index "collections", ["created_at"], :name => "index_collections_on_created_at"
69 add_index "collections", ["modified_at"], :name => "index_collections_on_modified_at"
70 add_index "collections", ["uuid"], :name => "index_collections_on_uuid", :unique => true
72 create_table "groups", :force => true do |t|
75 t.datetime "created_at"
76 t.string "modified_by_client"
77 t.string "modified_by_user"
78 t.datetime "modified_at"
81 t.datetime "updated_at"
84 add_index "groups", ["created_at"], :name => "index_groups_on_created_at"
85 add_index "groups", ["modified_at"], :name => "index_groups_on_modified_at"
86 add_index "groups", ["uuid"], :name => "index_groups_on_uuid", :unique => true
88 create_table "job_tasks", :force => true do |t|
91 t.string "modified_by_client"
92 t.string "modified_by_user"
93 t.datetime "modified_at"
100 t.datetime "created_at"
101 t.datetime "updated_at"
104 add_index "job_tasks", ["created_at"], :name => "index_job_tasks_on_created_at"
105 add_index "job_tasks", ["job_uuid"], :name => "index_job_tasks_on_job_uuid"
106 add_index "job_tasks", ["modified_at"], :name => "index_job_tasks_on_modified_at"
107 add_index "job_tasks", ["sequence"], :name => "index_job_tasks_on_sequence"
108 add_index "job_tasks", ["success"], :name => "index_job_tasks_on_success"
109 add_index "job_tasks", ["uuid"], :name => "index_job_tasks_on_uuid", :unique => true
111 create_table "jobs", :force => true do |t|
114 t.string "modified_by_client"
115 t.string "modified_by_user"
116 t.datetime "modified_at"
119 t.string "script_version"
120 t.text "script_parameters"
121 t.string "cancelled_by_client"
122 t.string "cancelled_by_user"
123 t.datetime "cancelled_at"
124 t.datetime "started_at"
125 t.datetime "finished_at"
129 t.datetime "created_at"
130 t.datetime "updated_at"
132 t.string "is_locked_by"
134 t.text "tasks_summary"
135 t.text "resource_limits"
138 add_index "jobs", ["created_at"], :name => "index_jobs_on_created_at"
139 add_index "jobs", ["finished_at"], :name => "index_jobs_on_finished_at"
140 add_index "jobs", ["modified_at"], :name => "index_jobs_on_modified_at"
141 add_index "jobs", ["output"], :name => "index_jobs_on_output"
142 add_index "jobs", ["script"], :name => "index_jobs_on_script"
143 add_index "jobs", ["started_at"], :name => "index_jobs_on_started_at"
144 add_index "jobs", ["submit_id"], :name => "index_jobs_on_submit_id", :unique => true
145 add_index "jobs", ["uuid"], :name => "index_jobs_on_uuid", :unique => true
147 create_table "links", :force => true do |t|
150 t.datetime "created_at"
151 t.string "modified_by_client"
152 t.string "modified_by_user"
153 t.datetime "modified_at"
156 t.string "link_class"
160 t.datetime "updated_at"
164 add_index "links", ["created_at"], :name => "index_links_on_created_at"
165 add_index "links", ["head_kind"], :name => "index_links_on_head_kind"
166 add_index "links", ["head_uuid"], :name => "index_links_on_head_uuid"
167 add_index "links", ["modified_at"], :name => "index_links_on_modified_at"
168 add_index "links", ["tail_kind"], :name => "index_links_on_tail_kind"
169 add_index "links", ["tail_uuid"], :name => "index_links_on_tail_uuid"
170 add_index "links", ["uuid"], :name => "index_links_on_uuid", :unique => true
172 create_table "logs", :force => true do |t|
175 t.string "modified_by_client"
176 t.string "modified_by_user"
177 t.string "object_kind"
178 t.string "object_uuid"
179 t.datetime "event_at"
180 t.string "event_type"
183 t.datetime "created_at"
184 t.datetime "updated_at"
185 t.datetime "modified_at"
188 add_index "logs", ["created_at"], :name => "index_logs_on_created_at"
189 add_index "logs", ["event_at"], :name => "index_logs_on_event_at"
190 add_index "logs", ["event_type"], :name => "index_logs_on_event_type"
191 add_index "logs", ["modified_at"], :name => "index_logs_on_modified_at"
192 add_index "logs", ["object_kind"], :name => "index_logs_on_object_kind"
193 add_index "logs", ["object_uuid"], :name => "index_logs_on_object_uuid"
194 add_index "logs", ["summary"], :name => "index_logs_on_summary"
195 add_index "logs", ["uuid"], :name => "index_logs_on_uuid", :unique => true
197 create_table "nodes", :force => true do |t|
200 t.datetime "created_at"
201 t.string "modified_by_client"
202 t.string "modified_by_user"
203 t.datetime "modified_at"
204 t.integer "slot_number"
207 t.string "ip_address"
208 t.datetime "first_ping_at"
209 t.datetime "last_ping_at"
211 t.datetime "updated_at"
214 add_index "nodes", ["created_at"], :name => "index_nodes_on_created_at"
215 add_index "nodes", ["hostname"], :name => "index_nodes_on_hostname", :unique => true
216 add_index "nodes", ["modified_at"], :name => "index_nodes_on_modified_at"
217 add_index "nodes", ["slot_number"], :name => "index_nodes_on_slot_number", :unique => true
218 add_index "nodes", ["uuid"], :name => "index_nodes_on_uuid", :unique => true
220 create_table "pipeline_instances", :force => true do |t|
223 t.datetime "created_at"
224 t.string "modified_by_client"
225 t.string "modified_by_user"
226 t.datetime "modified_at"
227 t.string "pipeline_template_uuid"
231 t.boolean "active", :default => false
232 t.datetime "updated_at"
236 add_index "pipeline_instances", ["created_at"], :name => "index_pipeline_instances_on_created_at"
237 add_index "pipeline_instances", ["modified_at"], :name => "index_pipeline_instances_on_modified_at"
238 add_index "pipeline_instances", ["uuid"], :name => "index_pipeline_instances_on_uuid", :unique => true
240 create_table "pipeline_templates", :force => true do |t|
243 t.datetime "created_at"
244 t.string "modified_by_client"
245 t.string "modified_by_user"
246 t.datetime "modified_at"
249 t.datetime "updated_at"
252 add_index "pipeline_templates", ["created_at"], :name => "index_pipeline_templates_on_created_at"
253 add_index "pipeline_templates", ["modified_at"], :name => "index_pipeline_templates_on_modified_at"
254 add_index "pipeline_templates", ["uuid"], :name => "index_pipeline_templates_on_uuid", :unique => true
256 create_table "specimens", :force => true do |t|
259 t.datetime "created_at"
260 t.string "modified_by_client"
261 t.string "modified_by_user"
262 t.datetime "modified_at"
264 t.datetime "updated_at"
268 add_index "specimens", ["created_at"], :name => "index_specimens_on_created_at"
269 add_index "specimens", ["modified_at"], :name => "index_specimens_on_modified_at"
270 add_index "specimens", ["uuid"], :name => "index_specimens_on_uuid", :unique => true
272 create_table "users", :force => true do |t|
275 t.datetime "created_at"
276 t.string "modified_by_client"
277 t.string "modified_by_user"
278 t.datetime "modified_at"
280 t.string "first_name"
282 t.string "identity_url"
285 t.datetime "updated_at"
286 t.string "default_owner"
289 add_index "users", ["created_at"], :name => "index_users_on_created_at"
290 add_index "users", ["modified_at"], :name => "index_users_on_modified_at"
291 add_index "users", ["uuid"], :name => "index_users_on_uuid", :unique => true