Torna al Thread
USE [c59onlineFR]
GO
/****** Oggetto: Table [dbo].[Archivio_mov] Data script: 04/18/2007 16:10:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Archivio_mov](
[codalbergo] [int] NOT NULL,
[prog_schedina] [int] NOT NULL,
[annogestionale] [int] NOT NULL,
[data_elaborazione] [smalldatetime] NOT NULL,
[stato] [varchar](1) COLLATE Latin1_General_CI_AS NULL,
[ncomp] [int] NULL,
[stato_res] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
[codstato] [varchar](3) COLLATE Latin1_General_CI_AS NULL,
[comune] [varchar](250) COLLATE Latin1_General_CI_AS NULL,
[prov] [varchar](2) COLLATE Latin1_General_CI_AS NULL,
[codcomune] [int] NULL CONSTRAINT [DF_Archivio_mov_codcomune] DEFAULT ((0)),
CONSTRAINT [PK_Archivio_mov] PRIMARY KEY CLUSTERED
(
[codalbergo] ASC,
[prog_schedina] ASC,
[annogestionale] ASC,
[data_elaborazione] 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].[Archivio_mov] WITH CHECK ADD CONSTRAINT [FK_Archivio_mov_Albergo] FOREIGN KEY([codalbergo])
REFERENCES [dbo].[Albergo] ([Codalb])
GO
ALTER TABLE [dbo].[Archivio_mov] CHECK CONSTRAINT [FK_Archivio_mov_Albergo]