| | |
| | | variable nvarchar(max) NULL, |
| | | flow_status nvarchar(20) NOT NULL, |
| | | activity_status tinyint DEFAULT('1') NULL, |
| | | def_json nvarchar(max) NULL, |
| | | create_by nvarchar(64) NULL, |
| | | create_time datetime2(7) NULL, |
| | | update_time datetime2(7) NULL, |
| | |
| | | 'SCHEMA', N'dbo', |
| | | 'TABLE', N'flow_instance', |
| | | 'COLUMN', N'activity_status' |
| | | GO |
| | | |
| | | EXEC sp_addextendedproperty |
| | | 'MS_Description', N'流程定义json', |
| | | 'SCHEMA', N'dbo', |
| | | 'TABLE', N'flow_instance', |
| | | 'COLUMN', N'def_json' |
| | | GO |
| | | |
| | | EXEC sp_addextendedproperty |
| | |
| | | definition_id bigint NOT NULL, |
| | | instance_id bigint NOT NULL, |
| | | task_id bigint NOT NULL, |
| | | node_code nvarchar(100) NULL, |
| | | node_name nvarchar(100) NULL, |
| | | node_code nvarchar(200) NULL, |
| | | node_name nvarchar(200) NULL, |
| | | node_type tinyint NULL, |
| | | target_node_code nvarchar(100) NULL, |
| | | target_node_name nvarchar(100) NULL, |
| | |
| | | form_custom nchar(1) DEFAULT('N') NULL, |
| | | form_path nvarchar(100) NULL, |
| | | message nvarchar(500) NULL, |
| | | variable nvarchar(max) NULL, |
| | | ext nvarchar(500) NULL, |
| | | create_time datetime2(7) NULL, |
| | | update_time datetime2(7) NULL, |
| | |
| | | 'SCHEMA', N'dbo', |
| | | 'TABLE', N'flow_his_task', |
| | | 'COLUMN', N'message' |
| | | GO |
| | | |
| | | EXEC sp_addextendedproperty |
| | | 'MS_Description', N'任务变量', |
| | | 'SCHEMA', N'dbo', |
| | | 'TABLE', N'flow_his_task', |
| | | 'COLUMN', N'variable' |
| | | GO |
| | | |
| | | EXEC sp_addextendedproperty |
| | |
| | | GO |
| | | |
| | | EXEC sp_addextendedproperty |
| | | 'MS_Description', N'删除标志(0代表存在 2代表删除)', |
| | | 'MS_Description', N'删除标志(0代表存在 1代表删除)', |
| | | 'SCHEMA', N'dbo', |
| | | 'TABLE', N'flow_category', |
| | | 'COLUMN', N'del_flag' |