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 (~)	2833640
Created	10/16/2018 3:33:04 PM
Last Modified	9/30/2022 9:24:18 AM

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
doc_id	int	4	10	True	False	False
seccion	int	4	10	True	False	False
campo	int	4	10	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	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
tipo_attach	varchar	1	0	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_LN_doc_campos	doc_id, seccion, campo	True

SQL Script

Copy

CREATE TABLE dbo.LN_doc_campos (
  doc_id int NOT NULL,
  seccion int NOT NULL,
  campo int NOT NULL,
  valor_fecha smalldatetime NULL,
  valor_texto varchar(max) NULL,
  valor_numerico float NULL,
  created smalldatetime NOT NULL,
  created_by int NULL,
  modified smalldatetime NULL,
  modified_by int NULL,
  tipo_attach varchar(1) NULL,
  CONSTRAINT PK_LN_doc_campos PRIMARY KEY CLUSTERED (doc_id, seccion, campo) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas