groups2users

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Group-to-user ID
creator	integer	plain		users.ID	Creator user ID (defaults to authenticated user on creation)
creationdate	bigint	plain			Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint	plain			Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
group	integer	plain		groups.ID	Group ID (**dependency**)
user	integer	plain		users.ID	User ID (**dependency**)
writable	smallint	plain			Default: 0Allow 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_creator	foreign_key
fk_groups2users_group	foreign_key
fk_groups2users_user	foreign_key
pk_groups2users	primary_key
u_groups2users_group_user	unique

Loading...