etl_intercambio/querys/20181006_DEV_ARGOS_CREATE_DEC_CONTRATO_INY_MER.sql

USE [DEV_ARGOS]
GO

/****** Object:  Table [dbo].[DEC_CONTRATO_INY_MER]    Script Date: 06/10/2018 09:06:54 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

/* Cambiar al esquema correspondiente en la base de datos */

CREATE TABLE [UT].[DEC_CONTRATO_INY_MER](
	[FECHA] [date] NOT NULL,
	[AGENTE_INYECTA] [nvarchar](255) NOT NULL,
	[MEDICION_INY] [nvarchar](255) NOT NULL,
	[AGENTE_RETIRA] [nvarchar](255) NOT NULL,
	[MEDICION_RET] [nvarchar](255) NOT NULL,
	[HORA_INICIO] [time](7) NOT NULL,
	[HORA_FIN] [time](7) NOT NULL,
	[TIPO_CONTRATO] [nvarchar](255) NOT NULL,
	[COD_CF] [nvarchar](255) NULL,
	[TITULAR_DT] [nvarchar](255) NULL,
	[RESPONSABLE_TX] [nvarchar](255) NULL,
	[ENERGIA_DECLARADA] [float] NOT NULL,
	[ENERGIA_REQUERIDA] [float] NOT NULL,
	[OFERTA_PMAX] [nvarchar](255) NOT NULL,
	[ENERGIA_B1] [float] NULL,
	[PRECIO_B1] [float] NULL,
	[ENERGIA_B2] [float] NULL,
	[PRECIO_B2] [float] NULL,
	[ENERGIA_B3] [float] NULL,
	[PRECIO_B3] [float] NULL,
	[ENERGIA_B4] [float] NULL,
	[PRECIO_B4] [float] NULL,
	[ENERGIA_B5] [float] NULL,
	[PRECIO_B5] [float] NULL,
	[OFERTA_FLEX] [nvarchar](255) NULL,
	[TIPO_OFERTA_FLEX] [nvarchar](255) NULL,
	[ENERGIA_FLEX_B1] [float] NULL,
	[PRECIO_FLEX_B1] [float] NULL,
	[ENERGIA_FLEX_B2] [float] NULL,
	[PRECIO_FLEX_B2] [float] NULL,
	[ENERGIA_FLEX_B3] [float] NULL,
	[PRECIO_FLEX_B3] [float] NULL,
	[ENERGIA_FLEX_B4] [float] NULL,
	[PRECIO_FLEX_B4] [float] NULL,
	[ENERGIA_FLEX_B5] [float] NULL,
	[PRECIO_FLEX_B5] [float] NULL,
	[RESPONSABLE_CMORC] [nvarchar](255) NULL,
	[WHO_INAME_M] [nvarchar](40) NULL CONSTRAINT [CNST_DEC_CONTRATO_INY_MER_AUDIT_NAME_I]  DEFAULT (suser_sname()),
	[WHO_IDATE_M] [datetime] NULL CONSTRAINT [CNST_DEC_CONTRATO_INY_MER_AUDIT_FECHA_I]  DEFAULT (getdate())	

) ON [PRIMARY]

GO