sentence

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('sentence_id_seq'::regclass)
period_length.sentence_id period_length_sentence_id_fkey R
recall_sentence.sentence_id fk_recall_sentence_to_sentence R
sentence.consecutive_to_id sentence_consecutive_to_id_fkey R
sentence.superseding_sentence_id sentence_superseding_sentence_id_fkey R
sentence_history.original_sentence_id sentence_history_original_sentence_id_fkey R
sentence_uuid uuid 2147483647 null
count_number varchar 2147483647 √ null
created_at timestamptz 35,6 null
created_by varchar 2147483647 null
created_prison varchar 2147483647 √ null
superseding_sentence_id int4 10 √ null
sentence.id sentence_superseding_sentence_id_fkey R
charge_id int4 10 √ null
charge.id sentence_charge_id_fkey R
sentence_serve_type varchar 2147483647 null
consecutive_to_id int4 10 √ null
sentence.id sentence_consecutive_to_id_fkey R
conviction_date date 13 √ null
sentence_type_id int4 10 √ null
sentence_type.id sentence_sentence_type_id_fkey R
legacy_data jsonb 2147483647 √ null
updated_at timestamptz 35,6 √ null
updated_by varchar 2147483647 √ null
updated_prison varchar 2147483647 √ null
fine_amount numeric 11,2 √ null
status_id varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
sentence_pkey Primary key Asc id
idx_sentence_booking_id Performance
idx_sentence_charge_id Performance Asc charge_id
idx_sentence_consecutive_to_id Performance Asc consecutive_to_id
idx_sentence_lifetime Performance Asc sentence_uuid
idx_sentence_status_id Performance Asc status_id
idx_sentence_superseding_sentence_id Performance Asc superseding_sentence_id

Relationships

Close relationships within degrees of separation