dbo.led_empleados

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 (~)	0
Created	3/6/2025 6:55:53 PM
Last Modified	3/6/2025 6:55:56 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
empleado	int	4	10	0	True	1 - 1		False	False
cliente	int	4	10	0	False			False	False
estado_empleado	varchar	1	0	0	False			False	False
tipo_empleado	tinyint	1	3	0	False			False	False
contratista	int	4	10	0	False			False	False
id_padron	int	4	10	0	False			False	False
contratista_1	int	4	10	0	False			False	False
alta_afip	datetime	8	23	3	False			False	False
baja_afip	datetime	8	23	3	False			False	False
created	datetime	8	23	3	False		(getdate())	False	False
servicios	text		0	0	False			False	False
subservicios	text		0	0	False			False	False
locaciones	text		0	0	False			False	False
domicilio_trabajo	varchar	500	0	0	False			False	False
old_tipo_empleado	int	4	10	0	False			False	False
migrado_por	varchar	3	0	0	False			False	False
migrado_fecha	smalldatetime	4	16	0	False			False	False
alta_servicio	date	3	10	0	False		(getdate())	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	XPKled_empleados	empleado	True

SQL Script

Copy

CREATE TABLE dbo.led_empleados (
  empleado int IDENTITY,
  cliente int NULL,
  estado_empleado varchar(1) NULL,
  tipo_empleado tinyint NULL,
  contratista int NULL,
  id_padron int NULL,
  contratista_1 int NULL,
  alta_afip datetime NULL,
  baja_afip datetime NULL,
  created datetime NULL DEFAULT (getdate()),
  servicios text NULL,
  subservicios text NULL,
  locaciones text NULL,
  domicilio_trabajo varchar(500) NULL,
  old_tipo_empleado int NULL,
  migrado_por varchar(3) NULL,
  migrado_fecha smalldatetime NULL,
  alta_servicio date NULL DEFAULT (getdate()),
  CONSTRAINT XPKled_empleados PRIMARY KEY CLUSTERED (empleado) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found