dbo.trazabilidad_monitoreos

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 (~)	3639
Created	2/7/2025 2:52:46 PM
Last Modified	2/12/2025 9:06:31 AM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_trazabilidad	int	4	10	0	True	1 - 1		False	False
tabla	varchar	100	0	0	False			False	False
id_registro_tabla	int	4	10	0	False			False	False
created	datetime	8	23	3	False		(getdate())	False	False
user_id	int	4	10	0	False			False	False
accion	varchar	20	0	0	False			False	False
detalle	varchar	1000	0	0	False			False	False
cliente	int	4	10	0	False			False	False
cuit	varchar	20	0	0	False			False	False
id_padron	int	4	10	0	False			False	False
seccion_old	varchar	100	0	0	False			False	False
seccion_new	varchar	100	0	0	False			False	False
fecha_desde_old	datetime	8	23	3	False			False	False
fecha_desde_new	datetime	8	23	3	False			False	False
fecha_vigencia_old	datetime	8	23	3	False			False	False
fecha_vigencia_new	datetime	8	23	3	False			False	False
visible_old	bit	1	1	0	False			False	False
visible_new	bit	1	1	0	False			False	False

SQL Script

Copy

CREATE TABLE dbo.trazabilidad_monitoreos (
  id_trazabilidad int IDENTITY,
  tabla varchar(100) NULL,
  id_registro_tabla int NULL,
  created datetime NULL CONSTRAINT DF_trazabilidad_monitoreos DEFAULT (getdate()),
  user_id int NULL,
  accion varchar(20) NULL,
  detalle varchar(1000) NULL,
  cliente int NULL,
  cuit varchar(20) NULL,
  id_padron int NULL,
  seccion_old varchar(100) NULL,
  seccion_new varchar(100) NULL,
  fecha_desde_old datetime NULL,
  fecha_desde_new datetime NULL,
  fecha_vigencia_old datetime NULL,
  fecha_vigencia_new datetime NULL,
  visible_old bit NULL,
  visible_new bit NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas