policy

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
code varchar 16 null
allocation.policy_code allocation_policy_code_fkey R
allocation_audit.policy_code Implied Constraint R
case_note_type_recorded_event_type.policy_code Implied Constraint R
prison_configuration.policy_code prison_configuration_policy_code_fkey R
prison_configuration_audit.policy_code Implied Constraint R
prison_statistic.policy_code prison_statistic_policy_code_fkey R
prisoner_statistic.policy_code fk_prisoner_statistic_policy_code R
recorded_event.policy_code recorded_event_policy_code_fkey R
recorded_event_audit.policy_code recorded_event_audit_policy_code_fkey R
reference_data_policy.policy_code reference_data_policy_policy_code_fkey R
staff_configuration.policy_code staff_configuration_policy_code_fkey R
staff_configuration_audit.policy_code Implied Constraint R
staff_role.policy_code Implied Constraint R
staff_role_audit.policy_code Implied Constraint R
description varchar 255 null

Indexes

Constraint Name Type Sort Column(s)
policy_pkey Primary key Asc code

Relationships

Close relationships within degrees of separation