Files
admin f9899ea207 feat: TDS × SSWFLOW 胶水全 V0–V1.4 落地 + DB 0813 v2 导出
V0 触发链 + 回调链(架构原承诺「SSWFLOW 被合约驱动调用」)
- tds/ContractSswflowTrigger: 合约双签 → 解析 f_policy_content.sswflowFlowId → SswflowClient.startRun → 回写 f_flow_run_id
- sswflow/FlowRunInternalController: /Internal/Start 白名单 App-Code (tds/tdc)
- sswflow/TdsCallbackClient + tds/RunCallbackService: 终态回调 → tds_chain_evidence (bizType=SSW_FLOW_RUN_FINISH)

V1.1 合约触发 + V1.2 dataset 同步 + V1.3 对账调度 + V1.4 TDC 直触发
- tds/DataProductDatasetSyncer: 上架 → /Dataset/Internal/Sync 按 f_external_ref='tds:dataProduct:<id>' upsert
- tds/FlowRunReconciliationScheduler: @Scheduled cron 扫合约漏单 → SswflowClient.getRun → 终态写 ledger + f_quota_used++
- tdc/DeliveryTaskController + TdcSswflowClient: /TriggerFlow 走 Internal/Start (trigger=DELIVERY_DIRECT,绕合约)

3 个 migration(必须按 V1.4→V1.5→V1.1 顺序跑)
- boot/db/tds/V1.4.0__tds_contract_flow_run_id.sql: tds_contract.f_flow_run_id + idx
- boot/db/tds/V1.5.0__tds_billing_ledger_run_id.sql: tds_billing_ledger.f_run_id + idx
- boot/db/sswflow/V1.1.0__dataset_external_ref.sql: dataset.f_external_ref + unique idx

