roleassignment

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('roleassignment_id_seq'::regclass)
assigneeidentifier varchar 255 null
privateurlanonymizedaccess bool 1 null
privateurltoken varchar 255 null
definitionpoint_id int8 19 null
dvobject.id fk_roleassignment_definitionpoint_idR
role_id int8 19 null
dataverserole.id fk_roleassignment_role_idR

Indexes

Constraint Name Type Sort Column(s)
roleassignment_pkey Primary key Asc id
index_roleassignment_assigneeidentifier Performance Asc assigneeidentifier
index_roleassignment_definitionpoint_id Performance Asc definitionpoint_id
index_roleassignment_role_id Performance Asc role_id
unq_roleassignment_0 Must be unique Asc/Asc/Asc assigneeidentifier + role_id + definitionpoint_id

Relationships