Blame view

项目文档相关/sql/添加报销申请表流程配置ID字段.sql 446 Bytes
b43001c6   “wangming”   Remove unused CSS...
1
2
3
4
5
6
7
  -- 报销申请表添加流程配置ID字段
  -- 用于关联 lq_reimbursement_workflow_config,以便列表和详情接口返回流程名称(workflowName
  -- 执行时间:2025
  
  ALTER TABLE `lq_reimbursement_application`
    ADD COLUMN `F_WorkflowConfigId` varchar(50) DEFAULT NULL COMMENT '流程配置ID(关联lq_reimbursement_workflow_config)' AFTER `F_PurchaseRecordsId`,
    ADD KEY `idx_workflow_config_id` (`F_WorkflowConfigId`);