USE [m&i]
GO
/****** Oggetto:  Table [dbo].[Articoli]    Data script: 01/31/2008 20:14:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Articoli](
  [idarticoli] [int] IDENTITY(1,1) NOT NULL,
  [articolo] [nvarchar](255) NULL,
  [Descrizione] [nvarchar](255) NULL,
  [PrezzoAcquisto] [nvarchar](50) NULL,
  [PrezzoVendita] [nvarchar](50) NULL,
  [IDFornitore] [int] NULL,
  [IDCategoria] [int] NULL,
  [annotazioni] [nvarchar](max) NULL,
  [qtperunit] [nchar](10) NULL,
  [barcode] [nvarchar](50) NULL,
 CONSTRAINT [PK_Articoli_1] PRIMARY KEY CLUSTERED 
(
  [idarticoli] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Articoli]  WITH CHECK ADD  CONSTRAINT [FK_Articoli_Articoli] FOREIGN KEY([idarticoli])
REFERENCES [dbo].[Articoli] ([idarticoli])
GO
ALTER TABLE [dbo].[Articoli] CHECK CONSTRAINT [FK_Articoli_Articoli]
GO
ALTER TABLE [dbo].[Articoli]  WITH NOCHECK ADD  CONSTRAINT [FK_Articoli_Categoria] FOREIGN KEY([IDCategoria])
REFERENCES [dbo].[Categoria] ([idcategoria])
GO
ALTER TABLE [dbo].[Articoli] CHECK CONSTRAINT [FK_Articoli_Categoria]
GO
ALTER TABLE [dbo].[Articoli]  WITH NOCHECK ADD  CONSTRAINT [FK_Articoli_fornitore] FOREIGN KEY([IDFornitore])
REFERENCES [dbo].[fornitore] ([idfornitore])
GO
ALTER TABLE [dbo].[Articoli] CHECK CONSTRAINT [FK_Articoli_fornitore]