davservers

Module: control

CalDAV/CardDAV server configurations for sync.

Name	Type	Nullable	Default Value	Notes
PKID	integer			DAV server ID
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)
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)
recipientuser users.ID	integer			Recipient user ID (PUBLIC if `recipientuser`=`null` and `recipientgroup`=`null`)
recipientgroup groups.ID	integer			Recipient group ID (PUBLIC if `recipientuser`=`null` and `recipientgroup`=`null`)
activity	smallint		0	Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
name	text			Name
type	smallint		0	Collection type (`0`=CONTACTS, `2`=APPOINTMENTS, `1`=TASKS)
url	text			Endpoint URL
username	text		''	Username
ctag	text		''	Collection entity tag (CTag) (caldav-ctag-03)
synctoken	text		''	Synchronization token (RFC 6578)
description	text		''	Detailed general description
password	bytea

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_davservers_ownergroup					gin	ownergroup
fk_davservers_owneruser					gin	owneruser
i_davservers_noowner					gin	ownergroup
pk_davservers					btree	ID
s_davservers_name					gin	name
s_davservers_url					gin	url

Name	Type
c_davservers_owner	check
c_davservers_recipient	check
dc_davservers_activity	check
dc_davservers_description	check
dc_davservers_name	check
dc_davservers_type	check
dc_davservers_url	check
dc_davservers_username	check
fk_davservers_ownergroup	foreign_key
fk_davservers_owneruser	foreign_key
fk_davservers_recipientgroup	foreign_key
fk_davservers_recipientuser	foreign_key
pk_davservers	primary_key

Name	Type	Events	Function	Definition
tu_davservers_type	before	update	ft_integrity

Loading...