
--Migration_RCCP_20260318_085522.txt
CREATE TABLE [dbo].[IncidentArchives] (
    [Id] [bigint] NOT NULL IDENTITY,
    [NVRSerial] [nvarchar](max),
    [CompanyId] [bigint],
    [BranchId] [bigint],
    [CompanySerial] [nvarchar](max),
    [Duration] [bigint],
    [IncidentArchiveStartDateTime] [datetime],
    [IncidentArchiveEndDateTime] [datetime],
    [CreatedUTCDateTime] [datetime],
    [S3VideoFileLink] [nvarchar](max),
    CONSTRAINT [PK_dbo.IncidentArchives] PRIMARY KEY ([Id])
)
