db/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: 2019_10_24_100711) do
# These are extensions that must be enabled in order to support this database
enable_extension "ltree"
enable_extension "pg_trgm"
enable_extension "plpgsql"
create_table "decidim_accountability_results", id: :serial, force: :cascade do |t|
t.jsonb "title"
t.jsonb "description"
t.string "reference"
t.date "start_date"
t.date "end_date"
t.decimal "progress", precision: 5, scale: 2
t.integer "parent_id"
t.integer "decidim_accountability_status_id"
t.integer "decidim_component_id"
t.integer "decidim_scope_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "children_count", default: 0
t.float "weight", default: 1.0
t.string "external_id"
t.index ["decidim_accountability_status_id"], name: "decidim_accountability_results_on_status_id"
t.index ["decidim_component_id"], name: "index_decidim_accountability_results_on_decidim_component_id"
t.index ["decidim_scope_id"], name: "index_decidim_accountability_results_on_decidim_scope_id"
t.index ["parent_id"], name: "decidim_accountability_results_on_parent_id"
end
create_table "decidim_accountability_statuses", id: :serial, force: :cascade do |t|
t.string "key"
t.jsonb "name"
t.integer "decidim_component_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "description"
t.integer "progress"
t.index ["decidim_component_id"], name: "index_decidim_accountability_statuses_on_decidim_component_id"
end
create_table "decidim_accountability_timeline_entries", id: :serial, force: :cascade do |t|
t.date "entry_date"
t.jsonb "description"
t.integer "decidim_accountability_result_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_accountability_result_id"], name: "index_decidim_accountability_timeline_entries_on_results_id"
t.index ["entry_date"], name: "index_decidim_accountability_timeline_entries_on_entry_date"
end
create_table "decidim_action_logs", force: :cascade do |t|
t.bigint "decidim_organization_id", null: false
t.bigint "decidim_user_id", null: false
t.bigint "decidim_component_id"
t.string "resource_type", null: false
t.bigint "resource_id", null: false
t.string "participatory_space_type"
t.bigint "participatory_space_id"
t.string "action", null: false
t.jsonb "extra"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "version_id"
t.string "visibility", default: "admin-only"
t.integer "decidim_scope_id"
t.integer "decidim_area_id"
t.index ["created_at"], name: "index_decidim_action_logs_on_created_at"
t.index ["decidim_component_id"], name: "index_action_logs_on_component_id"
t.index ["decidim_organization_id"], name: "index_action_logs_on_organization_id"
t.index ["decidim_user_id"], name: "index_action_logs_on_user_id"
t.index ["participatory_space_type", "participatory_space_id"], name: "index_action_logs_on_space_type_and_id"
t.index ["resource_type", "resource_id"], name: "index_action_logs_on_resource_type_and_id"
t.index ["visibility"], name: "index_decidim_action_logs_on_visibility"
end
create_table "decidim_amendments", force: :cascade do |t|
t.bigint "decidim_user_id", null: false
t.string "decidim_amendable_type"
t.bigint "decidim_amendable_id"
t.string "decidim_emendation_type"
t.bigint "decidim_emendation_id"
t.string "state"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_amendable_id", "decidim_amendable_type"], name: "index_on_amendable"
t.index ["decidim_user_id", "decidim_amendable_id", "decidim_amendable_type"], name: "index_on_amender_and_amendable"
t.index ["decidim_user_id"], name: "index_decidim_amendments_on_decidim_user_id"
t.index ["state"], name: "index_decidim_amendments_on_state"
end
create_table "decidim_area_types", force: :cascade do |t|
t.bigint "decidim_organization_id"
t.jsonb "name", null: false
t.jsonb "plural", null: false
t.index ["decidim_organization_id"], name: "index_decidim_area_types_on_decidim_organization_id"
end
create_table "decidim_areas", force: :cascade do |t|
t.jsonb "name"
t.bigint "area_type_id"
t.bigint "decidim_organization_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["area_type_id"], name: "index_decidim_areas_on_area_type_id"
t.index ["decidim_organization_id"], name: "index_decidim_areas_on_decidim_organization_id"
end
create_table "decidim_assemblies", id: :serial, force: :cascade do |t|
t.string "slug", null: false
t.string "hashtag"
t.integer "decidim_organization_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "title", null: false
t.jsonb "subtitle", null: false
t.jsonb "short_description", null: false
t.jsonb "description", null: false
t.string "hero_image"
t.string "banner_image"
t.boolean "promoted", default: false
t.datetime "published_at"
t.jsonb "developer_group"
t.jsonb "meta_scope"
t.jsonb "local_area"
t.jsonb "target"
t.jsonb "participatory_scope"
t.jsonb "participatory_structure"
t.boolean "show_statistics", default: false
t.integer "decidim_scope_id"
t.boolean "scopes_enabled", default: true, null: false
t.boolean "private_space", default: false
t.string "reference"
t.bigint "decidim_area_id"
t.bigint "parent_id"
t.ltree "parents_path"
t.integer "children_count", default: 0
t.jsonb "purpose_of_action"
t.jsonb "composition"
t.string "assembly_type"
t.jsonb "assembly_type_other"
t.date "creation_date"
t.string "created_by"
t.jsonb "created_by_other"
t.date "duration"
t.date "included_at"
t.date "closing_date"
t.jsonb "closing_date_reason"
t.jsonb "internal_organisation"
t.boolean "is_transparent", default: true
t.jsonb "special_features"
t.string "twitter_handler"
t.string "instagram_handler"
t.string "facebook_handler"
t.string "youtube_handler"
t.string "github_handler"
t.index ["decidim_area_id"], name: "index_decidim_assemblies_on_decidim_area_id"
t.index ["decidim_organization_id", "slug"], name: "index_unique_assembly_slug_and_organization", unique: true
t.index ["decidim_organization_id"], name: "index_decidim_assemblies_on_decidim_organization_id"
t.index ["parent_id"], name: "decidim_assemblies_assemblies_on_parent_id"
end
create_table "decidim_assembly_members", force: :cascade do |t|
t.bigint "decidim_assembly_id"
t.integer "weight", default: 0, null: false
t.string "full_name"
t.string "gender"
t.date "birthday"
t.string "birthplace"
t.date "designation_date"
t.string "designation_mode"
t.string "position"
t.string "position_other"
t.date "ceased_date"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.bigint "decidim_user_id"
t.index ["decidim_assembly_id"], name: "index_decidim_assembly_members_on_decidim_assembly_id"
t.index ["decidim_user_id"], name: "index_decidim_assembly_members_on_decidim_user_id"
t.index ["weight", "created_at"], name: "index_decidim_assembly_members_on_weight_and_created_at"
end
create_table "decidim_assembly_user_roles", force: :cascade do |t|
t.integer "decidim_user_id"
t.integer "decidim_assembly_id"
t.string "role"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_assembly_id", "decidim_user_id", "role"], name: "index_unique_user_and_assembly_role", unique: true
end
create_table "decidim_attachment_collections", force: :cascade do |t|
t.jsonb "name", null: false
t.jsonb "description", null: false
t.integer "weight", default: 0, null: false
t.string "collection_for_type", null: false
t.bigint "collection_for_id", null: false
t.index ["collection_for_type", "collection_for_id"], name: "decidim_attachment_collections_collection_for_id_and_type"
end
create_table "decidim_attachments", id: :serial, force: :cascade do |t|
t.jsonb "title", null: false
t.jsonb "description"
t.string "file", null: false
t.string "content_type", null: false
t.string "file_size", null: false
t.integer "attached_to_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "attached_to_type", null: false
t.integer "weight", default: 0, null: false
t.integer "attachment_collection_id"
t.index ["attached_to_id", "attached_to_type"], name: "index_decidim_attachments_on_attached_to"
end
create_table "decidim_authorizations", id: :serial, force: :cascade do |t|
t.string "name", null: false
t.jsonb "metadata"
t.integer "decidim_user_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "unique_id"
t.datetime "granted_at"
t.jsonb "verification_metadata", default: {}
t.string "verification_attachment"
t.index ["decidim_user_id", "name"], name: "index_decidim_authorizations_on_decidim_user_id_and_name", unique: true
t.index ["decidim_user_id"], name: "index_decidim_authorizations_on_decidim_user_id"
end
create_table "decidim_blogs_posts", id: :serial, force: :cascade do |t|
t.jsonb "title"
t.jsonb "body"
t.integer "decidim_component_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "decidim_author_id", null: false
t.string "decidim_author_type", null: false
t.index ["decidim_author_id", "decidim_author_type"], name: "index_decidim_blogs_posts_on_decidim_author"
t.index ["decidim_component_id"], name: "index_decidim_blogs_posts_on_decidim_component_id"
end
create_table "decidim_budgets_line_items", id: :serial, force: :cascade do |t|
t.integer "decidim_order_id"
t.integer "decidim_project_id"
t.index ["decidim_order_id", "decidim_project_id"], name: "decidim_budgets_line_items_order_project_unique", unique: true
t.index ["decidim_order_id"], name: "index_decidim_budgets_line_items_on_decidim_order_id"
t.index ["decidim_project_id"], name: "index_decidim_budgets_line_items_on_decidim_project_id"
end
create_table "decidim_budgets_orders", id: :serial, force: :cascade do |t|
t.integer "decidim_user_id"
t.integer "decidim_component_id"
t.datetime "checked_out_at"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_component_id"], name: "index_decidim_budgets_orders_on_decidim_component_id"
t.index ["decidim_user_id", "decidim_component_id"], name: "decidim_budgets_order_user_component_unique", unique: true
t.index ["decidim_user_id"], name: "index_decidim_budgets_orders_on_decidim_user_id"
end
create_table "decidim_budgets_projects", id: :serial, force: :cascade do |t|
t.jsonb "title"
t.jsonb "description"
t.bigint "budget", null: false
t.integer "decidim_component_id"
t.integer "decidim_scope_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "reference"
t.index ["decidim_component_id"], name: "index_decidim_budgets_projects_on_decidim_component_id"
t.index ["decidim_scope_id"], name: "index_decidim_budgets_projects_on_decidim_scope_id"
end
create_table "decidim_categories", id: :serial, force: :cascade do |t|
t.jsonb "name", null: false
t.jsonb "description", null: false
t.integer "parent_id"
t.integer "decidim_participatory_space_id"
t.string "decidim_participatory_space_type"
t.index ["decidim_participatory_space_id", "decidim_participatory_space_type"], name: "index_decidim_categories_on_decidim_participatory_space"
t.index ["parent_id"], name: "index_decidim_categories_on_parent_id"
end
create_table "decidim_categorizations", force: :cascade do |t|
t.bigint "decidim_category_id", null: false
t.string "categorizable_type", null: false
t.bigint "categorizable_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["categorizable_type", "categorizable_id"], name: "decidim_categorizations_categorizable_id_and_type"
t.index ["decidim_category_id"], name: "index_decidim_categorizations_on_decidim_category_id"
end
create_table "decidim_coauthorships", force: :cascade do |t|
t.bigint "decidim_author_id", null: false
t.bigint "decidim_user_group_id"
t.string "coauthorable_type"
t.bigint "coauthorable_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "decidim_author_type", null: false
t.index ["coauthorable_type", "coauthorable_id"], name: "index_coauthorable_on_coauthorship"
t.index ["decidim_author_id", "decidim_author_type"], name: "index_decidim_coauthorships_on_decidim_author"
t.index ["decidim_user_group_id"], name: "index_user_group_on_coauthorsihp"
end
create_table "decidim_comments_comment_votes", id: :serial, force: :cascade do |t|
t.integer "weight", null: false
t.integer "decidim_comment_id", null: false
t.integer "decidim_author_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "decidim_author_type", null: false
t.index ["decidim_author_id", "decidim_author_type"], name: "index_decidim_comments_comment_votes_on_decidim_author"
t.index ["decidim_author_id"], name: "decidim_comments_comment_vote_author"
t.index ["decidim_comment_id", "decidim_author_id"], name: "decidim_comments_comment_vote_comment_author_unique", unique: true
t.index ["decidim_comment_id"], name: "decidim_comments_comment_vote_comment"
end
create_table "decidim_comments_comments", id: :serial, force: :cascade do |t|
t.text "body", null: false
t.string "decidim_commentable_type", null: false
t.integer "decidim_commentable_id", null: false
t.integer "decidim_author_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "depth", default: 0, null: false
t.integer "alignment", default: 0, null: false
t.integer "decidim_user_group_id"
t.string "decidim_root_commentable_type", null: false
t.integer "decidim_root_commentable_id", null: false
t.string "decidim_author_type", null: false
t.index ["created_at"], name: "index_decidim_comments_comments_on_created_at"
t.index ["decidim_author_id", "decidim_author_type"], name: "index_decidim_comments_comments_on_decidim_author"
t.index ["decidim_author_id"], name: "decidim_comments_comment_author"
t.index ["decidim_commentable_type", "decidim_commentable_id"], name: "decidim_comments_comment_commentable"
t.index ["decidim_root_commentable_type", "decidim_root_commentable_id"], name: "decidim_comments_comment_root_commentable"
end
create_table "decidim_components", id: :serial, force: :cascade do |t|
t.string "manifest_name"
t.jsonb "name"
t.integer "participatory_space_id", null: false
t.jsonb "settings", default: {}
t.integer "weight", default: 0
t.jsonb "permissions"
t.datetime "published_at"
t.string "participatory_space_type", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["participatory_space_id", "participatory_space_type"], name: "index_decidim_components_on_decidim_participatory_space"
end
create_table "decidim_content_blocks", force: :cascade do |t|
t.integer "decidim_organization_id", null: false
t.string "manifest_name", null: false
t.string "scope", null: false
t.jsonb "settings"
t.datetime "published_at"
t.integer "weight"
t.jsonb "images", default: {}
t.index ["decidim_organization_id", "scope", "manifest_name"], name: "idx_dcdm_content_blocks_uniq_org_id_scope_manifest_name", unique: true
t.index ["decidim_organization_id"], name: "index_decidim_content_blocks_on_decidim_organization_id"
t.index ["manifest_name"], name: "index_decidim_content_blocks_on_manifest_name"
t.index ["published_at"], name: "index_decidim_content_blocks_on_published_at"
t.index ["scope"], name: "index_decidim_content_blocks_on_scope"
end
create_table "decidim_contextual_help_sections", force: :cascade do |t|
t.string "section_id", null: false
t.bigint "organization_id", null: false
t.jsonb "content", null: false
t.index ["organization_id"], name: "index_decidim_contextual_help_sections_on_organization_id"
end
create_table "decidim_continuity_badge_statuses", force: :cascade do |t|
t.integer "current_streak", default: 0, null: false
t.integer "integer", default: 0, null: false
t.date "last_session_at", null: false
t.string "subject_type", null: false
t.bigint "subject_id", null: false
t.index ["subject_type", "subject_id"], name: "decidim_continuity_statuses_subject"
end
create_table "decidim_crowdfundings_campaigns", force: :cascade do |t|
t.jsonb "title"
t.jsonb "description"
t.integer "default_amount"
t.integer "minimum_custom_amount"
t.integer "target_amount"
t.date "active_until"
t.bigint "decidim_component_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "amounts"
t.jsonb "terms_and_conditions"
t.string "reference"
t.index ["decidim_component_id"], name: "decidim_crowdfundings_component_index"
end
create_table "decidim_crowdfundings_contributions", force: :cascade do |t|
t.bigint "decidim_user_id"
t.bigint "decidim_crowdfundings_campaign_id"
t.decimal "amount", precision: 11, scale: 2, null: false
t.integer "state", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "frequency", default: 0, null: false
t.integer "payment_method_id"
t.date "last_order_request_date"
t.index ["decidim_crowdfundings_campaign_id"], name: "contribution_campaign_idx"
t.index ["decidim_user_id"], name: "contribution_user_idx"
t.index ["state"], name: "index_decidim_crowdfundings_contributions_on_state"
end
create_table "decidim_debates_debates", id: :serial, force: :cascade do |t|
t.jsonb "title"
t.jsonb "description"
t.jsonb "instructions"
t.datetime "start_time"
t.datetime "end_time"
t.string "image"
t.integer "decidim_component_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "information_updates"
t.integer "decidim_author_id", null: false
t.string "reference"
t.integer "decidim_user_group_id"
t.string "decidim_author_type", null: false
t.index ["decidim_author_id", "decidim_author_type"], name: "index_decidim_debates_debates_on_decidim_author"
t.index ["decidim_component_id"], name: "index_decidim_debates_debates_on_decidim_component_id"
end
create_table "decidim_follows", force: :cascade do |t|
t.bigint "decidim_user_id", null: false
t.string "decidim_followable_type"
t.bigint "decidim_followable_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_followable_id", "decidim_followable_type"], name: "index_follows_followable_id_and_type"
t.index ["decidim_user_id", "decidim_followable_id", "decidim_followable_type"], name: "index_uniq_on_follows_user_and_followable", unique: true
t.index ["decidim_user_id"], name: "index_decidim_follows_on_decidim_user_id"
end
create_table "decidim_forms_answer_choices", force: :cascade do |t|
t.bigint "decidim_answer_id"
t.bigint "decidim_answer_option_id"
t.integer "position"
t.jsonb "body"
t.text "custom_body"
t.index ["decidim_answer_id"], name: "index_decidim_forms_answer_choices_answer_id"
t.index ["decidim_answer_option_id"], name: "index_decidim_forms_answer_choices_answer_option_id"
end
create_table "decidim_forms_answer_options", force: :cascade do |t|
t.bigint "decidim_question_id"
t.jsonb "body"
t.boolean "free_text"
t.index ["decidim_question_id"], name: "index_decidim_forms_answer_options_question_id"
end
create_table "decidim_forms_answers", id: :serial, force: :cascade do |t|
t.text "body"
t.integer "decidim_user_id"
t.integer "decidim_questionnaire_id"
t.integer "decidim_question_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_question_id"], name: "index_decidim_forms_answers_question_id"
t.index ["decidim_questionnaire_id"], name: "index_decidim_forms_answers_on_decidim_questionnaire_id"
t.index ["decidim_user_id"], name: "index_decidim_forms_answers_on_decidim_user_id"
end
create_table "decidim_forms_questionnaires", id: :serial, force: :cascade do |t|
t.jsonb "title"
t.jsonb "description"
t.jsonb "tos"
t.string "questionnaire_for_type"
t.integer "questionnaire_for_id"
t.datetime "published_at"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["questionnaire_for_type", "questionnaire_for_id"], name: "index_decidim_forms_questionnaires_questionnaire_for"
end
create_table "decidim_forms_questions", id: :serial, force: :cascade do |t|
t.integer "decidim_questionnaire_id"
t.integer "position"
t.string "question_type"
t.boolean "mandatory"
t.jsonb "body"
t.jsonb "description"
t.integer "max_choices"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_questionnaire_id"], name: "index_decidim_forms_questions_on_decidim_questionnaire_id"
t.index ["position"], name: "index_decidim_forms_questions_on_position"
end
create_table "decidim_gamification_badge_scores", force: :cascade do |t|
t.bigint "user_id", null: false
t.string "badge_name", null: false
t.integer "value", default: 0, null: false
t.index ["user_id"], name: "index_decidim_gamification_badge_scores_on_user_id"
end
create_table "decidim_gravity_forms_gravity_forms", force: :cascade do |t|
t.jsonb "title", null: false
t.jsonb "description"
t.integer "form_number", null: false
t.string "slug", null: false
t.boolean "require_login", default: true, null: false
t.bigint "decidim_component_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.boolean "hidden", default: false, null: false
t.index ["decidim_component_id", "slug"], name: "decidim_gravity_forms_gravity_forms_component_slug_unique", unique: true
t.index ["decidim_component_id"], name: "index_decidim_gravity_forms_on_decidim_component_id"
end
create_table "decidim_hashtags", force: :cascade do |t|
t.bigint "decidim_organization_id"
t.string "name"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_organization_id"], name: "index_decidim_hashtags_on_decidim_organization_id"
t.index ["name"], name: "index_decidim_hashtags_on_name"
end
create_table "decidim_identities", id: :serial, force: :cascade do |t|
t.string "provider", null: false
t.string "uid", null: false
t.integer "decidim_user_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "decidim_organization_id"
t.index ["decidim_organization_id"], name: "index_decidim_identities_on_decidim_organization_id"
t.index ["decidim_user_id"], name: "index_decidim_identities_on_decidim_user_id"
t.index ["provider", "uid", "decidim_organization_id"], name: "decidim_identities_provider_uid_organization_unique", unique: true
end
create_table "decidim_impersonation_logs", force: :cascade do |t|
t.bigint "decidim_admin_id"
t.bigint "decidim_user_id"
t.datetime "started_at"
t.datetime "ended_at"
t.datetime "expired_at"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.text "reason"
t.index ["decidim_admin_id"], name: "index_decidim_impersonation_logs_on_decidim_admin_id"
t.index ["decidim_user_id"], name: "index_decidim_impersonation_logs_on_decidim_user_id"
end
create_table "decidim_meetings_agenda_items", force: :cascade do |t|
t.bigint "decidim_agenda_id"
t.integer "position"
t.bigint "parent_id"
t.integer "duration"
t.jsonb "title"
t.jsonb "description"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_agenda_id"], name: "index_decidim_meetings_agenda_items_on_decidim_agenda_id"
t.index ["parent_id"], name: "index_decidim_meetings_agenda_items_on_parent_id"
end
create_table "decidim_meetings_agendas", force: :cascade do |t|
t.jsonb "title"
t.bigint "decidim_meeting_id", null: false
t.boolean "visible"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_meeting_id"], name: "index_decidim_meetings_agendas_on_decidim_meeting_id"
end
create_table "decidim_meetings_invites", force: :cascade do |t|
t.bigint "decidim_user_id", null: false
t.bigint "decidim_meeting_id", null: false
t.datetime "sent_at"
t.datetime "accepted_at"
t.datetime "rejected_at"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_meeting_id"], name: "index_decidim_meetings_invites_on_decidim_meeting_id"
t.index ["decidim_user_id"], name: "index_decidim_meetings_invites_on_decidim_user_id"
end
create_table "decidim_meetings_meetings", id: :serial, force: :cascade do |t|
t.jsonb "title"
t.jsonb "description"
t.datetime "start_time"
t.datetime "end_time"
t.text "address"
t.jsonb "location"
t.jsonb "location_hints"
t.integer "decidim_component_id"
t.integer "decidim_author_id"
t.integer "decidim_scope_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "closing_report"
t.integer "attendees_count"
t.integer "contributions_count"
t.text "attending_organizations"
t.time "closed_at"
t.float "latitude"
t.float "longitude"
t.string "reference"
t.boolean "registrations_enabled", default: false, null: false
t.integer "available_slots", default: 0, null: false
t.jsonb "registration_terms"
t.integer "reserved_slots", default: 0, null: false
t.jsonb "services", default: []
t.boolean "private_meeting", default: false
t.boolean "transparent", default: true
t.bigint "organizer_id"
t.boolean "registration_form_enabled", default: false
t.index ["decidim_author_id"], name: "index_decidim_meetings_meetings_on_decidim_author_id"
t.index ["decidim_component_id"], name: "index_decidim_meetings_meetings_on_decidim_component_id"
t.index ["decidim_scope_id"], name: "index_decidim_meetings_meetings_on_decidim_scope_id"
t.index ["organizer_id"], name: "index_decidim_meetings_meetings_on_organizer_id"
end
create_table "decidim_meetings_minutes", force: :cascade do |t|
t.bigint "decidim_meeting_id"
t.jsonb "description"
t.string "video_url"
t.string "audio_url"
t.boolean "visible"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_meeting_id"], name: "index_decidim_meetings_minutes_on_decidim_meeting_id"
end
create_table "decidim_meetings_registrations", force: :cascade do |t|
t.bigint "decidim_user_id", null: false
t.bigint "decidim_meeting_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "code"
t.datetime "validated_at"
t.bigint "decidim_user_group_id"
t.index ["decidim_meeting_id"], name: "index_decidim_meetings_registrations_on_decidim_meeting_id"
t.index ["decidim_user_id", "decidim_meeting_id"], name: "decidim_meetings_registrations_user_meeting_unique", unique: true
t.index ["decidim_user_id"], name: "index_decidim_meetings_registrations_on_decidim_user_id"
end
create_table "decidim_messaging_conversations", force: :cascade do |t|
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
end
create_table "decidim_messaging_messages", force: :cascade do |t|
t.bigint "decidim_conversation_id", null: false
t.bigint "decidim_sender_id", null: false
t.text "body", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_conversation_id"], name: "index_decidim_messaging_messages_on_decidim_conversation_id"
t.index ["decidim_sender_id"], name: "index_decidim_messaging_messages_on_decidim_sender_id"
end
create_table "decidim_messaging_participations", force: :cascade do |t|
t.bigint "decidim_conversation_id", null: false
t.bigint "decidim_participant_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_conversation_id"], name: "index_conversation_participations_on_conversation_id"
t.index ["decidim_participant_id"], name: "index_conversation_participations_on_participant_id"
end
create_table "decidim_messaging_receipts", force: :cascade do |t|
t.bigint "decidim_message_id", null: false
t.bigint "decidim_recipient_id", null: false
t.datetime "read_at"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_message_id"], name: "index_decidim_messaging_receipts_on_decidim_message_id"
t.index ["decidim_recipient_id"], name: "index_decidim_messaging_receipts_on_decidim_recipient_id"
end
create_table "decidim_metrics", force: :cascade do |t|
t.date "day", null: false
t.string "metric_type", null: false
t.integer "cumulative", null: false
t.integer "quantity", null: false
t.bigint "decidim_organization_id", null: false
t.string "participatory_space_type"
t.bigint "participatory_space_id"
t.string "related_object_type"
t.bigint "related_object_id"
t.bigint "decidim_category_id"
t.index ["day", "metric_type", "decidim_organization_id", "participatory_space_type", "participatory_space_id", "related_object_type", "related_object_id", "decidim_category_id"], name: "idx_metric_by_day_type_org_space_object_category", unique: true
t.index ["day"], name: "index_decidim_metrics_on_day"
t.index ["decidim_category_id"], name: "index_decidim_metrics_on_decidim_category_id"
t.index ["decidim_organization_id"], name: "index_decidim_metrics_on_decidim_organization_id"
t.index ["metric_type"], name: "index_decidim_metrics_on_metric_type"
t.index ["participatory_space_type", "participatory_space_id"], name: "index_metric_on_participatory_space_id_and_type"
t.index ["related_object_type", "related_object_id"], name: "index_metric_on_related_object_id_and_type"
end
create_table "decidim_moderations", id: :serial, force: :cascade do |t|
t.integer "decidim_participatory_space_id", null: false
t.string "decidim_reportable_type", null: false
t.integer "decidim_reportable_id", null: false
t.integer "report_count", default: 0, null: false
t.datetime "hidden_at"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "decidim_participatory_space_type", null: false
t.index ["decidim_participatory_space_id", "decidim_participatory_space_type"], name: "decidim_moderations_participatory_space"
t.index ["decidim_reportable_type", "decidim_reportable_id"], name: "decidim_moderations_reportable", unique: true
t.index ["hidden_at"], name: "decidim_moderations_hidden_at"
t.index ["report_count"], name: "decidim_moderations_report_count"
end
create_table "decidim_newsletters", id: :serial, force: :cascade do |t|
t.jsonb "subject"
t.jsonb "body"
t.integer "organization_id"
t.integer "author_id"
t.integer "total_recipients"
t.integer "total_deliveries"
t.datetime "sent_at"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "extended_data", default: {}
t.index ["author_id"], name: "index_decidim_newsletters_on_author_id"
t.index ["organization_id"], name: "index_decidim_newsletters_on_organization_id"
end
create_table "decidim_notifications", force: :cascade do |t|
t.bigint "decidim_user_id", null: false
t.string "decidim_resource_type", null: false
t.bigint "decidim_resource_id", null: false
t.string "event_name", null: false
t.string "event_class", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "extra"
t.index ["decidim_user_id"], name: "index_decidim_notifications_on_decidim_user_id"
end
create_table "decidim_organizations", id: :serial, force: :cascade do |t|
t.string "name", null: false
t.string "host", null: false
t.string "default_locale", null: false
t.string "available_locales", default: [], array: true
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "description"
t.string "logo"
t.string "twitter_handler"
t.boolean "show_statistics", default: true
t.string "favicon"
t.string "instagram_handler"
t.string "facebook_handler"
t.string "youtube_handler"
t.string "github_handler"
t.string "official_img_header"
t.string "official_img_footer"
t.string "official_url"
t.string "reference_prefix", null: false
t.string "secondary_hosts", default: [], array: true
t.string "available_authorizations", default: [], array: true
t.text "header_snippets"
t.jsonb "cta_button_text"
t.string "cta_button_path"
t.boolean "enable_omnipresent_banner", default: false, null: false
t.jsonb "omnipresent_banner_title"
t.jsonb "omnipresent_banner_short_description"
t.string "omnipresent_banner_url"
t.boolean "highlighted_content_banner_enabled", default: false, null: false
t.jsonb "highlighted_content_banner_title"
t.jsonb "highlighted_content_banner_short_description"
t.jsonb "highlighted_content_banner_action_title"
t.jsonb "highlighted_content_banner_action_subtitle"
t.string "highlighted_content_banner_action_url"
t.string "highlighted_content_banner_image"
t.datetime "tos_version"
t.boolean "badges_enabled", default: false, null: false
t.boolean "send_welcome_notification", default: false, null: false
t.jsonb "welcome_notification_subject"
t.jsonb "welcome_notification_body"
t.integer "users_registration_mode", default: 0, null: false
t.string "id_documents_methods", default: ["online"], array: true
t.jsonb "id_documents_explanation_text", default: {}
t.boolean "user_groups_enabled", default: false, null: false
t.jsonb "colors", default: {}
t.jsonb "smtp_settings"
t.boolean "force_users_to_authenticate_before_access_organization", default: false
t.index ["host"], name: "index_decidim_organizations_on_host", unique: true
t.index ["name"], name: "index_decidim_organizations_on_name", unique: true
end
create_table "decidim_pages_pages", id: :serial, force: :cascade do |t|
t.jsonb "body"
t.integer "decidim_component_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_component_id"], name: "index_decidim_pages_pages_on_decidim_component_id"
end
create_table "decidim_participatory_process_groups", id: :serial, force: :cascade do |t|
t.jsonb "name", null: false
t.jsonb "description", null: false
t.string "hero_image"
t.integer "decidim_organization_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_organization_id"], name: "decidim_participatory_process_group_organization"
end
create_table "decidim_participatory_process_steps", id: :serial, force: :cascade do |t|
t.jsonb "title", null: false
t.jsonb "description"
t.date "start_date"
t.date "end_date"
t.integer "decidim_participatory_process_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.boolean "active", default: false
t.integer "position"
t.jsonb "cta_text", default: {}
t.string "cta_path"
t.index ["decidim_participatory_process_id", "active"], name: "unique_index_to_avoid_duplicate_active_steps", unique: true, where: "(active = true)"
t.index ["decidim_participatory_process_id", "position"], name: "index_unique_position_for_process", unique: true
t.index ["decidim_participatory_process_id"], name: "index_decidim_processes_steps__on_decidim_process_id"
t.index ["position"], name: "index_order_by_position_for_steps"
end
create_table "decidim_participatory_process_user_roles", id: :serial, force: :cascade do |t|
t.integer "decidim_user_id"
t.integer "decidim_participatory_process_id"
t.string "role"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_participatory_process_id", "decidim_user_id", "role"], name: "index_unique_user_and_process_role", unique: true
end
create_table "decidim_participatory_processes", id: :serial, force: :cascade do |t|
t.string "slug", null: false
t.string "hashtag"
t.integer "decidim_organization_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "title", null: false
t.jsonb "subtitle", null: false
t.jsonb "short_description", null: false
t.jsonb "description", null: false
t.string "hero_image"
t.string "banner_image"
t.boolean "promoted", default: false
t.datetime "published_at"
t.jsonb "developer_group"
t.date "end_date"
t.jsonb "meta_scope"
t.jsonb "local_area"
t.jsonb "target"
t.jsonb "participatory_scope"
t.jsonb "participatory_structure"
t.integer "decidim_scope_id"
t.integer "decidim_participatory_process_group_id"
t.boolean "show_statistics", default: true
t.jsonb "announcement"
t.boolean "scopes_enabled", default: true, null: false
t.date "start_date"
t.boolean "private_space", default: false
t.string "reference"
t.bigint "decidim_area_id"
t.index ["decidim_area_id"], name: "index_decidim_participatory_processes_on_decidim_area_id"
t.index ["decidim_organization_id", "slug"], name: "index_unique_process_slug_and_organization", unique: true
t.index ["decidim_organization_id"], name: "index_decidim_processes_on_decidim_organization_id"
end
create_table "decidim_participatory_space_links", id: :serial, force: :cascade do |t|
t.string "from_type", null: false
t.integer "from_id", null: false
t.string "to_type", null: false
t.integer "to_id", null: false
t.string "name", null: false
t.jsonb "data"
t.index ["from_type", "from_id"], name: "index_participatory_space_links_on_from"
t.index ["name"], name: "index_participatory_space_links_name"
t.index ["to_type", "to_id"], name: "index_participatory_space_links_on_to"
end
create_table "decidim_participatory_space_private_users", force: :cascade do |t|
t.bigint "decidim_user_id"
t.integer "privatable_to_id"
t.string "privatable_to_type"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_user_id"], name: "index_decidim_spaces_users_on_private_user_id"
t.index ["privatable_to_type", "privatable_to_id"], name: "space_privatable_to_privatable_id"
end
create_table "decidim_proposals_collaborative_draft_collaborator_requests", force: :cascade do |t|
t.bigint "decidim_proposals_collaborative_draft_id", null: false
t.bigint "decidim_user_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_proposals_collaborative_draft_id"], name: "index_collab_requests_on_decidim_proposals_collab_draft_id"
t.index ["decidim_user_id"], name: "index_collab_requests_on_decidim_user_id"
end
create_table "decidim_proposals_collaborative_drafts", force: :cascade do |t|
t.text "title", null: false
t.text "body", null: false
t.integer "decidim_component_id", null: false
t.integer "decidim_scope_id"
t.string "state"
t.string "reference"
t.text "address"
t.float "latitude"
t.float "longitude"
t.datetime "published_at"
t.integer "authors_count", default: 0, null: false
t.integer "versions_count", default: 0, null: false
t.integer "contributions_count", default: 0, null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "coauthorships_count", default: 0, null: false
t.index ["body"], name: "decidim_proposals_collaborative_draft_body_search"
t.index ["decidim_component_id"], name: "decidim_proposals_collaborative_drafts_on_decidim_component_id"
t.index ["decidim_scope_id"], name: "decidim_proposals_collaborative_drafts_on_decidim_scope_id"
t.index ["state"], name: "decidim_proposals_collaborative_drafts_on_state"
t.index ["title"], name: "decidim_proposals_collaborative_drafts_title_search"
t.index ["updated_at"], name: "decidim_proposals_collaborative_drafts_on_updated_at"
end
create_table "decidim_proposals_participatory_texts", force: :cascade do |t|
t.jsonb "title"
t.jsonb "description"
t.bigint "decidim_component_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_component_id"], name: "idx_participatory_texts_on_decidim_component_id"
end
create_table "decidim_proposals_proposal_endorsements", force: :cascade do |t|
t.bigint "decidim_proposal_id", null: false
t.bigint "decidim_author_id", null: false
t.bigint "decidim_user_group_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "decidim_author_type", null: false
t.index "decidim_proposal_id, decidim_author_id, (COALESCE(decidim_user_group_id, ('-1'::integer)::bigint))", name: "decidim_proposals_proposal_endorsmt_proposal_auth_ugroup_uniq", unique: true
t.index ["decidim_author_id", "decidim_author_type"], name: "index_decidim_proposals_proposal_endorsements_on_decidim_author"
t.index ["decidim_proposal_id"], name: "decidim_proposals_proposal_endorsement_proposal"
t.index ["decidim_user_group_id"], name: "decidim_proposals_proposal_endorsement_user_group"
end
create_table "decidim_proposals_proposal_notes", force: :cascade do |t|
t.bigint "decidim_proposal_id", null: false
t.bigint "decidim_author_id", null: false
t.text "body", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["created_at"], name: "index_decidim_proposals_proposal_notes_on_created_at"
t.index ["decidim_author_id"], name: "decidim_proposals_proposal_note_author"
t.index ["decidim_proposal_id"], name: "decidim_proposals_proposal_note_proposal"
end
create_table "decidim_proposals_proposal_votes", id: :serial, force: :cascade do |t|
t.integer "decidim_proposal_id", null: false
t.integer "decidim_author_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.boolean "temporary", default: false, null: false
t.index ["decidim_author_id"], name: "decidim_proposals_proposal_vote_author"
t.index ["decidim_proposal_id", "decidim_author_id"], name: "decidim_proposals_proposal_vote_proposal_author_unique", unique: true
t.index ["decidim_proposal_id"], name: "decidim_proposals_proposal_vote_proposal"
end
create_table "decidim_proposals_proposals", id: :serial, force: :cascade do |t|
t.text "title", null: false
t.text "body", null: false
t.integer "decidim_component_id", null: false
t.integer "decidim_scope_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "proposal_votes_count", default: 0, null: false
t.string "state"
t.datetime "answered_at"
t.jsonb "answer"
t.string "reference"
t.text "address"
t.float "latitude"
t.float "longitude"
t.integer "proposal_endorsements_count", default: 0, null: false
t.datetime "published_at"
t.integer "proposal_notes_count", default: 0, null: false
t.integer "coauthorships_count", default: 0, null: false
t.string "participatory_text_level"
t.integer "position"
t.boolean "created_in_meeting", default: false
t.index "md5(body)", name: "decidim_proposals_proposal_body_search"
t.index "md5(title)", name: "decidim_proposals_proposal_title_search"
t.index ["created_at"], name: "index_decidim_proposals_proposals_on_created_at"
t.index ["decidim_component_id"], name: "index_decidim_proposals_proposals_on_decidim_component_id"
t.index ["decidim_scope_id"], name: "index_decidim_proposals_proposals_on_decidim_scope_id"
t.index ["proposal_endorsements_count"], name: "idx_decidim_proposals_proposals_on_proposal_endorsemnts_count"
t.index ["proposal_votes_count"], name: "index_decidim_proposals_proposals_on_proposal_votes_count"
t.index ["state"], name: "index_decidim_proposals_proposals_on_state"
end
create_table "decidim_reports", id: :serial, force: :cascade do |t|
t.integer "decidim_moderation_id", null: false
t.integer "decidim_user_id", null: false
t.string "reason", null: false
t.text "details"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_moderation_id", "decidim_user_id"], name: "decidim_reports_moderation_user_unique", unique: true
t.index ["decidim_moderation_id"], name: "decidim_reports_moderation"
t.index ["decidim_user_id"], name: "decidim_reports_user"
end
create_table "decidim_resource_links", id: :serial, force: :cascade do |t|
t.string "from_type", null: false
t.integer "from_id", null: false
t.string "to_type", null: false
t.integer "to_id", null: false
t.string "name", null: false
t.jsonb "data"
t.index ["from_type", "from_id"], name: "index_decidim_resource_links_on_from_type_and_from_id"
t.index ["name"], name: "index_decidim_resource_links_on_name"
t.index ["to_type", "to_id"], name: "index_decidim_resource_links_on_to_type_and_to_id"
end
create_table "decidim_resource_permissions", force: :cascade do |t|
t.string "resource_type"
t.bigint "resource_id"
t.jsonb "permissions", default: {}
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["resource_type", "resource_id"], name: "index_decidim_resource_permissions_on_r_type_and_r_id", unique: true
end
create_table "decidim_scope_types", id: :serial, force: :cascade do |t|
t.integer "decidim_organization_id"
t.jsonb "name", null: false
t.jsonb "plural", null: false
t.index ["decidim_organization_id"], name: "index_decidim_scope_types_on_decidim_organization_id"
end
create_table "decidim_scopes", id: :serial, force: :cascade do |t|
t.integer "decidim_organization_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "name", null: false
t.integer "scope_type_id"
t.integer "parent_id"
t.string "code", null: false
t.integer "part_of", default: [], null: false, array: true
t.index ["decidim_organization_id", "code"], name: "index_decidim_scopes_on_decidim_organization_id_and_code", unique: true
t.index ["decidim_organization_id"], name: "index_decidim_scopes_on_decidim_organization_id"
t.index ["parent_id"], name: "index_decidim_scopes_on_parent_id"
t.index ["part_of"], name: "index_decidim_scopes_on_part_of", using: :gin
t.index ["scope_type_id"], name: "index_decidim_scopes_on_scope_type_id"
end
create_table "decidim_searchable_resources", force: :cascade do |t|
t.text "content_a"
t.text "content_b"
t.text "content_c"
t.text "content_d"
t.string "locale", null: false
t.datetime "datetime"
t.bigint "decidim_scope_id"
t.string "decidim_participatory_space_type"
t.bigint "decidim_participatory_space_id"
t.bigint "decidim_organization_id"
t.string "resource_type"
t.bigint "resource_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_organization_id"], name: "index_decidim_searchable_resources_on_decidim_organization_id"
t.index ["decidim_participatory_space_type", "decidim_participatory_space_id"], name: "index_decidim_searchable_resource_on_pspace_type_and_pspace_id"
t.index ["decidim_scope_id"], name: "index_decidim_searchable_resources_on_decidim_scope_id"
t.index ["resource_type", "resource_id"], name: "index_decidim_searchable_rsrcs_on_s_type_and_s_id"
end
create_table "decidim_sortitions_sortitions", force: :cascade do |t|
t.bigint "decidim_component_id"
t.integer "decidim_proposals_component_id"
t.integer "dice", null: false
t.integer "target_items", null: false
t.datetime "request_timestamp", null: false
t.jsonb "selected_proposals"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.jsonb "witnesses"
t.jsonb "additional_info"
t.bigint "decidim_author_id", null: false
t.string "reference"
t.jsonb "title"
t.jsonb "cancel_reason"
t.datetime "cancelled_on"
t.integer "cancelled_by_user_id"
t.jsonb "candidate_proposals"
t.string "decidim_author_type", null: false
t.index ["decidim_author_id", "decidim_author_type"], name: "index_decidim_sortitions_sortitions_on_decidim_author"
t.index ["decidim_author_id"], name: "index_decidim_sortitions_sortitions_on_decidim_author_id"
t.index ["decidim_component_id"], name: "index_sortitions__on_feature"
t.index ["decidim_proposals_component_id"], name: "index_sortitions__on_proposals_feature"
end
create_table "decidim_static_page_topics", force: :cascade do |t|
t.jsonb "title", null: false
t.jsonb "description", null: false
t.bigint "organization_id", null: false
t.integer "weight"
t.boolean "show_in_footer", default: false, null: false
t.index ["organization_id"], name: "index_decidim_static_page_topics_on_organization_id"
end
create_table "decidim_static_pages", id: :serial, force: :cascade do |t|
t.jsonb "title", null: false
t.string "slug", null: false
t.jsonb "content", null: false
t.integer "decidim_organization_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "weight"
t.boolean "show_in_footer", default: false, null: false
t.bigint "topic_id"
t.index ["decidim_organization_id"], name: "index_decidim_static_pages_on_decidim_organization_id"
t.index ["topic_id"], name: "index_decidim_static_pages_on_topic_id"
end
create_table "decidim_surveys_survey_answer_choices", force: :cascade do |t|
t.bigint "decidim_survey_answer_id"
t.bigint "decidim_survey_answer_option_id"
t.jsonb "body"
t.text "custom_body"
t.integer "position"
t.index ["decidim_survey_answer_id"], name: "index_decidim_surveys_answer_choices_answer_id"
t.index ["decidim_survey_answer_option_id"], name: "index_decidim_surveys_answer_choices_answer_option_id"
end
create_table "decidim_surveys_survey_answer_options", force: :cascade do |t|
t.bigint "decidim_survey_question_id"
t.jsonb "body"
t.boolean "free_text"
t.index ["decidim_survey_question_id"], name: "index_decidim_surveys_answer_options_question_id"
end
create_table "decidim_surveys_survey_answers", id: :serial, force: :cascade do |t|
t.integer "decidim_user_id"
t.integer "decidim_survey_id"
t.integer "decidim_survey_question_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.text "body"
t.index ["decidim_survey_id"], name: "index_decidim_surveys_survey_answers_on_decidim_survey_id"
t.index ["decidim_survey_question_id"], name: "index_decidim_surveys_answers_question_id"
t.index ["decidim_user_id"], name: "index_decidim_surveys_survey_answers_on_decidim_user_id"
end
create_table "decidim_surveys_survey_questions", id: :serial, force: :cascade do |t|
t.jsonb "body"
t.integer "decidim_survey_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "position"
t.boolean "mandatory"
t.string "question_type"
t.integer "max_choices"
t.jsonb "description"
t.index ["decidim_survey_id"], name: "index_decidim_surveys_survey_questions_on_decidim_survey_id"
end
create_table "decidim_surveys_surveys", id: :serial, force: :cascade do |t|
t.jsonb "title"
t.jsonb "description"
t.jsonb "tos"
t.integer "decidim_component_id"
t.datetime "published_at"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_component_id"], name: "index_decidim_surveys_surveys_on_decidim_component_id"
end
create_table "decidim_system_admins", id: :serial, force: :cascade do |t|
t.string "email", default: "", null: false
t.string "encrypted_password", default: "", null: false
t.string "reset_password_token"
t.datetime "reset_password_sent_at"
t.datetime "remember_created_at"
t.integer "failed_attempts", default: 0, null: false
t.string "unlock_token"
t.datetime "locked_at"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["email"], name: "index_decidim_system_admins_on_email", unique: true
t.index ["reset_password_token"], name: "index_decidim_system_admins_on_reset_password_token", unique: true
end
create_table "decidim_user_group_memberships", id: :serial, force: :cascade do |t|
t.integer "decidim_user_id", null: false
t.integer "decidim_user_group_id", null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "role", default: "requested", null: false
t.index ["decidim_user_group_id", "decidim_user_id"], name: "index_user_group_memberships_group_id_user_id"
t.index ["decidim_user_group_id"], name: "index_decidim_user_group_memberships_on_decidim_user_group_id"
t.index ["decidim_user_id", "decidim_user_group_id"], name: "decidim_user_group_memberships_unique_user_and_group_ids", unique: true
t.index ["decidim_user_id"], name: "index_decidim_user_group_memberships_on_decidim_user_id"
t.index ["role", "decidim_user_group_id"], name: "decidim_group_membership_one_creator_per_group", unique: true, where: "((role)::text = 'creator'::text)"
end
create_table "decidim_users", id: :serial, force: :cascade do |t|
t.string "email", default: "", null: false
t.string "encrypted_password", default: "", null: false
t.string "reset_password_token"
t.datetime "reset_password_sent_at"
t.datetime "remember_created_at"
t.integer "sign_in_count", default: 0, null: false
t.datetime "current_sign_in_at"
t.datetime "last_sign_in_at"
t.string "current_sign_in_ip"
t.string "last_sign_in_ip"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "invitation_token"
t.datetime "invitation_created_at"
t.datetime "invitation_sent_at"
t.datetime "invitation_accepted_at"
t.integer "invitation_limit"
t.string "invited_by_type"
t.integer "invited_by_id"
t.integer "invitations_count", default: 0
t.integer "decidim_organization_id"
t.string "confirmation_token"
t.datetime "confirmed_at"
t.datetime "confirmation_sent_at"
t.string "unconfirmed_email"
t.string "name", null: false
t.string "locale"
t.string "avatar"
t.text "delete_reason"
t.datetime "deleted_at"
t.boolean "admin", default: false, null: false
t.boolean "managed", default: false, null: false
t.string "roles", default: [], array: true
t.boolean "email_on_notification", default: false, null: false
t.string "nickname", limit: 20, default: "", null: false
t.string "personal_url"
t.text "about"
t.datetime "officialized_at"
t.jsonb "officialized_as"
t.datetime "accepted_tos_version"
t.string "newsletter_token", default: ""
t.datetime "newsletter_notifications_at"
t.string "type", null: false
t.jsonb "extended_data", default: {}
t.integer "following_count", default: 0, null: false
t.integer "followers_count", default: 0, null: false
t.string "notification_types", default: "all", null: false
t.index ["confirmation_token"], name: "index_decidim_users_on_confirmation_token", unique: true
t.index ["decidim_organization_id"], name: "index_decidim_users_on_decidim_organization_id"
t.index ["email", "decidim_organization_id"], name: "index_decidim_users_on_email_and_decidim_organization_id", unique: true, where: "((deleted_at IS NULL) AND (managed = false) AND ((type)::text = 'Decidim::User'::text))"
t.index ["id", "type"], name: "index_decidim_users_on_id_and_type"
t.index ["invitation_token"], name: "index_decidim_users_on_invitation_token", unique: true
t.index ["invitations_count"], name: "index_decidim_users_on_invitations_count"
t.index ["invited_by_id", "invited_by_type"], name: "index_decidim_users_on_invited_by_id_and_invited_by_type"
t.index ["invited_by_id"], name: "index_decidim_users_on_invited_by_id"
t.index ["nickname", "decidim_organization_id"], name: "index_decidim_users_on_nickame_and_decidim_organization_id", unique: true, where: "((deleted_at IS NULL) AND (managed = false))"
t.index ["officialized_at"], name: "index_decidim_users_on_officialized_at"
t.index ["reset_password_token"], name: "index_decidim_users_on_reset_password_token", unique: true
end
create_table "decidim_verifications_csv_data", force: :cascade do |t|
t.string "email"
t.bigint "decidim_organization_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.index ["decidim_organization_id"], name: "index_verifications_csv_census_to_organization"
end
create_table "decidim_votings_electoral_districts", force: :cascade do |t|
t.bigint "decidim_scope_id"
t.bigint "decidim_votings_voting_id"
t.string "voting_identifier"
t.index ["decidim_scope_id"], name: "index_decidim_votings_electoral_districts_on_decidim_scope_id"
t.index ["decidim_votings_voting_id"], name: "decidim_votings_electoral_distrings_on_voting_id"
end
create_table "decidim_votings_simulated_votes", force: :cascade do |t|
t.bigint "decidim_user_id"
t.bigint "decidim_votings_voting_id"
t.integer "status", default: 0
t.string "voter_identifier"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "simulation_code", default: 0, null: false
t.string "voting_identifier"
t.index ["decidim_user_id"], name: "index_decidim_votings_simulated_votes_on_decidim_user_id"
t.index ["decidim_votings_voting_id", "decidim_user_id", "simulation_code"], name: "idx_simulated_votes_voting_user_code", unique: true
t.index ["decidim_votings_voting_id"], name: "index_simulated_votes_on_voting"
end
create_table "decidim_votings_votes", force: :cascade do |t|
t.bigint "decidim_user_id"
t.bigint "decidim_votings_voting_id"
t.integer "status", default: 0
t.string "voter_identifier"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "voting_identifier"
t.index ["decidim_user_id"], name: "index_decidim_votings_votes_on_decidim_user_id"
t.index ["decidim_votings_voting_id", "decidim_user_id"], name: "idx_votes_voting_user", unique: true
t.index ["decidim_votings_voting_id"], name: "index_decidim_votings_votes_on_decidim_votings_voting_id"
end
create_table "decidim_votings_votings", force: :cascade do |t|
t.jsonb "title"
t.jsonb "description"
t.string "image"
t.datetime "start_date"
t.datetime "end_date"
t.integer "decidim_scope_id"
t.integer "importance"
t.string "voting_system"
t.jsonb "system_configuration"
t.bigint "decidim_component_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.integer "simulation_code", default: 0, null: false
t.index ["decidim_component_id"], name: "decidim_votings_component_index"
t.index ["decidim_scope_id"], name: "index_decidim_votings_votings_on_decidim_scope_id"
end
create_table "oauth_access_grants", force: :cascade do |t|
t.integer "resource_owner_id", null: false
t.bigint "application_id", null: false
t.string "token", null: false
t.integer "expires_in", null: false
t.text "redirect_uri", null: false
t.datetime "created_at", null: false
t.datetime "revoked_at"
t.string "scopes"
t.index ["application_id"], name: "index_oauth_access_grants_on_application_id"
t.index ["token"], name: "index_oauth_access_grants_on_token", unique: true
end
create_table "oauth_access_tokens", force: :cascade do |t|
t.integer "resource_owner_id"
t.bigint "application_id"
t.string "token", null: false
t.string "refresh_token"
t.integer "expires_in"
t.datetime "revoked_at"
t.datetime "created_at", null: false
t.string "scopes"
t.string "previous_refresh_token", default: "", null: false
t.index ["application_id"], name: "index_oauth_access_tokens_on_application_id"
t.index ["refresh_token"], name: "index_oauth_access_tokens_on_refresh_token", unique: true
t.index ["resource_owner_id"], name: "index_oauth_access_tokens_on_resource_owner_id"
t.index ["token"], name: "index_oauth_access_tokens_on_token", unique: true
end
create_table "oauth_applications", force: :cascade do |t|
t.string "name", null: false
t.string "organization_name", null: false
t.string "organization_url", null: false
t.string "organization_logo", null: false
t.string "uid", null: false
t.string "secret", null: false
t.text "redirect_uri", null: false
t.string "scopes", default: "", null: false
t.bigint "decidim_organization_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
t.string "type"
t.boolean "confidential", default: true, null: false
t.index ["decidim_organization_id"], name: "index_oauth_applications_on_decidim_organization_id"
t.index ["uid"], name: "index_oauth_applications_on_uid", unique: true
end
create_table "versions", force: :cascade do |t|
t.string "item_type", null: false
t.integer "item_id", null: false
t.string "event", null: false
t.string "whodunnit"
t.jsonb "object"
t.datetime "created_at"
t.text "object_changes"
t.index ["item_id", "item_type"], name: "index_versions_on_item_id_and_item_type"
t.index ["item_type", "item_id"], name: "index_versions_on_item_type_and_item_id"
end
add_foreign_key "decidim_area_types", "decidim_organizations"
add_foreign_key "decidim_areas", "decidim_area_types", column: "area_type_id"
add_foreign_key "decidim_areas", "decidim_organizations"
add_foreign_key "decidim_attachments", "decidim_attachment_collections", column: "attachment_collection_id", name: "fk_decidim_attachments_attachment_collection_id", on_delete: :nullify
add_foreign_key "decidim_authorizations", "decidim_users"
add_foreign_key "decidim_categorizations", "decidim_categories"
add_foreign_key "decidim_identities", "decidim_organizations"
add_foreign_key "decidim_newsletters", "decidim_users", column: "author_id"
add_foreign_key "decidim_participatory_process_steps", "decidim_participatory_processes"
add_foreign_key "decidim_participatory_processes", "decidim_organizations"
add_foreign_key "decidim_scope_types", "decidim_organizations"
add_foreign_key "decidim_scopes", "decidim_organizations"
add_foreign_key "decidim_scopes", "decidim_scope_types", column: "scope_type_id"
add_foreign_key "decidim_scopes", "decidim_scopes", column: "parent_id"
add_foreign_key "decidim_static_pages", "decidim_organizations"
add_foreign_key "decidim_users", "decidim_organizations"
add_foreign_key "decidim_verifications_csv_data", "decidim_organizations"
add_foreign_key "decidim_votings_electoral_districts", "decidim_scopes"
add_foreign_key "decidim_votings_electoral_districts", "decidim_votings_votings"
add_foreign_key "decidim_votings_simulated_votes", "decidim_users"
add_foreign_key "decidim_votings_simulated_votes", "decidim_votings_votings"
add_foreign_key "decidim_votings_votes", "decidim_users"
add_foreign_key "decidim_votings_votes", "decidim_votings_votings"
add_foreign_key "oauth_access_grants", "decidim_users", column: "resource_owner_id"
add_foreign_key "oauth_access_grants", "oauth_applications", column: "application_id"
add_foreign_key "oauth_access_tokens", "decidim_users", column: "resource_owner_id"
add_foreign_key "oauth_access_tokens", "oauth_applications", column: "application_id"
add_foreign_key "oauth_applications", "decidim_organizations"
end