CREATE TABLE [dbo].[TableA](
    [UserID] [INT] IDENTITY(1,1) NOT NULL,
    [Username] [nvarchar](100) NOT NULL,
    [FirstName] [nvarchar](50) NOT NULL,
    [LastName] [nvarchar](50) NOT NULL,
    [IsSuperUser] [bit] NOT NULL,
    [AffiliateId] [INT] NULL,
    [Email] [nvarchar](256) NULL,
    [DisplayName] [nvarchar](128) NOT NULL,
    [UpdatePassword] [bit] NOT NULL,
    [LastIPAddress] [nvarchar](50) NULL,
    [IsDeleted] [bit] NOT NULL,
    [CreatedByUserID] [INT] NULL,
    [CreatedOnDate] [datetime] NULL,
    [LastModifiedByUserID] [INT] NULL,
    [LastModifiedOnDate] [datetime] NULL,
    [PasswordResetToken] [uniqueidentifier] NULL,
    [PasswordResetExpiration] [datetime] NULL,
    [LowerEmail]  AS (LOWER([Email])) PERSISTED,
 CONSTRAINT [PK_TableA] PRIMARY KEY CLUSTERED
(
    [UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TableA] ADD  CONSTRAINT [DF_TableA_IsSuperUser]  DEFAULT ((0)) FOR [IsSuperUser]
GO

ALTER TABLE [dbo].[TableA] ADD  CONSTRAINT [DF_TableA_DisplayName]  DEFAULT ('') FOR [DisplayName]
GO

ALTER TABLE [dbo].[TableA] ADD  CONSTRAINT [DF_TableA_UpdatePassword]  DEFAULT ((0)) FOR [UpdatePassword]
GO

ALTER TABLE [dbo].[TableA] ADD  CONSTRAINT [DF_TableA_IsDeleted]  DEFAULT ((0)) FOR [IsDeleted]
GO

CREATE TABLE [dbo].[TableB](
    [TransactionID] [INT] IDENTITY(1,1) NOT NULL,
    [PortalID] [INT] NOT NULL,
    [UserID] [INT] NOT NULL,
    [RemoteTransactionID] [nvarchar](256) NOT NULL,
    [ResponseText] [text] NOT NULL,
    [StatusID] [INT] NOT NULL,
    [Amount] [money] NOT NULL,
    [LoyaltyRedemptionID] [INT] NULL,
    [DateCreated] [datetime] NOT NULL,
    [DateUpdated] [datetime] NOT NULL,
    [UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_TableB] PRIMARY KEY CLUSTERED
(
    [TransactionID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[TableB] ADD  CONSTRAINT [DF_TableB_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO

ALTER TABLE [dbo].[TableB] ADD  CONSTRAINT [DF_TableB_DateUpdated]  DEFAULT (getdate()) FOR [DateUpdated]
GO

ALTER TABLE [dbo].[TableB]  WITH CHECK ADD  CONSTRAINT [FK_TableB_TableBtatuses] FOREIGN KEY([StatusID])
REFERENCES [dbo].[TableBtatuses] ([StatusID])
GO

ALTER TABLE [dbo].[TableB] CHECK CONSTRAINT [FK_TableB_TableBtatuses]
GO

ALTER TABLE [dbo].[TableB]  WITH CHECK ADD  CONSTRAINT [FK_TableB_TableC] FOREIGN KEY([LoyaltyRedemptionID])
REFERENCES [dbo].[TableC] ([RedemptionID])
GO

ALTER TABLE [dbo].[TableB] CHECK CONSTRAINT [FK_TableB_TableC]
GO

ALTER TABLE [dbo].[TableB]  WITH CHECK ADD  CONSTRAINT [FK_TableB_TableA] FOREIGN KEY([UserID])
REFERENCES [dbo].[TableA] ([UserID])
GO

ALTER TABLE [dbo].[TableB] CHECK CONSTRAINT [FK_TableB_TableA]
GO


CREATE TABLE [dbo].[TableC](
    [RedemptionID] [INT] IDENTITY(1,1) NOT NULL,
    [RewardID] [INT] NOT NULL,
    [PortalID] [INT] NOT NULL,
    [UserID] [INT] NOT NULL,
    [PointAuditID] [INT] NOT NULL,
    [PointsPaid] [INT] NOT NULL,
    [Quantity] [INT] NOT NULL,
    [Fulfilled] [bit] NOT NULL,
    [FulfilledDate] [datetime] NULL,
    [FulfilledNotes] [text] NULL,
    [DateCreated] [datetime] NOT NULL,
    [DateUpdated] [datetime] NOT NULL,
    [UpdatedBy] [nvarchar](50) NOT NULL,
    [SeatID] [INT] NULL,
    [VoucherCodeID] [INT] NULL,
    [Active] [bit] NOT NULL,
 CONSTRAINT [PK_TableC] PRIMARY KEY CLUSTERED
(
    [RedemptionID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[TableC]  WITH CHECK ADD  CONSTRAINT [FK_TableC_TableA] FOREIGN KEY([UserID])
REFERENCES [dbo].[TableA] ([UserID])
GO

ALTER TABLE [dbo].[TableC] CHECK CONSTRAINT [FK_TableC_TableA]
GO