SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE EventLog(
    [Id] [uniqueidentifier] NOT NULL,
    [Created] [datetimeoffset](7) NULL,
    [Updated] [datetimeoffset](7) NULL,
    [Session] [uniqueidentifier] NOT NULL,
    [IdentityGlobalId] [uniqueidentifier] NOT NULL,
    [EventType] [nvarchar](max) NOT NULL,
    [Description] [nvarchar](max) NOT NULL,
    [Published] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_EventLog] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
))
CREATE TABLE Identities(
    [GlobalId] [uniqueidentifier] NOT NULL,
    [Created] [datetimeoffset](7) NULL,
    [Updated] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Identities] PRIMARY KEY CLUSTERED (
    [GlobalId] ASC
))
ALTER TABLE EventLog WITH CHECK ADD CONSTRAINT [FK_EventLog_Identities_IdentityGlobalId] 
FOREIGN KEY([IdentityGlobalId])
REFERENCES Identities([GlobalId])
ON DELETE CASCADE


ALTER TABLE EventLog CHECK CONSTRAINT [FK_EventLog_Identities_IdentityGlobalId]
insert into Identities values (newid(), GETUTCDATE() , GETUTCDATE() )
1 rows affected

select * from Identities


GlobalId
Created
Updated


ce77f227-ba0d-4bfe-9e83-29c6deda8305
2023-08-31 06:28:38.2800000 +00:00
2023-08-31 06:28:38.2800000 +00:00


INSERT INTO EventLog
    (Id
    ,Created
    ,Updated
    ,Session
    ,IdentityGlobalId
    ,EventType
    ,Description)
SELECT 
    NEWID()
    ,GETUTCDATE() 
    ,NULL 
    ,NEWID()
    ,GlobalId
    ,'4'
    ,'Removed role: '
from Identities;
1 rows affected

select * from EventLog


Id
Created
Updated
Session
IdentityGlobalId
EventType
Description
Published


5c6f4f34-f83d-45f6-aff7-a6beb49cf6fb
2023-08-31 06:28:38.2933333 +00:00
null
f2fc0ed0-c29c-4b1d-83af-d5b14f966fc7
ce77f227-ba0d-4bfe-9e83-29c6deda8305
4
Removed role:
null