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]