Dodeca Repository Schema Reference
|
The Dodeca repository schema is an implementation detail and may change between releases. This reference is provided for troubleshooting and diagnostic purposes only. Use supported Dodeca APIs and tools to read or modify repository content; do not build integrations that depend on direct access to repository tables. |
This reference describes the physical schema created by the Dodeca 8.9 repository migrations. It is generated from a fully migrated repository so that table and column descriptions remain aligned with the shipped schema.
Physical Relationship Diagram
The diagram shows relationships declared by primary-key and foreign-key constraints. Logical relationships that are not enforced by a database constraint are not shown.
Table and Column Reference
The Key column identifies primary-key (PK) and foreign-key (FK) columns.
Relationship tables list the referenced table and column for each declared foreign-key constraint.
BINARY_ARTIFACT_FOLDER_ITEMS
Associates binary artifacts with folders.
| Column | Data Type | Key | Description |
|---|---|---|---|
ARTIFACT_CATEGORY |
CHARACTER VARYING(80) |
PK, FK |
Artifact category for the folder item. |
ARTIFACT_ID |
CHARACTER VARYING(100) |
PK, FK |
Artifact identifier for the folder item. |
ARTIFACT_TENANT |
CHARACTER VARYING(100) |
PK, FK |
Tenant that owns the artifact. |
ARTIFACT_VERSION |
INTEGER |
PK, FK |
Artifact version in the folder. |
FOLDER_ID |
CHARACTER VARYING(36) |
PK, FK |
Folder identifier containing the artifact. |
FOLDER_TENANT |
CHARACTER VARYING(100) |
PK, FK |
Tenant that owns the folder. |
| Constraint | Column | References |
|---|---|---|
FK_BINARTFOLITE_ON_BINARY_ARTIFACT |
ARTIFACT_TENANT |
BINARY_ARTIFACTS.ARTIFACT_TENANT |
FK_BINARTFOLITE_ON_BINARY_ARTIFACT |
ARTIFACT_ID |
BINARY_ARTIFACTS.ARTIFACT_ID |
FK_BINARTFOLITE_ON_BINARY_ARTIFACT |
ARTIFACT_CATEGORY |
BINARY_ARTIFACTS.ARTIFACT_CATEGORY |
FK_BINARTFOLITE_ON_BINARY_ARTIFACT |
ARTIFACT_VERSION |
BINARY_ARTIFACTS.ARTIFACT_VERSION |
FK_BINARTFOLITE_ON_BINARY_ARTIFACT_FOLDER |
FOLDER_TENANT |
BINARY_ARTIFACT_FOLDERS.FOLDER_TENANT |
FK_BINARTFOLITE_ON_BINARY_ARTIFACT_FOLDER |
FOLDER_ID |
BINARY_ARTIFACT_FOLDERS.FOLDER_ID |
BINARY_ARTIFACT_FOLDERS
Organizes binary artifacts into tenant-scoped folders.
| Column | Data Type | Key | Description |
|---|---|---|---|
FOLDER_TENANT |
CHARACTER VARYING(100) |
PK |
Tenant that owns the folder. |
FOLDER_ID |
CHARACTER VARYING(36) |
PK |
Folder identifier. |
FOLDER_NAME |
CHARACTER VARYING(255) |
Display name for the folder. |
|
CREATED_DATE |
CHARACTER VARYING(19) |
Timestamp when the folder was created. |
|
IS_HIDDEN |
BOOLEAN |
Indicates whether the folder is hidden from normal listings. |
|
PARENT_FOLDER_TENANT |
CHARACTER VARYING(100) |
FK |
Tenant of the parent folder. |
PARENT_FOLDER_ID |
CHARACTER VARYING(36) |
FK |
Identifier of the parent folder. |
| Constraint | Column | References |
|---|---|---|
FK_BINARY_ARTIFACT_FOLDERS_ON_PAFOTEPAFOID |
PARENT_FOLDER_TENANT |
BINARY_ARTIFACT_FOLDERS.FOLDER_TENANT |
FK_BINARY_ARTIFACT_FOLDERS_ON_PAFOTEPAFOID |
PARENT_FOLDER_ID |
BINARY_ARTIFACT_FOLDERS.FOLDER_ID |
BINARY_ARTIFACT_LOCKS
Tracks temporary locks on binary artifacts.
| Column | Data Type | Key | Description |
|---|---|---|---|
BINARY_ARTIFACT_LOCK_ID |
CHARACTER VARYING(255) |
PK |
Lock record identifier. |
ARTIFACT_TENANT |
CHARACTER VARYING(100) |
Tenant that owns the locked artifact. |
|
ARTIFACT_CATEGORY |
CHARACTER VARYING(80) |
Category of the locked artifact. |
|
ARTIFACT_ID |
CHARACTER VARYING(100) |
Identifier of the locked artifact. |
|
ARTIFACT_VERSION |
INTEGER |
Version of the locked artifact. |
|
CREATED_DATE |
CHARACTER VARYING(19) |
Timestamp when the lock was created. |
|
USER_ID |
CHARACTER VARYING(120) |
User associated with the lock. |
|
LOCK_TYPE |
CHARACTER VARYING(50) |
Type of lock, such as system or user. |
BINARY_ARTIFACTS
Stores versioned repository artifacts and their encoded payloads.
| Column | Data Type | Key | Description |
|---|---|---|---|
ARTIFACT_TENANT |
CHARACTER VARYING(100) |
PK |
Tenant that owns the artifact. |
ARTIFACT_CATEGORY |
CHARACTER VARYING(80) |
PK |
Artifact category used to group repository content. |
ARTIFACT_ID |
CHARACTER VARYING(100) |
PK |
Artifact identifier within the tenant and category. |
ARTIFACT_VERSION |
INTEGER |
PK |
Version number of the artifact. |
CHECKSUM |
CHARACTER VARYING(128) |
Checksum of the artifact content. |
|
ARTIFACT_TYPE |
CHARACTER VARYING(80) |
Artifact content type or logical subtype. |
|
USER_ID |
CHARACTER VARYING(255) |
User associated with the artifact. |
|
ARTIFACT_NAME |
CHARACTER VARYING(255) |
Display name for the artifact. |
|
ARTIFACT_DESCRIPTION |
CHARACTER LARGE OBJECT |
Long-form artifact description. |
|
FILENAME |
CHARACTER VARYING(255) |
Original or exported file name. |
|
FILE_CREATION_DATETIME |
CHARACTER VARYING(50) |
Creation timestamp from the source file metadata. |
|
FILE_MODIFIED_DATETIME |
CHARACTER VARYING(50) |
Modified timestamp from the source file metadata. |
|
CREATED_BY |
CHARACTER VARYING(50) |
User that created the artifact record. |
|
CREATED_DATE |
CHARACTER VARYING(50) |
Timestamp when the artifact record was created. |
|
UPDATED_BY |
CHARACTER VARYING(50) |
User that last updated the artifact record. |
|
UPDATED_DATE |
CHARACTER VARYING(50) |
Timestamp when the artifact record was last updated. |
|
ENCODED_ARTIFACT |
CHARACTER LARGE OBJECT |
Encoded artifact payload. |
|
IMPORTED_BY |
CHARACTER VARYING(50) |
User that imported the artifact. |
|
IMPORTED_DATE |
CHARACTER VARYING(50) |
Timestamp when the artifact was imported. |
BINARY_OBJECTS
Stores deduplicated binary file contents referenced by attachments.
| Column | Data Type | Key | Description |
|---|---|---|---|
OBJECT_CHECKSUM |
CHARACTER VARYING(64) |
PK |
Checksum identifier for the stored binary content. |
SIZE_BYTES |
INTEGER |
Size of the binary content in bytes. |
|
CONTENTS |
BINARY LARGE OBJECT |
Raw binary content. |
COMMENT_ATTACHMENTS
Stores files attached to comment intersections.
| Column | Data Type | Key | Description |
|---|---|---|---|
COMMENT_TENANT |
CHARACTER VARYING(100) |
PK |
Tenant associated with the attachment. |
ATTACHMENT_ID |
CHARACTER VARYING(36) |
PK |
Attachment identifier. |
ATTACHMENT_DESCRIPTION |
CHARACTER VARYING(255) |
Optional attachment description. |
|
FILENAME |
CHARACTER VARYING(255) |
Original attachment file name. |
|
FILE_CREATION_DATETIME |
CHARACTER VARYING(50) |
Creation timestamp from the source file metadata. |
|
FILE_MODIFIED_DATETIME |
CHARACTER VARYING(50) |
Modified timestamp from the source file metadata. |
|
CREATED_BY |
CHARACTER VARYING(50) |
User that created the attachment record. |
|
CREATED_DATE |
CHARACTER VARYING(50) |
Timestamp when the attachment record was created. |
|
UPDATED_BY |
CHARACTER VARYING(50) |
User that last updated the attachment record. |
|
UPDATED_DATE |
CHARACTER VARYING(50) |
Timestamp when the attachment record was last updated. |
|
OBJECT_CHECKSUM |
CHARACTER VARYING(64) |
FK |
Checksum of the binary object for this attachment. |
SIZE_BYTES |
BIGINT |
Attachment size in bytes. |
|
INTERSECTION_KEY_HASH |
CHARACTER VARYING(64) |
FK |
Intersection key hash associated with the attachment. |
| Constraint | Column | References |
|---|---|---|
FKEK5R8U15KO26E97UC9DSB811F |
OBJECT_CHECKSUM |
BINARY_OBJECTS.OBJECT_CHECKSUM |
FKMYQNWWA4BAUJ1HGAGH4O7PRN9 |
INTERSECTION_KEY_HASH |
INTERSECTIONS.INTERSECTION_KEY_HASH |
COMMENT_AUDIT_LOG
Records create, update, and delete activity for comments.
| Column | Data Type | Key | Description |
|---|---|---|---|
COMMENT_AUDIT_LOG_ID |
UUID(16) |
PK |
Comment audit record identifier. |
TENANT |
CHARACTER VARYING(100) |
Tenant associated with the audited comment. |
|
COMMENT_ID |
CHARACTER VARYING(36) |
Identifier of the audited comment. |
|
COMMENT_KEY_HASH |
CHARACTER VARYING(128) |
Intersection key hash for the audited comment. |
|
COMMENT_TEXT |
CHARACTER LARGE OBJECT |
Comment text captured for the audit record. |
|
CONTEXT |
CHARACTER LARGE OBJECT |
Comment context captured for the audit record. |
|
SUBJECT |
CHARACTER VARYING(255) |
Comment subject captured for the audit record. |
|
CREATED_BY |
CHARACTER VARYING(50) |
User that caused the audit record. |
|
CREATED_DATE |
CHARACTER VARYING(50) |
Timestamp when the audit record was created. |
|
OPERATION_TYPE |
CHARACTER VARYING(255) |
Audited comment operation. |
|
VIEW_ID |
CHARACTER VARYING(100) |
Dodeca view identifier associated with the audited comment request. |
COMMENT_KEY_ITEMS
Stores key-value dimensions that identify comment intersections.
| Column | Data Type | Key | Description |
|---|---|---|---|
COMMENT_TENANT |
CHARACTER VARYING(100) |
PK, FK |
Tenant of the comment. |
COMMENT_ID |
CHARACTER VARYING(36) |
PK, FK |
Identifier of the comment. |
KEY_ITEM_KEY |
CHARACTER VARYING(255) |
PK |
Key item name. |
KEY_ITEM_VALUE |
CHARACTER VARYING(255) |
Key item value. |
| Constraint | Column | References |
|---|---|---|
FK4CFA7BA0FD127F51 |
COMMENT_TENANT |
COMMENTS.COMMENT_TENANT |
FK4CFA7BA0FD127F51 |
COMMENT_ID |
COMMENTS.COMMENT_ID |
COMMENTS
Stores analytic comments keyed by tenant and comment identifier.
| Column | Data Type | Key | Description |
|---|---|---|---|
COMMENT_TENANT |
CHARACTER VARYING(100) |
PK |
Tenant that owns the comment. |
COMMENT_ID |
CHARACTER VARYING(36) |
PK |
Comment identifier. |
COMMENT_KEY_HASH |
CHARACTER VARYING(128) |
Hash of the comment intersection key. |
|
SUBJECT |
CHARACTER VARYING(255) |
Comment subject. |
|
COMMENT_TEXT |
CHARACTER LARGE OBJECT |
Comment body text. |
|
CONTEXT |
CHARACTER LARGE OBJECT |
Context describing where the comment applies. |
|
PARENT_ID |
CHARACTER VARYING(36) |
Parent comment identifier for threaded comments. |
|
SORT_ORDER |
INTEGER |
Sort order within the comment set. |
|
CREATED_BY |
CHARACTER VARYING(50) |
User that created the comment. |
|
CREATED_DATE |
CHARACTER VARYING(50) |
Timestamp when the comment was created. |
|
UPDATED_BY |
CHARACTER VARYING(50) |
User that last updated the comment. |
|
UPDATED_DATE |
CHARACTER VARYING(50) |
Timestamp when the comment was last updated. |
DATA_AUDIT_LOG
Records data change audit events.
| Column | Data Type | Key | Description |
|---|---|---|---|
AUDIT_LOG_RECORD_NUMBER |
BIGINT |
PK |
Data audit record identifier. |
TENANT |
CHARACTER VARYING(255) |
Tenant associated with the data change. |
|
SERVER |
CHARACTER VARYING(255) |
Server associated with the data change. |
|
APPLICATION |
CHARACTER VARYING(255) |
Application associated with the data change. |
|
CUBE |
CHARACTER VARYING(255) |
Cube associated with the data change. |
|
USER_ID |
CHARACTER VARYING(255) |
User that made the data change. |
|
WORKSTATION_ID |
CHARACTER VARYING(255) |
Workstation that made the data change. |
|
CREATED_DATE |
CHARACTER VARYING(50) |
Timestamp when the data audit record was created. |
|
DESCRIPTION |
CHARACTER VARYING(255) |
Description of the data change. |
|
VIEW_ID |
CHARACTER VARYING(100) |
View identifier associated with the data change. |
DATA_AUDIT_LOG_DATAPOINTS
Stores dimensional coordinates for data audit items.
| Column | Data Type | Key | Description |
|---|---|---|---|
AUDIT_LOG_DATAPOINT_NUMBER |
BIGINT |
PK |
Data audit datapoint identifier. |
DIMENSION_NUMBER |
INTEGER |
Ordinal dimension number for the datapoint. |
|
MEMBER |
CHARACTER VARYING(255) |
Member name for the datapoint dimension. |
|
ALIAS |
CHARACTER VARYING(255) |
Member alias for the datapoint dimension. |
|
IS_PARENT |
BOOLEAN |
Indicates whether the member is a parent. |
|
AUDIT_LOG_ITEM_NUMBER |
BIGINT |
FK |
Data audit item that owns the datapoint. |
| Constraint | Column | References |
|---|---|---|
FK98FE5F81C1BFBE3A |
AUDIT_LOG_ITEM_NUMBER |
DATA_AUDIT_LOG_ITEMS.AUDIT_LOG_ITEM_NUMBER |
DATA_AUDIT_LOG_ITEMS
Stores value changes within data audit records.
| Column | Data Type | Key | Description |
|---|---|---|---|
AUDIT_LOG_ITEM_NUMBER |
BIGINT |
PK |
Data audit item identifier. |
OLD_VALUE |
DOUBLE PRECISION |
Value before the data change. |
|
NEW_VALUE |
DOUBLE PRECISION |
Value after the data change. |
|
AUDIT_LOG_RECORD_NUMBER |
BIGINT |
FK |
Data audit record that owns the item. |
| Constraint | Column | References |
|---|---|---|
FKB26CA8AC768FF7FA |
AUDIT_LOG_RECORD_NUMBER |
DATA_AUDIT_LOG.AUDIT_LOG_RECORD_NUMBER |
INTERSECTION_KEY_ITEMS
Stores key-value components for an intersection.
| Column | Data Type | Key | Description |
|---|---|---|---|
INTERSECTION_KEY_HASH |
CHARACTER VARYING(64) |
PK, FK |
Intersection key hash that owns the item. |
NAME |
CHARACTER VARYING(255) |
PK |
Intersection key item name. |
VALUE |
CHARACTER VARYING(255) |
Intersection key item value. |
| Constraint | Column | References |
|---|---|---|
FKBPMNJ1MJP6FI3Q2K8WG54GM5K |
INTERSECTION_KEY_HASH |
INTERSECTIONS.INTERSECTION_KEY_HASH |
INTERSECTIONS
Stores normalized intersection keys for comments and attachments.
| Column | Data Type | Key | Description |
|---|---|---|---|
INTERSECTION_KEY_HASH |
CHARACTER VARYING(64) |
PK |
Hash identifier for the intersection. |
DESCRIPTION |
CHARACTER VARYING(2000) |
Human-readable description of the intersection. |
METADATA_AUDIT_LOG
Records metadata change audit events.
| Column | Data Type | Key | Description |
|---|---|---|---|
AUDIT_LOG_RECORD_NUMBER |
BIGINT |
PK |
Metadata audit record identifier. |
MESSAGE |
CHARACTER VARYING(255) |
Audit message or operation name. |
|
TENANT |
CHARACTER VARYING(255) |
Tenant associated with the metadata change. |
|
CATEGORY |
CHARACTER VARYING(255) |
Artifact category associated with the metadata change. |
|
ID |
CHARACTER VARYING(255) |
Artifact identifier associated with the metadata change. |
|
VERSION |
INTEGER |
Artifact version associated with the metadata change. |
|
ENTITY_CLASS |
CHARACTER VARYING(255) |
Entity class that was changed. |
|
USER_ID |
CHARACTER VARYING(255) |
User that made the metadata change. |
|
WORKSTATION_ID |
CHARACTER VARYING(255) |
Workstation that made the metadata change. |
|
CREATED |
TIMESTAMP |
Timestamp when the metadata audit record was created. |
|
COMMENTS |
CHARACTER LARGE OBJECT |
Additional audit comments. |
METADATA_AUDIT_LOG_ITEMS
Stores property-level metadata audit changes.
| Column | Data Type | Key | Description |
|---|---|---|---|
AUDIT_LOG_ITEM_NUMBER |
BIGINT |
PK |
Metadata audit item identifier. |
PROPERTY |
CHARACTER VARYING(255) |
Changed property name. |
|
OLD_VALUE |
CHARACTER LARGE OBJECT |
Property value before the metadata change. |
|
NEW_VALUE |
CHARACTER LARGE OBJECT |
Property value after the metadata change. |
|
AUDIT_LOG_RECORD_NUMBER |
BIGINT |
FK |
Metadata audit record that owns the item. |
| Constraint | Column | References |
|---|---|---|
FKD4FA823190DD81A |
AUDIT_LOG_RECORD_NUMBER |
METADATA_AUDIT_LOG.AUDIT_LOG_RECORD_NUMBER |
PERMISSIONS
Defines repository permission types.
| Column | Data Type | Key | Description |
|---|---|---|---|
PERMISSION_ID |
CHARACTER VARYING(255) |
PK |
Permission identifier. |
NAME |
CHARACTER VARYING(255) |
Display name for the permission. |
|
DESCRIPTION |
CHARACTER VARYING(255) |
Description of the permission. |
SSO_TOKEN_ATTRIBUTES
Stores key-value attributes for SSO tokens.
| Column | Data Type | Key | Description |
|---|---|---|---|
NAME |
CHARACTER VARYING(120) |
PK |
Token attribute name. |
TOKEN_ID |
CHARACTER VARYING(255) |
PK, FK |
SSO token that owns the attribute. |
VALUE |
CHARACTER VARYING(120) |
PK |
Token attribute value. |
| Constraint | Column | References |
|---|---|---|
FK61B813CDB3A4B024 |
TOKEN_ID |
SSO_TOKENS.TOKEN_ID |
SSO_TOKENS
Stores single sign-on tokens issued for users.
| Column | Data Type | Key | Description |
|---|---|---|---|
TOKEN_ID |
CHARACTER VARYING(255) |
PK |
SSO token identifier. |
TENANT |
CHARACTER VARYING(100) |
Tenant associated with the token. |
|
APPLICATION |
CHARACTER VARYING(100) |
Application associated with the token. |
|
USER_ID |
CHARACTER VARYING(120) |
User associated with the token. |
|
CREATED_DATE |
CHARACTER VARYING(19) |
Timestamp when the token was created. |
|
VALID_UNTIL_DATE |
CHARACTER VARYING(19) |
Timestamp when the token expires. |
TENANT_CONFIGURATION
Stores name-value configuration for tenants.
| Column | Data Type | Key | Description |
|---|---|---|---|
TENANT_CONFIG_ID |
UUID(16) |
PK |
Tenant configuration record identifier. |
NAME |
CHARACTER VARYING(255) |
Tenant configuration name. |
|
VALUE |
CHARACTER VARYING(2000) |
Tenant configuration value. |
|
TENANT_ID |
UUID(16) |
FK |
Tenant that owns the configuration value. |
| Constraint | Column | References |
|---|---|---|
FK_TENANT_CONFIGURATION_TENANT |
TENANT_ID |
TENANTS.ID |
TENANTS
Stores tenant records for repository isolation.
| Column | Data Type | Key | Description |
|---|---|---|---|
ID |
UUID(16) |
PK |
Tenant record identifier. |
NAME |
CHARACTER VARYING(100) |
Unique tenant name. |
|
CREATED_DATE |
CHARACTER VARYING(50) |
Timestamp when the tenant was created. |
|
APPLICATION_ID |
CHARACTER VARYING(100) |
Application identifier for single-application tenants. |
|
TYPE |
CHARACTER VARYING(255) |
Tenant type. |
|
STATUS |
CHARACTER VARYING(255) |
Tenant status. |
USER_ROLE_MAPPINGS
Associates users with roles.
| Column | Data Type | Key | Description |
|---|---|---|---|
TENANT |
CHARACTER VARYING(100) |
PK |
Tenant of the user. |
APPLICATION |
CHARACTER VARYING(80) |
PK |
Application of the user. |
USER_ID |
CHARACTER VARYING(120) |
PK |
User identifier. |
CLIENT_TYPE |
INTEGER |
PK |
Client type for the user. |
ROLE |
CHARACTER VARYING(50) |
PK |
Role name assigned to the user. |
ROLE_TENANT |
CHARACTER VARYING(100) |
Tenant of the assigned role. |
USER_ROLE_PERMISSIONS
Associates roles with permissions.
| Column | Data Type | Key | Description |
|---|---|---|---|
PERMISSION_ID |
CHARACTER VARYING(255) |
PK, FK |
Permission assigned to the role. |
ROLE_TENANT |
CHARACTER VARYING(100) |
PK, FK |
Tenant of the role. |
ROLE_NAME |
CHARACTER VARYING(50) |
PK, FK |
Role name. |
| Constraint | Column | References |
|---|---|---|
FK_USEROLPER_ON_PERMISSION |
PERMISSION_ID |
PERMISSIONS.PERMISSION_ID |
FK_USEROLPER_ON_ROLE |
ROLE_TENANT |
USER_ROLES.TENANT |
FK_USEROLPER_ON_ROLE |
ROLE_NAME |
USER_ROLES.NAME |
USER_ROLES
Stores tenant-scoped roles.
| Column | Data Type | Key | Description |
|---|---|---|---|
TENANT |
CHARACTER VARYING(100) |
PK |
Tenant that owns the role. |
NAME |
CHARACTER VARYING(50) |
PK |
Role name. |
DESCRIPTION |
CHARACTER VARYING(255) |
Role description. |
USERS
Stores application user records and client telemetry.
| Column | Data Type | Key | Description |
|---|---|---|---|
TENANT |
CHARACTER VARYING(100) |
PK |
Tenant that owns the user. |
APPLICATION |
CHARACTER VARYING(80) |
PK |
Application associated with the user. |
USER_ID |
CHARACTER VARYING(120) |
PK |
User identifier. |
CLIENT_TYPE |
INTEGER |
PK |
Client type for the user. |
AUTHENTICATED_USERNAME |
CHARACTER VARYING(150) |
Last authenticated username for the user. |
|
USER_PRIVILEGES |
INTEGER |
Bitmask of user privileges. |
|
USER_ENABLED |
BOOLEAN |
Indicates whether the user is enabled. |
|
USER_ADMIN |
BOOLEAN |
Indicates whether the user is an administrator. |
|
USER_READ_ONLY |
BOOLEAN |
Unused read-only user flag. |
|
LOGIN_COUNT |
INTEGER |
Number of recorded logins. |
|
FIRST_LOGIN_DATE |
CHARACTER VARYING(19) |
Timestamp of the first recorded login. |
|
LAST_LOGIN_DATE |
CHARACTER VARYING(19) |
Timestamp of the last recorded login. |
|
USER_COMMENT |
CHARACTER VARYING(255) |
Administrative comment for the user. |
|
LAST_CLIENT_VERSION |
CHARACTER VARYING(22) |
Last reported client version. |
|
LAST_CLIENT_LAUNCH_MODE |
CHARACTER VARYING(15) |
Last reported client launch mode. |
|
LAST_WORKSTATION_ID |
CHARACTER VARYING(64) |
Last reported workstation identifier. |
|
LAST_PROCESSOR |
CHARACTER VARYING(70) |
Last reported client processor. |
|
LAST_ACCELERATED_FLAG |
BOOLEAN |
Last reported acceleration flag. |
|
LAST_CLIENT_OS |
CHARACTER VARYING(70) |
Last reported client operating system. |
|
LAST_IP_ADDRESS |
CHARACTER VARYING(20) |
Last reported client IP address. |
|
LAST_CLIENT_MEMORY |
CHARACTER VARYING(25) |
Last reported client memory. |
|
LAST_CLIENT_EXCEL_VERSION |
CHARACTER VARYING(30) |
Last reported Excel version. |
|
LAST_CLIENT_IE_VERSION |
CHARACTER VARYING(20) |
Last reported Internet Explorer version. |
|
LAST_CLIENT_VSTO_RUNTIME |
CHARACTER VARYING(15) |
Last reported VSTO runtime version. |
|
LAST_CLIENT_DOT_NET_VERSION |
CHARACTER VARYING(15) |
Last reported .NET version. |
|
LAST_AUTHENTICATED_ROLES |
CHARACTER LARGE OBJECT |
Last authenticated role list. |
VIEW_ACCESS
Stores access grants for view artifacts.
| Column | Data Type | Key | Description |
|---|---|---|---|
ARTIFACT_TENANT |
CHARACTER VARYING(100) |
PK |
Tenant of the view artifact. |
ARTIFACT_CATEGORY |
CHARACTER VARYING(80) |
PK |
Category of the view artifact. |
ARTIFACT_ID |
CHARACTER VARYING(100) |
PK |
Identifier of the view artifact. |
ARTIFACT_VERSION |
INTEGER |
PK |
Version of the view artifact. |
ACCESS_ID |
CHARACTER VARYING(100) |
PK |
Access record identifier. |
ACCESS_TYPE |
CHARACTER VARYING(100) |
Type of access principal. |
|
PERMISSION |
CHARACTER VARYING(100) |
Permission granted to the principal. |
|
USER_OR_ROLE |
CHARACTER VARYING(100) |
User or role receiving the access grant. |
VIEW_USAGE_LOG
Records view usage and build telemetry.
| Column | Data Type | Key | Description |
|---|---|---|---|
TENANT |
CHARACTER VARYING(100) |
PK |
Tenant associated with the view usage record. |
USAGE_ID |
CHARACTER VARYING(40) |
PK |
View usage record identifier. |
VIEW_ID |
CHARACTER VARYING(100) |
View identifier. |
|
VIEW_VERSION |
INTEGER |
View version. |
|
USER_ID |
CHARACTER VARYING(120) |
User that opened or built the view. |
|
CONNECTED_USER |
CHARACTER VARYING(80) |
Connected user reported by the client. |
|
APPLICATION |
CHARACTER VARYING(80) |
Application associated with the view usage record. |
|
USAGE_DATETIME |
CHARACTER VARYING(19) |
Timestamp of the view usage event. |
|
BUILD_STATE |
INTEGER |
Client-reported build state. |
|
BUILD_DURATION |
INTEGER |
Client-reported build duration. |
|
BUILD_ERRORS |
CHARACTER LARGE OBJECT |
Client-reported build errors. |
|
BUILD_TOKENS |
CHARACTER VARYING(2000) |
Client-reported build tokens. |