
--Migration_RCCP_20250603_113603.txt
CREATE TABLE [dbo].[AIModelDeploymentLogs] (
    [Id] [bigint] NOT NULL IDENTITY,
    [CompanySerial] [nvarchar](max),
    [ModelRegistryId] [bigint] NOT NULL,
    [Status] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.AIModelDeploymentLogs] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[AIModelRegistries] (
    [Id] [bigint] NOT NULL IDENTITY,
    [ModelUuid] [nvarchar](max),
    [ModelName] [nvarchar](max),
    [ModelType] [nvarchar](max),
    [Firmware] [nvarchar](max),
    [Version] [nvarchar](max),
    [Status] [nvarchar](max),
    [FilePath] [nvarchar](max),
    [CreatedDateTime] [datetime] NOT NULL,
    CONSTRAINT [PK_dbo.AIModelRegistries] PRIMARY KEY ([Id])
)
