The Portal object table is the most important table in the system. All Portal Users, Groups, Templates, and Documents must have a row in this table. Permissions for documents are stored in this table using a "UNIX-like" permissions scheme.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectkey | integer | not null | |
| objecttypekey | integer | with null | An integer value 0 through 11 representing the type of
object this entry is refering to.
Valid Values: TYPE_USER = 0 TYPE_GROUP = 1 TYPE_FOLDER = 2 TYPE_DOCUMENT = 3 TYPE_CHANNEL = 4; TYPE_MESSENGER = 5 (Unused) TYPE_PUBLISHER = 6 TYPE_NEWSCOMPONENT = 7 (Unused) TYPE_MESSAGE = 9 (Same discussion) TYPE_TEMPLATE = 10 TYPE_DISCUSSION = 11 |
| objectname | nvarchar(100) | with null | The name of this object. (This is the Title value from the Portal publish UI.) |
| ownerid | integer | with null | The owner user id of this object. |
| groupowner | integer | with null | |
| ownerreadpriv | integer | with null | Boolean value 0/1 representing if this object has owner read privilege. |
| ownerwritepriv | integer | with null | Boolean value 0/1 representing if this object has owner write privilege. |
| ownerexecutepriv | integer | with null | Boolean value 0/1 representing if this object has owner execute privilege. |
| groupreadpriv | integer | with null | Boolean value 0/1 representing if this object has group read privilege. |
| groupwritepriv | integer | with null | Boolean value 0/1 representing if this object has group write privilege. |
| groupexecutepriv | integer | with null | Boolean value 0/1 representing if this object has group execute privilege. |
| entreadpriv | integer | with null | Boolean value 0/1 representing if this object has enterprise read privilege. |
| entwritepriv | integer | with null | Boolean value 0/1 representing if this object has enterprise write privilege. |
| entexecutepriv | integer | with null | Boolean value 0/1 representing if this object has enterprise execute privilege. |
| creator | integer | with null | The user id of the creator of this document. |
| createdate | integer | with null | Seconds since the epoch when this document was created. |
| lastmodifiedby | integer | with null | The user id of the user which last modified this document. The value is -1 if that document has not been modified. |
| validationcode | integer | with null | Integer value that resolves to a users permission level such as guest mode, and knowledge access. |
| validationdatetime | integer | with null | Seconds since the epoch that the validation code was
generated.
(This field is not used by Portal) |
| validatedby | integer | with null | (This field is not used by Portal) |
| messagecount | integer | with null | The number of discussion board postings attached to a Library document. |
| description | nvarchar(255) | with null | A description of this object. |
| lastmoddatetime | integer | with null | Seconds since the epoch describing the last time this object was modified. |
| password | nvarchar(254) | with null | Base64 encoded password for this object. This can be a user's password, or a document's password. |
Product Name: Portal
Table Type: Table