t18release
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
app_goal_user_assignment
0
rows
Description
Stores the user assignments of goals
Columns
Related columns
Constraint
Comments
Search:
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
Showing 1 to 9 of 9 entries
Previous
1
Next
Indexes
Search:
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
Showing 1 to 3 of 3 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One
Two degrees
