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));