Upcoming database changes RELEASE 16 November 2021

-ActiveRecord::Schema.define(version: 2021_10_21_040049) do
+ActiveRecord::Schema.define(version: 2021_11_10_125204) do

@@ -751,2 +751,3 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
t.json "headers", default: {}, null: false
+ t.string "email_type"
t.index ["emailable_id"], name: "index_emails_on_emailable_id"
@@ -778,2 +779,27 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do

+ create_table "employment_hours", force: :cascade do |t|
+ t.bigint "site_id", null: false
+ t.bigint "placement_id", null: false
+ t.decimal "ave_week_hrs"
+ t.integer "basic_rate"
+ t.date "end_date"
+ t.decimal "hours_declared"
+ t.date "hrs_status_date"
+ t.decimal "income_declared"
+ t.string "outcome_lvl"
+ t.string "outcome_type"
+ t.integer "period_days"
+ t.string "request_desc"
+ t.string "request_reason_code"
+ t.string "referral_ess_identifier"
+ t.date "start_date"
+ t.string "status_code"
+ t.date "work_period_start_date"
+ t.date "work_period_end_date"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["placement_id"], name: "index_employment_hours_on_placement_id"
+ t.index ["site_id"], name: "index_employment_hours_on_site_id"
+ end
+
@@ -1866,8 +1892,16 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
t.integer "query_type_id"
- t.string "priority"
t.string "state"
- t.text "notes"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
+ t.bigint "jobseeker_id"
+ t.bigint "note_template_id"
+ t.text "comments"
+ t.bigint "assigned_to_id"
+ t.datetime "assigned_at"
+ t.date "follow_up_date"
+ t.datetime "state_updated_at"
+ t.index ["assigned_to_id"], name: "index_queries_on_assigned_to_id"
t.index ["created_by_id"], name: "index_queries_on_created_by_id"
+ t.index ["jobseeker_id"], name: "index_queries_on_jobseeker_id"
+ t.index ["note_template_id"], name: "index_queries_on_note_template_id"
end
@@ -2131,3 +2165,3 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
create_table "resume_attachments", id: :serial, force: :cascade do |t|
- t.string "file", null: false
+ t.string "file"
t.integer "user_id"
@@ -2141,2 +2175,3 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
t.string "av_signature"
+ t.string "resume_url"
t.index ["deleted_at"], name: "index_resume_attachments_on_deleted_at"
@@ -2373,2 +2408,3 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
t.boolean "can_complete_again", default: false, null: false
+ t.boolean "placement_validation", default: false
t.index ["quest_form_id"], name: "index_smart_forms_on_quest_form_id"
@@ -2736,2 +2772,3 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
t.boolean "can_create_ja_placement", default: false, null: false
+ t.boolean "can_manage_queries", default: false
t.index ["active"], name: "index_users_on_active"
@@ -2803,4 +2840,15 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
t.json "batch_data"
- t.bigint "employer_campaign_id"
t.bigint "occupation_id"
+ t.bigint "employer_campaign_id"
+ t.string "third_party_portal_reference"
+ t.date "active_date"
+ t.date "inactive_date"
+ t.date "close_date"
+ t.string "licence_type_code"
+ t.string "fifo_role"
+ t.string "special_group_code"
+ t.string "mining_energy_utilities"
+ t.string "skill_in_demand"
+ t.string "aware_details"
+ t.string "third_party_job_description"
t.index ["company_id"], name: "index_vacancies_on_company_id"
@@ -2911,7 +2959,19 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do

+ create_table "wage_subsidy_payment_schedule_template_instalments", force: :cascade do |t|
+ t.string "name", null: false
+ t.integer "sequence_number", null: false
+ t.integer "span_weeks", null: false
+ t.bigint "wage_subsidy_payment_schedule_template_id", null: false
+ t.bigint "document_library_file_id"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["document_library_file_id"], name: "index_ws_ps_template_installment_on_document_library_file_id"
+ t.index ["wage_subsidy_payment_schedule_template_id"], name: "index_ws_ps_template_installment_on_ws_ps_template_id"
+ end
+
create_table "wage_subsidy_payment_schedule_templates", force: :cascade do |t|
t.bigint "wage_subsidy_agreement_id"
- t.string "name", null: false
- t.string "frequency", null: false
- t.integer "number_of_payments", null: false
+ t.string "name"
+ t.string "frequency"
+ t.integer "number_of_payments"
t.boolean "active", default: true, null: false
@@ -2971,2 +3031,12 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do

+ create_table "webhooks", force: :cascade do |t|
+ t.string "url", null: false
+ t.string "name"
+ t.string "encrypted_token"
+ t.string "encrypted_token_iv"
+ t.string "events", default: [], array: true
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "why_chooses", id: :serial, force: :cascade do |t|
@@ -3028,2 +3098,4 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
add_foreign_key "employer_campaigns", "companies"
+ add_foreign_key "employment_hours", "placements"
+ add_foreign_key "employment_hours", "sites"
add_foreign_key "employment_property_options", "employment_properties"
@@ -3086,2 +3158,5 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
add_foreign_key "programs", "smart_forms"
+ add_foreign_key "queries", "jobseekers"
+ add_foreign_key "queries", "note_templates"
+ add_foreign_key "queries", "users", column: "assigned_to_id"
add_foreign_key "queries", "users", column: "created_by_id"
@@ -3124,2 +3199,4 @@ ActiveRecord::Schema.define(version: 2021_10_21_040049) do
add_foreign_key "wage_subsidy_agreements", "expense_payment_types"
+ add_foreign_key "wage_subsidy_payment_schedule_template_instalments", "document_library_files"
+ add_foreign_key "wage_subsidy_payment_schedule_template_instalments", "wage_subsidy_payment_schedule_templates"
add_foreign_key "wage_subsidy_payment_schedule_templates", "wage_subsidy_agreements"