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 (~) | 17 |
| Created | 2/23/2021 3:25:14 PM |
| Last Modified | 2/24/2021 10:12:39 AM |
Columns
9| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| app_id | tinyint | 1 | 3 | 0 | True |
False |
False |
|||||
| app_name | varchar | 50 | 0 | 0 | True |
False |
False |
|||||
| app_url | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| activo | bit | 1 | 1 | 0 | True |
False |
False |
|||||
| codigo_app | varchar | 3 | 0 | 0 | False |
False |
False |
|||||
| idiomas | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| servicio_contratado | int | 4 | 10 | 0 | False |
False |
False |
|||||
| cliente_contraparte | int | 4 | 10 | 0 | False |
False |
False |
|||||
| migrado | bit | 1 | 1 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.fide_apps (
app_id tinyint NOT NULL,
app_name varchar(50) NOT NULL,
app_url varchar(100) NULL,
activo bit NOT NULL,
codigo_app varchar(3) NULL,
idiomas varchar(100) NULL,
servicio_contratado int NULL,
cliente_contraparte int NULL,
migrado bit NULL
)
ON [PRIMARY]
GO
app_id tinyint NOT NULL,
app_name varchar(50) NOT NULL,
app_url varchar(100) NULL,
activo bit NOT NULL,
codigo_app varchar(3) NULL,
idiomas varchar(100) NULL,
servicio_contratado int NULL,
cliente_contraparte int NULL,
migrado bit NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas