Tables [dbo].[ConsolidationProcessStatus]
PropertyValue
Row Count (~)0
Created1:20:01 AM Thursday, March 21, 2019
Last Modified1:20:12 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefaultDescription
Cluster Primary Key PK_ConsolidationProcessStatus_AccountID: AccountIDForeign Keys FK_ConsolidationProcessStatus_AccountID_Account_AccountID: [dbo].[Account].AccountIDAccountIDint4
False
StartDatedatetime8
True
EndDatedatetime8
True
CurrentStagesmallint2
True
One value from DataValuesTypes that represents the current values being processed
Consolidatedbit1
False
((0))
KeyNameKey ColumnsUnique
Cluster Primary Key PK_ConsolidationProcessStatus_AccountID: AccountIDPK_ConsolidationProcessStatus_AccountIDAccountID
True
NameDeleteColumns
FK_ConsolidationProcessStatus_AccountID_Account_AccountIDCascadeAccountID->[dbo].[Account].[AccountID]
CREATE TABLE [dbo].[ConsolidationProcessStatus]
(
[AccountID] [int] NOT NULL,
[StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[CurrentStage] [smallint] NULL,
[Consolidated] [bit] NOT NULL CONSTRAINT [DF_ConsolidationProcessStatus_Consolidated] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ConsolidationProcessStatus] ADD CONSTRAINT [PK_ConsolidationProcessStatus_AccountID] PRIMARY KEY CLUSTERED  ([AccountID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ConsolidationProcessStatus] ADD CONSTRAINT [FK_ConsolidationProcessStatus_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'MS_Description', N'One value from DataValuesTypes that represents the current values being processed', 'SCHEMA', N'dbo', 'TABLE', N'ConsolidationProcessStatus', 'COLUMN', N'CurrentStage'
GO