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:54 PM |
| Last Modified | 3/6/2025 6:55:56 PM |
Columns
14| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
||||
| cliente | int | 4 | 10 | 0 | False |
False |
False |
|||||
| tabla | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| causal | int | 4 | 10 | 0 | False |
False |
False |
|||||
| dias | int | 4 | 10 | 0 | False |
False |
False |
|||||
| levantados | char | 1 | 0 | 0 | False |
False |
False |
|||||
| cantidad | int | 4 | 10 | 0 | False |
False |
False |
|||||
| monto | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| valor | decimal | 9 | 18 | 2 | False |
False |
False |
|||||
| puntos | decimal | 5 | 5 | 2 | False |
False |
False |
|||||
| contenido | varchar | 20 | 0 | 0 | False |
False |
False |
|||||
| producto | varchar | 10 | 0 | 0 | False |
('LED') | False |
False |
||||
| comentario_interno | varchar | 0 | 0 | False |
False |
False |
||||||
| nodo | varchar | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.LN_dias_alertas (
id int IDENTITY,
cliente int NULL,
tabla varchar(50) NULL,
causal int NULL,
dias int NULL,
levantados char(1) NULL,
cantidad int NULL,
monto bigint NULL,
valor decimal(18, 2) NULL,
puntos decimal(5, 2) NULL,
contenido varchar(20) NULL,
producto varchar(10) NULL DEFAULT ('LED'),
comentario_interno varchar(max) NULL,
nodo varchar(max) NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
id int IDENTITY,
cliente int NULL,
tabla varchar(50) NULL,
causal int NULL,
dias int NULL,
levantados char(1) NULL,
cantidad int NULL,
monto bigint NULL,
valor decimal(18, 2) NULL,
puntos decimal(5, 2) NULL,
contenido varchar(20) NULL,
producto varchar(10) NULL DEFAULT ('LED'),
comentario_interno varchar(max) NULL,
nodo varchar(max) NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
Depends On
1- FideDoc
Used By
No items found