Assign User Mapping Table Schema (assign_user_mapping)


Description

Map an assignment specific id number to a user

assign_user_mapping table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
assignment BIGINT 19 0
assign.id assiusermapp_ass2_fk R
userid BIGINT 19 0
user.id assiusermapp_use2_fk R

Table contained -1 rows

assign_user_mapping table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assiusermapp_ass_ix Performance Asc assignment
assiusermapp_use_ix Performance Asc userid

assign_user_mapping table relationships

Close relationships within degrees of separation