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