Torna al Thread
CREATE TABLE [dbo].[SchedinePS](
[codalbergo] [int] NOT NULL,
[AnnoGestionale] [int] NOT NULL,
[NSchedina] [int] NOT NULL,
[IdComponente] [int] NOT NULL,
[DataArrivo] [smalldatetime] NULL,
[DataPartenza] [smalldatetime] NULL,
[CodAlloggiato] [int] NOT NULL,
[Cognome] [varchar](50) NULL,
[Nome] [varchar](50) NULL,
[Sesso] [int] NULL,
[DataNascita] [smalldatetime] NULL,
[IdComuneNascita] [int] NULL,
[IdStatoNascita] [int] NULL,
[IdCittadinanza] [int] NULL,
[IdComuneResidenza] [int] NULL,
[IdStatoResidenza] [int] NULL,
[IdDocumento] [int] NULL,
[NDocumento] [varchar](20) NULL,
[LuogoDocumento] [varchar](50) NULL,
[IdStatoDocumento] [int] NULL,
[ncomponenti] [int] NULL,
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] ([Codice])
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] ([Codice])
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] ([Codice])
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] ([Codice])
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] ([Codice])
GO
ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_NazioniPS2]
GO
ALTER TABLE [dbo].[SchedinePS] WITH CHECK ADD CONSTRAINT [FK_SchedinePS_NazioniPS3] FOREIGN KEY([IdCittadinanza])
REFERENCES [dbo].[NazioniPs] ([Codice])
GO
ALTER TABLE [dbo].[SchedinePS] CHECK CONSTRAINT [FK_SchedinePS_NazioniPS3]
GO
ALTER TABLE [dbo].[SchedinePS] ADD CONSTRAINT [DF_SchedinePS_IdComponente] DEFAULT ((1)) FOR [IdComponente]
GO
ALTER TABLE [dbo].[SchedinePS] ADD CONSTRAINT [DF_SchedinePS_IdStatoNascita] DEFAULT ((0)) FOR [IdStatoNascita]
GO
ALTER TABLE [dbo].[SchedinePS] ADD CONSTRAINT [DF_SchedinePS_IdStatoResidenza] DEFAULT ((0)) FOR [IdStatoResidenza]
GO
ALTER TABLE [dbo].[SchedinePS] ADD CONSTRAINT [DF_SchedinePS_IdStatoDocumento] DEFAULT ((0)) FOR [IdStatoDocumento]
GO
ALTER TABLE [dbo].[SchedinePS] ADD CONSTRAINT [DF_SchedinePS_ncomponenti] DEFAULT ((0)) FOR [ncomponenti]
GO