Torna al Thread
CREATE TABLE [dbo].[T_VALORI_ICAAP](
[SYS_USER] [varchar](25) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_SYS_USER] DEFAULT (''),
[SYS_DATA_AGGIOR] [datetime] NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_SYS_DATA_AGGIOR] DEFAULT (getdate()),
[FK_ID_ENTE] [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,
[FK_ANNO] [smallint] NOT NULL,
[FK_MESE] [smallint] NOT NULL,
[TC_1] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_1] DEFAULT ('0'),
[TC_2] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_2] DEFAULT ('0'),
[TC_3] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_3] DEFAULT ('0'),
[TC_4] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_4] DEFAULT ('0'),
[TC_5] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_5] DEFAULT ('0'),
[TC_6] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_6] DEFAULT ('0'),
[TC_7] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_7] DEFAULT ('0'),
[TC_8] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_8] DEFAULT ('0'),
[TC_9] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_9] DEFAULT ('0'),
[TC_10] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_10] DEFAULT ('0'),
[TC_11] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_11] DEFAULT ('0'),
[TC_12] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_12] DEFAULT ('0'),
[TC_13] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_13] DEFAULT ('0'),
[TC_14] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_14] DEFAULT ('0'),
[TC_15] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_15] DEFAULT ('0'),
[TC_16] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_16] DEFAULT ('0'),
[TC_17] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_17] DEFAULT ('0'),
[TC_18] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_18] DEFAULT ('0'),
[TC_19] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_19] DEFAULT ('0'),
[TC_20] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_20] DEFAULT ('0'),
[TC_21] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_21] DEFAULT ('0'),
[TC_22] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_22] DEFAULT ('0'),
[TC_23] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_23] DEFAULT ('0'),
[TC_24] [varchar](30) NOT NULL CONSTRAINT [DF_T_VALORI_ICAAP_TC_24] DEFAULT ('0'),
CONSTRAINT [PK_T_VALORI_ICAAP] PRIMARY KEY CLUSTERED
(
[FK_ID_ENTE] ASC,
[FK_ID_LIV0] ASC,
[FK_ID_LIV1] ASC,
[FK_ID_LIV2] ASC,
[FK_ID_LIV3] ASC,
[FK_ANNO] ASC,
[FK_MESE] 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
CREATE TABLE [dbo].[T_DIZ_RACCORDO](
[SYS_USER] [varchar](25) NOT NULL,
[SYS_DATA_AGGIOR] [datetime] NOT NULL,
[ID_RACCORDO] [int] NOT NULL,
[DESC_PROCEDURA] [varchar](100) 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,
[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
CREATE TABLE [dbo].[T_DIZ_AGGR_DESCRIZIONI](
[SYS_USER] [varchar](25) NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_SYS_USER] DEFAULT (''),
[SYS_DATA_AGGIOR] [datetime] NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_SYS_DATA_AGGIOR] DEFAULT (getdate()),
[ID_AGGR] [int] NOT NULL,
[COD_AGGR] [char](9) NOT NULL,
[FK_ID_CONDIZIONE] [smallint] NOT NULL,
[FK_ID_FONTE] [smallint] NOT NULL,
[FK_ID_FUNZIONE] [smallint] NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_FK_ID_FUNZIONE] DEFAULT ((0)),
[DESC_PROCEDURA] [varchar](100) NOT NULL,
[DESCRIZIONE] [varchar](400) NOT NULL,
[LIVELLO] [smallint] NOT NULL,
[FLG_MANUALE] [bit] NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_FLG_MANUALE] DEFAULT ((0)),
[OLD_FATTORE] [smallint] NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_FATTORE] DEFAULT ((1000)),
[OLD_TIPO_ANALISI] [char](1) NOT NULL,
[OLD_TIPO_DATI] [smallint] NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_TIPO_DATI] DEFAULT ((0)),
[FORMATO_DATI] [smallint] NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_FORMATO_DATI] DEFAULT ((0)),
[FLG_STORICIZZATO] [bit] NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_FLG_STORICO] DEFAULT ((0)),
[STEP] [smallint] NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_STEP] DEFAULT ((0)),
[FLG_II_VALUTE_RILEVANTE] [bit] NOT NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_FLG_II_VALUTE_RILEVANTE] DEFAULT ((0)),
[FK_ID_AGGR] [int] NULL,
CONSTRAINT [PK_T_DIZ_AGGR_DESCRIZIONI] PRIMARY KEY CLUSTERED
(
[ID_AGGR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 98) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_DIZ_AGGR_DESCRIZIONI_PROC_STR](
[SYS_USER] [varchar](25) NULL,
[SYS_DATA_AGGIOR] [datetime] NULL CONSTRAINT [DF_T_DIZ_AGGR_DESCRIZIONI_PROC_STR_SYS_DATA_AGGIOR] DEFAULT (getdate()),
[ID_AGGR] [int] NOT NULL,
[ID_PROC_STR] [smallint] NOT NULL,
CONSTRAINT [PK_T_DIZ_AGGR_DESCRIZIONI_PROC_STR] PRIMARY KEY CLUSTERED
(
[ID_AGGR] ASC,
[ID_PROC_STR] 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
CREATE TABLE [dbo].[T_DIZ_RACCORDO_PROC_STR](
[SYS_USER] [varchar](25) NULL,
[SYS_DATA_AGGIOR] [datetime] NULL CONSTRAINT [DF_T_DIZ_RACCORDO_PROC_STR_SYS_DATA_AGGIOR] DEFAULT (getdate()),
[ID_RACCORDO] [int] NOT NULL,
[ID_PROC_STR] [smallint] NOT NULL,
CONSTRAINT [PK_T_DIZ_RACCORDO_PROC_STR] PRIMARY KEY CLUSTERED
(
[ID_RACCORDO] ASC,
[ID_PROC_STR] 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