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

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_contrato	int	4	10	0	True	1 - 1	False	False
nombre_contrato	varchar	100	0	0	False		False	False
country_code	varchar	2	0	0	False		False	False
fecha_venta	datetime	8	23	3	False		False	False
fecha_firma	datetime	8	23	3	False		False	False
fecha_vigencia	datetime	8	23	3	False		False	False
fecha_vencimiento	datetime	8	23	3	False		False	False
grupo	smallint	2	5	0	False		False	False
responsable_cliente	varchar	100	0	0	False		False	False
responsable_interno	varchar	100	0	0	False		False	False
estado_contrato	varchar	1	0	0	False		False	False
plazo_pago	smallint	2	5	0	False		False	False
detalle_contrato	text		0	0	False		False	False
codigo_contrato	varchar	11	0	0	False		False	False
user_id_cliente	int	4	10	0	False		False	False
user_id_interno	int	4	10	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__contrato__FF5F2A5605C13E6A	id_contrato	True

Foreign Keys

Name	Columns	Description
FK__contratos__grupo__33B5855E	grupo
FK__contratos__plazo__34A9A997	plazo_pago

SQL Script

Copy

CREATE TABLE dbo.contratos_grupos (
  id_contrato int IDENTITY,
  nombre_contrato varchar(100) NULL,
  country_code varchar(2) NULL,
  fecha_venta datetime NULL,
  fecha_firma datetime NULL,
  fecha_vigencia datetime NULL,
  fecha_vencimiento datetime NULL,
  grupo smallint NULL,
  responsable_cliente varchar(100) NULL,
  responsable_interno varchar(100) NULL,
  estado_contrato varchar(1) NULL,
  plazo_pago smallint NULL,
  detalle_contrato text NULL,
  codigo_contrato varchar(11) NULL,
  user_id_cliente int NULL,
  user_id_interno int NULL,
  PRIMARY KEY CLUSTERED (id_contrato) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE dbo.contratos_grupos
  ADD FOREIGN KEY (grupo) REFERENCES dbo.grupos (grupo)
GO

ALTER TABLE dbo.contratos_grupos
  ADD FOREIGN KEY (plazo_pago) REFERENCES dbo.plazos_pago (plazo_pago)
GO

Depends On

Used By

dbo.contratos_items