dbo.gdl_tipos

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 (~)	5
Created	7/15/2014 4:55:03 PM
Last Modified	4/2/2016 11:03:12 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
tipo_tarea	int	4	10	True	1 - 1	False	False
nombre_tipo_tarea	varchar	50	0	False		False	False
activacion	tinyint	1	3	False		False	False
registracion	tinyint	1	3	False		False	False
aviso_baja_legajo	tinyint	1	3	False		False	False
relevamiento_datos	tinyint	1	3	False		False	False
carga_datos	tinyint	1	3	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	XPKgdl_tipos_tarea	tipo_tarea	True

Triggers

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

SQL Script

Copy

CREATE TABLE dbo.gdl_tipos_tarea (
  tipo_tarea int IDENTITY,
  nombre_tipo_tarea varchar(50) NULL,
  activacion tinyint NULL,
  registracion tinyint NULL,
  aviso_baja_legajo tinyint NULL,
  relevamiento_datos tinyint NULL,
  carga_datos tinyint NULL,
  CONSTRAINT XPKgdl_tipos_tarea PRIMARY KEY CLUSTERED (tipo_tarea) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

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

    /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
    /* gdl_tipos_tarea R/36 gdl_usuarios_tipo_tarea on parent delete no action */
    /* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_tipos_tarea"
        CHILD_OWNER="", CHILD_TABLE="gdl_usuarios_tipo_tarea"
        P2C_VERB_PHRASE="R/36", C2P_VERB_PHRASE="R/36",
        FK_CONSTRAINT="R_36", FK_COLUMNS="tipo_tarea" */
    IF EXISTS (
      SELECT * FROM deleted,gdl_usuarios_tipo_tarea
      WHERE
        /*  %JoinFKPK(gdl_usuarios_tipo_tarea,deleted," = "," AND") */
        gdl_usuarios_tipo_tarea.tipo_tarea = deleted.tipo_tarea
    )
    BEGIN
      SELECT @errno  = 30001,
             @errmsg = 'Cannot delete gdl_tipos_tarea because gdl_usuarios_tipo_tarea 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_tipos_tarea]    Script Date: 06/16/2014 15:10:19 ******/
SET ANSI_NULLS ON
GO
CREATE OR ALTER trigger dbo.tU_gdl_tipos_tarea ON dbo.gdl_tipos_tarea FOR UPDATE AS
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* UPDATE trigger on gdl_tipos_tarea */
BEGIN
  DECLARE  @NUMROWS int,
           @nullcnt int,
           @validcnt int,
           @instipo_tarea int,
           @errno   int,
           @errmsg  varchar(255)

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

  /* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
  /* gdl_tipos_tarea R/36 gdl_usuarios_tipo_tarea on parent update no action */
  /* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_tipos_tarea"
      CHILD_OWNER="", CHILD_TABLE="gdl_usuarios_tipo_tarea"
      P2C_VERB_PHRASE="R/36", C2P_VERB_PHRASE="R/36",
      FK_CONSTRAINT="R_36", FK_COLUMNS="tipo_tarea" */
  IF
    /* %ParentPK(" OR",UPDATE) */
    UPDATE(tipo_tarea)
  BEGIN
    IF EXISTS (
      SELECT * FROM deleted,gdl_usuarios_tipo_tarea
      WHERE
        /*  %JoinFKPK(gdl_usuarios_tipo_tarea,deleted," = "," AND") */
        gdl_usuarios_tipo_tarea.tipo_tarea = deleted.tipo_tarea
    )
    BEGIN
      SELECT @errno  = 30005,
             @errmsg = 'Cannot update gdl_tipos_tarea because gdl_usuarios_tipo_tarea 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].[tD_gdl_usuarios_tipo_tarea]    Script Date: 06/16/2014 15:10:46 ******/
SET ANSI_NULLS ON
GO

dbo.gdl_tipos_tarea