Database Properties
Database Type: PostgreSQL - 16.9 (Debian 16.9-1.pgdg120+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| investigation_audit | 0 | 1 | 19 | -1 | Table | Investigation property changes |
| attendee | 0 | 2 | 8 | -1 | Table | Records the people who attended the review, their role and contribution |
| referral | 5 | 5 | 21 | -1 | Table | The referral that caused the CSIP record to be created. Referrals are step 1 of the CSIP process |
| plan_audit | 0 | 1 | 9 | -1 | Table | Plan property changes |
| decision_and_actions_audit | 0 | 3 | 21 | -1 | Table | Decision and actions property changes |
| plan | 4 | 1 | 7 | -1 | Table | The plan that was developed following a screening outcome or decision to ‘Progress to CSIP’. Developing a plan is step 5 of the CSIP process |
| audit_revision | 32 | 0 | 6 | -1 | Table | Hibernate Envers audit revision records. A revision is created for every set of changes to the CSIP entity graph and the history of every mutable property change is tracked. Full audit history starts from the 15th of November 2024 |
| person_summary | 3 | 0 | 9 | -1 | Table | Summary data for people with CSIPs. Used to optimise searching and pagination. Domain events cause the summary data to be updated keeping it accurate |
| review_audit | 0 | 3 | 21 | -1 | Table | Review property changes |
| attendee_audit | 0 | 3 | 13 | -1 | Table | Attendee property changes |
| identified_need_audit | 0 | 3 | 19 | -1 | Table | Identified needs property changes |
| decision_and_actions | 0 | 3 | 11 | -1 | Table | Record of the decision and any actions expected as a result. Recording a decision is an optional step 4 of the CSIP process following an investigation |
| investigation | 2 | 1 | 10 | -1 | Table | The investigation that took place following a ‘Progress to investigation’ screening outcome. Investigations are an optional step 3 of the CSIP process |
| interview_audit | 0 | 4 | 13 | -1 | Table | Interview property changes |
| safer_custody_screening_outcome | 0 | 2 | 7 | -1 | Table | The result of the referral screening process undertaken by the Safer Custody team. Screening is step 2 of the CSIP process which can end if the decision is not to proceed further |
| contributory_factor_audit | 0 | 4 | 9 | -1 | Table | Contributory factor property changes |
| csip_record | 2 | 3 | 7 | -1 | Table | Root CSIP entity associating a person with a CSIP and all the child entities. Conceptually a CSIP folder. All 1:1 child entities use the record_id value for their primary key |
| safer_custody_screening_outcome_audit | 0 | 2 | 13 | -1 | Table | Screening property changes |
| identified_need | 0 | 2 | 11 | -1 | Table | The needs identified in the plan or at subsequent reviews. Includes the plan to resolve the identified need and the progression of that plan |
| contributory_factor | 0 | 3 | 6 | -1 | Table | The contributory factors the referrer has identified as part of the referral |
| csip_record_audit | 0 | 3 | 9 | -1 | Table | CSIP record property changes |
| interview | 0 | 3 | 8 | -1 | Table | The interviews undertaken as part of the investigation |
| review | 2 | 2 | 12 | -1 | Table | The reviews of the plan. Plans are reviewed regularly as step 6 of the CSIP process. Plans can close the CSIP completing the CSIP process |
| referral_audit | 0 | 5 | 41 | -1 | Table | Referral property changes |
| reference_data | 10 | 0 | 11 | 112 | Table | Reference data used to populate properties that have fixed lists of valid options e.g. categories, decisions and statuses |
| csip_summary | 0 | 1 | 17 | 0 | View |