CREATE TABLE [dbo].[SCReportBillGroupChargeTransactions]
(
[ReportBillGroupTransactionID] [int] NOT NULL IDENTITY(1, 1),
[ReportBillGroupID] [int] NOT NULL,
[ChargeAccountTransactionID] [int] NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCReportBillGroupChargeTransactions_CreateDate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportBillGroupChargeTransactions] ADD CONSTRAINT [PK_SCReportBillGroupChargeTransactions] PRIMARY KEY CLUSTERED ([ReportBillGroupTransactionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportBillGroupChargeTransactions] ADD CONSTRAINT [FK_SCReportBillGroupChargeTransactions_ChargeAccountTransactionID_ARChargeAccountTransactions] FOREIGN KEY ([ChargeAccountTransactionID]) REFERENCES [dbo].[ARChargeAccountTransactions] ([ChargeAccountTransactionID])
GO
ALTER TABLE [dbo].[SCReportBillGroupChargeTransactions] ADD CONSTRAINT [FK_SCReportBillGroupChargeTransactions_ReportBillGroupID_SCReportBillGroups] FOREIGN KEY ([ReportBillGroupID]) REFERENCES [dbo].[SCReportBillGroups] ([ReportBillGroupID])
GO