Unicon documentation migration is in progress. You might find some broken links or experience minor issues in the documentation. We are working on resolving these issues.

X

Scout Database Model (CR)

Table: ReportsAdmins

Assignment table holding the information about which administrator is allowed to execute which report.

ColumnName DataType Key Not Null Default Value Comment
ReportsAdminsID INTEGER IDENTITY (1,1) PK NN    
AdminID INTEGER   NN    
IndexName IndexType Columns
PRIMARY PRIMARY ReportsAdminsID

How to create

CREATE TABLE ReportsAdmins( ReportsAdminsID INTEGER IDENTITY (1,1) NOT NULL, AdminID INTEGER NOT NULL, CONSTRAINT PK_ReportsAdmins PRIMARY KEY (ReportsAdminsID));
Table: ReportsAdmins