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 | 7/15/2014 4:55:04 PM |
| Last Modified | 8/10/2017 11:38:53 AM |
Columns
16| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| tarea_cc | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
||||
| descripcion | text | 0 | 0 | False |
False |
False |
||||||
| cliente | int | 4 | 10 | 0 | False |
False |
False |
|||||
| entidad_juridica | int | 4 | 10 | 0 | False |
False |
False |
|||||
| idioma | smallint | 2 | 5 | 0 | False |
False |
False |
|||||
| user_id | int | 4 | 10 | 0 | False |
False |
False |
|||||
| creacion | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| iniciada | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| finalizada | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| tipo_tarea | int | 4 | 10 | 0 | False |
False |
False |
|||||
| estado_tarea | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| legajo | int | 4 | 10 | 0 | False |
False |
False |
|||||
| tipo_doc | int | 4 | 10 | 0 | False |
False |
False |
|||||
| version | int | 4 | 10 | 0 | False |
False |
False |
|||||
| aceptada | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| excepcion_cliente | tinyint | 1 | 3 | 0 | False |
False |
False |
Triggers
2| Name | ANSI Nulls ON | Quoted Identifier ON | On | Not For Replication | Description |
|---|---|---|---|---|---|
| tD_gdl_tareas_cc | True |
True |
AFTER DELETE | False |
|
| tU_gdl_tareas_cc | True |
True |
AFTER UPDATE | False |
Foreign Keys
3| Name | Columns | Description |
|---|---|---|
| R_33 | entidad_juridica | |
| R_34 | tipo_tarea | |
| R_37 | estado_tarea |
SQL Script
Copy
CREATE TABLE dbo.gdl_tareas_cc (
tarea_cc int IDENTITY,
descripcion text NULL,
cliente int NULL,
entidad_juridica int NULL,
idioma smallint NULL,
user_id int NULL,
creacion datetime NULL,
iniciada datetime NULL,
finalizada datetime NULL,
tipo_tarea int NULL,
estado_tarea varchar(1) NULL,
legajo int NULL,
tipo_doc int NULL,
version int NULL,
aceptada datetime NULL,
excepcion_cliente tinyint NULL,
CONSTRAINT XPKgdl_tareas_cc PRIMARY KEY CLUSTERED (tarea_cc) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER trigger dbo.tD_gdl_tareas_cc ON dbo.gdl_tareas_cc FOR DELETE AS
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* DELETE trigger on gdl_tareas_cc */
BEGIN
DECLARE @errno int,
@errmsg varchar(255)
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_entidad_juridica_legajo R/33 gdl_tareas_cc on child delete no action */
/* ERWIN_RELATION:CHECKSUM="000457c4", 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_entidad_juridica_legajo
WHERE
/* %JoinFKPK(deleted,gdl_entidad_juridica_legajo," = "," AND") */
deleted.entidad_juridica = gdl_entidad_juridica_legajo.entidad_juridica AND
NOT EXISTS (
SELECT * FROM gdl_tareas_cc
WHERE
/* %JoinFKPK(gdl_tareas_cc,gdl_entidad_juridica_legajo," = "," AND") */
gdl_tareas_cc.entidad_juridica = gdl_entidad_juridica_legajo.entidad_juridica
)
)
BEGIN
SELECT @errno = 30010,
@errmsg = 'Cannot delete last gdl_tareas_cc because gdl_entidad_juridica_legajo exists.'
GOTO ERROR
END
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_tipos_tarea R/34 gdl_tareas_cc on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", 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_tipos_tarea
WHERE
/* %JoinFKPK(deleted,gdl_tipos_tarea," = "," AND") */
deleted.tipo_tarea = gdl_tipos_tarea.tipo_tarea AND
NOT EXISTS (
SELECT * FROM gdl_tareas_cc
WHERE
/* %JoinFKPK(gdl_tareas_cc,gdl_tipos_tarea," = "," AND") */
gdl_tareas_cc.tipo_tarea = gdl_tipos_tarea.tipo_tarea
)
)
BEGIN
SELECT @errno = 30010,
@errmsg = 'Cannot delete last gdl_tareas_cc because gdl_tipos_tarea exists.'
GOTO ERROR
END
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_estados_tarea R/37 gdl_tareas_cc on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_estados_tarea"
CHILD_OWNER="", CHILD_TABLE="gdl_tareas_cc"
P2C_VERB_PHRASE="R/37", C2P_VERB_PHRASE="R/37",
FK_CONSTRAINT="R_37", FK_COLUMNS="estado_tarea" */
IF EXISTS (SELECT * FROM deleted,gdl_estados_tarea
WHERE
/* %JoinFKPK(deleted,gdl_estados_tarea," = "," AND") */
deleted.estado_tarea = gdl_estados_tarea.estado_tarea AND
NOT EXISTS (
SELECT * FROM gdl_tareas_cc
WHERE
/* %JoinFKPK(gdl_tareas_cc,gdl_estados_tarea," = "," AND") */
gdl_tareas_cc.estado_tarea = gdl_estados_tarea.estado_tarea
)
)
BEGIN
SELECT @errno = 30010,
@errmsg = 'Cannot delete last gdl_tareas_cc because gdl_estados_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_tareas_cc] Script Date: 06/16/2014 15:04:39 ******/
SET ANSI_NULLS ON
GO
CREATE OR ALTER trigger dbo.tU_gdl_tareas_cc ON dbo.gdl_tareas_cc FOR UPDATE AS
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* UPDATE trigger on gdl_tareas_cc */
BEGIN
DECLARE @NUMROWS int,
@nullcnt int,
@validcnt int,
@instarea_cc int,
@errno int,
@errmsg varchar(255)
SELECT @NUMROWS = @@rowcount
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_entidad_juridica_legajo R/33 gdl_tareas_cc on child update no action */
/* ERWIN_RELATION:CHECKSUM="0004fa98", 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
/* %ChildFK(" OR",UPDATE) */
UPDATE(entidad_juridica)
BEGIN
SELECT @nullcnt = 0
SELECT @validcnt = count(*)
FROM inserted,gdl_entidad_juridica_legajo
WHERE
/* %JoinFKPK(inserted,gdl_entidad_juridica_legajo) */
inserted.entidad_juridica = gdl_entidad_juridica_legajo.entidad_juridica
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */
select @nullcnt = count(*) from inserted where
inserted.entidad_juridica IS NULL
IF @validcnt + @nullcnt != @NUMROWS
BEGIN
SELECT @errno = 30007,
@errmsg = 'Cannot update gdl_tareas_cc because gdl_entidad_juridica_legajo does not exist.'
GOTO ERROR
END
END
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_tipos_tarea R/34 gdl_tareas_cc on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", 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
/* %ChildFK(" OR",UPDATE) */
UPDATE(tipo_tarea)
BEGIN
SELECT @nullcnt = 0
SELECT @validcnt = count(*)
FROM inserted,gdl_tipos_tarea
WHERE
/* %JoinFKPK(inserted,gdl_tipos_tarea) */
inserted.tipo_tarea = gdl_tipos_tarea.tipo_tarea
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */
select @nullcnt = count(*) from inserted where
inserted.tipo_tarea IS NULL
IF @validcnt + @nullcnt != @NUMROWS
BEGIN
SELECT @errno = 30007,
@errmsg = 'Cannot update gdl_tareas_cc because gdl_tipos_tarea does not exist.'
GOTO ERROR
END
END
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_estados_tarea R/37 gdl_tareas_cc on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_estados_tarea"
CHILD_OWNER="", CHILD_TABLE="gdl_tareas_cc"
P2C_VERB_PHRASE="R/37", C2P_VERB_PHRASE="R/37",
FK_CONSTRAINT="R_37", FK_COLUMNS="estado_tarea" */
IF
/* %ChildFK(" OR",UPDATE) */
UPDATE(estado_tarea)
BEGIN
SELECT @nullcnt = 0
SELECT @validcnt = count(*)
FROM inserted,gdl_estados_tarea
WHERE
/* %JoinFKPK(inserted,gdl_estados_tarea) */
inserted.estado_tarea = gdl_estados_tarea.estado_tarea
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */
select @nullcnt = count(*) from inserted where
inserted.estado_tarea IS NULL
IF @validcnt + @nullcnt != @NUMROWS
BEGIN
SELECT @errno = 30007,
@errmsg = 'Cannot update gdl_tareas_cc because gdl_estados_tarea does not exist.'
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_tipo_campo_doc] Script Date: 06/16/2014 15:06:26 ******/
SET ANSI_NULLS ON
GO
ALTER TABLE dbo.gdl_tareas_cc
ADD CONSTRAINT R_33 FOREIGN KEY (entidad_juridica) REFERENCES dbo.gdl_entidad_juridica_legajo (entidad_juridica)
GO
ALTER TABLE dbo.gdl_tareas_cc
ADD CONSTRAINT R_34 FOREIGN KEY (tipo_tarea) REFERENCES dbo.gdl_tipos_tarea (tipo_tarea)
GO
ALTER TABLE dbo.gdl_tareas_cc
ADD CONSTRAINT R_37 FOREIGN KEY (estado_tarea) REFERENCES dbo.gdl_estados_tarea (estado_tarea)
GO
tarea_cc int IDENTITY,
descripcion text NULL,
cliente int NULL,
entidad_juridica int NULL,
idioma smallint NULL,
user_id int NULL,
creacion datetime NULL,
iniciada datetime NULL,
finalizada datetime NULL,
tipo_tarea int NULL,
estado_tarea varchar(1) NULL,
legajo int NULL,
tipo_doc int NULL,
version int NULL,
aceptada datetime NULL,
excepcion_cliente tinyint NULL,
CONSTRAINT XPKgdl_tareas_cc PRIMARY KEY CLUSTERED (tarea_cc) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER trigger dbo.tD_gdl_tareas_cc ON dbo.gdl_tareas_cc FOR DELETE AS
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* DELETE trigger on gdl_tareas_cc */
BEGIN
DECLARE @errno int,
@errmsg varchar(255)
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_entidad_juridica_legajo R/33 gdl_tareas_cc on child delete no action */
/* ERWIN_RELATION:CHECKSUM="000457c4", 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_entidad_juridica_legajo
WHERE
/* %JoinFKPK(deleted,gdl_entidad_juridica_legajo," = "," AND") */
deleted.entidad_juridica = gdl_entidad_juridica_legajo.entidad_juridica AND
NOT EXISTS (
SELECT * FROM gdl_tareas_cc
WHERE
/* %JoinFKPK(gdl_tareas_cc,gdl_entidad_juridica_legajo," = "," AND") */
gdl_tareas_cc.entidad_juridica = gdl_entidad_juridica_legajo.entidad_juridica
)
)
BEGIN
SELECT @errno = 30010,
@errmsg = 'Cannot delete last gdl_tareas_cc because gdl_entidad_juridica_legajo exists.'
GOTO ERROR
END
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_tipos_tarea R/34 gdl_tareas_cc on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", 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_tipos_tarea
WHERE
/* %JoinFKPK(deleted,gdl_tipos_tarea," = "," AND") */
deleted.tipo_tarea = gdl_tipos_tarea.tipo_tarea AND
NOT EXISTS (
SELECT * FROM gdl_tareas_cc
WHERE
/* %JoinFKPK(gdl_tareas_cc,gdl_tipos_tarea," = "," AND") */
gdl_tareas_cc.tipo_tarea = gdl_tipos_tarea.tipo_tarea
)
)
BEGIN
SELECT @errno = 30010,
@errmsg = 'Cannot delete last gdl_tareas_cc because gdl_tipos_tarea exists.'
GOTO ERROR
END
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_estados_tarea R/37 gdl_tareas_cc on child delete no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_estados_tarea"
CHILD_OWNER="", CHILD_TABLE="gdl_tareas_cc"
P2C_VERB_PHRASE="R/37", C2P_VERB_PHRASE="R/37",
FK_CONSTRAINT="R_37", FK_COLUMNS="estado_tarea" */
IF EXISTS (SELECT * FROM deleted,gdl_estados_tarea
WHERE
/* %JoinFKPK(deleted,gdl_estados_tarea," = "," AND") */
deleted.estado_tarea = gdl_estados_tarea.estado_tarea AND
NOT EXISTS (
SELECT * FROM gdl_tareas_cc
WHERE
/* %JoinFKPK(gdl_tareas_cc,gdl_estados_tarea," = "," AND") */
gdl_tareas_cc.estado_tarea = gdl_estados_tarea.estado_tarea
)
)
BEGIN
SELECT @errno = 30010,
@errmsg = 'Cannot delete last gdl_tareas_cc because gdl_estados_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_tareas_cc] Script Date: 06/16/2014 15:04:39 ******/
SET ANSI_NULLS ON
GO
CREATE OR ALTER trigger dbo.tU_gdl_tareas_cc ON dbo.gdl_tareas_cc FOR UPDATE AS
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* UPDATE trigger on gdl_tareas_cc */
BEGIN
DECLARE @NUMROWS int,
@nullcnt int,
@validcnt int,
@instarea_cc int,
@errno int,
@errmsg varchar(255)
SELECT @NUMROWS = @@rowcount
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_entidad_juridica_legajo R/33 gdl_tareas_cc on child update no action */
/* ERWIN_RELATION:CHECKSUM="0004fa98", 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
/* %ChildFK(" OR",UPDATE) */
UPDATE(entidad_juridica)
BEGIN
SELECT @nullcnt = 0
SELECT @validcnt = count(*)
FROM inserted,gdl_entidad_juridica_legajo
WHERE
/* %JoinFKPK(inserted,gdl_entidad_juridica_legajo) */
inserted.entidad_juridica = gdl_entidad_juridica_legajo.entidad_juridica
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */
select @nullcnt = count(*) from inserted where
inserted.entidad_juridica IS NULL
IF @validcnt + @nullcnt != @NUMROWS
BEGIN
SELECT @errno = 30007,
@errmsg = 'Cannot update gdl_tareas_cc because gdl_entidad_juridica_legajo does not exist.'
GOTO ERROR
END
END
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_tipos_tarea R/34 gdl_tareas_cc on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", 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
/* %ChildFK(" OR",UPDATE) */
UPDATE(tipo_tarea)
BEGIN
SELECT @nullcnt = 0
SELECT @validcnt = count(*)
FROM inserted,gdl_tipos_tarea
WHERE
/* %JoinFKPK(inserted,gdl_tipos_tarea) */
inserted.tipo_tarea = gdl_tipos_tarea.tipo_tarea
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */
select @nullcnt = count(*) from inserted where
inserted.tipo_tarea IS NULL
IF @validcnt + @nullcnt != @NUMROWS
BEGIN
SELECT @errno = 30007,
@errmsg = 'Cannot update gdl_tareas_cc because gdl_tipos_tarea does not exist.'
GOTO ERROR
END
END
/* ERwin Builtin Wednesday, March 27, 2013 3:55:23 PM */
/* gdl_estados_tarea R/37 gdl_tareas_cc on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="gdl_estados_tarea"
CHILD_OWNER="", CHILD_TABLE="gdl_tareas_cc"
P2C_VERB_PHRASE="R/37", C2P_VERB_PHRASE="R/37",
FK_CONSTRAINT="R_37", FK_COLUMNS="estado_tarea" */
IF
/* %ChildFK(" OR",UPDATE) */
UPDATE(estado_tarea)
BEGIN
SELECT @nullcnt = 0
SELECT @validcnt = count(*)
FROM inserted,gdl_estados_tarea
WHERE
/* %JoinFKPK(inserted,gdl_estados_tarea) */
inserted.estado_tarea = gdl_estados_tarea.estado_tarea
/* %NotnullFK(inserted," IS NULL","select @nullcnt = count(*) from inserted where"," AND") */
select @nullcnt = count(*) from inserted where
inserted.estado_tarea IS NULL
IF @validcnt + @nullcnt != @NUMROWS
BEGIN
SELECT @errno = 30007,
@errmsg = 'Cannot update gdl_tareas_cc because gdl_estados_tarea does not exist.'
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_tipo_campo_doc] Script Date: 06/16/2014 15:06:26 ******/
SET ANSI_NULLS ON
GO
ALTER TABLE dbo.gdl_tareas_cc
ADD CONSTRAINT R_33 FOREIGN KEY (entidad_juridica) REFERENCES dbo.gdl_entidad_juridica_legajo (entidad_juridica)
GO
ALTER TABLE dbo.gdl_tareas_cc
ADD CONSTRAINT R_34 FOREIGN KEY (tipo_tarea) REFERENCES dbo.gdl_tipos_tarea (tipo_tarea)
GO
ALTER TABLE dbo.gdl_tareas_cc
ADD CONSTRAINT R_37 FOREIGN KEY (estado_tarea) REFERENCES dbo.gdl_estados_tarea (estado_tarea)
GO