Project

General

Profile

Actions
Copy link

Feature #1600

open

Task 20278: Notificaciones: Corregir antes de notificar

Added by Estefany Santiago Trinidad about 1 month ago. Updated about 9 hours ago.

Status:
In Progress
Priority:
Normal
Assignee:
Yaira Rivera
Category:
-
Target version:
OAT - SUMAC | Asuntos Prioridad 2 | May-2026
Start date:
04/21/2026
Due date:
% Done:

0%

Estimated time:
150:00 h

Description

Actions
Copy link
 #1

Updated by Yaira Rivera 18 days ago

  • Status changed from Not Started to In Progress
  • Assignee set to Yaira Rivera
Actions
Copy link
 #2

Updated by Yaira Rivera about 9 hours ago 

INSERT INTO SUMACCatalogValueType (Code, DescriptionES, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate)
VALUES (26, 'Tipo de estampa', 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE())

INSERT INTO SUMACCatalogValue (Code, DescriptionES, CatalogTypeCode, IsLocked, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate)
VALUES 
	(388, 'Firma', 26, 1, 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE()),
	(389, 'Iniciales', 26, 1, 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE()),
	(390, 'Sello', 26, 1, 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE(), 'BA188E4A-E2B5-45F3-9835-32C94121C00E', GETDATE())
	
CREATE TABLE SUMACMunicipalQA.dbo.SUMACSignature (
    SignatureId int IDENTITY(1,1) NOT NULL,
    FileId int NOT NULL,
    Location varchar(100) NULL,
   	Width decimal(20, 10) NOT NULL,
   	Height decimal(20, 10) NOT NULL,
   	xAxisCoordinates decimal(20, 10) NOT NULL, 
   	yAxisCoordinates decimal(20, 10) NOT NULL,
   	PageNumber int NOT NULL,
   	TypeCode int NOT NULL,
    IsHidden bit DEFAULT 0 NOT NULL,
    HiddenReason varchar(100) NULL,
    CreatedDate datetime NOT NULL,
    CreatedBy uniqueidentifier NOT NULL,
    ModifiedDate datetime NOT NULL,
    ModifiedBy uniqueidentifier NOT NULL,
    UpdateVersion timestamp NOT NULL,
    CONSTRAINT PK__SignatureId PRIMARY KEY (SignatureId),
    CONSTRAINT fk_fromSUMACSignatureToSUMACFileBase FOREIGN KEY (FileId) REFERENCES SUMACMunicipalQA.dbo.SUMACFileBase(FileId),
    CONSTRAINT fk_fromSUMACSignatureToSUMACCatalogValue FOREIGN KEY (TypeCode) REFERENCES SUMACMunicipalQA.dbo.SUMACCatalogValue(Code),
)
Actions
Copy link

Also available in: Atom PDF