match_to_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
triggered bool 1 null
master_profile_id uuid 2147483647 null
match_profiles__t.id match_to_action_profiles__t_master_profile_id_fkeyR
detail_profile_type varchar 14 null
master_profile_type varchar 13 null
order numeric 131089 null
react_to varchar 5 null
job_profile_id uuid 2147483647 null
job_profiles__t.id match_to_action_profiles__t_job_profile_id_fkeyR
detail_profile_id uuid 2147483647 null
action_profiles__t.id match_to_action_profiles__t_detail_profile_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
match_to_action_profiles__t_pkey Primary key Asc __id
match_to_action_profiles__t___origin_idx Performance Asc __origin
match_to_action_profiles__t___source_idx Performance Asc __source
match_to_action_profiles__t___start_idx Performance Asc __start
match_to_action_profiles__t_detail_profile_id_idx Performance Asc detail_profile_id
match_to_action_profiles__t_detail_profile_type_idx Performance Asc detail_profile_type
match_to_action_profiles__t_id_idx Performance Asc id
match_to_action_profiles__t_job_profile_id_idx Performance Asc job_profile_id
match_to_action_profiles__t_master_profile_id_idx Performance Asc master_profile_id
match_to_action_profiles__t_master_profile_type_idx Performance Asc master_profile_type
match_to_action_profiles__t_order_idx Performance Asc order
match_to_action_profiles__t_react_to_idx Performance Asc react_to
match_to_action_profiles__t_triggered_idx Performance Asc triggered

Relationships