categories


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null

Category ID
owneruser int4 10 √ null
users.ID fk_categories_owneruser C

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
ownergroup int4 10 √ null
groups.ID fk_categories_ownergroup C

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
creator int4 10 √ null
users.ID fk_categories_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)
entity text 2147483647 null

Canonical entity
name text 2147483647 null

Name

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_categories Primary key Asc ID
u_categories_entity_name Must be unique Asc/Asc entity + name
u_categories_ownergroup_entity_name Must be unique Asc/Asc/Asc ownergroup + entity + name
u_categories_owneruser_entity_name Must be unique Asc/Asc/Asc owneruser + entity + name

Relationships

Close relationships within degrees of separation