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:53 PM |
| Last Modified | 3/6/2025 6:55:57 PM |
Columns
8| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| identificador | varchar | 10 | 0 | 0 | True |
False |
False |
|||||
| nombre_identificador | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| country_code | varchar | 2 | 0 | 0 | False |
False |
False |
|||||
| abreviatura | varchar | 20 | 0 | 0 | False |
False |
False |
|||||
| se_usa | bit | 1 | 1 | 0 | True |
(1) | False |
False |
||||
| tipo_ident | char | 1 | 0 | 0 | False |
False |
False |
|||||
| es_pasaporte | bit | 1 | 1 | 0 | False |
False |
False |
|||||
| orden | int | 4 | 10 | 0 | False |
False |
False |
Indexes
1Foreign Keys
20| Name | Columns | Description |
|---|---|---|
| FK__identific__count__63649880 | country_code | |
| FK__identific__count__6458BCB9 | country_code | |
| FK__identific__count__654CE0F2 | country_code | |
| FK__identific__count__6641052B | country_code | |
| FK__identific__count__67352964 | country_code | |
| FK__identific__count__68294D9D | country_code | |
| FK__identific__count__691D71D6 | country_code | |
| FK__identific__count__6A11960F | country_code | |
| FK__identific__count__6B05BA48 | country_code | |
| FK__identific__count__6BF9DE81 | country_code | |
| FK__identific__count__6CEE02BA | country_code | |
| FK__identific__count__6DE226F3 | country_code | |
| FK__identific__count__6ED64B2C | country_code | |
| FK__identific__count__6FCA6F65 | country_code | |
| FK__identific__count__70BE939E | country_code | |
| FK__identific__count__71B2B7D7 | country_code | |
| FK__identific__count__72A6DC10 | country_code | |
| FK__identific__count__739B0049 | country_code | |
| FK__identific__count__748F2482 | country_code | |
| FK__identific__count__758348BB | country_code |
SQL Script
Copy
CREATE TABLE dbo.identificadores (
identificador varchar(10) NOT NULL,
nombre_identificador varchar(100) NULL,
country_code varchar(2) NULL,
abreviatura varchar(20) NULL,
se_usa bit NOT NULL DEFAULT (1),
tipo_ident char(1) NULL,
es_pasaporte bit NULL,
orden int NULL,
PRIMARY KEY NONCLUSTERED (identificador) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
identificador varchar(10) NOT NULL,
nombre_identificador varchar(100) NULL,
country_code varchar(2) NULL,
abreviatura varchar(20) NULL,
se_usa bit NOT NULL DEFAULT (1),
tipo_ident char(1) NULL,
es_pasaporte bit NULL,
orden int NULL,
PRIMARY KEY NONCLUSTERED (identificador) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
ALTER TABLE dbo.identificadores
ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO
Depends On
2- FideDoc
- dbo.country