aboutsummaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/schema.rb17
1 files changed, 15 insertions, 2 deletions
diff --git a/db/schema.rb b/db/schema.rb
index 0660ef9..fa53f85 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -10,7 +10,7 @@
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 2020_10_09_061548) do
+ActiveRecord::Schema.define(version: 2020_11_10_225447) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
@@ -55,9 +55,21 @@ ActiveRecord::Schema.define(version: 2020_10_09_061548) do
t.bigint "section_id", null: false
end
+ create_table "maps", force: :cascade do |t|
+ t.uuid "uuid", null: false
+ t.decimal "latitude", precision: 9, scale: 7
+ t.decimal "longitude", precision: 10, scale: 7
+ t.integer "zoom", default: 13
+ t.bigint "taxonomy_id", null: false
+ t.datetime "created_at", precision: 6, null: false
+ t.datetime "updated_at", precision: 6, null: false
+ t.index ["taxonomy_id"], name: "index_maps_on_taxonomy_id"
+ t.index ["uuid"], name: "index_maps_on_uuid", unique: true
+ end
+
create_table "resources", force: :cascade do |t|
t.uuid "uuid"
- t.jsonb "feature", default: {"geometry"=>{"type"=>"Point", "coordinates"=>[0, 0]}, "properties"=>{"city"=>"", "name"=>"", "srid"=>4326, "email"=>"", "source"=>"incommon", "address"=>"", "website"=>"", "categories"=>[], "description"=>"", "postal_code"=>"", "entry_number"=>nil, "phone_number"=>""}}
+ t.jsonb "feature", default: {"geometry"=>{"type"=>"Point", "coordinates"=>[0, 0]}, "properties"=>{"city"=>"", "name"=>"", "srid"=>4326, "email"=>"", "source"=>"incommon", "address"=>"", "website"=>"", "categories"=>[], "description"=>"", "postal_code"=>"", "entry_number"=>"", "phone_number"=>""}}
t.bigint "agent_id", null: false
t.datetime "created_at", precision: 6, null: false
t.datetime "updated_at", precision: 6, null: false
@@ -109,6 +121,7 @@ ActiveRecord::Schema.define(version: 2020_10_09_061548) do
add_foreign_key "agencies", "agents"
add_foreign_key "agencies", "users"
add_foreign_key "categories", "taxonomies"
+ add_foreign_key "maps", "taxonomies"
add_foreign_key "resources", "agents"
add_foreign_key "sections", "categories"
add_foreign_key "taxonomies", "agents"