dbo.LN_campos

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	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	1446
Created	5/3/2022 3:52:49 PM
Last Modified	9/19/2023 3:18:45 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
campo	int	4	10	0	True	1 - 1		False	False
nombre_campo	varchar	100	0	0	False			False	False
etiqueta	varchar	1024	0	0	False			False	False
tipo_campo	varchar	1	0	0	False			False	False
longitud	smallint	2	5	0	False			False	False
decimales	tinyint	1	3	0	False		(0)	False	False
opciones	text		0	0	False			False	False
validacion	varchar	1	0	0	False			False	False
created	datetime	8	23	3	True		(getdate())	False	False
created_by	int	4	10	0	False			False	False
modified	datetime	8	23	3	False			False	False
modified_by	int	4	10	0	False			False	False
filas	tinyint	1	3	0	False			False	False
columnas	tinyint	1	3	0	False			False	False
anual_vencida	tinyint	1	3	0	False			False	False
aplica_formula_dep_econ	tinyint	1	3	0	False		(0)	False	False
tipo_attach	varchar	1	0	0	False			False	False
tipo_campo_padre	int	4	10	0	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__LN_campo__16D93B7B5968E82E	campo	True

SQL Script

Copy

CREATE TABLE dbo.LN_campos (
  campo int IDENTITY,
  nombre_campo varchar(100) NULL,
  etiqueta varchar(1024) NULL,
  tipo_campo varchar(1) NULL,
  longitud smallint NULL,
  decimales tinyint NULL CONSTRAINT DF__LN_campos__decim__1B8B6C98 DEFAULT (0),
  opciones text NULL,
  validacion varchar(1) NULL,
  created datetime NOT NULL CONSTRAINT DF__LN_campos__creat__1C7F90D1 DEFAULT (getdate()),
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  filas tinyint NULL,
  columnas tinyint NULL,
  anual_vencida tinyint NULL,
  aplica_formula_dep_econ tinyint NULL CONSTRAINT DF__LN_campos__aplic__624D5BAC DEFAULT (0),
  tipo_attach varchar(1) NULL,
  tipo_campo_padre int NULL,
  CONSTRAINT PK__LN_campo__16D93B7B5968E82E PRIMARY KEY CLUSTERED (campo) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas