USE [m&i]
GO
/****** Oggetto:  Table [dbo].[RigheStampe]    Data script: 01/31/2008 18:22:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RigheStampe](
  [IDRigheSchedeStampe] [int] IDENTITY(1,1) NOT NULL,
  [IDSchedaSposi] [int] NULL,
  [descrizione] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
  [Qt] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
  [prezzo] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
  [dataritiro] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
  [ritirato] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
  [idtipoStampa] [int] NULL,
  [idmodellostampa] [int] NULL,
  [idCartaEsterna] [int] NULL,
  [idCartaInterna] [int] NULL,
  [idchiusura1] [int] NULL,
  [idchiusura2] [int] NULL,
  [Bigliettonomi] [bit] NULL,
  [idceralacca] [int] NULL,
  [idcarattere] [int] NULL,
  [idcolorecarattere] [int] NULL,
  [timbro] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
  [annotazioni] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
  [noteritiro] [nvarchar](max) COLLATE Latin1_General_CI_AS NULL,
 CONSTRAINT [PK_RigheStampe_1] PRIMARY KEY CLUSTERED 
(
  [IDRigheSchedeStampe] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[RigheStampe]  WITH NOCHECK ADD  CONSTRAINT [FK_RigheStampe_carattere] FOREIGN KEY([idcarattere])
REFERENCES [dbo].[Carattere] ([IDcarattere])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_carattere]
GO
ALTER TABLE [dbo].[RigheStampe]  WITH NOCHECK ADD  CONSTRAINT [FK_RigheStampe_cartaesterna] FOREIGN KEY([idCartaEsterna])
REFERENCES [dbo].[Articoli] ([idarticoli])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_cartaesterna]
GO
ALTER TABLE [dbo].[RigheStampe]  WITH NOCHECK ADD  CONSTRAINT [FK_RigheStampe_cartainterna] FOREIGN KEY([idCartaInterna])
REFERENCES [dbo].[Articoli] ([idarticoli])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_cartainterna]
GO
ALTER TABLE [dbo].[RigheStampe]  WITH NOCHECK ADD  CONSTRAINT [FK_RigheStampe_Ceralacca] FOREIGN KEY([idceralacca])
REFERENCES [dbo].[Ceralacca] ([IDCeralacca])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_Ceralacca]
GO
ALTER TABLE [dbo].[RigheStampe]  WITH NOCHECK ADD  CONSTRAINT [FK_RigheStampe_Chiusura1] FOREIGN KEY([idchiusura1])
REFERENCES [dbo].[Chiusura] ([IDChiusura])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_Chiusura1]
GO
ALTER TABLE [dbo].[RigheStampe]  WITH NOCHECK ADD  CONSTRAINT [FK_RigheStampe_Chiusura2] FOREIGN KEY([idchiusura2])
REFERENCES [dbo].[Chiusura] ([IDChiusura])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_Chiusura2]
GO
ALTER TABLE [dbo].[RigheStampe]  WITH NOCHECK ADD  CONSTRAINT [FK_RigheStampe_ColoreCarattere] FOREIGN KEY([idcolorecarattere])
REFERENCES [dbo].[ColoreCarattere] ([IDColorecarattere])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_ColoreCarattere]
GO
ALTER TABLE [dbo].[RigheStampe]  WITH NOCHECK ADD  CONSTRAINT [FK_RigheStampe_ModelliStampa] FOREIGN KEY([idmodellostampa])
REFERENCES [dbo].[ModelliStampa] ([IDmodellistampa])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_ModelliStampa]
GO
ALTER TABLE [dbo].[RigheStampe]  WITH CHECK ADD  CONSTRAINT [FK_RigheStampe_SchedaSposi] FOREIGN KEY([IDSchedaSposi])
REFERENCES [dbo].[SchedaSposi] ([IDSchedaSposi])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_SchedaSposi]
GO
ALTER TABLE [dbo].[RigheStampe]  WITH NOCHECK ADD  CONSTRAINT [FK_RigheStampe_TipoStampa] FOREIGN KEY([idtipoStampa])
REFERENCES [dbo].[TipoStampa] ([IDTipoStampa])
GO
ALTER TABLE [dbo].[RigheStampe] CHECK CONSTRAINT [FK_RigheStampe_TipoStampa]