dbo.gdl_entidad_juridica

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 (~)	863
Created	7/15/2014 4:55:04 PM
Last Modified	8/15/2017 5:19:38 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
entidad_juridica	int	4	10	0	True	1 - 1		False	False
nombre_entidad_juridica	varchar	50	0	0	False			False	False
cliente	int	4	10	0	False			False	False
identificador	varchar	10	0	0	False			False	False
numero	varchar	30	0	0	False			False	False
email_contacto	varchar	50	0	0	False			False	False
domicilio	varchar	200	0	0	False			False	False
localidad	varchar	100	0	0	False			False	False
provincia	varchar	50	0	0	False			False	False
codigo_postal	varchar	15	0	0	False			False	False
country_code	varchar	2	0	0	False			False	False
telefono1	varchar	20	0	0	False			False	False
telefono2	varchar	20	0	0	False			False	False
fax	varchar	20	0	0	False			False	False
idioma	smallint	2	5	0	False			False	False
contador_ciclos_interaccion	int	4	10	0	False			False	False
contador_emails_interaccion	int	4	10	0	False			False	False
contador_llamados_interaccion	int	4	10	0	False			False	False
ultima_modif_legajos	datetime	8	23	3	False			False	False
ultimo_envio_mail	datetime	8	23	3	False			False	False
ultimo_llamado_cc	datetime	8	23	3	False			False	False
user_id_carga	int	4	10	0	False			False	False
rubro	int	4	10	0	False			False	False
nombre_contacto	varchar	100	0	0	False			False	False
fecha_cierre_ej	datetime	8	23	3	False			False	False
password	varchar	20	0	0	False			False	False
changed_pwd	tinyint	1	3	0	False			False	False
ultimo_login	datetime	8	23	3	False			False	False
expira_pwd	datetime	8	23	3	False			False	False
inicio_actividades	datetime	8	23	3	False			False	False
comprador_vendedor	int	4	10	0	False			False	False
requiere_activacion	tinyint	1	3	0	False			False	False
proximo_llamado_cc	datetime	8	23	3	False			False	False
activa	tinyint	1	3	0	True		(1)	False	False
usuario_alta	int	4	10	0	False			False	False
fecha_hora_alta	datetime	8	23	3	False		(getdate())	False	False
cliente3	int	4	10	0	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	XPKgdl_entidad_juridica_legajo	entidad_juridica	True

Triggers

Name	ANSI Nulls ON	Quoted Identifier ON	On	Not For Replication	Description
tD_gdl_entidad_juridica_legajo	True	True	AFTER DELETE	False
tU_gdl_entidad_juridica_legajo	True	True	AFTER UPDATE	False

Foreign Keys

Name	Columns	Description
R_189	rubro

SQL Script

Copy

