dbo.AGB_TRAZABILIDAD

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 (~) 9995
Created 6/22/2023 6:04:37 PM
Last Modified 6/22/2023 6:04:37 PM

Columns

11
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
texto varchar 1000 0 0

True

False

False

created datetime2 7 23 3

False

False

False

fecha_iniciado datetime2 7 23 3

False

False

False

idTarea int 4 10 0

False

False

False

IDT int 4 10 0

True

False

False

nombre_tarea varchar 150 0 0

False

False

False

contra int 4 10 0

True

False

False

contraparte int 4 10 0

False

False

False

padre int 4 10 0

False

False

False

informe int 4 10 0

True

False

False

estado_tarea varchar 1 0 0

False

False

False

SQL Script

Copy
CREATE TABLE dbo.AGB_TRAZABILIDAD (
  texto varchar(1000) NOT NULL,
  created datetime2(3) NULL,
  fecha_iniciado datetime2(3) NULL,
  idTarea int NULL,
  IDT int NOT NULL,
  nombre_tarea varchar(150) NULL,
  contra int NOT NULL,
  contraparte int NULL,
  padre int NULL,
  informe int NOT NULL,
  estado_tarea varchar(1) NULL
)
ON [PRIMARY]
GO

Depends On

1
  • Fidelitas

Used By

No items found