Skip to main content

likes

Module: main

User likes on activity records.

NameTypeNullableDefault ValueNotes
PKID
bigintLike ID
creator
users.ID
integerCreator user ID (defaults to authenticated user on creation)
creationdate
bigintdate_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified
bigintEXTRACT(epoch FROM now())Last modification date and time as a Unix timestamp (auto-reset on modification)
record
records.ID
bigintRecord ID (**dependency**)
NameUniqueNulls DistinctPrimaryPartialMethodKeys
pk_likesbtreeID
u_likes_record_creatorbtreerecord, creator
NameType
fk_likes_creatorforeign_key
fk_likes_recordforeign_key
pk_likesprimary_key
u_likes_record_creatorunique
Loading...