schema.rb

# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running all the migrations
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended that you check this file into your version control system.

ActiveRecord::Schema.define(version: 20200326094046) do

  create_table "about_pages", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "topical_event_id"
    t.string "name"
    t.text "summary"
    t.text "body"
    t.string "read_more_link_text"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.string "content_id"
    t.index ["name"], name: "index_about_pages_on_name", unique: true
  end

  create_table "access_and_opening_times", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.text "body"
    t.string "accessible_type"
    t.integer "accessible_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["accessible_id", "accessible_type"], name: "accessible_index"
  end

  create_table "attachment_data", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "carrierwave_file"
    t.string "content_type"
    t.integer "file_size"
    t.integer "number_of_pages"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "replaced_by_id"
    t.datetime "uploaded_to_asset_manager_at"
    t.boolean "present_at_unpublish"
    t.index ["replaced_by_id"], name: "index_attachment_data_on_replaced_by_id"
  end

  create_table "attachment_sources", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "attachment_id"
    t.string "url"
    t.index ["attachment_id"], name: "index_attachment_sources_on_attachment_id"
  end

  create_table "attachments", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "title"
    t.boolean "accessible"
    t.string "isbn"
    t.string "unique_reference"
    t.string "command_paper_number"
    t.string "order_url"
    t.integer "price_in_pence"
    t.integer "attachment_data_id"
    t.integer "ordering", null: false
    t.string "hoc_paper_number"
    t.string "parliamentary_session"
    t.boolean "unnumbered_command_paper"
    t.boolean "unnumbered_hoc_paper"
    t.integer "attachable_id"
    t.string "attachable_type"
    t.string "type"
    t.string "slug"
    t.string "locale"
    t.string "external_url"
    t.string "content_id"
    t.boolean "deleted", default: false, null: false
    t.index ["attachable_id", "attachable_type"], name: "index_attachments_on_attachable_id_and_attachable_type"
    t.index ["attachable_type", "attachable_id", "ordering"], name: "no_duplicate_attachment_orderings", unique: true
    t.index ["attachment_data_id"], name: "index_attachments_on_attachment_data_id"
    t.index ["ordering"], name: "index_attachments_on_ordering"
  end

  create_table "brexit_no_deal_content_notice_links", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "title"
    t.string "url"
    t.integer "edition_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "classification_featuring_image_data", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "carrierwave_image"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "classification_featurings", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "edition_id"
    t.integer "classification_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "ordering"
    t.integer "classification_featuring_image_data_id"
    t.string "alt_text"
    t.integer "offsite_link_id"
    t.index ["classification_featuring_image_data_id"], name: "index_cl_feat_on_edition_org_image_data_id"
    t.index ["classification_id"], name: "index_cl_feat_on_classification_id"
    t.index ["edition_id", "classification_id"], name: "index_cl_feat_on_edition_id_and_classification_id", unique: true
    t.index ["offsite_link_id"], name: "index_classification_featurings_on_offsite_link_id"
  end

  create_table "classification_memberships", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "classification_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "edition_id"
    t.integer "ordering"
    t.index ["classification_id"], name: "index_classification_memberships_on_classification_id"
    t.index ["edition_id"], name: "index_classification_memberships_on_edition_id"
  end

  create_table "classification_policies", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "classification_id"
    t.string "policy_content_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["classification_id"], name: "index_classification_policies_on_classification_id"
    t.index ["policy_content_id"], name: "index_classification_policies_on_policy_content_id"
  end

  create_table "classification_relations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "classification_id", null: false
    t.integer "related_classification_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["classification_id"], name: "index_classification_relations_on_classification_id", unique: true
    t.index ["related_classification_id"], name: "index_classification_relations_on_related_classification_id"
  end

  create_table "classifications", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.string "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.text "description"
    t.string "slug"
    t.string "state"
    t.string "type"
    t.string "carrierwave_image"
    t.string "logo_alt_text"
    t.date "start_date"
    t.date "end_date"
    t.string "content_id"
    t.index ["name"], name: "index_classifications_on_name", unique: true
    t.index ["slug"], name: "index_classifications_on_slug"
  end

  create_table "consultation_participations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "edition_id"
    t.string "link_url"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "email"
    t.integer "consultation_response_form_id"
    t.text "postal_address"
    t.index ["consultation_response_form_id"], name: "index_cons_participations_on_cons_response_form_id"
    t.index ["edition_id"], name: "index_consultation_participations_on_edition_id"
  end

  create_table "consultation_response_form_data", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "carrierwave_file"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "consultation_response_forms", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "title"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "consultation_response_form_data_id"
  end

  create_table "contact_number_translations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "contact_number_id"
    t.string "locale"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.string "label"
    t.string "number"
    t.index ["contact_number_id"], name: "index_contact_number_translations_on_contact_number_id"
    t.index ["locale"], name: "index_contact_number_translations_on_locale"
  end

  create_table "contact_numbers", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "contact_id"
    t.string "label"
    t.string "number"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["contact_id"], name: "index_contact_numbers_on_contact_id"
  end

  create_table "contact_translations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "contact_id"
    t.string "locale"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.string "title"
    t.text "comments"
    t.string "recipient"
    t.text "street_address"
    t.string "locality"
    t.string "region"
    t.string "email"
    t.string "contact_form_url"
    t.index ["contact_id"], name: "index_contact_translations_on_contact_id"
    t.index ["locale"], name: "index_contact_translations_on_locale"
  end

  create_table "contacts", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.decimal "latitude", precision: 15, scale: 10
    t.decimal "longitude", precision: 15, scale: 10
    t.integer "contactable_id"
    t.string "contactable_type"
    t.string "postal_code"
    t.integer "country_id"
    t.integer "contact_type_id", null: false
    t.string "content_id", null: false
    t.index ["contact_type_id"], name: "index_contacts_on_contact_type_id"
    t.index ["contactable_id", "contactable_type"], name: "index_contacts_on_contactable_id_and_contactable_type"
  end

  create_table "data_migration_records", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "version"
    t.index ["version"], name: "index_data_migration_records_on_version", unique: true
  end

  create_table "default_news_organisation_image_data", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.string "carrierwave_image"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "document_collection_group_memberships", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "document_id"
    t.integer "document_collection_group_id"
    t.integer "ordering"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.bigint "non_whitehall_link_id"
    t.index ["document_collection_group_id", "ordering"], name: "index_dc_group_memberships_on_dc_group_id_and_ordering"
    t.index ["document_id"], name: "index_document_collection_group_memberships_on_document_id"
    t.index ["non_whitehall_link_id"], name: "index_document_collection_non_whitehall_link"
  end

  create_table "document_collection_groups", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "document_collection_id"
    t.string "heading"
    t.text "body"
    t.integer "ordering"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["document_collection_id", "ordering"], name: "index_dc_groups_on_dc_id_and_ordering"
    t.index ["heading"], name: "index_document_collection_groups_on_heading", unique: true
  end

  create_table "document_collection_non_whitehall_links", force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "content_id", null: false
    t.string "title", null: false
    t.text "base_path", null: false
    t.string "publishing_app", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "document_sources", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "document_id"
    t.string "url", null: false
    t.integer "import_id"
    t.integer "row_number"
    t.string "locale", default: "en"
    t.index ["document_id"], name: "index_document_sources_on_document_id"
    t.index ["url"], name: "index_document_sources_on_url", unique: true
  end

  create_table "documents", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "slug"
    t.string "document_type"
    t.string "content_id", null: false
    t.boolean "locked", default: false, null: false
    t.index ["document_type"], name: "index_documents_on_document_type"
    t.index ["slug", "document_type"], name: "index_documents_on_slug_and_document_type", unique: true
  end

  create_table "edition_authors", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "edition_id"
    t.integer "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["edition_id"], name: "index_edition_authors_on_edition_id"
    t.index ["user_id"], name: "index_edition_authors_on_user_id"
  end

  create_table "edition_dependencies", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "edition_id"
    t.integer "dependable_id"
    t.string "dependable_type"
    t.index ["dependable_id", "dependable_type", "edition_id"], name: "index_edition_dependencies_on_dependable_and_edition", unique: true
  end

  create_table "edition_organisations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "edition_id"
    t.integer "organisation_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean "lead", default: false, null: false
    t.integer "lead_ordering"
    t.index ["edition_id", "organisation_id"], name: "index_edition_organisations_on_edition_id_and_organisation_id", unique: true
    t.index ["organisation_id"], name: "index_edition_organisations_on_organisation_id"
  end

  create_table "edition_policies", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "edition_id"
    t.string "policy_content_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["edition_id"], name: "index_edition_policies_on_edition_id"
    t.index ["policy_content_id"], name: "index_edition_policies_on_policy_content_id"
  end

  create_table "edition_relations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "edition_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "document_id"
    t.index ["document_id"], name: "index_edition_relations_on_document_id", unique: true
    t.index ["edition_id"], name: "index_edition_relations_on_edition_id"
  end

  create_table "edition_role_appointments", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "edition_id"
    t.integer "role_appointment_id"
    t.index ["edition_id"], name: "index_edition_role_appointments_on_edition_id"
    t.index ["role_appointment_id"], name: "index_edition_role_appointments_on_role_appointment_id"
  end

  create_table "edition_statistical_data_sets", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "edition_id"
    t.integer "document_id"
    t.index ["document_id"], name: "index_edition_statistical_data_sets_on_document_id"
    t.index ["edition_id"], name: "index_edition_statistical_data_sets_on_edition_id"
  end

  create_table "edition_translations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "edition_id"
    t.string "locale"
    t.string "title"
    t.text "summary"
    t.text "body", limit: 16777215
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["edition_id"], name: "index_edition_translations_on_edition_id"
    t.index ["locale"], name: "index_edition_translations_on_locale"
  end

  create_table "edition_world_locations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "edition_id"
    t.integer "world_location_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["edition_id", "world_location_id"], name: "idx_edition_world_locations_on_edition_and_world_location_ids", unique: true
    t.index ["edition_id"], name: "index_edition_world_locations_on_edition_id"
    t.index ["world_location_id"], name: "index_edition_world_locations_on_world_location_id"
  end

  create_table "edition_worldwide_organisations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "edition_id"
    t.integer "worldwide_organisation_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["edition_id"], name: "index_edition_worldwide_orgs_on_edition_id"
    t.index ["worldwide_organisation_id"], name: "index_edition_worldwide_orgs_on_worldwide_organisation_id"
  end

  create_table "editions", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "lock_version", default: 0
    t.integer "document_id"
    t.string "state", default: "draft", null: false
    t.string "type"
    t.integer "role_appointment_id"
    t.string "location"
    t.datetime "delivered_on"
    t.datetime "major_change_published_at"
    t.datetime "first_published_at"
    t.integer "speech_type_id"
    t.boolean "stub", default: false
    t.text "change_note"
    t.boolean "force_published"
    t.boolean "minor_change", default: false
    t.integer "publication_type_id"
    t.string "related_mainstream_content_url"
    t.string "related_mainstream_content_title"
    t.string "additional_related_mainstream_content_url"
    t.string "additional_related_mainstream_content_title"
    t.integer "alternative_format_provider_id"
    t.datetime "public_timestamp"
    t.datetime "scheduled_publication"
    t.boolean "replaces_businesslink", default: false
    t.boolean "access_limited", null: false
    t.integer "published_major_version"
    t.integer "published_minor_version"
    t.integer "operational_field_id"
    t.text "roll_call_introduction"
    t.integer "news_article_type_id"
    t.boolean "relevant_to_local_government", default: false
    t.string "person_override"
    t.boolean "external", default: false
    t.string "external_url"
    t.datetime "opening_at"
    t.datetime "closing_at"
    t.integer "corporate_information_page_type_id"
    t.string "primary_locale", default: "en", null: false
    t.boolean "political", default: false
    t.string "logo_url"
    t.boolean "read_consultation_principles", default: false
    t.boolean "show_brexit_no_deal_content_notice", default: false
    t.index ["alternative_format_provider_id"], name: "index_editions_on_alternative_format_provider_id"
    t.index ["closing_at"], name: "index_editions_on_closing_at"
    t.index ["document_id"], name: "index_editions_on_document_id"
    t.index ["first_published_at"], name: "index_editions_on_first_published_at"
    t.index ["opening_at"], name: "index_editions_on_opening_at"
    t.index ["operational_field_id"], name: "index_editions_on_operational_field_id"
    t.index ["public_timestamp", "document_id"], name: "index_editions_on_public_timestamp_and_document_id"
    t.index ["public_timestamp"], name: "index_editions_on_public_timestamp"
    t.index ["publication_type_id"], name: "index_editions_on_publication_type_id"
    t.index ["role_appointment_id"], name: "index_editions_on_role_appointment_id"
    t.index ["speech_type_id"], name: "index_editions_on_speech_type_id"
    t.index ["state", "type"], name: "index_editions_on_state_and_type"
    t.index ["state"], name: "index_editions_on_state"
    t.index ["type"], name: "index_editions_on_type"
  end

  create_table "editorial_remarks", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.text "body"
    t.integer "edition_id"
    t.integer "author_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["author_id"], name: "index_editorial_remarks_on_author_id"
    t.index ["edition_id"], name: "index_editorial_remarks_on_edition_id"
  end

  create_table "fact_check_requests", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "edition_id"
    t.string "key"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "email_address"
    t.text "comments"
    t.text "instructions"
    t.integer "requestor_id"
    t.index ["edition_id"], name: "index_fact_check_requests_on_edition_id"
    t.index ["key"], name: "index_fact_check_requests_on_key", unique: true
    t.index ["requestor_id"], name: "index_fact_check_requests_on_requestor_id"
  end

  create_table "fatality_notice_casualties", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "fatality_notice_id"
    t.text "personal_details"
  end

  create_table "feature_flags", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "key"
    t.boolean "enabled", default: false
  end

  create_table "feature_lists", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "featurable_id"
    t.string "featurable_type"
    t.string "locale"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["featurable_id", "featurable_type", "locale"], name: "featurable_lists_unique_locale_per_featurable", unique: true
  end

  create_table "featured_links", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.text "url"
    t.string "title"
    t.integer "linkable_id"
    t.string "linkable_type"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "features", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "document_id"
    t.integer "feature_list_id"
    t.string "carrierwave_image"
    t.string "alt_text"
    t.integer "ordering"
    t.datetime "started_at"
    t.datetime "ended_at"
    t.integer "topical_event_id"
    t.integer "offsite_link_id"
    t.index ["document_id"], name: "index_features_on_document_id"
    t.index ["feature_list_id", "ordering"], name: "index_features_on_feature_list_id_and_ordering", unique: true
    t.index ["feature_list_id"], name: "index_features_on_feature_list_id"
    t.index ["offsite_link_id"], name: "index_features_on_offsite_link_id"
    t.index ["ordering"], name: "index_features_on_ordering"
  end

  create_table "financial_reports", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "organisation_id"
    t.bigint "funding"
    t.bigint "spending"
    t.integer "year"
    t.index ["organisation_id", "year"], name: "index_financial_reports_on_organisation_id_and_year", unique: true
    t.index ["organisation_id"], name: "index_financial_reports_on_organisation_id"
    t.index ["year"], name: "index_financial_reports_on_year"
  end

  create_table "force_publication_attempts", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "import_id"
    t.integer "total_documents"
    t.integer "successful_documents"
    t.datetime "enqueued_at"
    t.datetime "started_at"
    t.datetime "finished_at"
    t.text "log", limit: 4294967295
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["import_id"], name: "index_force_publication_attempts_on_import_id"
  end

  create_table "governments", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "slug"
    t.string "name"
    t.date "start_date"
    t.date "end_date"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "content_id", null: false
    t.index ["content_id"], name: "index_governments_on_content_id", unique: true
    t.index ["end_date"], name: "index_governments_on_end_date"
    t.index ["name"], name: "index_governments_on_name", unique: true
    t.index ["slug"], name: "index_governments_on_slug", unique: true
    t.index ["start_date"], name: "index_governments_on_start_date"
  end

  create_table "govspeak_contents", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "html_attachment_id"
    t.text "body", limit: 16777215
    t.boolean "manually_numbered_headings"
    t.text "computed_body_html", limit: 16777215
    t.text "computed_headers_html"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["html_attachment_id"], name: "index_govspeak_contents_on_html_attachment_id"
  end

  create_table "group_memberships", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "group_id"
    t.integer "person_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["group_id"], name: "index_group_memberships_on_group_id"
    t.index ["person_id"], name: "index_group_memberships_on_person_id"
  end

  create_table "groups", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "organisation_id"
    t.string "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "slug"
    t.text "description"
    t.index ["organisation_id"], name: "index_groups_on_organisation_id"
    t.index ["slug"], name: "index_groups_on_slug"
  end

  create_table "historical_account_roles", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "role_id"
    t.integer "historical_account_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["historical_account_id"], name: "index_historical_account_roles_on_historical_account_id"
    t.index ["role_id"], name: "index_historical_account_roles_on_role_id"
  end

  create_table "historical_accounts", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "person_id"
    t.text "summary"
    t.text "body"
    t.string "born"
    t.string "died"
    t.text "major_acts"
    t.text "interesting_facts"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "political_party_ids"
    t.index ["person_id"], name: "index_historical_accounts_on_person_id"
  end

  create_table "home_page_list_items", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "home_page_list_id", null: false
    t.integer "item_id", null: false
    t.string "item_type", null: false
    t.integer "ordering"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["home_page_list_id", "ordering"], name: "index_home_page_list_items_on_home_page_list_id_and_ordering"
    t.index ["home_page_list_id"], name: "index_home_page_list_items_on_home_page_list_id"
    t.index ["item_id", "item_type"], name: "index_home_page_list_items_on_item_id_and_item_type"
  end

  create_table "home_page_lists", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "owner_id", null: false
    t.string "owner_type", null: false
    t.string "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["owner_id", "owner_type", "name"], name: "index_home_page_lists_on_owner_id_and_owner_type_and_name", unique: true
  end

  create_table "image_data", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.string "carrierwave_image"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "images", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "image_data_id"
    t.integer "edition_id"
    t.string "alt_text"
    t.text "caption"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["edition_id"], name: "index_images_on_edition_id"
    t.index ["image_data_id"], name: "index_images_on_image_data_id"
  end

  create_table "link_checker_api_report_links", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "link_checker_api_report_id"
    t.text "uri", null: false
    t.string "status", null: false
    t.datetime "checked"
    t.text "check_warnings"
    t.text "check_errors"
    t.integer "ordering", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.text "problem_summary"
    t.text "suggested_fix"
    t.index ["link_checker_api_report_id"], name: "index_link_checker_api_report_id"
  end

  create_table "link_checker_api_reports", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "batch_id"
    t.string "status", null: false
    t.string "link_reportable_type"
    t.integer "link_reportable_id"
    t.datetime "completed_at"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["batch_id"], name: "index_link_checker_api_reports_on_batch_id", unique: true
    t.index ["link_reportable_type", "link_reportable_id"], name: "index_link_checker_api_reportable"
  end

  create_table "nation_inapplicabilities", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "nation_id"
    t.integer "edition_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "alternative_url"
    t.index ["edition_id"], name: "index_nation_inapplicabilities_on_edition_id"
    t.index ["nation_id"], name: "index_nation_inapplicabilities_on_nation_id"
  end

  create_table "offsite_links", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "title"
    t.string "summary"
    t.string "url"
    t.string "link_type"
    t.integer "parent_id"
    t.string "parent_type"
    t.datetime "date"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "operational_fields", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.text "description"
    t.string "slug"
    t.string "content_id"
    t.index ["name"], name: "index_operational_fields_on_name", unique: true
    t.index ["slug"], name: "index_operational_fields_on_slug"
  end

  create_table "organisation_classifications", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "organisation_id", null: false
    t.integer "classification_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "ordering"
    t.boolean "lead", default: false, null: false
    t.integer "lead_ordering"
    t.index ["classification_id"], name: "index_org_classifications_on_classification_id"
    t.index ["organisation_id", "ordering"], name: "index_org_classifications_on_organisation_id_and_ordering", unique: true
    t.index ["organisation_id"], name: "index_org_classifications_on_organisation_id"
  end

  create_table "organisation_roles", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "organisation_id"
    t.integer "role_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "ordering"
    t.index ["organisation_id"], name: "index_organisation_roles_on_organisation_id"
    t.index ["role_id"], name: "index_organisation_roles_on_role_id"
  end

  create_table "organisation_supersedings", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "superseded_organisation_id"
    t.integer "superseding_organisation_id"
    t.index ["superseded_organisation_id"], name: "index_organisation_supersedings_on_superseded_organisation_id"
  end

  create_table "organisation_translations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "organisation_id"
    t.string "locale"
    t.string "name"
    t.text "logo_formatted_name"
    t.string "acronym"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["locale"], name: "index_organisation_translations_on_locale"
    t.index ["name"], name: "index_organisation_translations_on_name"
    t.index ["organisation_id"], name: "index_organisation_translations_on_organisation_id"
  end

  create_table "organisational_relationships", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "parent_organisation_id"
    t.integer "child_organisation_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["child_organisation_id"], name: "index_organisational_relationships_on_child_organisation_id"
    t.index ["parent_organisation_id"], name: "index_organisational_relationships_on_parent_organisation_id"
  end

  create_table "organisations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "slug", null: false
    t.string "url"
    t.string "alternative_format_contact_email"
    t.string "govuk_status", default: "live", null: false
    t.integer "organisation_logo_type_id", default: 2
    t.string "analytics_identifier"
    t.boolean "handles_fatalities", default: false
    t.integer "important_board_members", default: 1
    t.integer "default_news_organisation_image_data_id"
    t.datetime "closed_at"
    t.integer "organisation_brand_colour_id"
    t.boolean "ocpa_regulated"
    t.boolean "public_meetings"
    t.boolean "public_minutes"
    t.boolean "register_of_interests"
    t.boolean "regulatory_function"
    t.string "logo"
    t.string "organisation_type_key"
    t.boolean "foi_exempt", default: false, null: false
    t.string "organisation_chart_url"
    t.string "govuk_closed_status"
    t.string "custom_jobs_url"
    t.string "content_id"
    t.string "homepage_type", default: "news"
    t.boolean "political", default: false
    t.integer "ministerial_ordering"
    t.index ["content_id"], name: "index_organisations_on_content_id", unique: true
    t.index ["default_news_organisation_image_data_id"], name: "index_organisations_on_default_news_organisation_image_data_id"
    t.index ["organisation_logo_type_id"], name: "index_organisations_on_organisation_logo_type_id"
    t.index ["organisation_type_key"], name: "index_organisations_on_organisation_type_key"
    t.index ["slug"], name: "index_organisations_on_slug", unique: true
  end

  create_table "people", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.string "title"
    t.string "forename"
    t.string "surname"
    t.string "letters"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "carrierwave_image"
    t.string "slug"
    t.boolean "privy_counsellor", default: false
    t.string "content_id"
    t.index ["slug"], name: "index_people_on_slug", unique: true
  end

  create_table "person_translations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "person_id"
    t.string "locale"
    t.text "biography"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["locale"], name: "index_person_translations_on_locale"
    t.index ["person_id"], name: "index_person_translations_on_person_id"
  end

  create_table "policy_groups", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.string "email"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "name"
    t.text "description"
    t.text "summary"
    t.string "slug"
    t.string "content_id", null: false
    t.index ["slug"], name: "index_policy_groups_on_slug"
  end

  create_table "promotional_feature_items", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "promotional_feature_id"
    t.text "summary"
    t.string "image"
    t.string "image_alt_text"
    t.string "title"
    t.string "title_url"
    t.boolean "double_width", default: false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["promotional_feature_id"], name: "index_promotional_feature_items_on_promotional_feature_id"
  end

  create_table "promotional_feature_links", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "promotional_feature_item_id"
    t.string "url"
    t.string "text"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["promotional_feature_item_id"], name: "index_promotional_feature_links_on_promotional_feature_item_id"
  end

  create_table "promotional_features", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "organisation_id"
    t.string "title"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["organisation_id"], name: "index_promotional_features_on_organisation_id"
  end

  create_table "recent_edition_openings", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "edition_id", null: false
    t.integer "editor_id", null: false
    t.datetime "created_at", null: false
    t.index ["edition_id", "editor_id"], name: "index_recent_edition_openings_on_edition_id_and_editor_id", unique: true
  end

  create_table "related_mainstreams", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "edition_id"
    t.string "content_id"
    t.boolean "additional", default: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["content_id"], name: "index_related_mainstreams_on_content_id", unique: true
    t.index ["edition_id"], name: "index_related_mainstreams_on_edition_id"
  end

  create_table "responses", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "edition_id"
    t.text "summary"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.date "published_on"
    t.string "type"
    t.index ["edition_id", "type"], name: "index_responses_on_edition_id_and_type"
    t.index ["edition_id"], name: "index_responses_on_edition_id"
  end

  create_table "role_appointments", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "role_id"
    t.integer "person_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "started_at"
    t.datetime "ended_at"
    t.string "content_id"
    t.index ["ended_at"], name: "index_role_appointments_on_ended_at"
    t.index ["person_id"], name: "index_role_appointments_on_person_id"
    t.index ["role_id"], name: "index_role_appointments_on_role_id"
  end

  create_table "role_translations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "role_id"
    t.string "locale"
    t.string "name"
    t.text "responsibilities"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["locale"], name: "index_role_translations_on_locale"
    t.index ["name"], name: "index_role_translations_on_name"
    t.index ["role_id"], name: "index_role_translations_on_role_id"
  end

  create_table "roles", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "type", null: false
    t.boolean "permanent_secretary", default: false
    t.boolean "cabinet_member", default: false, null: false
    t.string "slug"
    t.boolean "chief_of_the_defence_staff", default: false, null: false
    t.integer "whip_organisation_id"
    t.integer "seniority", default: 100
    t.integer "attends_cabinet_type_id"
    t.integer "role_payment_type_id"
    t.boolean "supports_historical_accounts", default: false, null: false
    t.integer "whip_ordering", default: 100
    t.string "content_id"
    t.index ["attends_cabinet_type_id"], name: "index_roles_on_attends_cabinet_type_id"
    t.index ["slug"], name: "index_roles_on_slug"
    t.index ["supports_historical_accounts"], name: "index_roles_on_supports_historical_accounts"
  end

  create_table "sitewide_settings", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "key"
    t.text "description"
    t.boolean "on"
    t.text "govspeak"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "social_media_accounts", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "socialable_id"
    t.integer "social_media_service_id"
    t.string "url"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "socialable_type"
    t.string "title"
    t.index ["social_media_service_id"], name: "index_social_media_accounts_on_social_media_service_id"
    t.index ["socialable_id"], name: "index_social_media_accounts_on_organisation_id"
  end

  create_table "social_media_services", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.string "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["name"], name: "index_social_media_services_on_name", unique: true
  end

  create_table "specialist_sectors", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "edition_id", null: false
    t.string "tag"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.boolean "primary", default: false
    t.string "topic_content_id"
    t.index ["edition_id", "tag"], name: "index_specialist_sectors_on_edition_id_and_tag", unique: true
    t.index ["topic_content_id"], name: "index_specialist_sectors_on_topic_content_id", unique: true
  end

  create_table "sponsorships", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "organisation_id"
    t.integer "worldwide_organisation_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["organisation_id", "worldwide_organisation_id"], name: "unique_sponsorships", unique: true
    t.index ["worldwide_organisation_id"], name: "index_sponsorships_on_worldwide_organisation_id"
  end

  create_table "statistics_announcement_dates", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "statistics_announcement_id"
    t.datetime "release_date"
    t.integer "precision"
    t.boolean "confirmed"
    t.text "change_note"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.integer "creator_id"
    t.index ["creator_id"], name: "index_statistics_announcement_dates_on_creator_id"
    t.index ["statistics_announcement_id", "created_at"], name: "statistics_announcement_release_date"
  end

  create_table "statistics_announcement_organisations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "statistics_announcement_id"
    t.integer "organisation_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["organisation_id"], name: "index_statistics_announcement_organisations_on_organisation_id"
    t.index ["statistics_announcement_id", "organisation_id"], name: "index_on_statistics_announcement_id_and_organisation_id"
  end

  create_table "statistics_announcement_topics", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "statistics_announcement_id"
    t.integer "topic_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.index ["statistics_announcement_id"], name: "index_statistics_announcement_topics_on_statistics_announcement"
    t.index ["topic_id"], name: "index_statistics_announcement_topics_on_topic_id"
  end

  create_table "statistics_announcements", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "title"
    t.string "slug"
    t.text "summary"
    t.integer "publication_type_id"
    t.integer "topic_id"
    t.integer "creator_id"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.integer "publication_id"
    t.text "cancellation_reason"
    t.datetime "cancelled_at"
    t.integer "cancelled_by_id"
    t.string "publishing_state", default: "published", null: false
    t.string "redirect_url"
    t.string "content_id", null: false
    t.index ["cancelled_by_id"], name: "index_statistics_announcements_on_cancelled_by_id"
    t.index ["creator_id"], name: "index_statistics_announcements_on_creator_id"
    t.index ["publication_id"], name: "index_statistics_announcements_on_publication_id"
    t.index ["slug"], name: "index_statistics_announcements_on_slug"
    t.index ["title"], name: "index_statistics_announcements_on_title"
    t.index ["topic_id"], name: "index_statistics_announcements_on_topic_id"
  end

  create_table "take_part_pages", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.string "title", null: false
    t.string "slug", null: false
    t.string "summary", null: false
    t.text "body", limit: 16777215, null: false
    t.string "carrierwave_image"
    t.string "image_alt_text"
    t.integer "ordering", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "content_id"
    t.index ["ordering"], name: "index_take_part_pages_on_ordering"
    t.index ["slug"], name: "index_take_part_pages_on_slug", unique: true
  end

  create_table "unpublishings", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "edition_id"
    t.integer "unpublishing_reason_id"
    t.text "explanation"
    t.text "alternative_url"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "document_type"
    t.string "slug"
    t.boolean "redirect", default: false
    t.string "content_id", null: false
    t.index ["edition_id"], name: "index_unpublishings_on_edition_id"
    t.index ["unpublishing_reason_id"], name: "index_unpublishings_on_unpublishing_reason_id"
  end

  create_table "user_world_locations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "user_id"
    t.integer "world_location_id"
    t.index ["user_id", "world_location_id"], name: "index_user_world_locations_on_user_id_and_world_location_id", unique: true
  end

  create_table "users", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.string "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "email"
    t.string "uid"
    t.integer "version"
    t.text "permissions"
    t.boolean "remotely_signed_out", default: false
    t.string "organisation_slug"
    t.boolean "disabled", default: false
    t.index ["disabled"], name: "index_users_on_disabled"
    t.index ["organisation_slug"], name: "index_users_on_organisation_slug"
  end

  create_table "versions", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.string "item_type", null: false
    t.integer "item_id", null: false
    t.string "event", null: false
    t.string "whodunnit"
    t.text "object"
    t.datetime "created_at"
    t.text "state"
    t.index ["item_type", "item_id"], name: "index_versions_on_item_type_and_item_id"
  end

  create_table "world_location_translations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "world_location_id"
    t.string "locale"
    t.string "name"
    t.text "mission_statement"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "title"
    t.index ["locale"], name: "index_world_location_translations_on_locale"
    t.index ["world_location_id"], name: "index_world_location_translations_on_world_location_id"
  end

  create_table "world_locations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string "slug"
    t.boolean "active", default: false, null: false
    t.integer "world_location_type_id", null: false
    t.string "iso2", limit: 2
    t.string "analytics_identifier"
    t.string "content_id"
    t.string "news_page_content_id"
    t.index ["iso2"], name: "index_world_locations_on_iso2", unique: true
    t.index ["slug"], name: "index_world_locations_on_slug"
    t.index ["world_location_type_id"], name: "index_world_locations_on_world_location_type_id"
  end

  create_table "worldwide_office_worldwide_services", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "worldwide_office_id", null: false
    t.integer "worldwide_service_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "worldwide_offices", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "worldwide_organisation_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "worldwide_office_type_id", null: false
    t.string "slug"
    t.index ["slug"], name: "index_worldwide_offices_on_slug"
    t.index ["worldwide_organisation_id"], name: "index_worldwide_offices_on_worldwide_organisation_id"
  end

  create_table "worldwide_organisation_roles", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "worldwide_organisation_id"
    t.integer "role_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["role_id"], name: "index_worldwide_org_roles_on_role_id"
    t.index ["worldwide_organisation_id"], name: "index_worldwide_org_roles_on_worldwide_organisation_id"
  end

  create_table "worldwide_organisation_translations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" do |t|
    t.integer "worldwide_organisation_id"
    t.string "locale"
    t.string "name"
    t.text "services"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["locale"], name: "index_worldwide_org_translations_on_locale"
    t.index ["worldwide_organisation_id"], name: "index_worldwide_org_translations_on_worldwide_organisation_id"
  end

  create_table "worldwide_organisation_world_locations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.integer "worldwide_organisation_id"
    t.integer "world_location_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.index ["world_location_id"], name: "index_worldwide_org_world_locations_on_world_location_id"
    t.index ["worldwide_organisation_id"], name: "index_worldwide_org_world_locations_on_worldwide_organisation_id"
  end

  create_table "worldwide_organisations", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "url"
    t.string "slug"
    t.string "logo_formatted_name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer "main_office_id"
    t.integer "default_news_organisation_image_data_id"
    t.string "analytics_identifier"
    t.string "content_id"
    t.index ["default_news_organisation_image_data_id"], name: "index_worldwide_organisations_on_image_data_id"
    t.index ["slug"], name: "index_worldwide_organisations_on_slug", unique: true
  end

  create_table "worldwide_services", id: :integer, force: :cascade, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" do |t|
    t.string "name", default: "", null: false
    t.integer "service_type_id", null: false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_foreign_key "link_checker_api_report_links", "link_checker_api_reports"
  add_foreign_key "related_mainstreams", "editions"
end