links

Module: links

Bookmarked URLs with credentials and visit tracking.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Link ID
fork forks.ID	integer			Fork ID (`null` for base module)
owneruser users.ID	integer			Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroup groups.ID	integer			Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creator	integer			Creator user ID (defaults to authenticated user on creation)
assigneduser users.ID	integer			Assigned user ID
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
visibility	smallint		0	Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text			Name
url	text		''	URL
expdate	bigint			Expiry date as a Unix timestamp
username	text		''	Username
password	text		''	Password (empty if encrypted)
visits	integer		0	Number of visits
description	text		''	Detailed general description
password_encrypted	bytea
otpsecret	bytea

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_links_assigneduser					gin	assigneduser
fk_links_fork					gin	fork
fk_links_ownergroup					gin	ownergroup
fk_links_owneruser					gin	owneruser
i_links_nofork					gin	fork
i_links_noowner					gin	ownergroup
pk_links					btree	ID
s_links_name					gin	name
s_links_url					gin	url

Name	Type
c_links_owner	check
c_links_password	check
dc_links_description	check
dc_links_name	check
dc_links_url	check
dc_links_username	check
dc_links_visibility	check
dc_links_visits	check
fk_links_assigneduser	foreign_key
fk_links_fork	foreign_key
fk_links_ownergroup	foreign_key
fk_links_owneruser	foreign_key
pk_links	primary_key

Loading...