likes
User likes on activity records.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | bigint | Like 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) | |
record records.ID | bigint | Record ID (**dependency**) |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| pk_likes | btree | ID | ||||
| u_likes_record_creator | btree | record, creator |
| Name | Type |
|---|---|
| fk_likes_creator | foreign_key |
| fk_likes_record | foreign_key |
| pk_likes | primary_key |
| u_likes_record_creator | unique |
Loading...