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