Table System Flow

Flow Document

[sql]
CREATE TABLE [System].[Flow.Document]
(
[doctype_id] [TINYINT] NOT NULL
,[doctype_header] [CHAR](3) NOT NULL
,[doctype_desc] [NVARCHAR](50) NOT NULL
,[doctype_table] [NVARCHAR](50) NULL
,[hdr_id] [INT] NULL
,[hdr_journal] [BIT] NOT NULL
,CONSTRAINT [PK_Flow.Document] PRIMARY KEY CLUSTERED([doctype_id] 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 [System].[Flow.Document]
ADD
DEFAULT((1)) FOR [hdr_journal]
GO
[/sql]

Flow Logic

[sql]
CREATE TABLE [System].[Flow.Logic]
(
[logic_id] [INT] IDENTITY(1,1)
NOT NULL
,[doctype_id] [TINYINT] NOT NULL
,[logic_idx] [SMALLINT] NOT NULL
,[prev_seq] [TINYINT] NOT NULL
,[next_seq] [TINYINT] NOT NULL
,[logic_desc] [VARCHAR](250) NOT NULL
,[seq_privilege] [VARCHAR](MAX) NOT NULL
,[proc_check] [VARCHAR](100) NOT NULL
,[proc_update] [VARCHAR](100) NOT NULL
,[proc_fail] [VARCHAR](100) NOT NULL
,CONSTRAINT [PK_Flow.Logic] PRIMARY KEY CLUSTERED([logic_id] 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 [System].[Flow.Logic]
ADD CONSTRAINT [DF_Flow.Logic_logic_idx] DEFAULT((1)) FOR [logic_idx]
GO

ALTER TABLE [System].[Flow.Logic]
ADD CONSTRAINT [DF_Flow.Logic_seq_privilege] DEFAULT('All') FOR [seq_privilege]
GO

ALTER TABLE [System].[Flow.Logic]
WITH CHECK
ADD CONSTRAINT [FK_Flow.Logic_Flow.Document] FOREIGN KEY([doctype_id]) REFERENCES [System].[Flow.Document](
[doctype_id]) ON UPDATE CASCADE ON DELETE CASCADE
GO

ALTER TABLE [System].[Flow.Logic] CHECK CONSTRAINT [FK_Flow.Logic_Flow.Document]
GO
[/sql]

Flow History

[sql]
CREATE TABLE [System].[Flow.History]
(
[flow_id] [INT] IDENTITY(1,1)
NOT NULL
,[flow_processed] [BIT] NOT NULL
,[doctype_id] [TINYINT] NOT NULL
,[doc_id] [INT] NOT NULL
,[doc_no] [VARCHAR](15) NOT NULL
,[gl_no] [VARCHAR](50) NULL
,[docflow_prev] [TINYINT] NOT NULL
,[docflow_next] [TINYINT] NOT NULL
,[update_log] [NVARCHAR](MAX) NOT NULL
,[update_success] [BIT] NOT NULL
,[update_time] [dbo].[System.Time] NOT NULL
,[update_user] [NVARCHAR](50) NOT NULL
,[update_ws] [NVARCHAR](250) NOT NULL
,[flow_result] [BIT] NULL
,CONSTRAINT [PK_Flow.History] PRIMARY KEY CLUSTERED([flow_id] DESC)
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 [System].[Flow.History]
ADD CONSTRAINT [DF_Flow.History_flow_processed] DEFAULT((0)) FOR [flow_processed]
GO

ALTER TABLE [System].[Flow.History]
ADD CONSTRAINT [DF_Flow.History_update_log] DEFAULT('') FOR [update_log]
GO

ALTER TABLE [System].[Flow.History]
ADD CONSTRAINT [DF_Flow.History_update_success] DEFAULT((0)) FOR [update_success]
GO

ALTER TABLE [System].[Flow.History]
ADD
DEFAULT((0)) FOR [flow_result]
GO

ALTER TABLE [System].[Flow.History]
WITH CHECK
ADD CONSTRAINT [FK_Flow.History_Flow.Document] FOREIGN KEY([doctype_id]) REFERENCES [System].[Flow.Document](
[doctype_id]) ON UPDATE CASCADE ON DELETE CASCADE
GO

ALTER TABLE [System].[Flow.History] CHECK CONSTRAINT [FK_Flow.History_Flow.Document]
GO
[/sql]