cwf_collectionrole

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
collectionrole_id serial 10 √ nextval('cwf_collectionrole_seq'::regclass)
role_id text 2147483647 √ null
collection_id uuid 2147483647 √ null
collection.uuid cwf_collectionrole_collection_id_fkey R
group_id uuid 2147483647 √ null
epersongroup.uuid cwf_collectionrole_group_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
cwf_collectionrole_pkey Primary key Asc collectionrole_id
cwf_collectionrole_coll_fk_idx Performance Asc collection_id
cwf_collectionrole_coll_role_fk_idx Performance Asc/Asc collection_id + role_id
cwf_collectionrole_unique Must be unique Asc/Asc/Asc role_id + collection_id + group_id

Relationships

Close relationships within degrees of separation