match_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
job_to_match_profiles__t.detail_profile_id job_to_match_profiles__t_detail_profile_id_fkeyR
match_to_action_profiles__t.master_profile_id match_to_action_profiles__t_master_profile_id_fkeyR
match_to_match_profiles__t.detail_profile_id match_to_match_profiles__t_detail_profile_id_fkeyR
match_to_match_profiles__t.master_profile_id match_to_match_profiles__t_master_profile_id_fkeyR
existing_record_type varchar 18 √ null
incoming_record_type varchar 18 √ null
name varchar 63 √ null
deleted bool 1 √ null
description varchar 116 √ null

Indexes

Constraint Name Type Sort Column(s)
match_profiles__t_pkey Primary key Asc id
match_profiles__t___origin_idx Performance Asc __origin
match_profiles__t___source_idx Performance Asc __source
match_profiles__t___start_idx Performance Asc __start
match_profiles__t_deleted_idx Performance Asc deleted
match_profiles__t_description_idx Performance Asc description
match_profiles__t_existing_record_type_idx Performance Asc existing_record_type
match_profiles__t_id_idx Performance Asc id
match_profiles__t_incoming_record_type_idx Performance Asc incoming_record_type
match_profiles__t_name_idx Performance Asc name

Relationships

Close relationships within degrees of separation