-ActiveRecord::Schema.define(version: 2021_08_17_002254) do
+ActiveRecord::Schema.define(version: 2021_09_02_105301) do
@@ -723,2 +723,15 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
+ create_table "employer_campaigns", force: :cascade do |t|
+ t.string "name"
+ t.bigint "company_id"
+ t.integer "account_manager_id"
+ t.string "status"
+ t.string "objective"
+ t.string "contact_person"
+ t.string "contact_details"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["company_id"], name: "index_employer_campaigns_on_company_id"
+ end
+
create_table "employment_properties", id: :serial, force: :cascade do |t|
@@ -1423,2 +1436,12 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
+ create_table "occupations", force: :cascade do |t|
+ t.string "code", null: false
+ t.string "title", null: false
+ t.text "description"
+ t.boolean "jedi", default: true, null: false
+ t.boolean "pre_jedi", default: false, null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "old_passwords", force: :cascade do |t|
@@ -1653,3 +1676,5 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
t.datetime "updated_at", null: false
+ t.bigint "expense_payment_type_id"
t.index ["custom_expense_type_id"], name: "index_program_referral_types_on_custom_expense_type_id"
+ t.index ["expense_payment_type_id"], name: "index_program_referral_types_on_expense_payment_type_id"
end
@@ -1714,2 +1739,3 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
t.datetime "updated_at", null: false
+ t.integer "number_of_referrals_cap_per_jobseeker"
t.index ["company_id"], name: "index_programs_on_company_id"
@@ -2200,3 +2226,2 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
t.string "contract_ess_identifier"
- t.integer "site_manager_id"
t.string "email"
@@ -2207,3 +2232,2 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
t.index ["site_grouping_id"], name: "index_sites_on_site_grouping_id"
- t.index ["site_manager_id"], name: "index_sites_on_site_manager_id"
end
@@ -2579,2 +2603,3 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
t.boolean "can_manage_customer_leads", default: false, null: false
+ t.boolean "can_manage_employer_campaigns", default: false, null: false
t.index ["active"], name: "index_users_on_active"
@@ -2646,2 +2671,3 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
t.json "batch_data"
+ t.bigint "occupation_id"
t.index ["company_id"], name: "index_vacancies_on_company_id"
@@ -2650,2 +2676,3 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
t.index ["licence_requirement_id"], name: "index_vacancies_on_licence_requirement_id"
+ t.index ["occupation_id"], name: "index_vacancies_on_occupation_id"
t.index ["salary"], name: "index_vacancies_on_salary"
@@ -2834,2 +2861,3 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
add_foreign_key "emails", "reminders"
+ add_foreign_key "employer_campaigns", "companies"
add_foreign_key "employment_property_options", "employment_properties"
@@ -2873,2 +2901,3 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
add_foreign_key "program_referral_types", "custom_expense_types"
+ add_foreign_key "program_referral_types", "expense_payment_types"
add_foreign_key "program_referrals", "jobseekers"
@@ -2911,2 +2940,3 @@ ActiveRecord::Schema.define(version: 2021_08_17_002254) do
add_foreign_key "vacancies", "licence_requirements"
+ add_foreign_key "vacancies", "occupations"
add_foreign_key "vacancies", "sites"