Database Properties
Database Type: PostgreSQL - 15.0
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| appointment_delivery_address | 0 | 1 | 6 | 0 | Table | appointment location address if the appointment delivery type is ‘IN_PERSON_MEETING_OTHER’ |
| action_plan_session_appointment_pre_v1_78 | 0 | 0 | 2 | 0 | Table | backup no longer in use; for up-to-date session appointment links, see |
| draft_referral | 6 | 1 | 38 | 0 | Table | adding unallocated com related details |
| referral | 10 | 7 | 27 | 0 | Table | referral details |
| referral_desired_outcome | 0 | 4 | 3 | 0 | Table | desired outcome details |
| cancellation_reason | 1 | 0 | 2 | 10 | Table | reference data early end/cancellation reasons |
| flyway_schema_history | 0 | 0 | 10 | 234 | Table | |
| batch_job_execution_params | 0 | 1 | 5 | 0 | Table | |
| dynamic_framework_contract | 2 | 4 | 14 | 0 | Table | stores the scope of the commissioned rehabilitative services contracts |
| delivery_session | 1 | 1 | 3 | 0 | Table | session details for a referral |
| referral_location | 0 | 1 | 18 | 0 | Table | adding unallocated com related details |
| batch_job_execution_context | 0 | 1 | 3 | 0 | Table | |
| appointment | 4 | 7 | 40 | 0 | Table | person-on-probation appointment details (all kinds, assessments and delivery) |
| referral_selected_service_category | 4 | 2 | 2 | 0 | Table | selected service categories for each referral |
| contract_type_service_category | 0 | 2 | 2 | 40 | Table | configuration of selectable service categories for each contract type |
| supplier_assessment | 1 | 1 | 2 | 0 | Table | supplier assessment details for a referral |
| end_of_service_report_outcome | 0 | 2 | 5 | 0 | Table | outcome progress recorded in end of service reports |
| probation_practitioner_details | 0 | 1 | 15 | 0 | Table | storing the probation practitioner details for a particular referral |
| referral_service_user_data | 0 | 1 | 10 | 0 | Table | referral service user details |
| intervention | 1 | 1 | 6 | 0 | Table | intervention details |
| supplier_assessment_appointment | 0 | 2 | 2 | 0 | Table | links between supplier assessments and their appointments for a referral |
| batch_step_execution | 1 | 1 | 19 | 0 | Table | |
| batch_step_execution_context | 0 | 1 | 3 | 0 | Table | |
| changelog | 0 | 2 | 8 | 0 | Table | details about any amendments to an existing referral |
| service_provider | 3 | 0 | 2 | 0 | Table | service provider details |
| withdrawal_reason | 1 | 0 | 3 | 13 | Table | details about different withdrawal reason codes, description and grouping |
| draft_oasys_risk_information | 0 | 2 | 11 | 0 | Table | holds draft OASYS risk information only for a DraftReferral. Discarded after referral is sent. |
| complexity_level | 0 | 1 | 5 | 62 | Table | details about the complexity levels of the service category |
| referral_details | 1 | 2 | 12 | 0 | Table | details about a referral that can change that are not used to determine state |
| action_plan | 1 | 4 | 9 | 0 | Table | service user’s action plan details |
| referral_assignments | 0 | 3 | 5 | 0 | Table | snapshots of referral assignments |
| auth_user | 18 | 0 | 4 | 1 | Table | details about the user from hmpps-auth |
| dynamic_framework_contract_sub_contractor | 0 | 2 | 2 | 0 | Table | sub-contractors for each commissioned rehabilitative services contract |
| nps_region | 2 | 0 | 2 | 12 | Table | reference data National Probation Service (NPS) region details |
| batch_job_execution | 3 | 1 | 11 | 0 | Table | |
| contract_type | 2 | 0 | 3 | 23 | Table | contract (service) types available for commissioned rehabilitative services |
| service_category | 4 | 0 | 3 | 25 | Table | reference data intervention service categories, which relate to service user needs |
| relevant_sentence_end_dataload | 2 | 0 | 2 | 0 | Table | temporary table allowing loading of records for endOfSentence date implementation |
| pcc_region | 1 | 1 | 3 | 42 | Table | reference data Police and Crime Commissioner (PCC) region details |
| end_of_service_report | 1 | 3 | 7 | 0 | Table | end of service reports |
| appointment_delivery | 1 | 1 | 4 | 0 | Table | appointment delivery details |
| case_note | 0 | 2 | 6 | 0 | Table | case note provided by officer for a referral |
| batch_job_instance | 1 | 0 | 4 | 0 | Table | |
| desired_outcome | 2 | 1 | 3 | 146 | Table | reference data desired outcomes available for each intervention service category |
| delivery_session_appointment | 0 | 2 | 2 | 0 | Table | links between sessions and appointments for a referral |
| referral_complexity_level_ids | 0 | 3 | 3 | 0 | Table | selected complexity levels for each referral |
| metadata | 0 | 0 | 4 | 421 | Table | defines metadata about the schema |
| action_plan_activity | 0 | 1 | 4 | 0 | Table | service user’s action plan activity details |
| referral_summary | 0 | 1 | 28 | 0 | View | referral summary |