CREATE TABLE [T_VALORI_AGGR](
  [SYS_USER] [varchar](25) NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_SYS_USER]  DEFAULT (''),
  [SYS_DATA_AGGIOR] [datetime] NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_SYS_DATA_AGGIOR]  DEFAULT (getdate()),
  [FK_ID_UTENTE] [char](5) NOT NULL,
  [FK_ID_AGGR] [int] NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_FK_ID_AGGR]  DEFAULT ((0)),
  [FK_ID_PAESI_VALUTE] [smallint] NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_FK_ID_PAESI_VALUTE]  DEFAULT ((0)),
  [FK_MESE] [smallint] NOT NULL,
  [FK_ANNO] [smallint] NOT NULL,
  [T] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_T]  DEFAULT ((0)),
  [T12] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_T06]  DEFAULT ((0)),
  [T24] [decimal](18, 2) NOT NULL CONSTRAINT [DF_T_VALORI_AGGR_T12]  DEFAULT ((0)),
 CONSTRAINT [PK_T_VALORI_AGGR] PRIMARY KEY CLUSTERED 
(
  [FK_ID_UTENTE] ASC,
  [FK_ID_AGGR] ASC,
  [FK_ID_PAESI_VALUTE] ASC,
  [FK_MESE] ASC,
  [FK_ANNO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
)

ON PARTITIONS_PART_PScheme (FK_ID_UTENTE)