Column Type Size Nulls Auto Default Children Parents Comments
ID int8 19 null

Group-to-user ID

creator int4 10 null
users.ID fk_groups2users_creator N

Creator user ID (defaults to authenticated user on creation)

creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

group int4 10 null
groups.ID fk_groups2users_group C

Group ID

user int4 10 null
users.ID fk_groups2users_user C

User ID

writable int2 5 0

Allow writing of group-owned data by user

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_groups2users Primary key Asc ID
fk_groups2users_user Performance Asc user
u_groups2users_group_user Must be unique Asc/Asc group + user