-ActiveRecord::Schema[7.0].define(version: 2024_08_12_014526) do
+ActiveRecord::Schema[7.0].define(version: 2024_09_09_121212) do
# These are extensions that must be enabled in order to support this database
enable_extension "citext"
enable_extension "hstore"
@@ -1250,6 +1250,46 @@
t.index ["site_id"], name: "index_ess_wage_subsidy_agreements_on_site_id"
end
+ create_table "event_calendar_schedules", force: :cascade do |t|
+ t.integer "stream_participant_id"
+ t.integer "jobseeker_id"
+ t.integer "created_by_id", null: false
+ t.integer "event_calendar_id"
+ t.datetime "starts_at", precision: nil
+ t.datetime "ends_at", precision: nil
+ t.text "description"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.boolean "is_remote", default: false
+ t.boolean "is_onsite", default: false
+ t.integer "repeat_id"
+ t.integer "assigned_to_id"
+ t.boolean "attendance_required", default: false
+ t.string "attendance_status", default: "none"
+ t.integer "schedule_location_id"
+ t.integer "schedule_event_id"
+ t.string "type"
+ t.text "tags", default: [], array: true
+ t.integer "group_event_schedule_id"
+ t.index ["event_calendar_id"], name: "idst_id_idx"
+ t.index ["jobseeker_id"], name: "index_event_calendar_schedules_on_jobseeker_id"
+ t.index ["schedule_event_id"], name: "index_event_calendar_schedules_on_schedule_event_id"
+ t.index ["schedule_location_id"], name: "index_event_calendar_schedules_on_schedule_location_id"
+ t.index ["stream_participant_id"], name: "index_event_calendar_schedules_on_stream_participant_id"
+ end
+
+ create_table "event_calendars", force: :cascade do |t|
+ t.string "name", null: false
+ t.boolean "active", default: true, null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.boolean "attendance_required", default: false
+ t.boolean "copy", default: false
+ t.bigint "origin_template_id"
+ t.string "type"
+ t.index ["name"], name: "index_event_calendars_on_name", unique: true
+ end
+
create_table "events", id: :uuid, default: nil, force: :cascade do |t|
t.integer "eventable_id"
t.string "eventable_type"
@@ -1598,42 +1638,6 @@
t.index ["batch_id"], name: "index_imported_documents_on_batch_id"
end
- create_table "individual_development_schedule_templates", force: :cascade do |t|
- t.string "name", null: false
- t.boolean "active", default: true, null: false
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
- t.boolean "attendance_required", default: false
- t.boolean "copy", default: false
- t.bigint "origin_template_id"
- t.index ["name"], name: "index_individual_development_schedule_templates_on_name", unique: true
- end
-
- create_table "individual_development_schedules", force: :cascade do |t|
- t.integer "stream_participant_id"
- t.integer "jobseeker_id"
- t.integer "created_by_id", null: false
- t.integer "individual_development_schedule_template_id"
- t.datetime "starts_at", precision: nil
- t.datetime "ends_at", precision: nil
- t.text "description"
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
- t.boolean "is_remote", default: false
- t.boolean "is_onsite", default: false
- t.integer "repeat_id"
- t.integer "assigned_to_id"
- t.boolean "attendance_required", default: false
- t.string "attendance_status", default: "none"
- t.integer "schedule_location_id"
- t.integer "schedule_event_id"
- t.index ["individual_development_schedule_template_id"], name: "idst_id_idx"
- t.index ["jobseeker_id"], name: "index_individual_development_schedules_on_jobseeker_id"
- t.index ["schedule_event_id"], name: "index_individual_development_schedules_on_schedule_event_id"
- t.index ["schedule_location_id"], name: "index_individual_development_schedules_on_schedule_location_id"
- t.index ["stream_participant_id"], name: "index_individual_development_schedules_on_stream_participant_id"
- end
-
create_table "internship_agreements", force: :cascade do |t|
t.bigint "jobseeker_id", null: false
t.bigint "site_id", null: false
@@ -1764,6 +1768,16 @@
t.index ["jobseeker_id"], name: "index_jobseeker_goals_on_jobseeker_id"
end
+ create_table "jobseeker_group_events", force: :cascade do |t|
+ t.bigint "jobseeker_id", null: false
+ t.integer "event_calendar_schedule_id", null: false
+ t.string "attendance_status", default: "none"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["event_calendar_schedule_id"], name: "index_jobseeker_group_event_schedules_on_schedule_id"
+ t.index ["jobseeker_id"], name: "index_jobseeker_group_events_on_jobseeker_id"
+ end
+
create_table "jobseeker_leads", force: :cascade do |t|
t.string "first_name"
t.string "last_name"
@@ -2391,6 +2405,8 @@
t.datetime "updated_at", null: false
t.datetime "deleted_at"
t.bigint "peppol_order_line_id"
+ t.date "correction_start_date"
+ t.date "correction_end_date"
t.index ["deleted_at"], name: "index_peppol_invoice_lines_on_deleted_at"
t.index ["order_number", "item_id"], name: "index_peppol_invoice_lines_on_order_number_and_item_id"
t.index ["peppol_invoice_id", "item_id"], name: "index_peppol_invoice_lines_on_peppol_invoice_id_and_item_id", unique: true
@@ -3805,6 +3821,7 @@
t.datetime "updated_at", null: false
t.boolean "enabled", default: true, null: false
t.jsonb "dashboard_ui_config", default: {"hideTab"=>false, "hideTitle"=>false, "filtersVisible"=>true, "filtersExpanded"=>true, "hideChartControls"=>true}, null: false
+ t.boolean "apply_data_scoping", default: false, null: false
end
create_table "supplier_purchase_orders", id: :serial, force: :cascade do |t|
@@ -4513,6 +4530,7 @@
add_foreign_key "ess_wage_subsidy_agreements", "sites"
add_foreign_key "ess_wage_subsidy_agreements", "users", column: "created_by_id"
add_foreign_key "ess_wage_subsidy_agreements", "users", column: "ended_by_id"
+ add_foreign_key "event_calendar_schedules", "event_calendars"
add_foreign_key "expense_approvals", "expenses"
add_foreign_key "expense_credit_cards", "users"
add_foreign_key "expense_imports", "expense_exports"
@@ -4544,6 +4562,7 @@
add_foreign_key "jobseeker_goals", "goals"
add_foreign_key "jobseeker_goals", "jobseekers"
add_foreign_key "jobseeker_goals", "users", column: "created_by_id"
+ add_foreign_key "jobseeker_group_events", "jobseekers"
add_foreign_key "jobseeker_leads", "lead_stages"
add_foreign_key "jobseeker_leads", "lead_sub_stages"
add_foreign_key "jobseeker_leads", "lead_substatuses"
(END)Upcoming database changes RELEASE 18th September 2024
Nicholas Pesch