app_goal_user_assignment

0 rows


Description

Stores the user assignments of goals

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_goal_user_assignment_id_seq'::regclass)
assigntype int2 5 null
assignmentid int8 19 null
goalid int8 19 null
app_goal.id Defined in XML R
userid int8 19 null
app_user.id Defined in XML R
extrainfo varchar 255 null
timecreated int8 19 0
timemodified int8 19 null
usermodified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_goaluserassi_id_pk Primary key Asc id
app_goaluserassi_goa_ix Performance Asc goalid
app_goaluserassi_use_ix Performance Asc userid

Relationships