job_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
profile__t.create_job_profile_id profile__t_create_job_profile_id_fkeyR
profile__t.update_job_profile_id profile__t_update_job_profile_id_fkeyR
job_to_action_profiles__t.master_profile_id job_to_action_profiles__t_master_profile_id_fkeyR
job_to_match_profiles__t.master_profile_id job_to_match_profiles__t_master_profile_id_fkeyR
match_to_action_profiles__t.job_profile_id match_to_action_profiles__t_job_profile_id_fkeyR
match_to_match_profiles__t.job_profile_id match_to_match_profiles__t_job_profile_id_fkeyR
profile_snapshots__t.profile_id profile_snapshots__t_profile_id_fkeyR
description varchar 204 √ null
name varchar 63 √ null
data_type varchar 4 √ null
deleted bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
job_profiles__t_pkey Primary key Asc id
job_profiles__t___origin_idx Performance Asc __origin
job_profiles__t___source_idx Performance Asc __source
job_profiles__t___start_idx Performance Asc __start
job_profiles__t_data_type_idx Performance Asc data_type
job_profiles__t_deleted_idx Performance Asc deleted
job_profiles__t_description_idx Performance Asc description
job_profiles__t_id_idx Performance Asc id
job_profiles__t_name_idx Performance Asc name

Relationships

Close relationships within degrees of separation