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 (~) | 178495 |
| Created | 4/10/2019 12:48:08 PM |
| Last Modified | 5/14/2019 6:19:34 PM |
Columns
7| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| contraparte | int | 4 | 10 | 0 | True |
False |
False |
|||||
| gestion | int | 4 | 10 | 0 | True |
False |
False |
|||||
| indicador | int | 4 | 10 | 0 | True |
False |
False |
|||||
| detalle_killer | varchar | 0 | 0 | False |
False |
False |
||||||
| visible | bit | 1 | 1 | 0 | True |
False |
False |
|||||
| created | datetime | 8 | 23 | 3 | True |
False |
False |
|||||
| modified | datetime | 8 | 23 | 3 | False |
False |
False |
Indexes
1| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
| idx_ln_score_detalle_killer | contraparte, gestion, indicador, visible | False |
SQL Script
Copy
CREATE TABLE dbo.ln_score_detalle_killer (
contraparte int NOT NULL,
gestion int NOT NULL,
indicador int NOT NULL,
detalle_killer varchar(max) NULL,
visible bit NOT NULL,
created datetime NOT NULL,
modified datetime NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
CREATE INDEX idx_ln_score_detalle_killer
ON dbo.ln_score_detalle_killer (contraparte, gestion, indicador, visible)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
contraparte int NOT NULL,
gestion int NOT NULL,
indicador int NOT NULL,
detalle_killer varchar(max) NULL,
visible bit NOT NULL,
created datetime NOT NULL,
modified datetime NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
CREATE INDEX idx_ln_score_detalle_killer
ON dbo.ln_score_detalle_killer (contraparte, gestion, indicador, visible)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
91- dbo.LED_PANEL_CONTROL
- dbo.LED_PANEL_CONTROL_20201216
- dbo.LED_PANEL_CONTROL_dic2020
- dbo.LED_PANEL_CONTROL_mis
- dbo.LN_contrapartes_queue_
- dbo.LN_contrapartes_queue_07122022
- dbo.LN_contrapartes_queue_ID
- dbo.LN_contrapartes_queue_NEW_
- dbo.LN_dashboard_cliente
- dbo.LN_dashboard_cliente_0822
- dbo.LN_dashboard_cliente_13052020
- dbo.LN_dashboard_cliente_2020
- dbo.LN_dashboard_cliente_20200403
- dbo.LN_dashboard_cliente_2024
- dbo.LN_dashboard_cliente_21-08-2022-AGB
- dbo.LN_dashboard_cliente_A_BORRAR
- dbo.LN_dashboard_cliente_AB
- dbo.LN_dashboard_cliente_AGB
- dbo.LN_dashboard_cliente_ant
- dbo.LN_dashboard_cliente_BACKUP_12062019_2006HORAS
- dbo.LN_dashboard_cliente_DEV
- dbo.LN_dashboard_cliente_fidelitasprod
- dbo.LN_dashboard_cliente_fidelitasprod_06122022
- dbo.LN_dashboard_cliente_fidelitasprod_16112021
- dbo.LN_dashboard_cliente_fidelitasprod_17102020
- dbo.LN_dashboard_cliente_fidelitasprod_20221012
- dbo.LN_dashboard_cliente_fidelitasprod_AB
- dbo.LN_dashboard_cliente_fidelitasprod_AGB
- dbo.LN_dashboard_cliente_fidelitasprod_DEV
- dbo.LN_dashboard_cliente_fidelitasprod_mis
- dbo.LN_dashboard_cliente_fidelitasprod_mis_06122022
- dbo.LN_dashboard_cliente_fidelitasprod_mis_18102022
- dbo.LN_dashboard_cliente_fidelitasprod_mis_prueba
- dbo.LN_dashboard_cliente_fidelitasprod_mis2
- dbo.LN_dashboard_cliente_fidelitasprod_mis2024
- dbo.LN_dashboard_cliente_fidelitasprod_prueba
- dbo.LN_dashboard_cliente_fidelitasprod_test
- dbo.LN_dashboard_cliente_fidelitasprod_vigente_o_novigente
- dbo.LN_dashboard_cliente_fidelitasprod121022
- dbo.LN_dashboard_cliente_MIS
- dbo.LN_dashboard_cliente_MS
- dbo.LN_dashboard_cliente_ppp
- dbo.LN_demo_
- dbo.LN_demo_19112021
- dbo.LN_demo_DEV
- dbo.LN_demo_mis
- dbo.LN_indicadores_manual_cliente
- dbo.LN_panel_control_excel
- dbo.LN_panel_control_excel_2020
- dbo.LN_panel_control_excel2
- dbo.LN_score_alertas
- dbo.LN_score_alertas_12dic2019
- dbo.LN_score_alertas_16082023
- dbo.LN_score_alertas_161219
- dbo.LN_score_alertas_16mar2020
- dbo.LN_score_alertas_ant
- dbo.LN_score_alertas_ant2
- dbo.LN_score_alertas_antes_de_12dic2019
- dbo.LN_score_alertas_debug
- dbo.LN_score_alertas_modificado
- dbo.LN_score_alertas_new
- dbo.LN_score_alertas_p
- dbo.LN_score_alertas_prueba
- dbo.LN_score_apocrifas
- dbo.LN_score_arba_sircreb
- dbo.LN_score_blackList
- dbo.LN_score_blackList_agb
- dbo.LN_score_datos
- dbo.LN_score_dependencia_economica
- dbo.LN_score_dependencia_economica_anterior
- dbo.LN_score_dependencia_economica_nuevo
- dbo.LN_score_detalle_killer_
- dbo.LN_score_fidecheck
- dbo.LN_score_fidecheck_ant
- dbo.LN_score_fiscales
- dbo.LN_score_fiscales_16082023
- dbo.LN_score_fiscales_antiguedad_SIN_USO
- dbo.LN_score_formal_antiguedad_edad
- dbo.LN_score_formal_antiguedad_edad_16082023
- dbo.LN_score_formal_edad_SIN_USO
- dbo.LN_score_judicial
- dbo.LN_score_judicial_dic2019
- dbo.LN_score_patrimonio
- dbo.LN_score_patrimonio_16082023
- dbo.LN_score_prensa
- dbo.LN_subcontratistas_fancy
- dbo.LN_subcontratistas_fancy_AGB
- dbo.PANEL_CONTROL_EXCEL_
- dbo.PANEL_CONTROL_EXCEL_08072024
- dbo.PANEL_CONTROL_EXCEL_11072024
- dbo.PANEL_CONTROL_EXCEL_2_