This table stores Portal Library content attributes such as the location, mime type, file name, etc.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectkey | integer | not null | |
| locale | nvarchar(10) | with null | The column is to denote the locale of the document. The value in this column is not actively used by Portal. (The value is always "en_US" unless explicitely set by XML-API). |
| filename | nvarchar(1024) | with null | The filename of the document if it exists. Blank if no filename exists (like on folders or channels). |
| location | integer | with null | The location of the document in the Portal Library hiearchy. It is the parent key (objectkey) of the parent folder or channel or -1 if this is a root level folder. |
| doctype | nvarchar(100) | with null | The mimetype of the document. |
| mountptr | integer | with null | The integer representing which mount point the files bytes are stored on. The mount points are configured on a per-server basis and not stored in the database. |
| version | integer | with null | The version number of the document. This field is not actively used by Portal and the value is always 0. |
| headline | nvarchar(100) | with null | The headline for a document. This field is not actively used by portal and is always blank unless explicitly set through XML-API. (Last used in CleverPath Portal r3) |
| expires | integer | with null | Seconds since the Unix Epoch describing the date that this document will expire. Value is -1 if it is not set to expire. |
| docsize | integer | with null | The size in bytes of the document. If this is not a document with bytes (folder, channel, link, etc...) the value is 0. |
| serverkey | integer | with null | The server key of the server that the document was published to. In a distributed repository, this is also the server that holds the bytes of the documents. |
| proxy | integer | with null | Boolean value (0/1) of whether or not Portal should proxy this document.) A proxied document is fetched by the Portal on the users behalf. |
| target | nvarchar(40) | with null | The HTML target of this document. This is used for the target feature of the library which can open a document in a new window, in the current frame or take over the whole browser on serve. |
| shortcut | integer | with null | If the document is a shortcut, than this field is the objectkey of the document it points to. If it is not a shortcut, the value is -1. |
| relativeuri | nvarchar(1024) | with null | The unique URI of the document relative to the library. Folders and Channels do not have URIs, but documents include their parent folders in their URIs. These URIs are used to serve documents in the library. |
| schedule | integer | with null | The interval in minutes to schedule content to be refreshed. This only affects certain content like dynamic content. |
| isrequired | nvarchar(10) | with null | True/false value of whether or not a document is required on the user's required workplace. |
| isconfigurable | nvarchar(10) | with null | True/false value of whether or not a document is configurable. (DynamicContent is configurable content) |
| isminimizable | nvarchar(10) | with null | Dual purpose field that holds whether or not a document is
minimizable or detachable.
Valid values: true - minimizable/detachable false - not minimizable/detachable t+d - minimizable/detachable t-d - minimizable/not detachable f+d - not minimizable/detachable t-f - not minimizable/not detachable |
Product Name: Portal
Table Type: Table