配置 + 文档
- application.yml: exclude-url 加 Dataset/Internal/** + ssw.reconciliation 默认 + ssw.tds.callback.*
- docs/tds/SSWFLOW_BINDING.md: §10 V1.1–V1.4 全标 ✅
- docs/db/0813/{sswflow,tds,tdc,j7}/: schema 含新字段
2026-08-13 16:38:01 +08:00

511 lines
21 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
-- ============================================================
-- Database: sswflow
-- Schema snapshot at 2026-08-13 16:37:13
-- Exported by export_app_db.py (psycopg2)
-- schema-only: 业务数据未导出
-- ============================================================
SET client_min_messages = warning;
-- ----------------------------------------------------------
-- Table: artifact (462 rows, 408 kB)
-- ----------------------------------------------------------
-- Table: artifact
CREATE TABLE "artifact" (
"f_id" varchar(50) NOT NULL,
"f_run_id" varchar(50) NOT NULL,
"f_step_id" varchar(50) NOT NULL,
"f_port_key" varchar(50),
"f_type" varchar(20) NOT NULL DEFAULT 'table'::character varying,
"f_title" varchar(200),
"f_summary" varchar(1000),
"f_columns" text,
"f_rows" text,
"f_metrics" text,
"f_uri" varchar(500),
"f_row_count" bigint DEFAULT 0,
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
CONSTRAINT "pk_artifact" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "artifact" IS '步骤产物';
CREATE INDEX idx_art_run ON public.artifact USING btree (f_run_id);
CREATE INDEX idx_art_step ON public.artifact USING btree (f_run_id, f_step_id);
COMMENT ON COLUMN "artifact"."f_type" IS 'table 数据表 / report 报告 / model 模型 / rule 规则';
COMMENT ON COLUMN "artifact"."f_uri" IS '真实产物在参与方侧的存储路径, 平台不落原始数据';
COMMENT ON COLUMN "artifact"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "artifact"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "artifact"."f_flow_state" IS '流程任务状态';
-- ----------------------------------------------------------
-- Table: dataset (10 rows, 80 kB)
-- ----------------------------------------------------------
-- Table: dataset
CREATE TABLE "dataset" (
"f_id" varchar(50) NOT NULL,
"f_dataset_code" varchar(50) NOT NULL,
"f_name" varchar(100) NOT NULL,
"f_party_id" varchar(50) NOT NULL,
"f_datasource_id" varchar(50),
"f_storage_type" varchar(30) NOT NULL DEFAULT 'LOCAL_CSV'::character varying,
"f_location" varchar(500),
"f_desc" varchar(500),
"f_row_count" bigint DEFAULT 0,
"f_columns" text,
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
"f_external_ref" varchar(128),
CONSTRAINT "pk_dataset" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "dataset" IS '数据集';
CREATE INDEX idx_dataset_party ON public.dataset USING btree (f_party_id);
CREATE UNIQUE INDEX uk_dataset_code ON public.dataset USING btree (f_dataset_code) WHERE (f_delete_mark IS NULL);
CREATE UNIQUE INDEX uq_dataset_external_ref ON public.dataset USING btree (f_external_ref) WHERE (f_external_ref IS NOT NULL);
COMMENT ON COLUMN "dataset"."f_columns" IS '字段元信息 JSON 数组: [{name,type,comment,joinKey,label,sensitive}]';
COMMENT ON COLUMN "dataset"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "dataset"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "dataset"."f_flow_state" IS '流程任务状态';
COMMENT ON COLUMN "dataset"."f_external_ref" IS '外部系统引用 ID(tds:dataProduct:xxx),用于跨子系统反查;唯一索引保证同步幂等';
-- ----------------------------------------------------------
-- Table: dataset_auth (9 rows, 64 kB)
-- ----------------------------------------------------------
-- Table: dataset_auth
CREATE TABLE "dataset_auth" (
"f_id" varchar(50) NOT NULL,
"f_dataset_id" varchar(50) NOT NULL,
"f_project_id" varchar(50) NOT NULL,
"f_auth_status" varchar(20) NOT NULL DEFAULT 'PENDING'::character varying,
"f_auth_time" timestamp without time zone,
"f_auth_user_id" varchar(50),
"f_expire_time" timestamp without time zone,
"f_reject_reason" varchar(500),
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
CONSTRAINT "pk_dataset_auth" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "dataset_auth" IS '数据授权';
CREATE INDEX idx_da_dataset ON public.dataset_auth USING btree (f_dataset_id);
CREATE INDEX idx_da_project ON public.dataset_auth USING btree (f_project_id);
COMMENT ON COLUMN "dataset_auth"."f_auth_status" IS 'PENDING 待审批 / APPROVED 已授权 / REJECTED 已拒绝 / REVOKED 已撤销';
COMMENT ON COLUMN "dataset_auth"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "dataset_auth"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "dataset_auth"."f_flow_state" IS '流程任务状态';
-- ----------------------------------------------------------
-- Table: dataset_auth_vote (16 rows, 64 kB)
-- ----------------------------------------------------------
-- Table: dataset_auth_vote
CREATE TABLE "dataset_auth_vote" (
"f_id" varchar(50) NOT NULL,
"f_auth_id" varchar(50) NOT NULL,
"f_party_id" varchar(50) NOT NULL,
"f_vote_status" varchar(20) NOT NULL DEFAULT 'PENDING'::character varying,
"f_vote_time" timestamp without time zone,
"f_vote_user_id" varchar(50),
"f_comment" varchar(500),
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
CONSTRAINT "pk_dataset_auth_vote" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "dataset_auth_vote" IS '数据授权投票';
CREATE INDEX idx_dav_auth ON public.dataset_auth_vote USING btree (f_auth_id);
CREATE INDEX idx_dav_party ON public.dataset_auth_vote USING btree (f_party_id);
COMMENT ON COLUMN "dataset_auth_vote"."f_vote_status" IS 'PENDING 待投票 / APPROVED 同意 / REJECTED 拒绝';
-- ----------------------------------------------------------
-- Table: datasource (1 rows, 48 kB)
-- ----------------------------------------------------------
-- Table: datasource
CREATE TABLE "datasource" (
"f_id" varchar(50) NOT NULL,
"f_name" varchar(100) NOT NULL,
"f_party_id" varchar(50) NOT NULL,
"f_type" varchar(30) NOT NULL DEFAULT 'LOCAL_CSV'::character varying,
"f_config" text,
"f_status" varchar(20) NOT NULL DEFAULT 'ENABLED'::character varying,
"f_desc" varchar(500),
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
CONSTRAINT "pk_datasource" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "datasource" IS '数据源';
CREATE INDEX idx_datasource_party ON public.datasource USING btree (f_party_id);
COMMENT ON COLUMN "datasource"."f_type" IS 'LOCAL_CSV / HIVE / MYSQL / OSS / ODPS';
COMMENT ON COLUMN "datasource"."f_config" IS '连接配置 JSON, 敏感项加密存储';
COMMENT ON COLUMN "datasource"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "datasource"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "datasource"."f_flow_state" IS '流程任务状态';
-- ----------------------------------------------------------
-- Table: flow (87 rows, 288 kB)
-- ----------------------------------------------------------
-- Table: flow
CREATE TABLE "flow" (
"f_id" varchar(50) NOT NULL,
"f_project_id" varchar(50) NOT NULL,
"f_name" varchar(100) NOT NULL,
"f_desc" varchar(500),
"f_steps" text,
"f_edges" text,
"f_last_run_id" varchar(50),
"f_last_run_status" varchar(20),
"f_last_run_time" timestamp without time zone,
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
CONSTRAINT "pk_flow" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "flow" IS '流程';
CREATE INDEX idx_flow_project ON public.flow USING btree (f_project_id);
COMMENT ON COLUMN "flow"."f_steps" IS '画布节点 JSON 数组: [{stepId,operatorKey,label,x,y,params}]';
COMMENT ON COLUMN "flow"."f_edges" IS '画布连线 JSON 数组: [{edgeId,sourceStepId,sourcePort,targetStepId,targetPort}]';
COMMENT ON COLUMN "flow"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "flow"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "flow"."f_flow_state" IS '流程任务状态';
-- ----------------------------------------------------------
-- Table: flow_run (80 rows, 288 kB)
-- ----------------------------------------------------------
-- Table: flow_run
CREATE TABLE "flow_run" (
"f_id" varchar(50) NOT NULL,
"f_flow_id" varchar(50) NOT NULL,
"f_flow_name" varchar(100),
"f_project_id" varchar(50) NOT NULL,
"f_status" varchar(20) NOT NULL DEFAULT 'PENDING'::character varying,
"f_trigger" varchar(20) NOT NULL DEFAULT 'MANUAL'::character varying,
"f_operator" varchar(50),
"f_start_time" timestamp without time zone,
"f_end_time" timestamp without time zone,
"f_cost_ms" bigint,
"f_error_msg" varchar(2000),
"f_cancelled_mark" smallint NOT NULL DEFAULT 0,
"f_steps_snapshot" text,
"f_edges_snapshot" text,
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
"f_run_mode" varchar(32) NOT NULL DEFAULT 'FULL'::character varying,
"f_selected_steps" text,
"f_base_run_id" varchar(64),
CONSTRAINT "pk_flow_run" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "flow_run" IS '流程运行实例';
CREATE INDEX idx_run_flow ON public.flow_run USING btree (f_flow_id);
CREATE INDEX idx_run_project ON public.flow_run USING btree (f_project_id);
CREATE INDEX idx_run_status ON public.flow_run USING btree (f_status);
COMMENT ON COLUMN "flow_run"."f_status" IS 'PENDING 等待 / RUNNING 执行中 / SUCCESS 成功 / FAILED 失败 / STOPPED 已终止';
COMMENT ON COLUMN "flow_run"."f_trigger" IS 'MANUAL 手动触发 / SCHEDULE 定时触发 / API 接口触发';
COMMENT ON COLUMN "flow_run"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "flow_run"."f_flow_state" IS '流程任务状态';
-- ----------------------------------------------------------
-- Table: flow_schedule (2 rows, 32 kB)
-- ----------------------------------------------------------
-- Table: flow_schedule
CREATE TABLE "flow_schedule" (
"f_id" varchar(64) NOT NULL,
"f_flow_id" varchar(64),
"f_project_id" varchar(64),
"f_name" varchar(128),
"f_cron" varchar(64),
"f_enabled_mark" integer NOT NULL DEFAULT 0,
"f_next_fire_time" timestamp without time zone,
"f_last_fire_time" timestamp without time zone,
"f_last_run_id" varchar(64),
"f_last_status" varchar(32),
"f_misfire_policy" varchar(32),
"f_run_scope" text,
"f_tenant_id" varchar(64),
"f_sort_code" bigint,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(64),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(64),
"f_delete_mark" integer,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(64),
CONSTRAINT "flow_schedule_pkey" PRIMARY KEY (f_id)
);
-- ----------------------------------------------------------
-- Table: flow_step_run (512 rows, 256 kB)
-- ----------------------------------------------------------
-- Table: flow_step_run
CREATE TABLE "flow_step_run" (
"f_id" varchar(50) NOT NULL,
"f_run_id" varchar(50) NOT NULL,
"f_step_id" varchar(50) NOT NULL,
"f_operator_key" varchar(100) NOT NULL,
"f_label" varchar(100),
"f_status" varchar(20) NOT NULL DEFAULT 'PENDING'::character varying,
"f_progress" integer NOT NULL DEFAULT 0,
"f_seq" integer NOT NULL DEFAULT 0,
"f_start_time" timestamp without time zone,
"f_end_time" timestamp without time zone,
"f_cost_ms" bigint,
"f_error_msg" varchar(2000),
"f_parties" text,
"f_params_snapshot" text,
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
CONSTRAINT "pk_flow_step_run" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "flow_step_run" IS '步骤运行记录';
CREATE INDEX idx_sr_run ON public.flow_step_run USING btree (f_run_id);
COMMENT ON COLUMN "flow_step_run"."f_status" IS 'PENDING / RUNNING / SUCCESS / FAILED / STOPPED / SKIPPED';
COMMENT ON COLUMN "flow_step_run"."f_seq" IS '拓扑排序后的执行序号';
COMMENT ON COLUMN "flow_step_run"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "flow_step_run"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "flow_step_run"."f_flow_state" IS '流程任务状态';
-- ----------------------------------------------------------
-- Table: party (6 rows, 64 kB)
-- ----------------------------------------------------------
-- Table: party
CREATE TABLE "party" (
"f_id" varchar(50) NOT NULL,
"f_party_code" varchar(50) NOT NULL,
"f_name" varchar(100) NOT NULL,
"f_organize_id" varchar(50),
"f_org_name" varchar(200),
"f_endpoint" varchar(500),
"f_role" varchar(20) NOT NULL DEFAULT 'GUEST'::character varying,
"f_status" varchar(20) NOT NULL DEFAULT 'OFFLINE'::character varying,
"f_self_mark" smallint NOT NULL DEFAULT 0,
"f_cert_pem" text,
"f_desc" varchar(500),
"f_last_heartbeat_time" timestamp without time zone,
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
CONSTRAINT "pk_party" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "party" IS '参与方';
CREATE INDEX idx_party_organize ON public.party USING btree (f_organize_id);
CREATE UNIQUE INDEX uk_party_code ON public.party USING btree (f_party_code) WHERE (f_delete_mark IS NULL);
COMMENT ON COLUMN "party"."f_party_code" IS '参与方业务标识, 如 ssw-bank';
COMMENT ON COLUMN "party"."f_organize_id" IS '绑定 JNPF 组织 base_organize.f_id (主库 j7), 用于数据权限';
COMMENT ON COLUMN "party"."f_org_name" IS '组织名称快照, 避免跨库 join';
COMMENT ON COLUMN "party"."f_role" IS 'HOST 发起方 / GUEST 协作方';
COMMENT ON COLUMN "party"."f_status" IS 'ONLINE 在线 / OFFLINE 离线';
COMMENT ON COLUMN "party"."f_self_mark" IS '1 表示本平台自身所属方';
COMMENT ON COLUMN "party"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "party"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "party"."f_flow_state" IS '流程任务状态';
-- ----------------------------------------------------------
-- Table: project (8 rows, 64 kB)
-- ----------------------------------------------------------
-- Table: project
CREATE TABLE "project" (
"f_id" varchar(50) NOT NULL,
"f_project_code" varchar(50) NOT NULL,
"f_name" varchar(100) NOT NULL,
"f_desc" varchar(500),
"f_owner_party_id" varchar(50) NOT NULL,
"f_compute_mode" varchar(20) NOT NULL DEFAULT 'MPC'::character varying,
"f_status" varchar(20) NOT NULL DEFAULT 'DRAFT'::character varying,
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
CONSTRAINT "pk_project" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "project" IS '项目';
CREATE INDEX idx_project_owner ON public.project USING btree (f_owner_party_id);
CREATE UNIQUE INDEX uk_project_code ON public.project USING btree (f_project_code) WHERE (f_delete_mark IS NULL);
COMMENT ON COLUMN "project"."f_compute_mode" IS 'MPC 密态计算 / TEE 可信执行环境';
COMMENT ON COLUMN "project"."f_status" IS 'DRAFT 草稿 / RUNNING 进行中 / ARCHIVED 已归档';
COMMENT ON COLUMN "project"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "project"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "project"."f_flow_state" IS '流程任务状态';
-- ----------------------------------------------------------
-- Table: project_party (15 rows, 64 kB)
-- ----------------------------------------------------------
-- Table: project_party
CREATE TABLE "project_party" (
"f_id" varchar(50) NOT NULL,
"f_project_id" varchar(50) NOT NULL,
"f_party_id" varchar(50) NOT NULL,
"f_role" varchar(20) NOT NULL DEFAULT 'GUEST'::character varying,
"f_join_status" varchar(20) NOT NULL DEFAULT 'INVITED'::character varying,
"f_invite_time" timestamp without time zone,
"f_join_time" timestamp without time zone,
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
CONSTRAINT "pk_project_party" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "project_party" IS '项目参与方';
CREATE INDEX idx_pp_party ON public.project_party USING btree (f_party_id);
CREATE INDEX idx_pp_project ON public.project_party USING btree (f_project_id);
COMMENT ON COLUMN "project_party"."f_join_status" IS 'INVITED 已邀请 / JOINED 已加入 / REJECTED 已拒绝 / QUIT 已退出';
COMMENT ON COLUMN "project_party"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "project_party"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "project_party"."f_flow_state" IS '流程任务状态';
-- ----------------------------------------------------------
-- Table: run_event (2643 rows, 920 kB)
-- ----------------------------------------------------------
-- Table: run_event
CREATE TABLE "run_event" (
"f_id" varchar(50) NOT NULL,
"f_run_id" varchar(50) NOT NULL,
"f_step_id" varchar(50),
"f_type" varchar(30) NOT NULL,
"f_status" varchar(20),
"f_progress" integer,
"f_level" varchar(10) DEFAULT 'INFO'::character varying,
"f_message" varchar(4000),
"f_ts" timestamp without time zone NOT NULL,
"f_tenant_id" varchar(50),
"f_sort_code" bigint DEFAULT 0,
"f_creator_time" timestamp without time zone,
"f_creator_user_id" varchar(50),
"f_last_modify_time" timestamp without time zone,
"f_last_modify_user_id" varchar(50),
"f_delete_mark" smallint,
"f_delete_time" timestamp without time zone,
"f_delete_user_id" varchar(50),
"f_flow_id" varchar(50),
"f_flow_task_id" varchar(50),
"f_flow_state" integer,
CONSTRAINT "pk_run_event" PRIMARY KEY (f_id)
);
COMMENT ON TABLE "run_event" IS '运行期事件';
CREATE INDEX idx_ev_run ON public.run_event USING btree (f_run_id);
CREATE INDEX idx_ev_run_ts ON public.run_event USING btree (f_run_id, f_ts);
COMMENT ON COLUMN "run_event"."f_type" IS 'run.status / step.status / step.log / run.finish';
COMMENT ON COLUMN "run_event"."f_flow_id" IS '流程id';
COMMENT ON COLUMN "run_event"."f_flow_task_id" IS '流程任务主键';
COMMENT ON COLUMN "run_event"."f_flow_state" IS '流程任务状态';