vdsReport
The vdsReport table contains the attributes of the existing reports defined in OneSpan Authentication Server.
Columns
Table: vdsReport table columns
Column name |
Data type |
Primary key |
Nullable |
Description |
vdsDomain
|
varchar(255) |
Yes |
No |
|
vdsReportID
|
varchar(64) |
Yes |
No |
|
vdsReportName
|
varchar(64) |
No |
No |
The name of the report. |
vdsReportDesc
|
varchar(255) |
No |
Yes |
|
vdsDataSource
|
integer |
No |
No |
The source from where the data in the report originates. |
vdsGroupLevel
|
integer |
No |
Yes |
This is used to group the information in the report into the format required. |
vdsReportType
|
integer |
No |
No |
|
vdsRunPerms
|
integer |
No |
No |
The usage permissions specifying who can view and run the report. |
vdsChangePerms
|
integer |
No |
No |
The change permissions specifying who can change the report. |
vdsTimeFreq
|
integer |
No |
Yes |
Specifies the sub-count time frequency for trend analysis reports. |
vdsQueryDef
|
varchar(4000) |
No |
No |
|
vdsUserID
|
varchar(255) |
No |
Yes |
|
vdsCreateTime
|
timestamp |
No |
No |
The date and time the data record was created. |
vdsModifyTime
|
timestamp |
No |
No |
The date and time the data record was last modified. |
vdsVersion
|
integer |
No |
Yes |
The current data schema version of the data record. |
Keys
Primary key: (vdsDomain,
vdsReportID)
Foreign keys:
-
(vdsDomain) references vdsDomain (vdsDomain)
-
(vdsDomain, vdsUserID) references vdsUser (vdsDomain, vdsUserID)
Indexes
Table: vdsReport table indexes
Index name |
Included fields |
Level 0 (default) |
vdsreportidx
|
vdsDomain
vdsReportId
|