Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"associations_ID_seq"'::regclass)
creator int4 10 null

The object creator

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

Last modification date/time (Unix timestamp in seconds)

entity1 TP_entity 2147483647 null

First entity name (e.g. "tasks")

entity2 TP_entity 2147483647 null

Second entity name (e.g. "contracts")

index1 int4 10 null

First object ID

index2 int4 10 null

Second object ID

relation text 2147483647 ''::text

Relationship name

meta json 2147483647 null

Optional meta data

Table contained 0 rows


Constraint Name Type Sort Column(s)
PK_associations_ID Primary key Asc ID
IDX_associations_entity2_index2 Performance Asc/Asc entity2 + index2
UNQ_associations_entity1_index1_entity2_index2 Must be unique Asc/Asc/Asc/Asc entity1 + index1 + entity2 + index2