Skip to main content

links

NameTypeStorageNullableForeign KeysDefault Value & Notes
PKIDintegerplainLink ID
forkintegerplainforks.IDFork ID (`null` for base module)
owneruserintegerplainusers.IDOwner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroupintegerplaingroups.IDOwner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creatorintegerplainusers.IDCreator user ID (defaults to authenticated user on creation)
assigneduserintegerplainusers.IDAssigned user ID
creationdatebigintplainDefault: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodifiedbigintplainDefault: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
visibilitysmallintplainDefault: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
nametextmainName
urltextmainDefault: ''URL
expdatebigintplainExpiry date as a Unix timestamp
usernametextextendedDefault: ''Username
passwordtextextendedDefault: ''Password (empty if encrypted)
visitsintegerplainDefault: 0Number of visits
descriptiontextextendedDefault: ''Detailed general description
password_encryptedbyteaextendedNo description provided.
otpsecretbyteaextendedNo description provided.
NameUniqueNulls DistinctPrimaryPartialMethodKeys
fk_links_assigneduserginassigneduser
fk_links_forkginfork
fk_links_ownergroupginownergroup
fk_links_owneruserginowneruser
i_links_noforkginfork
i_links_noownerginownergroup
pk_linksbtreeID
s_links_nameginname
s_links_urlginurl
NameType
c_links_ownercheck
c_links_passwordcheck
dc_links_descriptioncheck
dc_links_namecheck
dc_links_urlcheck
dc_links_usernamecheck
dc_links_visibilitycheck
dc_links_visitscheck
fk_links_assigneduserforeign_key
fk_links_creatorforeign_key
fk_links_forkforeign_key
fk_links_ownergroupforeign_key
fk_links_owneruserforeign_key
pk_linksprimary_key
Loading...