CREATE TABLE dbo.gdl_entidad_juridica_legajo (
  entidad_juridica int IDENTITY,
  nombre_entidad_juridica varchar(50) NULL,
  cliente int NULL,
  identificador varchar(10) NULL,
  numero varchar(30) NULL,
  email_contacto varchar(50) NULL,
  domicilio varchar(200) NULL,
  localidad varchar(100) NULL,
  provincia varchar(50) NULL,
  codigo_postal varchar(15) NULL,
  country_code varchar(2) NULL,
  telefono1 varchar(20) NULL,
  telefono2 varchar(20) NULL,
  fax varchar(20) NULL,
  idioma smallint NULL,
  contador_ciclos_interaccion int NULL,
  contador_emails_interaccion int NULL,
  contador_llamados_interaccion int NULL,
  ultima_modif_legajos datetime NULL,
  ultimo_envio_mail datetime NULL,
  ultimo_llamado_cc datetime NULL,
  user_id_carga int NULL,
  rubro int NULL,
  nombre_contacto varchar(100) NULL,
  fecha_cierre_ej datetime NULL,
  password varchar(20) NULL,
  changed_pwd tinyint NULL,
  ultimo_login datetime NULL,
  expira_pwd datetime NULL,
  inicio_actividades datetime NULL,
  comprador_vendedor int NULL,
  requiere_activacion tinyint NULL,
  proximo_llamado_cc datetime NULL,
  activa tinyint NOT NULL DEFAULT (1),
  usuario_alta int NULL,
  fecha_hora_alta datetime NULL DEFAULT (getdate()),
  cliente3 int NULL,
  CONSTRAINT XPKgdl_entidad_juridica_legajo PRIMARY KEY CLUSTERED (entidad_juridica) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER trigger dbo.tD_gdl_entidad_juridica_legajo ON dbo.gdl_entidad_juridica_legajo FOR DELETE AS
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* DELETE trigger on gdl_entidad_juridica_legajo */
BEGIN
  DECLARE  @errno   int,
           @errmsg  varchar(255)
    /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
    /* gdl_entidad_juridica_legajo R/9 gdl_legajos on parent delete no action */
    /* ERWIN_RELATION:CHECKSUM="000397a9", PARENT_OWNER="", PARENT_TABLE="gdl_entidad_juridica_legajo"
        CHILD_OWNER="", CHILD_TABLE="gdl_legajos"
        P2C_VERB_PHRASE="R/9", C2P_VERB_PHRASE="",
        FK_CONSTRAINT="R_9", FK_COLUMNS="entidad_juridica" */
    IF EXISTS (
      SELECT * FROM deleted,gdl_legajos
      WHERE
        /*  %JoinFKPK(gdl_legajos,deleted," = "," AND") */
        gdl_legajos.entidad_juridica = deleted.entidad_juridica
    )
    BEGIN
      SELECT @errno  = 30001,
             @errmsg = 'Cannot delete gdl_entidad_juridica_legajo because gdl_legajos exists.'
      GOTO ERROR
    END

    /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
    /* gdl_entidad_juridica_legajo R/27 gdl_log_interaccion on parent delete no action */
    /* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_entidad_juridica_legajo"
        CHILD_OWNER="", CHILD_TABLE="gdl_log_interaccion"
        P2C_VERB_PHRASE="R/27", C2P_VERB_PHRASE="R/27",
        FK_CONSTRAINT="R_27", FK_COLUMNS="entidad_juridica" */
    IF EXISTS (
      SELECT * FROM deleted,gdl_log_interaccion
      WHERE
        /*  %JoinFKPK(gdl_log_interaccion,deleted," = "," AND") */
        gdl_log_interaccion.entidad_juridica = deleted.entidad_juridica
    )
    BEGIN
      SELECT @errno  = 30001,
             @errmsg = 'Cannot delete gdl_entidad_juridica_legajo because gdl_log_interaccion exists.'
      GOTO ERROR
    END

    /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
    /* gdl_entidad_juridica_legajo R/33 gdl_tareas_cc on parent delete no action */
    /* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_entidad_juridica_legajo"
        CHILD_OWNER="", CHILD_TABLE="gdl_tareas_cc"
        P2C_VERB_PHRASE="R/33", C2P_VERB_PHRASE="R/33",
        FK_CONSTRAINT="R_33", FK_COLUMNS="entidad_juridica" */
    IF EXISTS (
      SELECT * FROM deleted,gdl_tareas_cc
      WHERE
        /*  %JoinFKPK(gdl_tareas_cc,deleted," = "," AND") */
        gdl_tareas_cc.entidad_juridica = deleted.entidad_juridica
    )
    BEGIN
      SELECT @errno  = 30001,
             @errmsg = 'Cannot delete gdl_entidad_juridica_legajo because gdl_tareas_cc exists.'
      GOTO ERROR
    END

    /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
    RETURN
ERROR:
    raiserror (@errmsg,@errno,1)
    rollback transaction
END

/****** Object:  Trigger [dbo].[tU_gdl_entidad_juridica_legajo]    Script Date: 06/16/2014 14:57:03 ******/
SET ANSI_NULLS ON
GO
CREATE OR ALTER trigger dbo.tU_gdl_entidad_juridica_legajo ON dbo.gdl_entidad_juridica_legajo FOR UPDATE AS
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* UPDATE trigger on gdl_entidad_juridica_legajo */
BEGIN
  DECLARE  @NUMROWS int,
           @nullcnt int,
           @validcnt int,
           @insentidad_juridica int,
           @errno   int,
           @errmsg  varchar(255)

  SELECT @NUMROWS = @@rowcount
  /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
  /* gdl_entidad_juridica_legajo R/9 gdl_legajos on parent update no action */
  /* ERWIN_RELATION:CHECKSUM="0003d9c9", PARENT_OWNER="", PARENT_TABLE="gdl_entidad_juridica_legajo"
      CHILD_OWNER="", CHILD_TABLE="gdl_legajos"
      P2C_VERB_PHRASE="R/9", C2P_VERB_PHRASE="",
      FK_CONSTRAINT="R_9", FK_COLUMNS="entidad_juridica" */
  IF
    /* %ParentPK(" OR",UPDATE) */
    UPDATE(entidad_juridica)
  BEGIN
    IF EXISTS (
      SELECT * FROM deleted,gdl_legajos
      WHERE
        /*  %JoinFKPK(gdl_legajos,deleted," = "," AND") */
        gdl_legajos.entidad_juridica = deleted.entidad_juridica
    )
    BEGIN
      SELECT @errno  = 30005,
             @errmsg = 'Cannot update gdl_entidad_juridica_legajo because gdl_legajos exists.'
      GOTO ERROR
    END
  END

  /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
  /* gdl_entidad_juridica_legajo R/27 gdl_log_interaccion on parent update no action */
  /* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_entidad_juridica_legajo"
      CHILD_OWNER="", CHILD_TABLE="gdl_log_interaccion"
      P2C_VERB_PHRASE="R/27", C2P_VERB_PHRASE="R/27",
      FK_CONSTRAINT="R_27", FK_COLUMNS="entidad_juridica" */
  IF
    /* %ParentPK(" OR",UPDATE) */
    UPDATE(entidad_juridica)
  BEGIN
    IF EXISTS (
      SELECT * FROM deleted,gdl_log_interaccion
      WHERE
        /*  %JoinFKPK(gdl_log_interaccion,deleted," = "," AND") */
        gdl_log_interaccion.entidad_juridica = deleted.entidad_juridica
    )
    BEGIN
      SELECT @errno  = 30005,
             @errmsg = 'Cannot update gdl_entidad_juridica_legajo because gdl_log_interaccion exists.'
      GOTO ERROR
    END
  END

  /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
  /* gdl_entidad_juridica_legajo R/33 gdl_tareas_cc on parent update no action */
  /* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_entidad_juridica_legajo"
      CHILD_OWNER="", CHILD_TABLE="gdl_tareas_cc"
      P2C_VERB_PHRASE="R/33", C2P_VERB_PHRASE="R/33",
      FK_CONSTRAINT="R_33", FK_COLUMNS="entidad_juridica" */
  IF
    /* %ParentPK(" OR",UPDATE) */
    UPDATE(entidad_juridica)
  BEGIN
    IF EXISTS (
      SELECT * FROM deleted,gdl_tareas_cc
      WHERE
        /*  %JoinFKPK(gdl_tareas_cc,deleted," = "," AND") */
        gdl_tareas_cc.entidad_juridica = deleted.entidad_juridica
    )
    BEGIN
      SELECT @errno  = 30005,
             @errmsg = 'Cannot update gdl_entidad_juridica_legajo because gdl_tareas_cc exists.'
      GOTO ERROR
    END
  END

  /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
  RETURN
ERROR:
    raiserror (@errmsg,@errno,1)
    rollback transaction
END

/****** Object:  Trigger [dbo].[tU_gdl_entidad_scoring]    Script Date: 06/16/2014 14:57:55 ******/
SET ANSI_NULLS ON
GO

ALTER TABLE dbo.gdl_entidad_juridica_legajo
  ADD CONSTRAINT R_189 FOREIGN KEY (rubro) REFERENCES dbo.gdl_rubros (rubro)
GO

dbo.gdl_entidad_juridica_legajo