dbo.SAAS_Historial

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 (~)	48573
Created	8/3/2021 2:41:56 PM
Last Modified	2/27/2023 9:44:58 AM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
saas_historial_consulta	int	4	10	0	True	1 - 1		False	False
saas_usuario_contrato	int	4	10	0	True			False	False
fecha_consulta	smalldatetime	4	16	0	False			False	False
estado	char	1	0	0	False			False	False
formales_estado	char	1	0	0	False			False	False
formales_score	decimal	5	5	2	False			False	False
fiscales_estado	char	1	0	0	False			False	False
fiscales_score	decimal	5	5	2	False			False	False
contables_estado	char	1	0	0	False			False	False
contables_score	decimal	5	5	2	False			False	False
patrimonio_estado	char	1	0	0	False			False	False
patrimonio_score	decimal	5	5	2	False			False	False
legales_estado	char	1	0	0	False			False	False
legales_score	decimal	5	5	2	False			False	False
bancos_estado	char	1	0	0	False			False	False
bancos_score	decimal	5	5	2	False			False	False
cheques_estado	char	1	0	0	False			False	False
cheques_score	decimal	5	5	2	False			False	False
created	smalldatetime	4	16	0	True		(getdate())	False	False
created_by	int	4	10	0	False			False	False
modified	smalldatetime	4	16	0	False			False	False
modified_by	int	4	10	0	False			False	False
contraparte	int	4	10	0	False			False	False
black_list	varchar	1	0	0	False			False	False
black_list_score	int	4	10	0	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idxSAASHistConsu	contraparte	False
	PK_SAAS_Historial_Consultas	saas_historial_consulta	True

SQL Script

Copy

CREATE TABLE dbo.SAAS_Historial_Consultas (
  saas_historial_consulta int IDENTITY,
  saas_usuario_contrato int NOT NULL,
  fecha_consulta smalldatetime NULL,
  estado char(1) NULL,
  formales_estado char(1) NULL,
  formales_score decimal(5, 2) NULL,
  fiscales_estado char(1) NULL,
  fiscales_score decimal(5, 2) NULL,
  contables_estado char(1) NULL,
  contables_score decimal(5, 2) NULL,
  patrimonio_estado char(1) NULL,
  patrimonio_score decimal(5, 2) NULL,
  legales_estado char(1) NULL,
  legales_score decimal(5, 2) NULL,
  bancos_estado char(1) NULL,
  bancos_score decimal(5, 2) NULL,
  cheques_estado char(1) NULL,
  cheques_score decimal(5, 2) NULL,
  created smalldatetime NOT NULL CONSTRAINT DF__SAAS_Hist__creat__65D34A92 DEFAULT (getdate()),
  created_by int NULL,
  modified smalldatetime NULL,
  modified_by int NULL,
  contraparte int NULL,
  black_list varchar(1) NULL,
  black_list_score int NULL,
  CONSTRAINT PK_SAAS_Historial_Consultas PRIMARY KEY CLUSTERED (saas_historial_consulta) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX idxSAASHistConsu
  ON dbo.SAAS_Historial_Consultas (contraparte)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.SAAS_Historial_Consultas