dbo.LN_doc_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 (~)	14730855
Created	10/31/2018 4:18:05 PM
Last Modified	10/31/2018 4:18:05 PM

Columns

Name	Data Type	Length	Precision	Not Null	Default	Computed	Persisted
doc_id	int	4	10	True		False	False
seccion	int	4	10	True		False	False
campo	int	4	10	True		False	False
fila	tinyint	1	3	True		False	False
col	tinyint	1	3	True		False	False
valor_fecha	smalldatetime	4	16	False		False	False
valor_texto	varchar		0	False		False	False
valor_numerico	float	8	53	False		False	False
created	smalldatetime	4	16	True	(getdate())	False	False
created_by	int	4	10	False		False	False
modified	smalldatetime	4	16	False		False	False
modified_by	int	4	10	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_LN_doc_campos_col	doc_id, seccion, campo, fila, col	True

SQL Script

Copy

CREATE TABLE dbo.LN_doc_campos_col (
  doc_id int NOT NULL,
  seccion int NOT NULL,
  campo int NOT NULL,
  fila tinyint NOT NULL,
  col tinyint NOT NULL,
  valor_fecha smalldatetime NULL,
  valor_texto varchar(max) NULL,
  valor_numerico float NULL,
  created smalldatetime NOT NULL DEFAULT (getdate()),
  created_by int NULL,
  modified smalldatetime NULL,
  modified_by int NULL,
  CONSTRAINT PK_LN_doc_campos_col PRIMARY KEY CLUSTERED (doc_id, seccion, campo, fila, col) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.LN_doc_campos_col