Database/Tables/Collection
From DAViCal Wiki
Missing languages
• አማርኛ • العربية • Български • Brezhoneg • Bosanski • Català • Česky • Dansk • Deutsch • Ελληνικά • Esperanto • Español • Eesti • Euskara • Suomi • Frysk • Créole guadeloupéen • עברית • Hrvatski • Magyar • Հայերեն • Interlingua • Íslenska • Italiano • 日本語 • 한국어 • Lëtzebuergesch • Lietuvių • Latviešu • Македонски • Nederlands • Norsk (nynorsk) • Norsk (bokmål) • Polski • Português • Português do Brasil • Română • Română (Moldova) • Русский • Slovenčina • Slovenščina • Shqip • Svenska • Türkçe • Українська • Tiếng Việt • 中文(简体) • 中文(繁體)
Description
This table stores information on "collections". A collection (in DAV terms) is like a directory which will contain files (DAV resources). In our case collections are usually collections of calendar resources.
Fields
| Column | Type | Not Null | Defaut | Comment |
| user_no | integer | NOT NULL | references usr(user_no) of the owner | |
| parent_container | text | references any parent collection which contains this one | ||
| dav_name | text | NOT NULL | essentially the pathname within the DAV space (after caldav.php in URL) | |
| dav_etag | text | an ETag as defined in HTTP/1.1 - a string which will be invariant until the contents have changed (in our case a hash of the contents) | ||
| dav_displayname | text | A user-friendly name to display when a client requests the DAV::displayname property | ||
| is_calendar | boolean | Whether this DAV collection is also a CalDAV calendar collection | ||
| created | timestamp with time zone | |||
| modified | timestamp with time zone | |||
| public_events_only | boolean | NOT NULL | false | Whether this calendar should refuse to store PRIVATE or CONFIDENTIAL events. |
| publicly_readable | boolean | NOT NULL | false | Whether this entire calendar should be readable by anyone. |
| collection_id | bigint | NOT NULL | nextval | A unique ID |
