dbo.monitoreos_resultados

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	7096
Created	5/9/2017 1:54:15 PM
Last Modified	6/21/2017 2:31:08 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Default	Computed	Persisted
cuit	varchar	20	0	True			False	False
seccion_mantenimiento	int	4	10	True			False	False
fecha	smalldatetime	4	16	True		(getdate())	False	False
novedad	bit	1	1	True			False	False
tipo_novedad	varchar	100	0	False			False	False
nro_cheque	varchar	20	0	False			False	False
id_cendeu	int	4	10	False			False	False
id_juicio	int	4	10	False			False	False
id_cheque	int	4	10	False			False	False
html	varchar		0	False			False	False
id_monitoreo	int	4	10	True	1 - 1		False	False

SQL Script

Copy

CREATE TABLE dbo.monitoreos_resultados_ant (
  cuit varchar(20) NOT NULL,
  seccion_mantenimiento int NOT NULL,
  fecha smalldatetime NOT NULL CONSTRAINT DF_mantenimiento_resultados_fecha DEFAULT (getdate()),
  novedad bit NOT NULL,
  tipo_novedad varchar(100) NULL,
  nro_cheque varchar(20) NULL,
  id_cendeu int NULL,
  id_juicio int NULL,
  id_cheque int NULL,
  html varchar(max) NULL,
  id_monitoreo int IDENTITY
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found