-- ----------------------------
-- Table structure for xy_xiangyueInfo员工管理
-- ----------------------------
DROP TABLE IF EXISTS `xy_personinfo`;
CREATE TABLE `xy_personinfo` (
  `xx_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `xx_name` varchar(255) DEFAULT NULL COMMENT '员工姓名',
  `xx_number` varchar(255) DEFAULT NULL COMMENT '身份证号码',
  `xx_telphone` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `xx_project` varchar(255) DEFAULT NULL COMMENT '项目组',
  `xx_position` varchar(255) DEFAULT NULL COMMENT '岗位类型',
  `xx_formal_wage` varchar(255) DEFAULT NULL COMMENT '正式工资',
  `xx_pro_wage` varchar(255) DEFAULT NULL COMMENT '试用期工资',
  `xx_entry_time` varchar(255) DEFAULT NULL COMMENT '入职时间',
  `xx_leave_date` varchar(255) DEFAULT NULL COMMENT '离职时间',
  `xx_is_befo_after` varchar(255) DEFAULT NULL COMMENT '税前或税后',
  `xx_pro_time` varchar(255) DEFAULT NULL COMMENT '试用期时长',
  `xx_end_pro_time` varchar(255) DEFAULT NULL COMMENT '试用期截止日期',
  `xx_grad_time` varchar(255) DEFAULT NULL COMMENT '毕业时间',
  `xx_enducation` varchar(255) DEFAULT NULL COMMENT '学历',
  `xx_is_true` varchar(255) DEFAULT NULL COMMENT '学信网是否可查',
  `xx_bank_name` varchar(255) DEFAULT NULL COMMENT '银行名称',
  `xx_bank_number` varchar(255) DEFAULT NULL COMMENT '银行卡号',
  `xx_gongjijin` varchar(255) DEFAULT NULL COMMENT '公积金账户',
  `xx_remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `xx_appendix` varchar(255) DEFAULT NULL COMMENT '附件',
  `xx_create_user` varchar(255) DEFAULT NULL COMMENT '创建人',
  `xx_create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `xx_status` bit(1) DEFAULT NULL COMMENT '状态：1正常、0删除',
  PRIMARY KEY (`xx_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for xy_resumeInfo简历管理
-- ----------------------------
DROP TABLE IF EXISTS `xy_resumeInfo`;
CREATE TABLE `xy_resumeInfo` (
  `xs_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `xs_name` varchar(255) DEFAULT NULL COMMENT '员工姓名',
  `xs_email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `xs_telphone` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `xs_project` varchar(255) DEFAULT NULL COMMENT '项目组',
  `xs_position` varchar(255) DEFAULT NULL COMMENT '岗位类型',
  `xs_workday` varchar(255) DEFAULT NULL COMMENT '工作年限',
  `xs_expect_wage` varchar(255) DEFAULT NULL COMMENT '期望薪资',
  `xs_birthday` varchar(255) DEFAULT NULL COMMENT '出生年月',
  `xs_school` varchar(255) DEFAULT NULL COMMENT '毕业学校',
  `xs_sex` varchar(255) DEFAULT NULL COMMENT '性别',
  `xs_grad_time` varchar(255) DEFAULT NULL COMMENT '毕业时间',
  `xs_enducation` varchar(255) DEFAULT NULL COMMENT '学历',
  `xs_is_true` varchar(255) DEFAULT NULL COMMENT '学信网是否可查',
  `xs_remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `xs_appendix` varchar(255) DEFAULT NULL COMMENT '附件',
  `xs_create_user` varchar(255) DEFAULT NULL COMMENT '创建人或负责人',
  `xs_create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `xs_status` bit(1) DEFAULT NULL COMMENT '状态：1正常、0删除',
  PRIMARY KEY (`xs_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for xy_leaveInfo请假管理
-- ----------------------------
DROP TABLE IF EXISTS `xy_leaveInfo`;
CREATE TABLE `xy_leaveinfo` (
  `xl_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `xl_name` varchar(255) DEFAULT NULL COMMENT '员工姓名',
  `xl_project` varchar(255) DEFAULT NULL COMMENT '项目组',
  `xl_position` varchar(255) DEFAULT NULL COMMENT '岗位类型',
  `xl_start_time` varchar(255) DEFAULT NULL COMMENT '请假开始时间',
  `xl_end_time` varchar(255) DEFAULT NULL COMMENT '请假结束时间',
  `xl_leave_lenth` varchar(255) DEFAULT NULL COMMENT '请假时长',
  `xl_remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `xl_create_user` varchar(255) DEFAULT NULL COMMENT '创建人',
  `xl_create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `xl_status` bit(1) DEFAULT NULL COMMENT '状态：1正常、0删除',
  PRIMARY KEY (`xl_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for xy_projectInfo项目管理202112
-- ----------------------------
DROP TABLE IF EXISTS `xy_projectInfo`;
CREATE TABLE `xy_projectInfo`  (
  `xp_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `xp_projectNum`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目编号',
  `xp_pro_name`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
  `xp_customerName`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `xp_pro_debtor`    varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '我方项目经理',
  `xp_pro_linkperson`    varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对方联系人',
  `xp_pro_type`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目类型(1人月类。2项目类)',
  `xp_con_total`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同总额',
  `xp_ssje`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实收金额',
  `xp_dsje`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '待收金额',
  `xp_xmcb`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目成本',
  `xp_xmlr`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目利润',
  `xp_con_staDate`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同开始日期',
  `xp_con_endDate`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同结束日期',
  `xp_remark`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `xp_remark1`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1',
  `xp_remark2`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2',
  `xp_remark3`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3',
  `xp_create_user`   varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `xp_create_time`   datetime NULL DEFAULT NULL COMMENT '创建时间',
  `xp_status`          varchar(255) NULL DEFAULT NULL COMMENT '状态：1、未签合同，2、合同已签从未结款，3、阶段已结款，4、待付款，5、项目结束',
  PRIMARY KEY (`xp_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;


-- ----------------------------
-- Table structure for xy_feeInfo成本管理202112
-- ----------------------------
DROP TABLE IF EXISTS `xy_feeInfo`;
CREATE TABLE `xy_feeInfo`  (
  `xf_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `xf_projectNum`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目编号',
  `xf_projectName`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
  `xf_name`         varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工姓名',
  `xf_telnumber`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码',
  `xf_sex`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `xf_gongzi`    varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工工资',
  `xf_wuxianyijin`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '五险一金',
  `xf_formal_wage`   varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正式工资',
  `xf_settle_fee`    varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结算费用报价',
  `xf_taxes_fee`    varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税金',
  `xf_otherFee`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其它费用',
  `xf_start_date`   varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开始日期',
  `xf_end_date`   varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结束日期',
  `xf_remark`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `xf_remark1`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1',
  `xf_remark2`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2',
  `xf_remark3`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3',
  `xf_create_user`   varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `xf_create_time`   datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`xf_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for xy_openBillInfo发票管理202112
-- ----------------------------
DROP TABLE IF EXISTS `xy_openBillInfo`;
CREATE TABLE `xy_openBillInfo`  (
  `xo_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `xo_projectNum`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目编号',
  `xo_projectName`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
  `xo_customerName`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `xo_open_bill_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票日期',
  `xo_open_bill_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票类型(1、专票。2、普票)',
  `xo_bill_total_amt` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票总金额',
  `xo_bill_count`    varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票张数',
  `xo_state`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1、待开。2、已开票未付款。3、已开票已付款',
  `xo_remark`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `xo_remark1`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1',
  `xo_remark2`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2',
  `xo_remark3`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3',
  `xo_appendix`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件',
  `xo_create_user`   varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `xo_create_time`   datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`xo_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for xb_reimbursement报销管理
-- ----------------------------
DROP TABLE IF EXISTS `xb_reimbursement`;
CREATE TABLE `xb_reimbursement`  (
  `xb_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `xb_person_name`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工姓名',
  `xb_fee_type`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报销类型',
  `xb_fee_date`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '费用时间',
  `xb_amt`         varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '金额',
  `xb_sement_date`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报销时间',
  `xb_remark`       varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `xb_appendix`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件',
  `xb_create_user`   varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `xb_create_time`   datetime NULL DEFAULT NULL COMMENT '创建时间',
  `xb_isyesorno`          bit(1) NULL DEFAULT NULL COMMENT '是否报销：1未报销、0已报销',
  `xb_status`          bit(1) NULL DEFAULT NULL COMMENT '状态：1正常、0删除',
  PRIMARY KEY (`xb_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- xyadmin_db.xy_bidding_info definition

CREATE TABLE `xy_bidding_info` (
                                   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
                                   `project_id` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '项目编号',
                                   `project_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '项目简称',
                                   `project_long_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '项目名称',
                                   `registration_lot_number` int(11) DEFAULT NULL COMMENT '报名标段编号',
                                   `registration_deadline` datetime DEFAULT NULL COMMENT '报名截止时间',
                                   `registration_fee` decimal(10,2) DEFAULT NULL COMMENT '报名费用',
                                   `registration_method` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '报名方式',
                                   `bidding_date_time` datetime DEFAULT NULL COMMENT '投标具体时间',
                                   `bid_bond` decimal(10,2) DEFAULT NULL COMMENT '投标保证金',
                                   `bond_account_number` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '保证金账户',
                                   `bidding_location` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '投标地址',
                                   `is_onsite_bidding` tinyint(1) DEFAULT NULL COMMENT '是否现场投标',
                                   `number_of_suppliers_per_lot` int(11) DEFAULT NULL COMMENT '每个包招几家供应商',
                                   `is_business_technical_separate` tinyint(1) DEFAULT NULL COMMENT '标书商务技术标是否分开',
                                   `number_of_original_bid_documents` int(11) DEFAULT NULL COMMENT '标书一正几副',
                                   `is_electronic_bid_required` tinyint(1) DEFAULT NULL COMMENT '标书是否要电子版',
                                   `is_bid_price_separately_sealed` tinyint(1) DEFAULT NULL COMMENT '标书报价是否单独封装',
                                   `is_tender_fee_required` tinyint(1) DEFAULT NULL COMMENT '是否要招标服务费',
                                   `remarks` text COLLATE utf8mb4_bin COMMENT '备注',
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='投标信息';

