-ActiveRecord::Schema.define(version: 2021_11_20_224821) do
+ActiveRecord::Schema.define(version: 2021_12_07_053734) do
@@ -295,2 +295,20 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
+ create_table "breaks", id: :serial, force: :cascade do |t|
+ t.integer "placement_id", null: false
+ t.date "start_date"
+ t.date "end_date"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.string "type", default: "PermissibleBreak", null: false
+ t.index ["placement_id"], name: "index_breaks_on_placement_id"
+ end
+
+ create_table "break_reasons", force: :cascade do |t|
+ t.string "name", null: false
+ t.string "break_type", null: false
+ t.boolean "active", default: true, null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "caseloads", id: :serial, force: :cascade do |t|
@@ -782,3 +800,3 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
t.bigint "site_id", null: false
- t.bigint "placement_id", null: false
+ t.bigint "placement_id"
t.decimal "ave_week_hrs"
@@ -792,3 +810,3 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
t.integer "period_days"
- t.string "request_desc"
+ t.string "request_type_code"
t.string "request_reason_code"
@@ -801,2 +819,4 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
t.datetime "updated_at", null: false
+ t.bigint "jobseeker_id", null: false
+ t.index ["jobseeker_id"], name: "index_employment_hours_on_jobseeker_id"
t.index ["placement_id"], name: "index_employment_hours_on_placement_id"
@@ -912,2 +932,12 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
+ create_table "expense_contact_emails", force: :cascade do |t|
+ t.bigint "contact_id", null: false
+ t.bigint "expense_id", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["contact_id", "expense_id"], name: "index_expense_contact_emails_on_contact_id_and_expense_id"
+ t.index ["contact_id"], name: "index_expense_contact_emails_on_contact_id"
+ t.index ["expense_id"], name: "index_expense_contact_emails_on_expense_id"
+ end
+
create_table "expense_credit_cards", id: :serial, force: :cascade do |t|
@@ -1516,2 +1546,10 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
+ create_table "marketo_access_tokens", force: :cascade do |t|
+ t.string "access_token"
+ t.string "expires_at"
+ t.string "token_type"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "note_templates", id: :serial, force: :cascade do |t|
@@ -1590,12 +1628,2 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
- create_table "permissible_breaks", id: :serial, force: :cascade do |t|
- t.integer "placement_id", null: false
- t.date "start_date"
- t.date "end_date"
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
- t.string "type", default: "PermissibleBreak", null: false
- t.index ["placement_id"], name: "index_permissible_breaks_on_placement_id"
- end
-
create_table "placements", id: :serial, force: :cascade do |t|
@@ -1884,2 +1912,27 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
+ create_table "provider_tag_categories", force: :cascade do |t|
+ t.string "category_code", null: false
+ t.string "category_desc", null: false
+ end
+
+ create_table "provider_tag_descriptions", force: :cascade do |t|
+ t.string "tag_code", null: false
+ t.string "tag_desc", null: false
+ end
+
+ create_table "provider_tags", force: :cascade do |t|
+ t.bigint "jobseeker_id", null: false
+ t.bigint "provider_tag_description_id", null: false
+ t.bigint "provider_tag_category_id", null: false
+ t.string "ess_identifier", null: false
+ t.date "start_date"
+ t.date "end_date"
+ t.integer "updated_by_id"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["jobseeker_id"], name: "index_provider_tags_on_jobseeker_id"
+ t.index ["provider_tag_category_id"], name: "index_provider_tags_on_provider_tag_category_id"
+ t.index ["provider_tag_description_id"], name: "index_provider_tags_on_provider_tag_description_id"
+ end
+
create_table "purchase_orders", id: :serial, force: :cascade do |t|
@@ -2093,2 +2146,26 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
+ create_table "rate_reductions", force: :cascade do |t|
+ t.bigint "site_id", null: false
+ t.bigint "jobseeker_id", null: false
+ t.bigint "placement_id"
+ t.decimal "basic_rate"
+ t.date "date_paid_from"
+ t.date "date_paid_to"
+ t.decimal "earned_casual_income"
+ t.string "outcome_type"
+ t.integer "payment_period_days"
+ t.decimal "rate_reduction"
+ t.string "referral_ess_identifier"
+ t.date "request_period_start_date"
+ t.date "request_period_end_date"
+ t.string "result_code"
+ t.date "result_date"
+ t.string "outcome_lvl"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["jobseeker_id"], name: "index_rate_reductions_on_jobseeker_id"
+ t.index ["placement_id"], name: "index_rate_reductions_on_placement_id"
+ t.index ["site_id"], name: "index_rate_reductions_on_site_id"
+ end
+
create_table "referral_sources", id: :serial, force: :cascade do |t|
@@ -2871,2 +2948,5 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
t.string "third_party_job_description"
+ t.string "address_line_1"
+ t.string "address_line_2"
+ t.text "duties"
t.index ["company_id"], name: "index_vacancies_on_company_id"
@@ -3127,2 +3207,3 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
add_foreign_key "employer_campaigns", "companies"
+ add_foreign_key "employment_hours", "jobseekers"
add_foreign_key "employment_hours", "placements"
@@ -3187,2 +3268,5 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
add_foreign_key "programs", "smart_forms"
+ add_foreign_key "provider_tags", "jobseekers"
+ add_foreign_key "provider_tags", "provider_tag_categories"
+ add_foreign_key "provider_tags", "provider_tag_descriptions"
add_foreign_key "queries", "jobseekers"
@@ -3194,2 +3278,5 @@ ActiveRecord::Schema.define(version: 2021_11_20_224821) do
add_foreign_key "quest_submission_view_tokens", "quest_submissions"
+ add_foreign_key "rate_reductions", "jobseekers"
+ add_foreign_key "rate_reductions", "placements"
+ add_foreign_key "rate_reductions", "sites"
add_foreign_key "reminders", "jobseeker_goals"