0 rows


Mapping of tracks to user group assignments


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_perform_track_assignment_id_seq'::regclass)
app_perform_track_user_assignment_via.track_assignment_id Defined in XMLR
track_id int8 19 0 Defined in XMLR
type int2 5 null
user_group_type int2 5 null
user_group_id int8 19 0
created_by int8 19 null
created_at int8 19 null
updated_at int8 19 null
expand int2 5 0


Constraint Name Type Sort Column(s)
app_perftracassi_id_pk Primary key Asc id
app_perftracassi_tra_ix Performance Asc track_id
app_perftracassi_tratypuse_uix Must be unique Asc/Asc/Asc/Asc track_id + type + user_group_type + user_group_id
app_perftracassi_use2_ix Performance Asc user_group_id
app_perftracassi_use_ix Performance Asc user_group_type
app_perftracassi_useuse_ix Performance Asc/Asc user_group_type + user_group_id