app_perform_track_assignment

0 rows


Description

Mapping of tracks to user group assignments

Columns

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 XML R
track_id int8 19 0
app_perform_track.id Defined in XML R
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

Indexes

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

Relationships