programs_info/小艾协同/流程图地址/流程从保障房项目拿过来的/pro-base下的/apply.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 0测试数据库_47.113.226.116
 Source Server Type    : MySQL
 Source Server Version : 50716
 Source Host           : 47.113.226.116:3306
 Source Schema         : idea_settle_down

 Target Server Type    : MySQL
 Target Server Version : 50716
 File Encoding         : 65001

 Date: 15/11/2024 13:18:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for apply_add_work
-- ----------------------------
DROP TABLE IF EXISTS `apply_add_work`;
CREATE TABLE `apply_add_work`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `pro_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联项目id',
  `apply_reasons` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '加班事由',
  `position` int(4) NULL DEFAULT NULL COMMENT '加班位置 1公司, 2客户处, 3居家',
  `total_add_time` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '共计请假时间',
  `file_data_ids` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件列表(frame_data)id例如:,121212,342323,',
  `status` int(4) NULL DEFAULT NULL COMMENT '状态0正常',
  `created_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  `created_at` datetime NULL DEFAULT NULL COMMENT '创建时间/申请时间',
  `updated_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分表_加班申请' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for apply_add_work_time
-- ----------------------------
DROP TABLE IF EXISTS `apply_add_work_time`;
CREATE TABLE `apply_add_work_time`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `add_work_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '加班表(apply_add_work)id',
  `use_time` decimal(10, 2) NULL DEFAULT NULL COMMENT '加班消耗时间',
  `start_day` datetime NULL DEFAULT NULL COMMENT '开始天',
  `start_time` datetime NULL DEFAULT NULL COMMENT '开始时如08:00:00',
  `end_time` datetime NULL DEFAULT NULL COMMENT '结束时如08:00:00',
  `status` int(4) NULL DEFAULT NULL COMMENT '状态0正常',
  `created_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  `created_at` datetime NULL DEFAULT NULL COMMENT '创建时间/申请时间',
  `updated_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分表子表_加班申请时间表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for apply_payment_settle
-- ----------------------------
DROP TABLE IF EXISTS `apply_payment_settle`;
CREATE TABLE `apply_payment_settle`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `flow_num` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程编码',
  `title` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `is_no_contract` int(4) NULL DEFAULT NULL COMMENT '是否为无合同付款1是,0不是',
  `payer_name` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '付款单位',
  `payee_name` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收款单位',
  `money_purpose` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资金用途',
  `contract_price` decimal(12, 2) NULL DEFAULT NULL COMMENT '合同总价(单位元)',
  `pay_remark` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '付款说明',
  `have_pay_money` decimal(12, 2) NULL DEFAULT NULL COMMENT '累计付款',
  `apply_pay_money` decimal(12, 2) NULL DEFAULT NULL COMMENT '申请金额（小写）',
  `apply_pay_money_uppercase` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请金额（大写）',
  `file_data_ids` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相关附件附件列表(frame_data)id例如:,121212,342323,',
  `status` int(4) NULL DEFAULT NULL COMMENT '状态0正常',
  `created_by_dept` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人部门',
  `created_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  `created_at` datetime NULL DEFAULT NULL COMMENT '创建时间/申请时间',
  `updated_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分表_新项目(房屋保障)的付款申请' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;