dbo.clientes_usuarios

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:52 PM
Last Modified	3/6/2025 6:55:57 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Default	Computed	Persisted
activo	tinyint	1	3	0	False		False	False
created	datetime	8	23	3	False		False	False
cliente	int	4	10	0	True		False	False
user_id	int	4	10	0	True		False	False
last_login	datetime	8	23	3	False		False	False
global_view	tinyint	1	3	0	False		False	False
enviar_copia_aprobados	tinyint	1	3	0	False		False	False
gdl_global_view	tinyint	1	3	0	False		False	False
ingreso_solicitudes	tinyint	1	3	0	False		False	False
gdl_ingreso_legajos	tinyint	1	3	0	False		False	False
modificar_seguimientos	tinyint	1	3	0	False		False	False
gdl_modificar_legajos	tinyint	1	3	0	False		False	False
acceso_dashboard	tinyint	1	3	0	False		False	False
consulta_reportes	tinyint	1	3	0	False		False	False
gdl_consulta	tinyint	1	3	0	False		False	False
iv_ingresar_busqueda	tinyint	1	3	0	False		False	False
iv_consultar_busqueda	tinyint	1	3	0	False		False	False
iv_consultar_cuenta	tinyint	1	3	0	False		False	False
led_control_acceso	tinyint	1	3	0	False		False	False
led_control_contratistas	tinyint	1	3	0	False		False	False
led_control_doc	tinyint	1	3	0	False		False	False
id_producto	int	4	10	0	False		False	False
led_autoriza_exc_acceso	tinyint	1	3	0	False		False	False
lista_tipo_legajo	varchar	100	0	0	False		False	False
cliente3	int	4	10	0	False		False	False
led_dashboard	bit	1	1	0	False	(1)	False	False
led_panel	bit	1	1	0	False	(1)	False	False
admin_user	bit	1	1	0	True	(0)	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__clientes__1B58742448F52F57	cliente, user_id	True

Foreign Keys

Name	Columns	Description
FK__clientes___clien__5629CD9C	cliente
FK__clientes___user___2D0887CF	user_id

SQL Script

Copy

CREATE TABLE dbo.clientes_usuarios (
  activo tinyint NULL,
  created datetime NULL,
  cliente int NOT NULL,
  user_id int NOT NULL,
  last_login datetime NULL,
  global_view tinyint NULL,
  enviar_copia_aprobados tinyint NULL,
  gdl_global_view tinyint NULL,
  ingreso_solicitudes tinyint NULL,
  gdl_ingreso_legajos tinyint NULL,
  modificar_seguimientos tinyint NULL,
  gdl_modificar_legajos tinyint NULL,
  acceso_dashboard tinyint NULL,
  consulta_reportes tinyint NULL,
  gdl_consulta tinyint NULL,
  iv_ingresar_busqueda tinyint NULL,
  iv_consultar_busqueda tinyint NULL,
  iv_consultar_cuenta tinyint NULL,
  led_control_acceso tinyint NULL,
  led_control_contratistas tinyint NULL,
  led_control_doc tinyint NULL,
  id_producto int NULL,
  led_autoriza_exc_acceso tinyint NULL,
  lista_tipo_legajo varchar(100) NULL,
  cliente3 int NULL,
  led_dashboard bit NULL DEFAULT (1),
  led_panel bit NULL DEFAULT (1),
  admin_user bit NOT NULL DEFAULT (0),
  PRIMARY KEY NONCLUSTERED (cliente, user_id) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

ALTER TABLE dbo.clientes_usuarios WITH NOCHECK
  ADD CONSTRAINT FK__clientes___clien__5629CD9C FOREIGN KEY (cliente) REFERENCES dbo.clientes (cliente)
GO

ALTER TABLE dbo.clientes_usuarios WITH NOCHECK
  ADD FOREIGN KEY (user_id) REFERENCES dbo.users (user_id)
GO

Depends On

Used By

No items found