shanxia/bx/bx-backend/sql/V2_reimburse_detail.sql

-- 报销明细表
CREATE TABLE IF NOT EXISTS bx_reimburse_detail (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  reimburse_id BIGINT NOT NULL COMMENT '报销单ID',
  expense_id BIGINT NOT NULL COMMENT '费用项目ID',
  expense_name VARCHAR(128) NOT NULL COMMENT '费用项目名称',
  amount DECIMAL(14,2) NOT NULL COMMENT '报销金额',
  remark VARCHAR(512) DEFAULT NULL COMMENT '备注',
  del_flag SMALLINT NOT NULL DEFAULT 0,
  create_by VARCHAR(64) DEFAULT NULL,
  create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  update_by VARCHAR(64) DEFAULT NULL,
  update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX idx_reimburse_id (reimburse_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='报销明细';