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 (~) | 32 |
| Created | 8/2/2023 12:01:09 PM |
| Last Modified | 9/15/2023 3:07:32 PM |
Columns
13| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id_trazabilidad | bigint | 8 | 19 | 0 | True |
1 - 1 | False |
False |
||||
| created | datetime | 8 | 23 | 3 | False |
(getdate()) | False |
False |
||||
| accion | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| cliente | int | 4 | 10 | 0 | False |
False |
False |
|||||
| usuario | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| codEmpresa | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| ptoTrabajo | int | 4 | 10 | 0 | False |
False |
False |
|||||
| escenario | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| vista | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| url | varchar | 200 | 0 | 0 | False |
False |
False |
|||||
| err | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| error | varchar | 500 | 0 | 0 | False |
False |
False |
|||||
| realizado | bit | 1 | 1 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.ITerceros_conexiones (
id_trazabilidad bigint IDENTITY,
created datetime NULL CONSTRAINT DF_bejerman_conexiones_created DEFAULT (getdate()),
accion varchar(100) NULL,
cliente int NULL,
usuario varchar(100) NULL,
codEmpresa varchar(100) NULL,
ptoTrabajo int NULL,
escenario varchar(100) NULL,
vista varchar(100) NULL,
url varchar(200) NULL,
err varchar(100) NULL,
error varchar(500) NULL,
realizado bit NULL
)
ON [PRIMARY]
GO
id_trazabilidad bigint IDENTITY,
created datetime NULL CONSTRAINT DF_bejerman_conexiones_created DEFAULT (getdate()),
accion varchar(100) NULL,
cliente int NULL,
usuario varchar(100) NULL,
codEmpresa varchar(100) NULL,
ptoTrabajo int NULL,
escenario varchar(100) NULL,
vista varchar(100) NULL,
url varchar(200) NULL,
err varchar(100) NULL,
error varchar(500) NULL,
realizado bit NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas