CREATE TABLE [dbo].[OBRQ](
	CNSOBRQ [int] IDENTITY(1,1) NOT NULL,
	FECHA_INI DATETIME NOT NULL,
	FECHA_FIN DATETIME NOT NULL,
	CDG_OBR [varchar](20) NULL,
	CODIGO_ACTIVIDAD [varchar](20) NULL,
	CANTIDAD FLOAT NULL,
	HORAS FLOAT NULL,
	VALOR FLOAT NULL,
	USUARIO VARCHAR(20),
	FCH_MDF DATETIME NULL,
 CONSTRAINT [OBRQLLAVE] PRIMARY KEY CLUSTERED 
(
	[CNSOBRQ] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


CREATE TABLE [dbo].[OBRI](
	CNSOBRI [int] IDENTITY(1,1) NOT NULL,	
	CDG_OBR [varchar](20) NULL,
	CDG_OBRP [varchar](20) NULL,
	FECHA_INI DATETIME  NULL,
	FECHA_FIN DATETIME  NULL,
	NRO_EMP INT NULL,
	USUARIO VARCHAR(20),
	FCH_CREA DATETIME NULL,
	FCH_CIERRE DATETIME NULL,
 CONSTRAINT [OBRILLAVE] PRIMARY KEY CLUSTERED 
(
	CNSOBRI ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]