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
|