Upcoming database changes RELEASE 15 June 2021

-ActiveRecord::Schema.define(version: 2021_05_25_020926) do
+ActiveRecord::Schema.define(version: 2021_06_07_235457) do

@@ -399,2 +399,15 @@ create_table "claims_weekly_snapshots", id: :serial, force: :cascade do |t|

+ create_table "commitment_assessments_surveys", force: :cascade do |t|
+ t.bigint "jobseeker_id", null: false
+ t.datetime "completed_at"
+ t.string "stage"
+ t.datetime "exercise_completed_at"
+ t.bigint "created_by_id", null: false
+ t.string "survey_type", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["created_by_id"], name: "index_commitment_assessments_surveys_on_created_by_id"
+ t.index ["jobseeker_id"], name: "index_commitment_assessments_surveys_on_jobseeker_id"
+ end

create_table "companies", id: :serial, force: :cascade do |t|
@@ -1538,4 +1551,15 @@ create_table "program_referrals", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.bigint "rejected_by_id"
+ t.text "rejection_reason"
+ t.datetime "rejected_at"
+ t.bigint "approved_by_id"
+ t.datetime "approved_at"
+ t.bigint "justification_template_id"
+ t.bigint "created_by_id"
+ t.index ["approved_by_id"], name: "index_program_referrals_on_approved_by_id"
+ t.index ["created_by_id"], name: "index_program_referrals_on_created_by_id"
t.index ["jobseeker_id"], name: "index_program_referrals_on_jobseeker_id"
+ t.index ["justification_template_id"], name: "index_program_referrals_on_justification_template_id"
t.index ["program_id"], name: "index_program_referrals_on_program_id"
+ t.index ["rejected_by_id"], name: "index_program_referrals_on_rejected_by_id"
end

@@ -1560,3 +1584,3 @@ create_table "programs", force: :cascade do |t|
t.string "program_name", null: false
- t.bigint "site_id", null: false
+ t.bigint "site_id"
t.datetime "started_at"

@@ -2406,2 +2430,4 @@ create_table "users", id: :serial, force: :cascade do |t|
t.boolean "employment_fund", default: false, null: false
+ t.boolean "can_receive_voucher_at_site", default: false, null: false
+ t.boolean "can_manage_organisation_leads", default: false, null: false
t.index ["active"], name: "index_users_on_active"

@@ -2636,2 +2662,4 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "claims_weekly_snapshots", "sites"
+ add_foreign_key "commitment_assessments_surveys", "jobseekers"
+ add_foreign_key "commitment_assessments_surveys", "users", column: "created_by_id"
add_foreign_key "companies", "users", column: "recruitment_coordinator_id"

@@ -2674,3 +2702,7 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "program_referrals", "jobseekers"
+ add_foreign_key "program_referrals", "program_referral_justification_templates", column: "justification_template_id"
add_foreign_key "program_referrals", "programs"
+ add_foreign_key "program_referrals", "users", column: "approved_by_id"
+ add_foreign_key "program_referrals", "users", column: "created_by_id"
+ add_foreign_key "program_referrals", "users", column: "rejected_by_id"
add_foreign_key "programs", "companies"