diff options
Diffstat (limited to 'db/schema.rb')
-rw-r--r-- | db/schema.rb | 32 |
1 files changed, 31 insertions, 1 deletions
diff --git a/db/schema.rb b/db/schema.rb index 626ec36..7cae7d0 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: 2021_05_03_235646) do +ActiveRecord::Schema.define(version: 2021_05_18_214817) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" @@ -27,6 +27,16 @@ ActiveRecord::Schema.define(version: 2021_05_03_235646) do t.index ["location_id"], name: "index_activities_on_location_id" end + create_table "built_hearth_amenities", force: :cascade do |t| + t.bigint "hearth_id", null: false + t.bigint "hearth_amenity_id", null: false + t.integer "level" + t.datetime "created_at", precision: 6, null: false + t.datetime "updated_at", precision: 6, null: false + t.index ["hearth_amenity_id"], name: "index_built_hearth_amenities_on_hearth_amenity_id" + t.index ["hearth_id"], name: "index_built_hearth_amenities_on_hearth_id" + end + create_table "character_items", force: :cascade do |t| t.bigint "character_id", null: false t.bigint "item_id", null: false @@ -59,6 +69,23 @@ ActiveRecord::Schema.define(version: 2021_05_03_235646) do t.index ["user_id"], name: "index_characters_on_user_id" end + create_table "hearth_amenities", force: :cascade do |t| + t.string "gid" + t.string "name" + t.text "description" + t.jsonb "build_data" + t.datetime "created_at", precision: 6, null: false + t.datetime "updated_at", precision: 6, null: false + t.index ["gid"], name: "index_hearth_amenities_on_gid" + end + + create_table "hearths", force: :cascade do |t| + t.bigint "character_id", null: false + t.datetime "created_at", precision: 6, null: false + t.datetime "updated_at", precision: 6, null: false + t.index ["character_id"], name: "index_hearths_on_character_id" + end + create_table "items", force: :cascade do |t| t.string "gid" t.string "name" @@ -118,11 +145,14 @@ ActiveRecord::Schema.define(version: 2021_05_03_235646) do t.index ["unlock_token"], name: "index_users_on_unlock_token", unique: true end + add_foreign_key "built_hearth_amenities", "hearth_amenities" + add_foreign_key "built_hearth_amenities", "hearths" add_foreign_key "character_items", "characters" add_foreign_key "character_items", "items" add_foreign_key "character_skills", "characters" add_foreign_key "character_skills", "skills" add_foreign_key "characters", "activities" add_foreign_key "characters", "users" + add_foreign_key "hearths", "characters" add_foreign_key "users", "characters", column: "active_character_id" end |