
--Migration_RCCP_20260401_085620.txt
CREATE TABLE [dbo].[CompanyAddressBooks] (
    [Id] [bigint] NOT NULL IDENTITY,
    [CompanyId] [bigint] NOT NULL,
    [AddressLine1] [nvarchar](max),
    [AddressLine2] [nvarchar](max),
    [State] [nvarchar](max),
    [Country] [nvarchar](max),
    [ZipCode] [nvarchar](max),
    [ContactNumber] [nvarchar](max),
    [ContactEmail] [nvarchar](max),
    [Remark] [nvarchar](max),
    [IsDefault] [bit] NOT NULL,
    [UpdatedDateTime] [datetime] NOT NULL,
    [CreatedBy] [nvarchar](max),
    [UpdatedBy] [nvarchar](max),
    [AddressName] [nvarchar](max),
    CONSTRAINT [PK_dbo.CompanyAddressBooks] PRIMARY KEY ([Id])
)
ALTER TABLE [dbo].[EntityMetrics] ADD [StatusUpdatedDateTime] [datetime]
