CREATE TABLE `data_ticket_link` (
`Guid` char(50) NOT NULL,
`SourceGuid` char(50) NOT NULL,
`TargetGuid` char(50) NOT NULL,
`LinkType` enum('BLOCKS','RELATED','DUPLICATE','CHILD') DEFAULT 'RELATED',
`CreatedBy` varchar(255) DEFAULT NULL,
`CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`Guid`),
KEY `idx_source` (`SourceGuid`),
KEY `idx_target` (`TargetGuid`),
KEY `idx_link_type` (`LinkType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
INSERT INTO data_ticket_link
(Guid, SourceGuid, TargetGuid,
LinkType, CreatedBy, CreatedDate)
VALUES
('{guid}', '{source_guid}',
'{target_guid}', '{link_type}',
'{created_by}', now())
SELECT *
FROM data_ticket_link
WHERE SourceGuid = '{guid}'
OR TargetGuid = '{guid}'
ORDER BY CreatedDate
SELECT *
FROM data_ticket_link
WHERE TargetGuid = '{guid}'
AND LinkType = 'BLOCKS'
ORDER BY CreatedDate
DELETE FROM data_ticket_link
WHERE Guid = '{guid}'