dbo.informe_valores

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:53 PM
Last Modified	3/6/2025 6:55:57 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
nombre_variable	varchar	200	0	0	True	False	False
valor	varchar	512	0	0	False	False	False
instancia	tinyint	1	3	0	True	False	False
cargado_por	int	4	10	0	False	False	False
cargado_fecha	datetime	8	23	3	False	False	False
modificado_por	int	4	10	0	False	False	False
modificado_fecha	datetime	8	23	3	False	False	False
informe	int	4	10	0	True	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__informe___55DCE0E85BC2FAD5	informe, nombre_variable, instancia	True

Foreign Keys

Name	Columns	Description
FK__informe_v__infor__785FB566	informe

SQL Script

Copy

CREATE TABLE dbo.informe_valores (
  nombre_variable varchar(200) NOT NULL,
  valor varchar(512) NULL,
  instancia tinyint NOT NULL,
  cargado_por int NULL,
  cargado_fecha datetime NULL,
  modificado_por int NULL,
  modificado_fecha datetime NULL,
  informe int NOT NULL,
  PRIMARY KEY NONCLUSTERED (informe, nombre_variable, instancia) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

ALTER TABLE dbo.informe_valores WITH NOCHECK
  ADD FOREIGN KEY (informe) REFERENCES dbo.informes (informe)
GO

Depends On

FideDoc
dbo.informes

Used By

dbo.informe_valores_historico