categories


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"categories_ID_seq"'::regclass)
owneruser int4 10 null
users.ID FK_categories_owneruser C

The owner user

ownergroup int4 10 null
groups.ID FK_categories_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_categories_creator N

The object creator

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

Last modification date/time (Unix timestamp in seconds)

entity text 2147483647 null

The referenced entity name (e.g. "contacts")

name text 2147483647 null

Category name

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_categories_ID Primary key Asc ID
UNQ_categories_entity_name Must be unique Asc/Asc entity + name
UNQ_categories_ownergroup_entity_name Must be unique Asc/Asc/Asc ownergroup + entity + name
UNQ_categories_owneruser_entity_name Must be unique Asc/Asc/Asc owneruser + entity + name

Relationships