dbo.gdl_contratos

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:57 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
contrato	int	4	10	0	True	1 - 1	False	False
cliente	int	4	10	0	False		False	False
vigencia_desde	datetime	8	23	3	False		False	False
vigencia_hasta	datetime	8	23	3	False		False	False
nombre_contrato	varchar	50	0	0	False		False	False
dia_envio_notificaciones	int	4	10	0	False		False	False
max_emails_ciclo	int	4	10	0	False		False	False
max_llamados_ciclo	int	4	10	0	False		False	False
dias_entre_email	int	4	10	0	False		False	False
dias_entre_llamado	int	4	10	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	XPKgdl_contratos	contrato	True

SQL Script

Copy

CREATE TABLE dbo.gdl_contratos (
  contrato int IDENTITY,
  cliente int NULL,
  vigencia_desde datetime NULL,
  vigencia_hasta datetime NULL,
  nombre_contrato varchar(50) NULL,
  dia_envio_notificaciones int NULL,
  max_emails_ciclo int NULL,
  max_llamados_ciclo int NULL,
  dias_entre_email int NULL,
  dias_entre_llamado int NULL,
  CONSTRAINT XPKgdl_contratos PRIMARY KEY CLUSTERED (contrato) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

dbo.gdl_detalle_contratos