USE [GLOBALRISK]
GO
/****** Oggetto:  Table [dbo].[T_DIZIONARIO_RACCORDO]    Data script: 09/03/2008 18:09:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_DIZIONARIO_RACCORDO](
  [SYS_USER] [varchar](25) NOT NULL,
  [SYS_DATA_AGGIOR] [datetime] NOT NULL,
  [ID_RACCORDO] [int] IDENTITY(1,1) NOT NULL,
  [FK_ID_PROCEDURA] [smallint] NOT NULL,
  [FK_ID_LIV0] [smallint] NOT NULL,
  [FK_ID_LIV1] [smallint] NOT NULL,
  [FK_ID_LIV2] [int] NOT NULL,
  [FK_ID_LIV3] [int] NOT NULL,
  [NOME_COLONNA] [varchar](10) NOT NULL,
  [NOME_COLONNA_T12] [varchar](10) NOT NULL,
  [FK_ID_AGGR] [int] NOT NULL,
  [COD_AGGR] [char](9) NOT NULL,
  [INDICE] [int] NOT NULL CONSTRAINT [DF_T_DIZIONARIO_RACCORDO_INDICE]  DEFAULT ((1)),
  [FATTORE] [smallint] NOT NULL,
  [FK_ID_RAC_PAESI_VALUTE] [smallint] NOT NULL CONSTRAINT [DF_T_DIZIONARIO_RACCORDO_FK_ID_PAESI_VALUTE]  DEFAULT ((0)),
 CONSTRAINT [PK_T_DIZIONARIO_RACCORDO_1] PRIMARY KEY CLUSTERED 
(
  [ID_RACCORDO] 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