dbo.SAAS_Clientes

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	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	29
Created	10/30/2019 12:39:53 PM
Last Modified	12/2/2020 9:39:02 AM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Default	Computed	Persisted
saas_cliente	int	4	10	True	1 - 1		False	False
cliente	int	4	10	True			False	False
cliente_saas	varchar	50	0	False			False	False
id_padron	int	4	10	True			False	False
country_code	varchar	2	0	True			False	False
domicilio	varchar	200	0	False			False	False
localidad	varchar	100	0	False			False	False
provincia	varchar	100	0	False			False	False
pais	varchar	50	0	False			False	False
codpos	varchar	20	0	False			False	False
telefono	varchar	100	0	False			False	False
nombre_contacto	varchar	100	0	False			False	False
email_contacto	varchar	100	0	False			False	False
telefono_contacto	varchar	100	0	False			False	False
datos_adicionales	varchar		0	False			False	False
clave	varchar	80	0	False			False	False
clave_temporal	tinyint	1	3	False			False	False
last_login	smalldatetime	4	16	False			False	False
vigencia_desde	date	3	10	False			False	False
vigencia_hasta	date	3	10	False			False	False
activo	bit	1	1	True		(1)	False	False
created	smalldatetime	4	16	True		(getdate())	False	False
created_by	int	4	10	False			False	False
modified	smalldatetime	4	16	False			False	False
modified_by	int	4	10	False			False	False
codigo_idioma	varchar	5	0	False		('spa')	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_SAAS_Clientes	saas_cliente	True

SQL Script

Copy

CREATE TABLE dbo.SAAS_Clientes (
  saas_cliente int IDENTITY,
  cliente int NOT NULL,
  cliente_saas varchar(50) NULL,
  id_padron int NOT NULL,
  country_code varchar(2) NOT NULL,
  domicilio varchar(200) NULL,
  localidad varchar(100) NULL,
  provincia varchar(100) NULL,
  pais varchar(50) NULL,
  codpos varchar(20) NULL,
  telefono varchar(100) NULL,
  nombre_contacto varchar(100) NULL,
  email_contacto varchar(100) NULL,
  telefono_contacto varchar(100) NULL,
  datos_adicionales varchar(max) NULL,
  clave varchar(80) NULL,
  clave_temporal tinyint NULL,
  last_login smalldatetime NULL,
  vigencia_desde date NULL,
  vigencia_hasta date NULL,
  activo bit NOT NULL DEFAULT (1),
  created smalldatetime NOT NULL DEFAULT (getdate()),
  created_by int NULL,
  modified smalldatetime NULL,
  modified_by int NULL,
  codigo_idioma varchar(5) NULL DEFAULT ('spa'),
  CONSTRAINT PK_SAAS_Clientes PRIMARY KEY CLUSTERED (saas_cliente) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas