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
fecha_hora	datetime	8	23	3	True	False	False
valor	varchar	512	0	0	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
nombre_variable	varchar	200	0	0	True	False	False
instancia	tinyint	1	3	0	True	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__informe___600C6D03727D69D8	informe, nombre_variable, instancia, fecha_hora	True

Foreign Keys

Name	Columns	Description
FK__informe_valores___7953D99F	informe, nombre_variable, instancia

SQL Script

Copy

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

ALTER TABLE dbo.informe_valores_historico
  ADD FOREIGN KEY (informe, nombre_variable, instancia) REFERENCES dbo.informe_valores (informe, nombre_variable, instancia)
GO

Depends On

FideDoc
dbo.informe_valores

Used By

No items found