Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| contributory_factor_id | uuid | 2147483647 | null |
|
|
Public primary key |
|||||
| referral_id | uuid | 2147483647 | null |
|
|
Parent referral foreign key which is the shared primary key with csip_record and therefore uses the same value as csip_record.record_id |
|||||
| contributory_factor_type_id | int8 | 19 | null |
|
|
Foreign key to reference data using the ‘CONTRIBUTORY_FACTOR_TYPE’ domain for the type of contributory factor believed to have caused the incident or behaviour. The reference_data.code value maps to OFFENDER_CSIP_FACTORS.CSIP_FACTOR |
|||||
| comment | text | 2147483647 | √ | null |
|
|
Additional information about the contributory factor. Maps to OFFENDER_CSIP_FACTORS.COMMENTS which has a 4000 character limit |
||||
| version | int4 | 10 | null |
|
|
Supports optimistic locking preventing unnecessary select queries for new entities |
|||||
| legacy_id | int8 | 19 | √ | null |
|
|
The NOMIS OFFENDER_CSIP_FACTORS.CSIP_FACTOR_ID primary key value. Stored to guarantee uniqueness via sync. Not returned by API |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| contributory_factor_pkey | Primary key | Asc | contributory_factor_id |
| contributory_factor_legacy_id_key | Must be unique | Asc | legacy_id |
| idx_contributory_factor_contributory_factor_type_id | Performance | Asc | contributory_factor_type_id |
| idx_contributory_factor_record_id | Performance | Asc | referral_id |