| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ID | int4 | 10 | √ | null |
|
|
DAV server ID |
|||
| owneruser | int4 | 10 | √ | null |
|
|
Owner user ID (PUBLIC if |
|||
| ownergroup | int4 | 10 | √ | null |
|
|
Owner group ID (PUBLIC if |
|||
| creator | int4 | 10 | √ | null |
|
|
Creator user ID (defaults to authenticated user on creation) |
|||
| creationdate | int8 | 19 | date_part('epoch'::text, now()) |
|
|
Creation date and time as a Unix time stamp (defaults to current date and time on creation) |
||||
| lastmodified | int8 | 19 | date_part('epoch'::text, now()) |
|
|
Last modification date and time as a Unix time stamp (auto-reset on modification) |
||||
| recipientuser | int4 | 10 | √ | null |
|
|
Recipient user ID (PUBLIC if |
|||
| recipientgroup | int4 | 10 | √ | null |
|
|
Recipient group ID (PUBLIC if |
|||
| activity | int2 | 5 | 0 |
|
|
Activity ( |
||||
| name | text | 2147483647 | null |
|
|
Name |
||||
| type | int2 | 5 | 0 |
|
|
Collection type ( |
||||
| url | text | 2147483647 | null |
|
|
Endpoint URL |
||||
| username | text | 2147483647 | ''::text |
|
|
Username |
||||
| password | text | 2147483647 | ''::text |
|
|
|||||
| ctag | text | 2147483647 | ''::text |
|
|
Collection entity tag (CTag) (caldav-ctag-03) |
||||
| synctoken | text | 2147483647 | ''::text |
|
|
Synchronization token (RFC 6578) |
||||
| description | text | 2147483647 | ''::text |
|
|
Detailed general description |
Table contained 0 rows
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_davservers | Primary key | Asc | ID |
| i_davservers_noowner | Performance | Asc | ownergroup |
| i_davservers_owner | Performance | Asc/Asc | owneruser + ownergroup |
| s_davservers | Performance | Asc/Asc/Asc | name + url + username |
