follows
User follows for entity notifications.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | bigint | Follow ID | ||
creator users.ID | integer | Creator user ID (defaults to authenticated user on creation) | ||
creationdate | bigint | date_part('epoch', now()) | Creation date and time as a Unix timestamp (defaults to current date and time on creation) | |
lastmodified | bigint | EXTRACT(epoch FROM now()) | Last modification date and time as a Unix timestamp (auto-reset on modification) | |
entity | t_entity | Canonical entity | ||
index | bigint | Entity ID |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| pk_follows | btree | ID | ||||
| u_follows_entity_creator_index | btree | entity, creator, index |
| Name | Type |
|---|---|
| c_follows_entity | check |
| fk_follows_creator | foreign_key |
| pk_follows | primary_key |
| u_follows_entity_creator_index | unique |
Loading...