
--Migration_RCCP_20231010_104334.txt
CREATE TABLE [dbo].[DeviceRemarks] (
    [Id] [bigint] NOT NULL IDENTITY,
    [CompanySerial] [nvarchar](max),
    [Remark] [nvarchar](max),
    [RemarkDateTime] [datetime] NOT NULL,
    [CurrentAllocatedCompanyId] [bigint] NOT NULL,
    [CurrentAllocatedBranchId] [bigint] NOT NULL,
    [CurrentAllocatedServerGuid] [uniqueidentifier] NOT NULL,
    [UserId] [bigint] NOT NULL,
    [UserType] [nvarchar](max),
    [RemarkType] [nvarchar](max),
    [IsInternal] [bit] NOT NULL,
    CONSTRAINT [PK_dbo.DeviceRemarks] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[DeviceRemarkTypes] (
    [GUID] [uniqueidentifier] NOT NULL,
    [WorkspaceId] [nvarchar](max),
    CONSTRAINT [PK_dbo.DeviceRemarkTypes] PRIMARY KEY ([GUID])
)
