Samuele E. Locatelli
31 lines
1.9 KiB
Transact-SQL
31 lines
1.9 KiB
Transact-SQL
CREATE TABLE [dbo].[ReportPrintTicket] (
|
|
[Ticket] INT NOT NULL,
|
|
[Report] NVARCHAR (50) CONSTRAINT [DF_Table1_Tabella] DEFAULT ('') NOT NULL,
|
|
[Chiave] NVARCHAR (250) CONSTRAINT [DF_ReportPrintTicket_Chiave] DEFAULT ('') NOT NULL,
|
|
[UserReq] NVARCHAR (50) CONSTRAINT [DF_ReportPrintTicket_UserReq] DEFAULT ('') NOT NULL,
|
|
[DataReq] DATETIME CONSTRAINT [DF_ReportPrintTicket_DataReq] DEFAULT (getdate()) NOT NULL,
|
|
[DataPrint] DATETIME NULL,
|
|
CONSTRAINT [PK_ReportPrintTicket] PRIMARY KEY CLUSTERED ([Ticket] ASC, [Report] ASC, [Chiave] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'data stampa', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ReportPrintTicket', @level2type = N'COLUMN', @level2name = N'DataPrint';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'data richiesta', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ReportPrintTicket', @level2type = N'COLUMN', @level2name = N'DataReq';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'user richiesta', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ReportPrintTicket', @level2type = N'COLUMN', @level2name = N'UserReq';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'chiave multipla richiesta (specifica epr report)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ReportPrintTicket', @level2type = N'COLUMN', @level2name = N'Chiave';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Ticket univoco per stampa', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ReportPrintTicket', @level2type = N'COLUMN', @level2name = N'Ticket';
|
|
|