-ActiveRecord::Schema.define(version: 2023_07_14_010552) do +ActiveRecord::Schema.define(version: 2023_08_06_144702) do @@ -2033,2 +2033,4 @@ create_table "licence_requirements", id: :serial, force: :cascade do |t| t.datetime "deleted_at" + t.bigint "employment_property_option_id" + t.index ["employment_property_option_id"], name: "index_licence_requirements_on_employment_property_option_id" t.index ["requirement"], name: "index_licence_requirements_on_requirement", unique: true @@ -3679,3 +3681,3 @@ create_table "vacancies", id: :serial, force: :cascade do |t| t.string "status", default: "Active", null: false - t.string "work_type" + t.string "work_type", default: [], array: true t.string "type" @@ -3714,3 +3716,3 @@ create_table "vacancies", id: :serial, force: :cascade do |t| t.string "salary" - t.integer "licence_requirement_id" + t.integer "licence_requirement_id", default: [], array: true t.json "jobs_board_custom_fields", default: {}, null: false @@ -4115,2 +4117,3 @@ create_table "work_for_doles", force: :cascade do |t| add_foreign_key "lead_sub_stages", "lead_stages" + add_foreign_key "licence_requirements", "employment_property_options" add_foreign_key "line_items", "expenses" @@ -4196,3 +4199,2 @@ create_table "work_for_doles", force: :cascade do |t| add_foreign_key "vacancies", "employer_campaigns" - add_foreign_key "vacancies", "licence_requirements" add_foreign_key "vacancies", "occupations" end