Actions
Bug #1367
openTask 21581: Copias Certificadas: Notificación OAT 1812
Status:
In Progress
Priority:
Normal
Assignee:
Category:
-
Target version:
Start date:
02/24/2026
Due date:
% Done:
0%
Estimated time:
Actions
Added by Estefany Santiago Trinidad about 1 month ago. Updated 3 days ago.
0%
Para añadir tipo notificación
INSERT INTO SUMACCertifiedCopyDocumentType(
Code,
DescriptionEN,
DescriptionES,
CreateDate,
CreatedBy,
ModifiedDate,
ModifiedBy
)
VALUES (
3,
'Notification',
'Notificación',
'2026-03-27 14:11:57.310',
'BA188E4A-E2B5-45F3-9835-32C94121C00E',
'2026-03-27 14:11:57.310',
'BA188E4A-E2B5-45F3-9835-32C94121C00E'
)
Para añadir columna de NotificationId
ALTER TABLE SUMACCertifiedCopyDocument
ADD NotificationId INT
ADD CONSTRAINT fk_NotificationId
FOREIGN KEY (NotificationId)
REFERENCES SUMACNotification(NotificationId);