Torna al Thread

USE [dbsend] GO /****** Oggetto: Table [dbo].[SchedinePS] Data script: 04/03/2008 11:00:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SchedinePS]( [codalbergo] [int] NOT NULL, [AnnoGestionale] [int] NOT NULL, [NSchedina] [int] NOT NULL, [IdComponente] [int] NOT NULL CONSTRAINT [DF_SchedinePS_IdComponente] DEFAULT ((1)), [DataArrivo] [smalldatetime] NULL, [DataPartenza] [smalldatetime] NULL, [CodAlloggiato] [int] NOT NULL, [Cognome] [varchar](50) COLLATE Latin1_General_CI_AS NULL, [Nome] [varchar](50) COLLATE Latin1_General_CI_AS NULL, [Sesso] [int] NULL, [DataNascita] [smalldatetime] NULL, [IdComuneNascita] [int] NULL, [IdStatoNascita] [int] NULL CONSTRAINT [DF_SchedinePS_IdStatoNascita] DEFAULT ((0)), [IdCittadinanza] [int] NULL, [IdComuneResidenza] [int] NULL, [IdStatoResidenza] [int] NULL CONSTRAINT [DF_SchedinePS_IdStatoResidenza] DEFAULT ((0)), [IdDocumento] [int] NULL, [NDocumento] [varchar](20) COLLATE Latin1_General_CI_AS NULL, [LuogoDocumento] [varchar](50) COLLATE Latin1_General_CI_AS NULL, [IdStatoDocumento] [int] NULL CONSTRAINT [DF_SchedinePS_IdStatoDocumento] DEFAULT ((0)), [ncomponenti] [int] NULL CONSTRAINT [DF_SchedinePS_ncomponenti] DEFAULT ((0)), CONSTRAINT [PK_SchedinePS_1] PRIMARY KEY CLUSTERED ( [codalbergo] ASC, [AnnoGestionale] ASC, [NSchedina] ASC, [IdComponente] ASC, [CodAlloggiato] 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 SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[SchedinePS] WITH CHECK ADD CONSTRAINT [FK_SchedinePS_Albergo] FOREIGN KEY([codalbergo]) REFERENCES [dbo].[Albergo] ([Codalb]) GO ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_Albergo] GO ALTER TABLE [dbo].[SchedinePS] WITH CHECK ADD CONSTRAINT [FK_SchedinePS_Comuni] FOREIGN KEY([IdComuneNascita]) REFERENCES [dbo].[Comuni] ([id]) GO ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_Comuni] GO ALTER TABLE [dbo].[SchedinePS] WITH CHECK ADD CONSTRAINT [FK_SchedinePS_Comuni1] FOREIGN KEY([IdComuneResidenza]) REFERENCES [dbo].[Comuni] ([id]) GO ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_Comuni1] GO ALTER TABLE [dbo].[SchedinePS] WITH CHECK ADD CONSTRAINT [FK_SchedinePS_Documenti] FOREIGN KEY([IdDocumento]) REFERENCES [dbo].[Documenti] ([Id]) GO ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_Documenti] GO ALTER TABLE [dbo].[SchedinePS] WITH CHECK ADD CONSTRAINT [FK_SchedinePS_NazioniPS] FOREIGN KEY([IdStatoNascita]) REFERENCES [dbo].[NazioniPS] ([Id]) GO ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_NazioniPS] GO ALTER TABLE [dbo].[SchedinePS] WITH CHECK ADD CONSTRAINT [FK_SchedinePS_NazioniPS1] FOREIGN KEY([IdCittadinanza]) REFERENCES [dbo].[NazioniPS] ([Id]) GO ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_NazioniPS1] GO ALTER TABLE [dbo].[SchedinePS] WITH CHECK ADD CONSTRAINT [FK_SchedinePS_NazioniPS2] FOREIGN KEY([IdStatoResidenza]) REFERENCES [dbo].[NazioniPS] ([Id]) GO ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_NazioniPS2] GO ALTER TABLE [dbo].[SchedinePS] WITH CHECK ADD CONSTRAINT [FK_SchedinePS_NazioniPS3] FOREIGN KEY([IdStatoDocumento]) REFERENCES [dbo].[NazioniPS] ([Id]) GO ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_NazioniPS3]
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5