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 (~) | 128 |
| Created | 12/29/2015 4:57:46 PM |
| Last Modified | 6/15/2017 11:29:50 AM |
Columns
6| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id_blacklist | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
||||
| cliente | int | 4 | 10 | 0 | False |
False |
False |
|||||
| id_padron | int | 4 | 10 | 0 | False |
False |
False |
|||||
| causa | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| activo | tinyint | 1 | 3 | 0 | False |
False |
False |
|||||
| tipo_lista | varchar | 1 | 0 | 0 | False |
('X') | False |
False |
SQL Script
Copy
CREATE TABLE dbo.led_blacklist (
id_blacklist int IDENTITY,
cliente int NULL,
id_padron int NULL,
causa varchar(250) NULL,
activo tinyint NULL,
tipo_lista varchar(1) NULL DEFAULT ('X'),
CONSTRAINT XPKled_blacklist PRIMARY KEY CLUSTERED (id_blacklist) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO
id_blacklist int IDENTITY,
cliente int NULL,
id_padron int NULL,
causa varchar(250) NULL,
activo tinyint NULL,
tipo_lista varchar(1) NULL DEFAULT ('X'),
CONSTRAINT XPKled_blacklist PRIMARY KEY CLUSTERED (id_blacklist) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
12- dbo.Imperium_api_acceso_taxid
- dbo.Imperium_buscar_empleado_acceso
- dbo.Imperium_Digicard_Full
- dbo.Imperium_Digicard_Response
- dbo.Imperium_Digicard_Response_BKP
- dbo.Imperium_Digicard_Response_Diff
- dbo.Imperium_Digicard_Response_Diff_SIN_EMPLEADOS_LOCACIONES
- dbo.Imperium_Digicard_Response_SIN_EMPLEADOS_LOCACIONES
- dbo.Imperium_listas
- dbo.Imperium_reporte_actividad_usuarios
- dbo.LN_Impe_buscar_empleado_acceso
- dbo.LN_Impe_buscar_empleado_accesoprueba