Actions
Feature #1600
openTask 20278: Notificaciones: Corregir antes de notificar
Status:
In Progress
Priority:
Normal
Assignee:
Category:
-
Target version:
Start date:
04/21/2026
Due date:
% Done:
0%
Estimated time:
150:00 h
Actions
Added by Estefany Santiago Trinidad about 1 month ago. Updated about 9 hours ago.
0%
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),
)