Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| attendee_id | uuid | 2147483647 | null |
|
|
Public primary key |
|||||
| review_id | uuid | 2147483647 | null |
|
|
Parent review foreign key |
|||||
| name | varchar | 100 | √ | null |
|
|
Name of review attendee/contributor. Free text so not guaranteed to match any user information. Maps to OFFENDER_CSIP_ATTENDEES.ATTENDEE_NAME which has a 100 character limit |
||||
| role | varchar | 50 | √ | null |
|
|
Role of review attendee/contributor. Maps to OFFENDER_CSIP_ATTENDEES.ATTENDEE_ROLE which has a 50 character limit |
||||
| attended | bool | 1 | √ | null |
|
|
Whether the person attended the review. Indicates that they were a contributor if false. Maps to OFFENDER_CSIP_ATTENDEES.ATTENDED where the default is ‘N’ |
||||
| contribution | text | 2147483647 | √ | null |
|
|
Description of attendee contribution. Maps to OFFENDER_CSIP_ATTENDEES.CONTRIBUTION 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_ATTENDEES.ATTENDEE_ID primary key value. Stored to guarantee uniqueness via sync. Not returned by API |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| attendee_pkey | Primary key | Asc | attendee_id |
| attendee_legacy_id_key | Must be unique | Asc | legacy_id |
| idx_attendee_review_id | Performance | Asc | review_id |