3VJzrREP

1CREATE TABLE IF NOT EXISTS `Reports` (
2    `ID`    integer NOT NULL PRIMARY KEY AUTOINCREMENT,
3    `ParameterTypeID`   integer,
4    `ReportTypeID`  integer NOT NULL,
5    `DurationToSpan`    integer NOT NULL,--# of Days or # of Week
6    `SpanDurationType`  char ( 4 ) NOT NULL,--Day,Week
7    `Name`  nvarchar ( 250 ) NOT NULL,
8    `Description`   nvarchar ( 500 ) DEFAULT NULL,
9    `DateCreated`   datetime DEFAULT current_timestamp,
10    `DateModified`  datetime DEFAULT current_timestamp,
11    `CreatedBy` nvarchar ( 100 ) DEFAULT 'Admin',
12    `IsActive`  boolean DEFAULT 1,
13    `SortBy`    char ( 4 ) NOT NULL, --Amit, confirm NOT NULL is okay with your code
14    CONSTRAINT `FK_Reports_0_0` FOREIGN KEY(`ReportTypeID`) REFERENCES `ReportsType`(`ID`) MATCH NONE ON UPDATE NO ACTION ON DELETE NO ACTION
15);