
--Migration_RCCP_20240828_183959.txt
CREATE TABLE [dbo].[FFBranchDetails] (
    [ID] [bigint] NOT NULL IDENTITY,
    [BranchId] [bigint] NOT NULL,
    [AddressLine1] [nvarchar](max),
    [AddressLine2] [nvarchar](max),
    [State] [nvarchar](max),
    [ZipCode] [nvarchar](max),
    [StoreContactName] [nvarchar](max),
    [StoreContactNumber] [nvarchar](max),
    [StoreContactEmail] [nvarchar](max),
    [StoreEmergencyContactName] [nvarchar](max),
    [StoreEmergencyContactNumber] [nvarchar](max),
    [StoreEmergencyContactEmail] [nvarchar](max),
    CONSTRAINT [PK_dbo.FFBranchDetails] PRIMARY KEY ([ID])
)
CREATE INDEX [IX_BranchId] ON [dbo].[FFBranchDetails]([BranchId])
ALTER TABLE [dbo].[FFBranchDetails] ADD CONSTRAINT [FK_dbo.FFBranchDetails_dbo.FFBranches_BranchId] FOREIGN KEY ([BranchId]) REFERENCES [dbo].[FFBranches] ([ID]) ON DELETE CASCADE
