48 lines
1.3 KiB
Transact-SQL
48 lines
1.3 KiB
Transact-SQL
CREATE TABLE [test].[PL_D2_S168TabellaEmittenti] (
|
|
[ProcedureName] varchar(42) NOT NULL,
|
|
[i_rete] char(1) NULL,
|
|
[i_codiceFiscale] varchar(16) NULL,
|
|
[COD_FISCALE] varchar(128) NULL,
|
|
[RETE] varchar(10) NULL,
|
|
[RATING_AAA] int NULL,
|
|
[RATING_AAp] int NULL,
|
|
[RATING_AA] int NULL,
|
|
[RATING_AAm] int NULL,
|
|
[RATING_Ap] int NULL,
|
|
[RATING_A] int NULL,
|
|
[RATING_Am] int NULL,
|
|
[RATING_BBBp] int NULL,
|
|
[RATING_BBB] int NULL,
|
|
[RATING_BBBm] int NULL,
|
|
[RATING_BBp] int NULL,
|
|
[RATING_BB] int NULL,
|
|
[RATING_BBm] int NULL,
|
|
[RATING_Bp] int NULL,
|
|
[RATING_B] int NULL,
|
|
[RATING_Bm] int NULL,
|
|
[RATING_CCCp] int NULL,
|
|
[RATING_CCC] int NULL,
|
|
[RATING_CCCm] int NULL,
|
|
[RATING_CC] int NULL,
|
|
[RATING_C] int NULL,
|
|
[RATING_D] int NULL,
|
|
[RATING_na] int NULL,
|
|
[FLG_RISKCLASS1] int NULL,
|
|
[FLG_RISKCLASS2] int NULL,
|
|
[FLG_RISKCLASS3] int NULL,
|
|
[FLG_RISKCLASS4] int NULL,
|
|
[FLG_RISKCLASS5] int NULL,
|
|
[FLG_RISKCLASS6] int NULL,
|
|
[FLG_RISKCLASS7] int NULL,
|
|
[FLG_RISKCLASS8] int NULL,
|
|
[FLG_RISKCLASS9] int NULL,
|
|
[FLG_RISKCLASS10] int NULL,
|
|
[INTERMEDIARIO] varchar(128) NOT NULL,
|
|
[ISSUER] varchar(512) NULL,
|
|
[STOCKSCounterValue] numeric(38,7) NULL,
|
|
[bondsCounterValue] numeric(38,7) NULL,
|
|
[CONCENTRATION_ISSUER] numeric(38,6) NULL,
|
|
[CONCENTRATION] numeric(38,6) NULL,
|
|
[NC] int NULL
|
|
)
|
|
GO |