Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| interview_id | uuid | 2147483647 | null |
|
|
Public primary key |
|||||
| investigation_id | uuid | 2147483647 | null |
|
|
Parent investigation foreign key which is the shared primary key with csip_record and therefore uses the same value as csip_record.record_id |
|||||
| interviewee | varchar | 100 | null |
|
|
Name of the person being interviewed. Free text so not guaranteed to match any user information. Maps to OFFENDER_CSIP_INTVW.CSIP_INTERVIEWEE which has a 100 character limit |
|||||
| interview_date | date | 13 | null |
|
|
The date the interview took place. Maps to OFFENDER_CSIP_INTVW.INTVW_DATE |
|||||
| interviewee_role_id | int4 | 10 | null |
|
|
Foreign key to reference data using the ‘INTERVIEWEE_ROLE’ domain for the role the interviewee played in the incident or behaviour. Maps to OFFENDER_CSIP_INTVW.INTVW_ROLE |
|||||
| interview_text | text | 2147483647 | √ | null |
|
|
Information provided in interview. Maps to OFFENDER_CSIP_INTVW.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_INTVW.CSIP_INTVW_ID primary key value. Stored to guarantee uniqueness via sync. Not returned by API |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| interview_pkey | Primary key | Asc | interview_id |
| idx_interview_interviewee_role_id | Performance | Asc | interviewee_role_id |
| idx_interview_record_id | Performance | Asc | investigation_id |
| interview_legacy_id_key | Must be unique | Asc | legacy_id |