dbo.tareas_usuarios_documentos

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 (~)	2559
Created	3/19/2020 5:02:13 PM
Last Modified	3/19/2020 5:02:13 PM

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
task_id	int	4	10	True	False	False
user_id	int	4	10	True	False	False
doc_id	bigint	8	19	True	False	False
tipo	varchar	50	0	False	False	False
created	smalldatetime	4	16	True	False	False
created_by	int	4	10	True	False	False
vigencia_desde	smalldatetime	4	16	True	False	False
vigencia_hasta	smalldatetime	4	16	True	False	False
fecha_inicio_tarea	smalldatetime	4	16	False	False	False
fecha_fin_tarea	smalldatetime	4	16	False	False	False
fecha_aprobacion	smalldatetime	4	16	False	False	False
fecha_rechazo	smalldatetime	4	16	False	False	False
observaciones	text		0	False	False	False
cuit	varchar	20	0	False	False	False
id_externo	int	4	10	False	False	False
id_externo_2	int	4	10	False	False	False
id_externo_3	int	4	10	False	False	False
contraparte	int	4	10	False	False	False
gestion	int	4	10	False	False	False

SQL Script

Copy

CREATE TABLE dbo.tareas_usuarios_documentos_bkp (
  task_id int NOT NULL,
  user_id int NOT NULL,
  doc_id bigint NOT NULL,
  tipo varchar(50) NULL,
  created smalldatetime NOT NULL,
  created_by int NOT NULL,
  vigencia_desde smalldatetime NOT NULL,
  vigencia_hasta smalldatetime NOT NULL,
  fecha_inicio_tarea smalldatetime NULL,
  fecha_fin_tarea smalldatetime NULL,
  fecha_aprobacion smalldatetime NULL,
  fecha_rechazo smalldatetime NULL,
  observaciones text NULL,
  cuit varchar(20) NULL,
  id_externo int NULL,
  id_externo_2 int NULL,
  id_externo_3 int NULL,
  contraparte int NULL,
  gestion int NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found