dbo.telefonos

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 (~)	38042302
Created	12/22/2017 1:29:23 PM
Last Modified	4/17/2024 12:11:51 PM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	id_telefono	int	4	10	0	True	1 - 1		False	False
	id_padron	int	4	10	0	False			False	False
2	telefono	varchar	100	0	0	False			False	False
	tipo	varchar	50	0	0	False			False	False
	created	datetime	8	23	3	False		(getdate())	False	False
	modified	datetime	8	23	3	False			False	False
	id_fuente	int	4	10	0	False			False	False
	fuente	varchar	50	0	0	False			False	False
	telefono_limpio	varchar	100	0	0	False			False	False
	activo	bit	1	1	0	False		(1)	False	False

Indexes

Name	Columns	Unique
idx_tel_limpio	telefono_limpio	False
idx_telefonos_idpadron_telefono	id_padron, telefono	False
idxTelefonos	telefono	False

SQL Script

Copy

CREATE TABLE dbo.telefonos (
  id_telefono int IDENTITY,
  id_padron int NULL,
  telefono varchar(100) NULL,
  tipo varchar(50) NULL,
  created datetime NULL CONSTRAINT DF_telefonos_created DEFAULT (getdate()),
  modified datetime NULL,
  id_fuente int NULL,
  fuente varchar(50) NULL,
  telefono_limpio varchar(100) NULL,
  activo bit NULL DEFAULT (1)
)
ON [PRIMARY]
GO

CREATE INDEX idx_tel_limpio
  ON dbo.telefonos (telefono_limpio)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_telefonos_idpadron_telefono
  ON dbo.telefonos (id_padron, telefono)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxTelefonos
  ON dbo.telefonos (telefono)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas