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 => 20130123180228) 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"
28 add_index "api_client_authorizations", ["api_client_id"], :name => "index_api_client_authorizations_on_api_client_id"
29 add_index "api_client_authorizations", ["api_token"], :name => "index_api_client_authorizations_on_api_token", :unique => true
30 add_index "api_client_authorizations", ["expires_at"], :name => "index_api_client_authorizations_on_expires_at"
31 add_index "api_client_authorizations", ["user_id"], :name => "index_api_client_authorizations_on_user_id"
33 create_table "api_clients", :force => true do |t|
35 t.string "created_by_client"
36 t.string "created_by_user"
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", ["uuid"], :name => "index_api_clients_on_uuid", :unique => true
48 create_table "collections", :force => true do |t|
50 t.string "created_by_client"
51 t.string "created_by_user"
52 t.datetime "created_at"
53 t.string "modified_by_client"
54 t.string "modified_by_user"
55 t.datetime "modified_at"
56 t.string "portable_data_hash"
58 t.integer "redundancy"
59 t.string "redundancy_confirmed_by_client"
60 t.datetime "redundancy_confirmed_at"
61 t.integer "redundancy_confirmed_as"
62 t.datetime "updated_at"
66 add_index "collections", ["uuid"], :name => "index_collections_on_uuid", :unique => true
68 create_table "logs", :force => true do |t|
70 t.string "created_by_client"
71 t.string "created_by_user"
72 t.string "modified_by_client"
73 t.string "modified_by_user"
74 t.string "object_kind"
75 t.string "object_uuid"
80 t.datetime "created_at"
81 t.datetime "updated_at"
82 t.datetime "modified_at"
85 add_index "logs", ["event_at"], :name => "index_logs_on_event_at"
86 add_index "logs", ["event_type"], :name => "index_logs_on_event_type"
87 add_index "logs", ["object_kind"], :name => "index_logs_on_object_kind"
88 add_index "logs", ["object_uuid"], :name => "index_logs_on_object_uuid"
89 add_index "logs", ["summary"], :name => "index_logs_on_summary"
90 add_index "logs", ["uuid"], :name => "index_logs_on_uuid", :unique => true
92 create_table "metadata", :force => true do |t|
94 t.string "created_by_client"
95 t.string "created_by_user"
96 t.datetime "created_at"
97 t.string "modified_by_client"
98 t.string "modified_by_user"
99 t.datetime "modified_at"
102 t.integer "native_target_id"
103 t.string "native_target_type"
104 t.string "metadata_class"
108 t.datetime "updated_at"
112 add_index "metadata", ["head"], :name => "index_metadata_on_head"
113 add_index "metadata", ["head_kind"], :name => "index_metadata_on_head_kind"
114 add_index "metadata", ["tail"], :name => "index_metadata_on_tail"
115 add_index "metadata", ["tail_kind"], :name => "index_metadata_on_tail_kind"
116 add_index "metadata", ["uuid"], :name => "index_metadata_on_uuid", :unique => true
118 create_table "nodes", :force => true do |t|
120 t.string "created_by_client"
121 t.string "created_by_user"
122 t.datetime "created_at"
123 t.string "modified_by_client"
124 t.string "modified_by_user"
125 t.datetime "modified_at"
126 t.integer "slot_number"
129 t.string "ip_address"
130 t.datetime "first_ping_at"
131 t.datetime "last_ping_at"
133 t.datetime "updated_at"
136 add_index "nodes", ["hostname"], :name => "index_nodes_on_hostname", :unique => true
137 add_index "nodes", ["slot_number"], :name => "index_nodes_on_slot_number", :unique => true
138 add_index "nodes", ["uuid"], :name => "index_nodes_on_uuid", :unique => true
140 create_table "pipeline_invocations", :force => true do |t|
142 t.string "created_by_client"
143 t.string "created_by_user"
144 t.datetime "created_at"
145 t.string "modified_by_client"
146 t.string "modified_by_user"
147 t.datetime "modified_at"
148 t.string "pipeline_uuid"
152 t.boolean "active", :default => false
153 t.datetime "updated_at"
156 add_index "pipeline_invocations", ["uuid"], :name => "index_pipeline_invocations_on_uuid", :unique => true
158 create_table "pipelines", :force => true do |t|
160 t.string "created_by_client"
161 t.string "created_by_user"
162 t.datetime "created_at"
163 t.string "modified_by_client"
164 t.string "modified_by_user"
165 t.datetime "modified_at"
168 t.datetime "updated_at"
171 add_index "pipelines", ["uuid"], :name => "index_pipelines_on_uuid", :unique => true
173 create_table "projects", :force => true do |t|
175 t.string "created_by_client"
176 t.string "created_by_user"
177 t.datetime "created_at"
178 t.string "modified_by_client"
179 t.string "modified_by_user"
180 t.datetime "modified_at"
183 t.datetime "updated_at"
186 add_index "projects", ["uuid"], :name => "index_projects_on_uuid", :unique => true
188 create_table "specimens", :force => true do |t|
190 t.string "created_by_client"
191 t.string "created_by_user"
192 t.datetime "created_at"
193 t.string "modified_by_client"
194 t.string "modified_by_user"
195 t.datetime "modified_at"
197 t.datetime "updated_at"
200 add_index "specimens", ["uuid"], :name => "index_specimens_on_uuid", :unique => true
202 create_table "users", :force => true do |t|
204 t.string "created_by_client"
205 t.string "created_by_user"
206 t.datetime "created_at"
207 t.string "modified_by_client"
208 t.string "modified_by_user"
209 t.datetime "modified_at"
211 t.string "first_name"
213 t.string "identity_url"
216 t.datetime "updated_at"
219 add_index "users", ["uuid"], :name => "index_users_on_uuid", :unique => true