Table: ServiceProviderReport

 

ColumnName	DataType	Key	Not Null	Default Value	Comment
ServiceProviderReportID	UNIQUEIDENTIFIER	PK	NN		Unique ID of service provider report
ReportCreated	DATETIME		NN
ReportSent	DATETIME	(FK)	NN
ReportText	NVARCHAR(max)		NN
ReportFile	NVARCHAR(max)		NN
ReportSentOk	BIT		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ServiceProviderReportID

 

how to create

CREATE TABLE ServiceProviderReport(
ServiceProviderReportID UNIQUEIDENTIFIER NOT NULL,
ReportCreated DATETIME NOT NULL,
ReportSent DATETIME NOT NULL,
ReportText NVARCHAR(max)NOT NULL,
ReportFile NVARCHAR(max)NOT NULL,
ReportSentOk BIT NOT NULL,
CONSTRAINT PK_ServiceProviderReport
PRIMARY KEY (ServiceProviderReportID));