groups2users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"groups2users_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_groups2users_creator N

The object creator

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

Last modification date/time (Unix timestamp in seconds)

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

Last modification date/time (Unix timestamp in seconds)

group int4 10 null
groups.ID FK_groups2users_group C
user int4 10 null
users.ID FK_groups2users_user C
writable int2 5 0

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_groups2users_ID Primary key Asc ID
UNQ_groups2users_group_user Must be unique Asc/Asc group + user

Relationships