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

Association ID

creator int4 10 null

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)

entity1 text 2147483647 null

First canonical entity

entity2 text 2147483647 null

Second canonical entity

index1 int4 10 null

First entity ID

index2 int4 10 null

Second entity ID

relation text 2147483647 ''::text
meta json 2147483647 null

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_associations Primary key Asc ID
i_associations_entity2_index2 Performance Asc/Asc entity2 + index2
u_associations_entity1_index1_entity2_index2 Must be unique Asc/Asc/Asc/Asc entity1 + index1 + entity2 + index2