+ create_table "bank_transactions_import_logs", force: :cascade do |t|
+ t.string "status"
+ t.string "kind"
+ t.text "description"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "basic_benefit_rates", force: :cascade do |t|
@@ -573,2 +581,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"
@@ -577,2 +586,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"
@@ -881,2 +891,4 @@ create_table "employment_hours", force: :cascade do |t|
t.string "programme"
+ t.bigint "fortnight_id"
+ t.index ["fortnight_id"], name: "index_employment_hours_on_fortnight_id"
t.index ["jobseeker_id"], name: "index_employment_hours_on_jobseeker_id"
@@ -1049,2 +1061,3 @@ create_table "expense_payment_types", id: :serial, force: :cascade do |t|
t.integer "company_id"
+ t.boolean "second_approval_required", default: false
t.index ["company_id"], name: "index_expense_payment_types_on_company_id"
@@ -1201,2 +1214,3 @@ create_table "fortnights", force: :cascade do |t|
t.date "end_date"
+ t.decimal "overridden_ess_result"
t.index ["placement_id"], name: "index_fortnights_on_placement_id"
@@ -2350,2 +2364,4 @@ create_table "rate_reductions", force: :cascade do |t|
t.string "programme"
+ t.bigint "fortnight_id"
+ t.index ["fortnight_id"], name: "index_rate_reductions_on_fortnight_id"
t.index ["jobseeker_id"], name: "index_rate_reductions_on_jobseeker_id"
@@ -2600,2 +2616,5 @@ create_table "settings", id: :serial, force: :cascade do |t|
t.boolean "marketo_sync_enabled", default: false, null: false
+ t.boolean "bank_transactions_import_enabled", default: false
+ t.string "bank_transactions_import_filename"
+ t.string "bank_transactions_import_checksum"
end
@@ -3405,2 +3424,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"