EventLog, SQLServer, Create

EventLog, SQLServer, Create, Giga

Entity Framework EventLog

https://giga.chat/link/gcsHlTVaJn

USE Langs

CREATE TABLE Hosts (

    HostId INT PRIMARY KEY IDENTITY(1,1),

    Name NVARCHAR(MAX) NOT NULL,

    Description NVARCHAR(MAX) NULL

);

GO

CREATE TABLE Apps (

    AppId INT PRIMARY KEY IDENTITY(1,1),

    HostId INT NOT NULL FOREIGN KEY REFERENCES Hosts(HostId),

    Name NVARCHAR(MAX) NOT NULL,

    Version NVARCHAR(MAX) NOT NULL,

    Description NVARCHAR(MAX) NULL

);

GO

CREATE TABLE EventLogs (

    EventLogId INT PRIMARY KEY IDENTITY(1,1),

    AppId INT NOT NULL FOREIGN KEY REFERENCES Apps(AppId),

    LocalLogId INT NOT NULL,

    Code NVARCHAR(MAX) NOT NULL,

    Name NVARCHAR(MAX) NOT NULL,

    Description NVARCHAR(MAX) NOT NULL,

    CreatedDT DATETIMEOFFSET NOT NULL,

    CONSTRAINT UQ_EventLog UNIQUE (AppId, LocalLogId)

);

GO

CREATE TABLE EventLogItems (

    ItemId INT PRIMARY KEY IDENTITY(1,1),

    EventLogId INT NOT NULL FOREIGN KEY REFERENCES EventLogs(EventLogId),

    LocalItemId INT NOT NULL,

    DT DATETIMEOFFSET NOT NULL,

    LogLevel INT NOT NULL,

    Source NVARCHAR(MAX) NOT NULL,

    Entity NVARCHAR(MAX) NOT NULL,

    Operation NVARCHAR(MAX) NOT NULL,

    Description NVARCHAR(MAX) NOT NULL,

    Object NVARCHAR(MAX) NOT NULL,

    CONSTRAINT UQ_EventLogItem UNIQUE (EventLogId, LocalItemId)

);

GO

INSERT INTO Hosts(Name, Description) VALUES ('HostA', 'Первый хост');

INSERT INTO Hosts(Name, Description) VALUES ('HostB', 'Второй хост');

GO

EventLog, SQLServer, Create

INSERT INTO Apps(HostId, Name, Version, Description) VALUES (1, 'AppX', 'v1.0', 'Первое прил.');

INSERT INTO Apps(HostId, Name, Version, Description) VALUES (1, 'AppY', 'v2.0', 'Второе прил.');

INSERT INTO Apps(HostId, Name, Version, Description) VALUES (2, 'AppZ', 'v1.5', 'Третье прил.');

INSERT INTO Apps(HostId, Name, Version, Description) VALUES (2, 'AppW', 'v3.0', 'Четвёртое прил.');

GO

INSERT INTO EventLogs(AppId, LocalLogId, Code, Name, Description, CreatedDT) VALUES (1, 100, 'INF', 'EventLog1', 'Test log 1', '2023-10-17T12:00:00');

INSERT INTO EventLogs(AppId, LocalLogId, Code, Name, Description, CreatedDT) VALUES (1, 101, 'ERR', 'EventLog2', 'Test log 2', '2023-10-17T12:01:00');

INSERT INTO EventLogs(AppId, LocalLogId, Code, Name, Description, CreatedDT) VALUES (2, 200, 'WRN', 'EventLog3', 'Test log 3', '2023-10-17T12:02:00');

INSERT INTO EventLogs(AppId, LocalLogId, Code, Name, Description, CreatedDT) VALUES (2, 201, 'DBG', 'EventLog4', 'Test log 4', '2023-10-17T12:03:00');

INSERT INTO EventLogs(AppId, LocalLogId, Code, Name, Description, CreatedDT) VALUES (3, 300, 'INF', 'EventLog5', 'Test log 5', '2023-10-17T12:04:00');

INSERT INTO EventLogs(AppId, LocalLogId, Code, Name, Description, CreatedDT) VALUES (3, 301, 'ERR', 'EventLog6', 'Test log 6', '2023-10-17T12:05:00');

INSERT INTO EventLogs(AppId, LocalLogId, Code, Name, Description, CreatedDT) VALUES (4, 400, 'WRN', 'EventLog7', 'Test log 7', '2023-10-17T12:06:00');

INSERT INTO EventLogs(AppId, LocalLogId, Code, Name, Description, CreatedDT) VALUES (4, 401, 'DBG', 'EventLog8', 'Test log 8', '2023-10-17T12:07:00');

GO