dbo.asignacion

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 (~)	679
Created	11/23/2017 5:07:04 PM
Last Modified	12/15/2017 6:02:45 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_asignacion	int	4	10	True	1 - 1	False	False
id_tabla	int	4	10	False		False	False
tabla	varchar	50	0	False		False	False
nombre_columna	varchar	50	0	False		False	False
buscado_por_nombre	bit	1	1	False		False	False
buscado_por_domicilio	bit	1	1	False		False	False
multiplicidad	bit	1	1	False		False	False
cuit	varchar	50	0	False		False	False
proceso_1	bit	1	1	False		False	False
proceso_2	bit	1	1	False		False	False
proceso_3	bit	1	1	False		False	False
error	varchar	200	0	False		False	False
created	smalldatetime	4	16	False		False	False
modified	smalldatetime	4	16	False		False	False
busquedas_adicionales	varchar	200	0	False		False	False

SQL Script

Copy

CREATE TABLE dbo.asignacion_cuits (
  id_asignacion int IDENTITY,
  id_tabla int NULL,
  tabla varchar(50) NULL,
  nombre_columna varchar(50) NULL,
  buscado_por_nombre bit NULL,
  buscado_por_domicilio bit NULL,
  multiplicidad bit NULL,
  cuit varchar(50) NULL,
  proceso_1 bit NULL,
  proceso_2 bit NULL,
  proceso_3 bit NULL,
  error varchar(200) NULL,
  created smalldatetime NULL,
  modified smalldatetime NULL,
  busquedas_adicionales varchar(200) NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

dbo.backend_insertar_asignacion_cuit