associations
| Name | Type | Storage | Nullable | Foreign Keys | Default Value & Notes |
|---|---|---|---|---|---|
| PKID | bigint | plain | Association ID | ||
| creator | integer | plain | users.ID | Creator user ID (defaults to authenticated user on creation) | |
| creationdate | bigint | plain | Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation) | ||
| lastmodified | bigint | plain | Default: EXTRACT(epoch FROM now())Last modification date and time as a Unix timestamp (auto-reset on modification) | ||
| entity1 | t_entity | plain | First canonical entity | ||
| entity2 | t_entity | plain | Second canonical entity | ||
| index1 | integer | plain | First entity ID | ||
| index2 | integer | plain | Second entity ID | ||
| relation | text | extended | Default: ''Relation | ||
| meta | json | extended | JSON-encoded metadata (object) |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| i_associations_entity2_index2 | btree | entity2, index2 | ||||
| pk_associations | btree | ID | ||||
| u_associations_entity1_index1_entity2_index2 | btree | entity1, index1, entity2, index2 |
| Name | Type |
|---|---|
| c_associations_entity | check |
| dc_associations_meta | check |
| dc_associations_relation | check |
| fk_associations_creator | foreign_key |
| pk_associations | primary_key |
| u_associations_entity1_index1_entity2_index2 | unique |
| Name | Type | Events | Function | Definition |
|---|---|---|---|---|
| tiu_associations_unique | before | insert, update | ftiu_associations_unique |
Loading...