dbo.LN_tipo_informes_backup

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 (~) 0
Created 3/6/2025 6:55:54 PM
Last Modified 3/6/2025 6:55:54 PM

Columns

16
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
idTipoInforme int 4 10 0

True

False

False

nombre_tipo_informe varchar 150 0 0

False

False

False

descripcion text 0 0

False

False

False

cliente int 4 10 0

False

False

False

duracion tinyint 1 3 0

False

False

False

perfil_usr_default varchar 50 0 0

False

False

False

activo bit 1 1 0

True

False

False

prioridad tinyint 1 3 0

True

False

False

familia int 4 10 0

False

False

False

idioma varchar 3 0 0

True

False

False

created datetime2 7 23 3

False

False

False

created_by int 4 10 0

False

False

False

modified datetime2 7 23 3

False

False

False

modified_by int 4 10 0

False

False

False

tipo varchar 1 0 0

True

False

False

servicio_contratado int 4 10 0

False

False

False

SQL Script

Copy
CREATE TABLE dbo.LN_tipo_informes_backup (
  idTipoInforme int NOT NULL,
  nombre_tipo_informe varchar(150) NULL,
  descripcion text NULL,
  cliente int NULL,
  duracion tinyint NULL,
  perfil_usr_default varchar(50) NULL,
  activo bit NOT NULL,
  prioridad tinyint NOT NULL,
  familia int NULL,
  idioma varchar(3) NOT NULL,
  created datetime2(3) NULL,
  created_by int NULL,
  modified datetime2(3) NULL,
  modified_by int NULL,
  tipo varchar(1) NOT NULL,
  servicio_contratado int NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

1
  • FideDoc

Used By

No items found