action_profiles__t


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 null
action_to_mapping_profiles__t.master_profile_id action_to_mapping_profiles__t_master_profile_id_fkeyR
job_to_action_profiles__t.detail_profile_id job_to_action_profiles__t_detail_profile_id_fkeyR
match_to_action_profiles__t.detail_profile_id match_to_action_profiles__t_detail_profile_id_fkeyR
description varchar 171 √ null
folio_record varchar 18 √ null
name varchar 49 √ null
action varchar 6 √ null
deleted bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
action_profiles__t_pkey Primary key Asc id
action_profiles__t___origin_idx Performance Asc __origin
action_profiles__t___source_idx Performance Asc __source
action_profiles__t___start_idx Performance Asc __start
action_profiles__t_action_idx Performance Asc action
action_profiles__t_deleted_idx Performance Asc deleted
action_profiles__t_description_idx Performance Asc description
action_profiles__t_folio_record_idx Performance Asc folio_record
action_profiles__t_id_idx Performance Asc id
action_profiles__t_name_idx Performance Asc name

Relationships

Close relationships within degrees of separation