-ActiveRecord::Schema.define(version: 2022_08_02_055146) do
+ActiveRecord::Schema.define(version: 2022_08_17_042118) do
@@ -393,2 +393,4 @@ create_table "claim_ccu_change_reasons", id: :serial, force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_claim_ccu_change_reasons_on_deleted_at"
t.index ["reason", "workflow_state"], name: "index_claim_ccu_change_reasons_on_reason_and_workflow_state", unique: true
@@ -597,2 +599,3 @@ create_table "companies", id: :serial, force: :cascade do |t|
t.string "contact_method"
+ t.bigint "created_by_id"
t.index ["account_manager_id"], name: "index_companies_on_account_manager_id"
@@ -601,2 +604,3 @@ create_table "companies", id: :serial, force: :cascade do |t|
t.index ["company_lead_id"], name: "index_companies_on_company_lead_id"
+ t.index ["created_by_id"], name: "index_companies_on_created_by_id"
t.index ["entity_type"], name: "index_companies_on_entity_type"
@@ -650,3 +654,5 @@ create_table "company_types", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
t.index ["company_type"], name: "index_company_types_on_company_type", unique: true
+ t.index ["deleted_at"], name: "index_company_types_on_deleted_at"
end
@@ -655,2 +661,4 @@ create_table "contact_types", id: :serial, force: :cascade do |t|
t.string "name", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_contact_types_on_deleted_at"
end
@@ -759,3 +767,5 @@ create_table "custom_expense_types", id: :serial, force: :cascade do |t|
t.boolean "second_approval_required", default: false
+ t.datetime "deleted_at"
t.index ["code"], name: "index_custom_expense_types_on_code"
+ t.index ["deleted_at"], name: "index_custom_expense_types_on_deleted_at"
t.index ["employment_fund"], name: "index_custom_expense_types_on_employment_fund"
@@ -873,2 +883,4 @@ create_table "embed_reports", id: :serial, force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_embed_reports_on_deleted_at"
end
@@ -941,2 +953,4 @@ create_table "employment_property_options", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_employment_property_options_on_deleted_at"
t.index ["employment_property_id"], name: "index_employment_property_options_on_employment_property_id"
@@ -1067,2 +1081,4 @@ create_table "expense_finance_statuses", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_expense_finance_statuses_on_deleted_at"
end
@@ -1341,2 +1357,4 @@ create_table "intervention_detail_templates", id: :serial, force: :cascade do |t
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_intervention_detail_templates_on_deleted_at"
end
@@ -1368,2 +1386,4 @@ create_table "job_end_reasons", id: :serial, force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_job_end_reasons_on_deleted_at"
end
@@ -1452,2 +1472,4 @@ create_table "jobseeker_portal_contact_us_query_types", id: :serial, force: :cas
t.string "query_type", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_jobseeker_portal_contact_us_query_types_on_deleted_at"
end
@@ -1461,2 +1483,4 @@ create_table "jobseeker_portal_links", id: :serial, force: :cascade do |t|
t.string "logo"
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_jobseeker_portal_links_on_deleted_at"
end
@@ -1559,2 +1583,4 @@ create_table "jobseeker_suggestion_rejection_reasons", id: :serial, force: :casc
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_jobseeker_suggestion_rejection_reasons_on_deleted_at"
t.index ["name"], name: "index_jobseeker_suggestion_rejection_reasons_on_name", unique: true
@@ -2187,3 +2213,2 @@ create_table "queries", force: :cascade do |t|
t.datetime "updated_at", null: false
- t.bigint "jobseeker_id"
t.bigint "note_template_id"
@@ -2197,7 +2222,10 @@ create_table "queries", force: :cascade do |t|
t.bigint "note_id"
+ t.string "queryable_type"
+ t.bigint "queryable_id"
+ t.datetime "closed_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_id"], name: "index_queries_on_note_id"
t.index ["note_template_id"], name: "index_queries_on_note_template_id"
+ t.index ["queryable_type", "queryable_id"], name: "index_queries_on_queryable_type_and_queryable_id"
end
@@ -2553,2 +2581,4 @@ create_table "reverse_marketing_activity_results", force: :cascade do |t|
t.string "result", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_reverse_marketing_activity_results_on_deleted_at"
t.index ["result"], name: "index_reverse_marketing_activity_results_on_result", unique: true
@@ -2605,2 +2635,4 @@ create_table "service_descriptions", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_service_descriptions_on_deleted_at"
end
@@ -2944,2 +2976,4 @@ create_table "sub_statuses", id: :serial, force: :cascade do |t|
t.string "status"
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_sub_statuses_on_deleted_at"
t.index ["name", "status"], name: "index_sub_statuses_on_name_and_status", unique: true
@@ -3384,2 +3418,4 @@ create_table "wage_subsidy_payment_schedule_template_instalments", force: :casca
t.string "previous_system_identifier"
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_ws_ps_template_instalments_on_deleted_at"
t.index ["document_library_file_id"], name: "index_ws_ps_template_installment_on_document_library_file_id"
@@ -3538,2 +3574,3 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "companies", "company_leads"
+ add_foreign_key "companies", "users", column: "created_by_id"
add_foreign_key "companies", "users", column: "recruitment_coordinator_id"
@@ -3621,3 +3658,2 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "provider_tags", "provider_tag_descriptions"
- add_foreign_key "queries", "jobseekers"
add_foreign_key "queries", "note_templates"