dbo.te_movistar

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 (~)	9059411
Created	2/5/2018 8:36:16 PM
Last Modified	9/27/2018 10:56:29 AM

Columns

Key	Name	Data Type	Length	Precision	Not Null	Identity	Default	Computed	Persisted
	documento	varchar	20	0	False		(NULL)	False	False
	sexo	varchar	1	0	False		(NULL)	False	False
	nombre	varchar	100	0	False		(NULL)	False	False
	direccion	varchar	100	0	False		(NULL)	False	False
	localidad	varchar	50	0	False		(NULL)	False	False
	cpostal	varchar	4	0	False		(NULL)	False	False
	provincia	varchar	25	0	False		(NULL)	False	False
	celular	varchar	20	0	False		(NULL)	False	False
	telfijo	varchar	20	0	False		(NULL)	False	False
	producto	varchar	10	0	False		(NULL)	False	False
	debito	varchar	10	0	False		(NULL)	False	False
	precio	varchar	20	0	False		(NULL)	False	False
	recarga1	varchar	20	0	False		(NULL)	False	False
	recarga2	varchar	20	0	False		(NULL)	False	False
	recarga3	varchar	20	0	False		(NULL)	False	False
	recarga4	varchar	20	0	True		(NULL)	False	False
	cuit	varchar	20	0	False			False	False
2	id_movistar	int	4	10	True	1 - 1		False	False
	_domicilios_proc	tinyint	1	3	False			False	False

Indexes

Name	Columns	Unique
idx_movistar_direccion_cuit	direccion, cuit	False
idx_movistar_telfijo_idmovistar	telfijo, id_movistar	False
idx_te_movistar_temp_idmovistar	id_movistar	False

SQL Script

Copy

CREATE TABLE dbo.te_movistar_temp (
  documento varchar(20) NULL CONSTRAINT DF__te_movist__docum__5419C19F DEFAULT (NULL),
  sexo varchar(1) NULL CONSTRAINT DF__te_movista__sexo__550DE5D8 DEFAULT (NULL),
  nombre varchar(100) NULL CONSTRAINT DF__te_movist__nombr__56020A11 DEFAULT (NULL),
  direccion varchar(100) NULL CONSTRAINT DF__te_movist__direc__56F62E4A DEFAULT (NULL),
  localidad varchar(50) NULL CONSTRAINT DF__te_movist__local__57EA5283 DEFAULT (NULL),
  cpostal varchar(4) NULL CONSTRAINT DF__te_movist__cpost__58DE76BC DEFAULT (NULL),
  provincia varchar(25) NULL CONSTRAINT DF__te_movist__provi__59D29AF5 DEFAULT (NULL),
  celular varchar(20) NULL CONSTRAINT DF__te_movist__celul__5AC6BF2E DEFAULT (NULL),
  telfijo varchar(20) NULL CONSTRAINT DF__te_movist__telfi__5BBAE367 DEFAULT (NULL),
  producto varchar(10) NULL CONSTRAINT DF__te_movist__produ__5CAF07A0 DEFAULT (NULL),
  debito varchar(10) NULL CONSTRAINT DF__te_movist__debit__5DA32BD9 DEFAULT (NULL),
  precio varchar(20) NULL CONSTRAINT DF__te_movist__preci__5E975012 DEFAULT (NULL),
  recarga1 varchar(20) NULL CONSTRAINT DF__te_movist__recar__5F8B744B DEFAULT (NULL),
  recarga2 varchar(20) NULL CONSTRAINT DF__te_movist__recar__607F9884 DEFAULT (NULL),
  recarga3 varchar(20) NULL CONSTRAINT DF__te_movist__recar__6173BCBD DEFAULT (NULL),
  recarga4 varchar(20) NOT NULL CONSTRAINT DF__te_movist__recar__6267E0F6 DEFAULT (NULL),
  cuit varchar(20) NULL,
  id_movistar int IDENTITY,
  _domicilios_proc tinyint NULL
)
ON [PRIMARY]
GO

CREATE INDEX idx_movistar_direccion_cuit
  ON dbo.te_movistar_temp (direccion, cuit)
  INCLUDE (localidad, cpostal, id_movistar)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_movistar_telfijo_idmovistar
  ON dbo.te_movistar_temp (telfijo, id_movistar)
  INCLUDE (cuit)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_te_movistar_temp_idmovistar
  ON dbo.te_movistar_temp (id_movistar)
  INCLUDE (celular, cuit)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

dbo.sp_procesos_bdd_fisicas_telefonos