dbo.cc_cuadros

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 (~)	46
Created	9/23/2013 11:16:52 AM
Last Modified	7/22/2017 11:00:14 PM

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
cuadro	tinyint	1	3	True	False	False
titulo_cuadro	varchar	50	0	False	False	False
orden	tinyint	1	3	False	False	False
texto_ayuda	text		0	False	False	False
tipo_secuencia	varchar	1	0	False	False	False
columnas	varchar	200	0	False	False	False
tipo_datos	varchar	50	0	False	False	False
longitud_datos	varchar	100	0	False	False	False
requerido	tinyint	1	3	False	False	False
requiere_doc	tinyint	1	3	False	False	False
cantidad_lineas	tinyint	1	3	False	False	False
seccion_cuadro	varchar	50	0	False	False	False
unifica_docs	tinyint	1	3	False	False	False
linea_completa	tinyint	1	3	False	False	False
ignorar_salida	varchar	20	0	False	False	False
generico	tinyint	1	3	False	False	False
questions	text		0	False	False	False
id_tipo_informe	int	4	10	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__cc_cuadr__538D27D357DEA292	cuadro	True

SQL Script

Copy

CREATE TABLE dbo.cc_cuadros (
  cuadro tinyint NOT NULL,
  titulo_cuadro varchar(50) NULL,
  orden tinyint NULL,
  texto_ayuda text NULL,
  tipo_secuencia varchar(1) NULL,
  columnas varchar(200) NULL,
  tipo_datos varchar(50) NULL,
  longitud_datos varchar(100) NULL,
  requerido tinyint NULL,
  requiere_doc tinyint NULL,
  cantidad_lineas tinyint NULL,
  seccion_cuadro varchar(50) NULL,
  unifica_docs tinyint NULL,
  linea_completa tinyint NULL,
  ignorar_salida varchar(20) NULL,
  generico tinyint NULL,
  questions text NULL,
  id_tipo_informe int NULL,
  PRIMARY KEY NONCLUSTERED (cuadro) WITH (FILLFACTOR = 20)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas