groups2users

Module: admin

Junction table linking users to groups with write permissions.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Group-to-user ID
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
group groups.ID	integer			Group ID (**dependency**)
user users.ID	integer			User ID (**dependency**)
writable	smallint		0	Allow writing of group-owned data by user

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_groups2users_user					btree	user
pk_groups2users					btree	ID
u_groups2users_group_user					btree	group, user

Name	Type
fk_groups2users_group	foreign_key
fk_groups2users_user	foreign_key
pk_groups2users	primary_key
u_groups2users_group_user	unique

Loading...