
-- ----------------------------
-- Table structure for oa_admin
-- ----------------------------


-- ----------------------------
-- Table structure for oa_admin_profiles
-- ----------------------------
CREATE TABLE `oa_admin_profiles`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Employee ID',
  `types` int(1) NOT NULL DEFAULT 0 COMMENT 'Type:1/2/3/4/5',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '//Name/Name/Name/Name/',
  `start_time` varchar(255) NOT NULL DEFAULT '' COMMENT 'Start time',
  `end_time` varchar(255) NOT NULL DEFAULT '' COMMENT 'End time',
  `speciality` varchar(50) NOT NULL DEFAULT '' COMMENT 'Major',
  `education` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `authority` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `position` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `know` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `sort` int(5) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_labor_contract
-- ----------------------------
CREATE TABLE `oa_labor_contract`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `renewal_pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `change_pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID',
  `cate` int(1) NOT NULL DEFAULT 1 COMMENT ':1,2,3',
  `types` int(1) NOT NULL DEFAULT 1 COMMENT 'Type:1,2,2',
  `enterprise_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `properties` int(1) NOT NULL DEFAULT 1 COMMENT ':1,2,3',
  `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `sign_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `start_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `secure_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `trial_months` int(5) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `trial_end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time',
  `trial_salary` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `worker_salary` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2,3',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_admin_log
-- ----------------------------
CREATE TABLE `oa_admin_log`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `type` varchar(80) NOT NULL DEFAULT '' COMMENT 'Type',
  `action` varchar(80) NOT NULL DEFAULT '' COMMENT 'Comment',
  `subject` varchar(80) NOT NULL DEFAULT '' COMMENT 'Comment',
  `module` varchar(32) NOT NULL DEFAULT '' COMMENT 'Comment',
  `controller` varchar(32) NOT NULL DEFAULT '' COMMENT 'Comment',
  `function` varchar(32) NOT NULL DEFAULT '' COMMENT 'Comment',
  `ip` varchar(64) NOT NULL DEFAULT '' COMMENT 'ip',
  `param_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `param` mediumtext  NULL COMMENT 'json',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_admin_module
-- ----------------------------
CREATE TABLE `oa_admin_module`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT ',,',
  `desc` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `type` int(2) NOT NULL DEFAULT 1 COMMENT 'Status:1,2,3',
  `sourse` int(2) NOT NULL DEFAULT 1 COMMENT ':1,2',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:0,1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_admin_module
-- ----------------------------
INSERT INTO `oa_admin_module` VALUES (1, 'System Module', 'home','', 1, 1,1, 1639562910, 0);
INSERT INTO `oa_admin_module` VALUES (2, 'HR Module', 'user','', 1, 1,1, 1639562910, 0);
INSERT INTO `oa_admin_module` VALUES (3, 'Administration Module', 'adm','', 1, 1,1, 1639562910, 0);
INSERT INTO `oa_admin_module` VALUES (4, 'Office Module', 'office','', 1, 1,1, 1639562910, 0);
INSERT INTO `oa_admin_module` VALUES (5, 'Finance Module', 'finance','', 1, 1,1, 1639562910, 0);
INSERT INTO `oa_admin_module` VALUES (6, 'Customer Module', 'customer','', 2, 1,1, 1639562910, 0);
INSERT INTO `oa_admin_module` VALUES (7, 'Contract Module', 'contract','', 2, 1,1, 1656142368, 0);
INSERT INTO `oa_admin_module` VALUES (8, 'Project Module', 'project','', 2, 1,1, 1656142368, 0);
INSERT INTO `oa_admin_module` VALUES (9, 'Disk Module', 'disk','', 2, 1,1, 1656143065, 0);

-- ----------------------------
-- Table structure for oa_admin_rule
-- ----------------------------
CREATE TABLE `oa_admin_rule`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `src` varchar(255) NOT NULL DEFAULT '' COMMENT 'url',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `module` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `menu` int(1) NOT NULL DEFAULT 0 COMMENT ',1,2',
  `sort` int(11) NOT NULL DEFAULT 1 COMMENT 'Comment',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status,0,1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_admin_rule
-- ----------------------------
INSERT INTO `oa_admin_rule` VALUES (1, 0, '', 'System Management', 'System Management', 'home', 'icon-jichupeizhi', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (2, 0, '', 'Master Data', 'Master Data', 'base', 'icon-hetongshezhi', 1, 2, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (3, 0, '', 'HR Management', 'HR Management', 'user', 'icon-renshishezhi', 1, 3, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (4, 0, '', 'Administration', 'Administration', 'adm', 'icon-banjiguanli', 1, 4, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (5, 0, '', 'Personal Office', 'Personal Office', 'office', 'icon-kaoshijihua', 1, 5, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (6, 0, '', 'Finance', 'Finance', 'finance', 'icon-yuangongtidian', 1, 6, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (7, 0, '', 'Customers', 'Customers', 'customer', 'icon-kehuguanli', 1, 7, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (8, 0, '', 'Contracts', 'Contracts', 'contract', 'icon-hetongyidong', 1, 8, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (9, 0, '', 'Projects', 'Projects', 'project', 'icon-xiangmuguanli', 1, 9, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (10, 0, '', 'Knowledge Drive', 'Knowledge Drive', 'disk', 'icon-tikuguanli', 1, 10, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (11, 1, 'home/conf/index', 'System Settings', 'System Settings', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (12, 11, 'home/conf/add', 'Create/Edit', 'Config Item', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (13, 11, 'home/conf/delete', 'Delete', 'Config Item', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (14, 11, 'home/conf/edit', 'Edit', 'Config Details', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (15, 1, 'home/module/index', 'Modules', 'Modules', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (16, 15, 'home/module/add', 'Create/Edit', 'Modules', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (17, 15, 'home/module/del', 'Delete', 'Modules', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (18, 15, 'home/module/recovery', 'Restore', 'Modules', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (19, 15, 'home/module/install', 'Install', 'Modules', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (20, 1, 'home/dataauth/index', 'Module Settings', 'Module Settings', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (21, 20, 'home/dataauth/edit', 'Edit', 'Module Settings', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (22, 1, 'home/rule/index', 'Feature Nodes', 'Feature Nodes', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (23, 22, 'home/rule/add', 'Create/Edit', 'Feature Nodes', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (24, 22, 'home/rule/delete', 'Delete', 'Feature Nodes', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (25, 1, 'mobile/bar/datalist', 'Mobile Configuration', 'Mobile Configuration', 'home', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (26, 25, 'mobile/bar/datalist', 'BAR Menu', 'BAR Menu', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (27, 26, 'mobile/bar/add', 'Create/Edit', 'BAR Menu', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (28, 26, 'mobile/bar/set', 'Settings', 'BAR Menu', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (29, 25, 'mobile/types/datalist', 'Workspace Menu Types', 'Workspace Menu Types', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (30, 29, 'mobile/types/add', 'Create/Edit', 'Workspace Menu Types', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (31, 29, 'mobile/types/del', 'Delete', 'Workspace Menu Types', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (32, 29, 'mobile/types/set', 'Settings', 'Workspace Menu Types', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (33, 25, 'mobile/menu/datalist', 'Workspace Menu', 'Workspace Menu', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (34, 33, 'mobile/menu/add', 'Create/Edit', 'Workspace Menu', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (35, 33, 'mobile/menu/del', 'Delete', 'Workspace Menu', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (36, 33, 'mobile/menu/set', 'Settings', 'Workspace Menu', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (37, 1, 'home/role/index', 'Roles & Permissions', 'Roles & Permissions', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (38, 37, 'home/role/add', 'Create/Edit', 'Roles & Permissions', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (39, 37, 'home/role/delete', 'Delete', 'Roles & Permissions', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (40, 1, 'home/log/index', 'Operation Log', 'Operation Log', 'home', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (41, 1, 'home/files/index', 'Attachment Management','Attachment Management', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (42, 41, 'home/files/edit', 'EditAttachment','Attachment', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (43, 41, 'home/files/move', 'Move Attachment','Attachment', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (44, 41, 'home/files/delete', 'DeleteAttachment','Attachment', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (45, 41, 'home/files/get_group', 'Attachment Groups','Attachment Groups', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (46, 41, 'home/files/add_group', 'Create/Edit','Attachment Groups', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (47, 41, 'home/files/del_group', 'DeleteAttachment Groups','Attachment Groups', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (48, 1, 'home/database/database', 'Backup Data', 'Data Backup', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (49, 48, 'home/database/backup', 'Backup Tables', 'Data', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (50, 48, 'home/database/optimize', 'Optimize Tables', 'Tables', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (51, 48, 'home/database/repair', 'Repair Tables', 'Tables', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (52, 1, 'home/database/backuplist', 'Restore Data', 'Data Restore', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (53, 52, 'home/database/import', 'Restore Tables', 'Data', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (54, 52, 'home/database/downfile', 'Backup Data', 'Backup Data', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (55, 52, 'home/database/del', 'DeleteBackup Data', 'Backup Data', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (56, 1, 'home/task/index', 'Scheduled Tasks', 'Scheduled Tasks', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (57, 56, 'home/task/add', 'Create/Edit', 'Scheduled Tasks', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (58, 56, 'home/task/delete', 'Delete', 'Scheduled Tasks', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (59, 2, '', 'Common Module', 'Common Module', 'home', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (60, 59, 'home/template/datalist', 'Message Templates', 'Message Templates', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (61, 60, 'home/template/add', 'Create/Edit', 'Message Templates', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (62, 60, 'home/template/set', 'Settings', 'Message Templates', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (63, 60, 'home/template/view', 'View', 'Message Templates', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (64, 59, 'adm/flow/modulelist', 'Approval Modules', 'Approval Modules', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (65, 64, 'adm/flow/module_add', 'Create/Edit', 'Approval Modules', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (66, 64, 'adm/flow/module_check', 'Settings', 'Approval Modules', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (67, 59, 'adm/flow/catelist', 'Approval Categories', 'Approval Categories', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (68, 67, 'adm/flow/cate_add', 'Create/Edit', 'Approval Categories', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (69, 67, 'adm/flow/cate_check', 'Settings', 'Approval Categories', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (70, 59, 'adm/flow/datalist', 'Approval Workflows', 'Approval Workflows', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (71, 70, 'adm/flow/add', 'Create/Edit', 'Approval Workflows', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (72, 70, 'adm/flow/del', 'Delete', 'Approval Workflows', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (73, 70, 'adm/flow/check', 'Settings', 'Approval Workflows', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (74, 59, 'home/cate/enterprise', 'Company Entity', 'Company Entity', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (75, 74, 'home/cate/enterprise_add', 'Create/Edit', 'Company Entity', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (76, 74, 'home/cate/enterprise_check', 'Settings', 'Company Entity', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (77, 59, 'home/area/datalist', 'Provinces & Cities', 'Provinces & Cities', 'home', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (78, 77, 'home/area/add', 'Create/Edit', 'Provinces & Cities', 'home', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (79, 77, 'home/area/set', 'Settings', 'Provinces & Cities', 'home', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (80, 2, '', 'HR Module', 'HR Module', 'user', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (81, 80, 'user/rewardscate/datalist', 'Reward/Penalty Items', 'Reward/Penalty Items', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (82, 81, 'user/rewardscate/add', 'Create/Edit', 'Reward/Penalty Items', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (83, 81, 'user/rewardscate/set', 'Settings', 'Reward/Penalty Items', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (84, 80, 'user/carecate/datalist', 'Care Items', 'Care Items', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (85, 84, 'user/carecate/add', 'Create/Edit', 'Care Items', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (86, 84, 'user/carecate/set', 'Settings', 'Care Items', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (87, 80, 'user/basic/datalist', 'Data', 'Data', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (88, 87, 'user/basic/add', 'Create/Edit', 'Data', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (89, 87, 'user/basic/set', 'Settings', 'Data', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (90, 3, 'user/department/index', 'Department Structure', 'Department', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (91, 90, 'user/department/add', 'Create/Edit', 'Department', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (92, 90, 'user/department/delete', 'Delete', 'Department', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (93, 3, 'user/position/index', 'Positions & Titles', 'Positions & Titles', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (94, 93, 'user/position/add', 'Create/Edit', 'Positions & Titles', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (95, 93, 'user/position/delete', 'Delete', 'Positions & Titles', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (96, 93, 'user/position/view', 'View', 'Positions & Titles', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (97, 3, 'user/user/index', 'Employees', 'Item', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (98, 97, 'user/user/add', 'Create/Edit', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (99, 97, 'user/user/view', 'View', 'Employee Info', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (100, 97, 'user/user/set', 'Settings', 'Employee Status', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (102, 97, 'user/user/del', 'Delete', 'Item', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (103, 3, 'user/files/datalist', 'Employee Files', 'Employee Files', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (104, 103, 'user/files/add', 'Edit', 'Employee Files', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (105, 103, 'user/files/view', 'View', 'Employee Files', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (106, 3, 'user/personal/change', 'Personnel Transfer', 'Personnel Transfer', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (107, 106, 'user/personal/change_add', 'Create/Edit', 'Personnel Transfer', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (108, 3, 'user/personal/leave', 'Resignation Request', 'Resignation Request', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (109, 108, 'user/personal/leave_add', 'Create/Edit', 'Resignation Request', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (110, 108, 'user/personal/leave_delete', 'Delete', 'Resignation Request', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (111, 108, 'user/personal/leave_view', 'View', 'Resignation Request', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (112, 3, 'user/rewards/datalist', 'Rewards & Penalties', 'Rewards & Penalties', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (113, 112, 'user/rewards/add', 'Create/Edit', 'Rewards & Penalties', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (114, 112, 'user/rewards/view', 'View', 'Rewards & Penalties', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (115, 112, 'user/rewards/del', 'Delete', 'Rewards & Penalties', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (116, 3, 'user/care/datalist', 'Employee Care', 'Employee Care', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (117, 116, 'user/care/add', 'Create/Edit', 'Employee Care', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (118, 116, 'user/care/view', 'View', 'Employee Care', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (119, 116, 'user/care/del', 'Delete', 'Employee Care', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (120, 3, 'user/laborcontract/datalist', 'Item', 'Item', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (121, 120, 'user/laborcontract/add', 'Create/Edit', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (122, 120, 'user/laborcontract/add_renewal', 'Item', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (123, 120, 'user/laborcontract/add_change', 'Item', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (124, 120, 'user/laborcontract/view', 'View', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (125, 120, 'user/laborcontract/del', 'Delete', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (126, 120, 'user/laborcontract/set', 'Settings', 'Item', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (127, 2, '', 'Administration Module', 'Administration Module', 'adm', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (128, 127, 'adm/propertycate/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (129, 128, 'adm/propertycate/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (130, 128, 'adm/propertycate/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (131, 127, 'adm/propertybrand/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (132, 131, 'adm/propertybrand/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (133, 131, 'adm/propertybrand/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (134, 127, 'adm/propertyunit/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (135, 134, 'adm/propertyunit/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (136, 134, 'adm/propertyunit/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (137, 127, 'adm/sealcate/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (138, 137, 'adm/sealcate/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (139, 137, 'adm/sealcate/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (140, 127, 'adm/basic/datalist', 'Data', 'Data', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (141, 140, 'adm/basic/add', 'Create/Edit', 'Data', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (142, 140, 'adm/basic/set', 'Settings', 'Data', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (143, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (144, 143, 'adm/property/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (145, 144, 'adm/property/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (146, 144, 'adm/property/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (147, 144, 'adm/property/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (148, 143, 'adm/property/repair_list', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (149, 148, 'adm/property/repair_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (150, 148, 'adm/property/repair_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (151, 148, 'adm/property/repair_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (152, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (153, 152, 'adm/car/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (154, 153, 'adm/car/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (155, 153, 'adm/car/check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (156, 153, 'adm/car/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (157, 152, 'adm/car/repair_list', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (158, 157, 'adm/car/repair_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (159, 157, 'adm/car/repair_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (160, 157, 'adm/car/repair_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (161, 152, 'adm/car/protect_list', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (162, 161, 'adm/car/protect_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (163, 161, 'adm/car/protect_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (164, 161, 'adm/car/protect_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (165, 152, 'adm/car/mileage_list', 'Item', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (166, 165, 'adm/car/mileage_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (167, 165, 'adm/car/mileage_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (168, 152, 'adm/car/fee_list', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (169, 168, 'adm/car/fee_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (170, 168, 'adm/car/fee_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (171, 168, 'adm/car/fee_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (172, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (173, 172, 'adm/meeting/room', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (174, 173, 'adm/meeting/room_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (175, 173, 'adm/meeting/room_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (176, 173, 'adm/meeting/room_check', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (177, 172, 'adm/meeting/records', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (178, 177, 'adm/meeting/records_add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (179, 177, 'adm/meeting/records_view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (180, 177, 'adm/meeting/records_del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (181, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (182, 181, 'adm/official/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (183, 182, 'adm/official/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (184, 182, 'adm/official/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (185, 182, 'adm/official/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (186, 181, 'adm/official/pending', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (187, 181, 'adm/official/reviewed', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (188, 4, '', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (189, 188, 'adm/seal/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (190, 189, 'adm/seal/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (191, 189, 'adm/seal/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (192, 189, 'adm/seal/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (193, 188, 'adm/seal/record', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (194, 127, 'adm/notecate/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (195, 194, 'adm/notecate/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (196, 194, 'adm/notecate/set', 'Settings', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (197, 4, 'adm/note/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (198, 197, 'adm/note/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (199, 197, 'adm/note/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (200, 197, 'adm/note/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (201, 4, 'adm/news/datalist', 'Item', 'Item', 'adm', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (202, 201, 'adm/news/add', 'Create/Edit', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (203, 201, 'adm/news/del', 'Delete', 'Item', 'adm', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (204, 201, 'adm/news/view', 'View', 'Item', 'adm', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (205, 5, 'oa/plan/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (206, 205, 'oa/plan/add', 'Create/Edit', 'Item', 'oa', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (207, 205, 'oa/plan/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (208, 205, 'oa/plan/del', 'Delete', 'Item', 'oa', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (209, 5, 'oa/plan/calendar', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (210, 5, 'oa/schedule/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (211, 210, 'oa/schedule/add', 'Create/Edit', 'Item', 'oa', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (212, 210, 'oa/schedule/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (213, 210, 'oa/schedule/del', 'Delete', 'Item', 'oa', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (214, 5, 'oa/schedule/calendar', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (215, 5, 'oa/work/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (216, 215, 'oa/work/add', 'Create/Edit', 'Item', 'oa', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (217, 215, 'oa/work/send', 'Item', 'Item', 'oa', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (218, 215, 'oa/work/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (219, 215, 'oa/work/del', 'Delete', 'Item', 'oa', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (220, 5, 'oa/note/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (221, 220, 'oa/note/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (222, 5, 'oa/news/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (223, 222, 'oa/news/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (224, 5, 'oa/meeting/datalist', 'Item', 'Item', 'oa', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (225, 224, 'oa/meeting/view', 'View', 'Item', 'oa', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (226, 2, '', 'Finance Module', 'Finance Module', 'finance', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (227, 226, 'finance/expensecate/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (228, 227, 'finance/expensecate/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (229, 227, 'finance/expensecate/set', 'Settings', 'Item', 'finance', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (230, 226, 'finance/costcate/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (231, 230, 'finance/costcate/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (233, 230, 'finance/costcate/set', 'Settings', 'Item', 'finance', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (234, 6, 'finance/expense/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (235, 234, 'finance/expense/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (236, 234, 'finance/expense/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (237, 234, 'finance/expense/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (238, 6, 'finance/invoice/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (239, 238, 'finance/invoice/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (240, 238, 'finance/invoice/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (241, 238, 'finance/invoice/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (242, 6, 'finance/ticket/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (243, 242, 'finance/ticket/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (244, 242, 'finance/ticket/delete', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (245, 242, 'finance/ticket/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (246, 6, 'finance/income/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (247, 246, 'finance/income/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (248, 246, 'finance/income/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (249, 246, 'finance/income/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (250, 6, 'finance/invoice/datalist_a', 'Item', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (251, 250, 'finance/invoice/add_a', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (252, 250, 'finance/invoice/del_a', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (253, 250, 'finance/invoice/view_a', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (254, 6, 'finance/payment/datalist', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (255, 254, 'finance/payment/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (256, 254, 'finance/payment/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (257, 254, 'finance/payment/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (258, 6, 'finance/ticket/datalist_a', 'Item', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (259, 258, 'finance/ticket/add_a', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (260, 258, 'finance/ticket/del_a', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (261, 258, 'finance/ticket/view_a', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (262, 6, '', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (263, 262, 'finance/expense/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (264, 262, 'finance/invoice/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (265, 262, 'finance/ticket/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (266, 262, 'finance/income/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (267, 262, 'finance/payment/record', 'Item', 'Item', 'finance', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (268, 2, '', 'Customer Module', 'Customer Module', 'customer', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (269, 268, 'customer/industry/datalist', 'Item', 'Item', 'home', '', 1, 0, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (270, 269, 'customer/industry/add', 'Create/Edit', 'Item', 'home', '', 2, 0, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (271, 269, 'customer/industry/set', 'Settings', 'Item', 'home', '', 2, 0, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (272, 268, 'customer/grade/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (273, 272, 'customer/grade/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (274, 272, 'customer/grade/set', 'Settings', 'Item', 'customer', '', 2,0, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (275, 268, 'customer/source/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (276, 275, 'customer/source/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (277, 275, 'customer/source/set', 'Settings', 'Item', 'customer', '', 2,0, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (278, 268, 'customer/basic/datalist', 'Data', 'Data', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (279, 278, 'customer/basic/add', 'Create/Edit', 'Data', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (280, 278, 'customer/basic/set', 'Settings', 'Data', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (281, 7, 'customer/customer/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 1556143065, 0);
INSERT INTO `oa_admin_rule` VALUES (282, 281, 'customer/customer/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0);
INSERT INTO `oa_admin_rule` VALUES (283, 281, 'customer/customer/view', 'View', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0);
INSERT INTO `oa_admin_rule` VALUES (284, 281, 'customer/customer/del', 'Delete', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0);

INSERT INTO `oa_admin_rule` VALUES (285, 7, 'customer/index/rush', 'Item', 'Item', 'customer', '', 1, 0, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (286, 7, 'customer/index/sea', 'Item', 'Item', 'customer', '', 1, 0, 1, 1556143065, 0);
INSERT INTO `oa_admin_rule` VALUES (287, 286, 'customer/index/to_get', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0);
INSERT INTO `oa_admin_rule` VALUES (288, 286, 'customer/index/to_divide', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0);
INSERT INTO `oa_admin_rule` VALUES (289, 286, 'customer/index/to_sea', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0);
INSERT INTO `oa_admin_rule` VALUES (290, 286, 'customer/index/to_trash', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0);
INSERT INTO `oa_admin_rule` VALUES (291, 286, 'customer/index/to_revert', 'Item', 'Item', 'customer', '', 2, 0, 1, 1556143065, 0);

INSERT INTO `oa_admin_rule` VALUES (292, 7, 'customer/index/trash', 'Item', 'Item', 'customer', '', 1, 0, 1, 1556143065, 0);

INSERT INTO `oa_admin_rule` VALUES (293, 7, 'customer/contact/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (294, 286, 'customer/contact/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (295, 286, 'customer/contact/del', 'Delete', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (296, 286, 'customer/contact/view', 'View', 'Item', 'customer', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (297, 7, 'customer/chance/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (298, 297, 'customer/chance/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (299, 297, 'customer/chance/view', 'View', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (300, 297, 'customer/chance/del', 'Delete', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (301, 7, 'customer/trace/datalist', 'Item', 'Item', 'customer', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (302, 301, 'customer/trace/add', 'Create/Edit', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (303, 301, 'customer/trace/view', 'View', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (304, 301, 'customer/trace/del', 'Delete', 'Item', 'customer', '', 2, 0, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (305, 2, '', 'Contract Module', 'Contract Module', 'contract', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (306, 305, 'contract/cate/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (307, 306, 'contract/cate/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 0, 1656143065);
INSERT INTO `oa_admin_rule` VALUES (308, 306, 'contract/cate/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (309, 305, 'contract/productcate/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (310, 309, 'contract/productcate/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (311, 309, 'contract/productcate/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (312, 305, 'contract/product/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (313, 312, 'contract/product/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (314, 312, 'contract/product/view', 'View', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (315, 312, 'contract/product/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (316, 312, 'contract/product/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (317, 305, 'contract/services/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (318, 317, 'contract/services/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (319, 317, 'contract/services/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (320, 305, 'contract/supplier/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (321, 320, 'contract/supplier/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (322, 320, 'contract/supplier/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (323, 320, 'contract/supplier/view', 'View', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (324, 320, 'contract/supplier/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (325, 320, 'contract/supplier/contact_add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (326, 320, 'contract/supplier/contact_del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (327, 305, 'contract/purchasedcate/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (328, 327, 'contract/purchasedcate/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (329, 327, 'contract/purchasedcate/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (330, 305, 'contract/purchased/datalist', 'Item', 'Item', 'contract', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (331, 330, 'contract/purchased/add', 'Create/Edit', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (332, 330, 'contract/purchased/view', 'View', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (333, 330, 'contract/purchased/del', 'Delete', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (334, 330, 'contract/purchased/set', 'Settings', 'Item', 'contract', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (335, 8, 'contract/contract/datalist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (336, 335, 'contract/contract/add', 'Create/Edit', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (337, 335, 'contract/contract/view', 'View', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (338, 335, 'contract/contract/del', 'Delete', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (339, 8, 'contract/purchase/datalist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (340, 339, 'contract/purchase/add', 'Create/Edit', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (341, 339, 'contract/purchase/view', 'View', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (342, 339, 'contract/purchase/del', 'Delete', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (343, 8, 'contract/contract/archivelist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (344, 343, 'contract/purchase/archivelist', 'Item', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (345, 8, 'contract/contract/stoplist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (346, 345, 'contract/purchase/stoplist', 'Item', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (347, 8, 'contract/contract/voidlist', 'Item', 'Item', 'contract', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (348, 347, 'contract/purchase/voidlist', 'Item', 'Item', 'contract', '', 2, 0, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (349, 2, '', 'Project Module', 'Project Module', 'project', '', 1, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (350, 349, 'project/step/datalist', 'Item', 'Item', 'project', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (351, 350, 'project/step/add', 'Create/Edit', 'Item', 'project', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (352, 350, 'project/step/set', 'Settings', 'Item', 'project', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (353, 349, 'project/cate/datalist', 'Item', 'Item', 'project', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (354, 353, 'project/cate/add', 'Create/Edit', 'Item', 'project', '', 2, 1, 1, 0, 1656143065);
INSERT INTO `oa_admin_rule` VALUES (355, 353, 'project/cate/set', 'Settings', 'Item', 'project', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (356, 349, 'project/work/datalist', 'Item', 'Item', 'project', '', 1, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (357, 356, 'project/work/add', 'Create/Edit', 'Item', 'project', '', 2, 1, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (358, 356, 'project/work/set', 'Settings', 'Item', 'project', '', 2, 1, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (359, 9, 'project/index/datalist', 'Item', 'Item', 'project', '', 1, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (360, 359, 'project/index/add', 'Create', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (361, 359, 'project/index/edit', 'Edit', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (362, 359, 'project/index/view', 'View', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (363, 359, 'project/index/del', 'Delete', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);

INSERT INTO `oa_admin_rule` VALUES (364, 9, 'project/task/datalist', 'Item', 'Item', 'project', '', 1, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (365, 364, 'project/task/add', 'Create', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (366, 364, 'project/task/edit', 'Edit', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (367, 364, 'project/task/view', 'View', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (368, 364, 'project/task/del', 'Delete', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);

INSERT INTO `oa_admin_rule` VALUES (369, 9, 'project/task/hour', 'Item', 'Item', 'project', '', 1, 0, 1, 1656142368, 0);

INSERT INTO `oa_admin_rule` VALUES (370, 9, 'project/document/datalist', 'Item', 'Item', 'project', '', 1, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (371, 370, 'project/document/add', 'Create/Edit', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (372, 370, 'project/document/view', 'View', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);
INSERT INTO `oa_admin_rule` VALUES (373, 370, 'project/document/delete', 'Delete', 'Item', 'project', '', 2, 0, 1, 1656142368, 0);

INSERT INTO `oa_admin_rule` VALUES (374, 10, 'disk/index/datalist', 'Item', 'Item', 'disk', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (375, 374, 'disk/index/add_upload', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (376, 374, 'disk/index/add_folder', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (377, 374, 'disk/index/add_article', '/Edit', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (378, 374, 'disk/index/view_article', 'View', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (379, 374, 'disk/index/del', 'Delete', '//', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (380, 374, 'disk/index/rename', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (381, 374, 'disk/index/move', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (382, 374, 'disk/index/star', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (383, 374, 'disk/index/unstar', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (384, 374, 'disk/index/back', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (385, 374, 'disk/index/clear', 'Item', 'Item', 'disk', '', 2, 0, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (386, 10, 'disk/index/sharelist', 'Item', 'Item', 'disk', '', 1, 0, 1, 1656143065, 0);
INSERT INTO `oa_admin_rule` VALUES (387, 386, 'disk/index/add_group', 'Create/Edit','Item', 'disk', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (388, 386, 'disk/index/del_group', 'Delete','Item', 'disk', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (389, 10, 'disk/index/clearlist', 'Item', 'Item', 'disk', '', 1, 0, 1, 1656143065, 0);

INSERT INTO `oa_admin_rule` VALUES (390, 6, 'finance/loan/datalist', 'Item', 'Item', 'finance', '', 1, 0, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (391, 390, 'finance/loan/add', 'Create/Edit', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (392, 390, 'finance/loan/del', 'Delete', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (393, 390, 'finance/loan/view', 'View', 'Item', 'finance', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (394, 262, 'finance/loan/record', 'Item', 'Item', 'finance', '', 1, 0, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (395, 3, 'user/talent/datalist', 'Item', 'Item', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (396, 395, 'user/talent/add', '/Edit', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (397, 395, 'user/talent/view', 'View', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (398, 395, 'user/talent/del', 'Delete', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (399, 395, 'user/talent/set', 'Item', 'Item', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (400, 3, 'user/blacklist/datalist', 'Item', 'Item', 'user', '', 1, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (401, 400, 'user/blacklist/add', 'Edit', 'Item', 'user', '', 2, 1, 1, 0, 0);
INSERT INTO `oa_admin_rule` VALUES (402, 400, 'user/blacklist/del', 'Delete', 'Item', 'user', '', 2, 1, 1, 0, 0);

INSERT INTO `oa_admin_rule` VALUES (403, 106, 'user/personal/change_view', 'View', 'Personnel Transfer', 'user', '', 2, 1, 1, 0, 0);

-- ----------------------------
-- Table structure for oa_admin_group
-- ----------------------------
CREATE TABLE `oa_admin_group`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT 1,
  `rules` mediumtext  NULL COMMENT 'id',
  `layouts` mediumtext  NULL COMMENT 'Comment',
  `mobile_bar` mediumtext  NULL COMMENT 'Bar',
  `mobile_menu` mediumtext  NULL COMMENT 'Comment',
  `desc` mediumtext  NULL COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0,
  `update_time` bigint(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_admin_group
-- ----------------------------
INSERT INTO `oa_admin_group` VALUES (1, 'Item', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403', '1,2,3,4,5,6,7,8,9,10,11,12','1,2,3,4,5','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16',',,Data,,Delete.', 0, 0);
INSERT INTO `oa_admin_group` VALUES (2, 'Item', 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403','1,2,3,4,5,6,7,8,9,10,11,12','1,2,3,4,5','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 'Roles & Permissions,.', 0, 0);
INSERT INTO `oa_admin_group` VALUES (3, 'Item', 1, '4,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,197,198,199,200,201,202,203,204,5,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,6,390,391,392,393,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,394,263,264,265,266,267,7,281,282,283,284,285,286,287,288,289,290,291,294,295,296,292,293,297,298,299,300,301,302,303,304,8,335,336,337,338,339,340,341,342,343,344,345,346,347,348,9,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,10,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16','1,2,3,4,5','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 'Roles & Permissions,.', 0, 0);

-- ----------------------------
-- Table structure for oa_data_auth
-- ----------------------------
CREATE TABLE `oa_data_auth`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT ',',
  `desc` mediumtext  NULL COMMENT 'Comment',
  `module` varchar(255) NOT NULL DEFAULT '' COMMENT ',,',
  `uids` mediumtext  NULL COMMENT ',1,2,3',
  `conf_1` mediumtext  NULL COMMENT '1,',
  `conf_2` mediumtext  NULL COMMENT '2,',
  `conf_3` mediumtext  NULL COMMENT '3,',
  `conf_4` mediumtext  NULL COMMENT '4,',
  `conf_5` mediumtext  NULL COMMENT '5,',
  `conf_6` mediumtext  NULL COMMENT '6,',
  `conf_7` mediumtext  NULL COMMENT '7,',
  `conf_8` mediumtext  NULL COMMENT '8,',
  `conf_9` mediumtext  NULL COMMENT '9,',
  `conf_10` mediumtext  NULL COMMENT '9,',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of  oa_data_auth
-- ----------------------------
INSERT INTO `oa_data_auth` VALUES (1, 'Item', 'office_admin', 'Data.', 'office', '', '', '3', '', '', '', '', '', '', '', '', 1656143065, 1724830718);
INSERT INTO `oa_data_auth` VALUES (2, 'Finance Module', 'finance_admin', 'Data.', 'finance', '', '', '', '', '', '', '', '', '', '', '', 1656143065, 0);
INSERT INTO `oa_data_auth` VALUES (3, 'Customer Module', 'customer_admin', 'Customer ModuleData.', 'customer', '', '', '10', '100', '', '', '', '', '', '', '', 1656143065, 1724830738);
INSERT INTO `oa_data_auth` VALUES (4, 'Contract Module', 'contract_admin', 'Contract ModuleData.', 'contract', '', '', '1', '1', '1', '1', '1', '1', '', '', '30', 1656143065, 1724830772);
INSERT INTO `oa_data_auth` VALUES (5, 'Project Module', 'project_admin', 'Project ModuleData.', 'project', '', '', '', '', '', '', '', '', '', '', '3', 1656143065, 0);
INSERT INTO `oa_data_auth` VALUES (6, 'Disk Module', 'disk_admin', 'Disk ModuleData.', 'disk', '', '', '', '', '', '', '', '', '', '', '', 1656143065, 0);

-- ----------------------------
-- Table structure for oa_config
-- ----------------------------
CREATE TABLE `oa_config`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `content` mediumtext  NULL COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_config
-- ----------------------------
INSERT INTO `oa_config`VALUES (1, 'Item', 'web', 'a:10:{s:2:\"id\";s:1:\"1\";s:11:\"admin_title\";s:2:\"OA\";s:6:\"domain\";s:24:\"https://www.gougucms.com\";s:3:\"icp\";s:12:\"ICPxxxxxxx-1\";s:4:\"logo\";s:31:\"/static/home/images/syslogo.png\";s:4:\"file\";s:0:\"\";s:10:\"small_logo\";s:37:\"/static/home/images/syslogo_small.png\";s:5:\"beian\";s:9:\"xxxxxxx-1\";s:8:\"keywords\";s:2:\"OA\";s:4:\"desc\";s:76:\"ThinkPHP8 + Layui + MySql,.Settings. Data. . . . . . . . . . .,,,,,CRM,ERP,.\";}', 1, 1612514630, 1724823769);
INSERT INTO `oa_config`VALUES (2, 'Item', 'system', 'a:8:{s:9:\"menu_mode\";s:9:\"classical\";s:19:\"upload_max_filesize\";s:2:\"50\";s:9:\"msg_sound\";s:1:\"1\";s:9:\"watermark\";s:1:\"1\";s:6:\"qrcode\";s:1:\"2\";s:7:\"version\";s:5:\"5.0.2\";s:9:\"copyright\";s:24:\"© 2021-2025 gouguoa.com\";s:2:\"id\";s:1:\"2\";}', 1, 1612514630, 1724824879);
INSERT INTO `oa_config`VALUES (3, 'Item', 'email', 'a:8:{s:2:\"id\";s:1:\"2\";s:4:\"smtp\";s:11:\"smtp.qq.com\";s:9:\"smtp_port\";s:3:\"465\";s:9:\"smtp_user\";s:15:\"gougucms@qq.com\";s:8:\"smtp_pwd\";s:6:\"123456\";s:4:\"from\";s:3:\"CMS\";s:5:\"email\";s:18:\"admin@gougucms.com\";s:8:\"template\";s:65:\"<p>ThinkPHP8 + Layui + MySql,.Settings. . . . .,,,,,CRM,ERP,.</p>\";}', 1, 1612521657, 1637075205);
INSERT INTO `oa_config`VALUES (4, 'Api Token', 'token', 'a:5:{s:2:\"id\";s:1:\"3\";s:3:\"iss\";s:15:\"oa.gougucms.com\";s:3:\"aud\";s:7:\"gouguoa\";s:7:\"secrect\";s:7:\"GOUGUOA\";s:7:\"exptime\";s:4:\"3600\";}', 1, 1627313142, 1638010233);
INSERT INTO `oa_config`VALUES (5, 'Item', 'other', 'a:3:{s:2:\"id\";s:1:\"5\";s:6:\"author\";s:0:\"\";s:7:\"version\";s:13:\"v1.2025.06.06\";}', 1, 1613725791, 1724824410);

-- ----------------------------
-- Table structure for oa_timing_task
-- ----------------------------
CREATE TABLE `oa_timing_task`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT ',',
  `link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `types` int(2) NOT NULL DEFAULT 3 COMMENT 'Status:1,2,3',
  `desc` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_department
-- ----------------------------
CREATE TABLE `oa_department`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `leader_ids` varchar(500) NULL DEFAULT '' COMMENT 'ids',
  `phone` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_department
-- ----------------------------
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (1, 'Item', 0);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (2, 'Item', 1);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (3, 'Item', 1);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (4, 'Item', 1);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (5, 'Item', 1);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (6, 'Item', 1);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (7, 'Item', 1);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (8, 'Item', 5);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (9, 'Item', 5);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (10, 'Item', 5);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (11, 'Item', 6);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (12, 'Item', 6);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (13, 'Item', 6);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (14, 'Item', 7);
INSERT INTO `oa_department`(`id`, `title`, `pid`) VALUES (15, 'Item', 7);

-- ----------------------------
-- Table structure for oa_department_admin
-- ----------------------------
CREATE TABLE `oa_department_admin`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID',
  `department_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_talent
-- ----------------------------
CREATE TABLE `oa_talent`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Email',
  `mobile` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Mobile number',
  `sex` int(255) NOT NULL DEFAULT 0 COMMENT 'Gender: 1 male, 2 female',
  `to_did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `to_dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `thumb` varchar(255) NOT NULL COMMENT 'Avatar',
  `position_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Position id',
  `type` int(1) NOT NULL DEFAULT 0 COMMENT 'Employee type: 0 unset, 1 full-time, 2 probation, 3 intern',
  `position_name` int(11) NOT NULL DEFAULT 0 COMMENT 'Job title',
  `position_rank` int(11) NOT NULL DEFAULT 0 COMMENT 'Job rank',
  `job_number` varchar(255) NOT NULL DEFAULT '' COMMENT 'Employee number',
  `birthday` varchar(255) NOT NULL DEFAULT '' COMMENT 'Birthday',
  `pid` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `work_date` varchar(255) NOT NULL DEFAULT '' COMMENT 'Work start date',
  `work_location` int(11) NOT NULL DEFAULT 0 COMMENT 'Work location',
  `native_place` varchar(255) NOT NULL DEFAULT '' COMMENT 'Native place',
  `nation` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ethnicity',
  `home_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Home address',
  `current_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Current address',
  `contact` varchar(255) NOT NULL DEFAULT '' COMMENT 'Emergency contact',
  `contact_mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Emergency contact phone',
  `resident_type` int(1) NOT NULL DEFAULT 0 COMMENT 'Household type: 1 rural, 2 urban',
  `resident_place` varchar(255) NOT NULL DEFAULT '' COMMENT 'Household location',
  `graduate_school` varchar(255) NOT NULL DEFAULT '' COMMENT 'School',
  `graduate_day` varchar(255) NOT NULL DEFAULT 'Item',
  `political` int(1) NOT NULL DEFAULT 1 COMMENT 'Political status: 1 party member, 2 league member',
  `marital_status` int(1) NOT NULL DEFAULT 1 COMMENT 'Marital status: 1 single, 2 married, 3 divorced',
  `idcard` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID card',
  `education` varchar(255) NOT NULL DEFAULT '' COMMENT 'Degree',
  `speciality` varchar(255) NOT NULL DEFAULT '' COMMENT 'Major',
  `bank_account` varchar(255) NOT NULL DEFAULT '' COMMENT 'Bank card number',
  `social_account` varchar(255) NOT NULL DEFAULT '' COMMENT 'Social security account',
  `salary` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `salary_remark` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `reference_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `reference_rel` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `reference_mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'File attachments',
  `desc` mediumtext  NULL COMMENT 'Comment',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `entry_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `is_staff` int(1) NOT NULL DEFAULT 1 COMMENT 'Identity type:1,2',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Updated at',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `talent_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_personal_quit
-- ----------------------------
CREATE TABLE `oa_personal_quit`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `lead_admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `connect_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `connect_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `connect_uids` varchar(100) NOT NULL DEFAULT '' COMMENT ',',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'File attachments',
  `quit_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_department_change
-- ----------------------------
CREATE TABLE `oa_department_change`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID',
  `from_did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `to_did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `connect_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `connect_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `connect_uids` varchar(100) NOT NULL DEFAULT '' COMMENT ',',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'File attachments',
  `move_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_blacklist
-- ----------------------------
CREATE TABLE `oa_blacklist`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Mobile number',
  `idcard` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID card',
  `remark` text NULL COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Updated at',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_file_group
-- ----------------------------
CREATE TABLE `oa_file_group`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_file
-- ----------------------------
CREATE TABLE `oa_file`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `module` varchar(15) NOT NULL DEFAULT '' COMMENT 'Comment',
  `sha1` varchar(60) NOT NULL COMMENT 'sha1',
  `md5` varchar(60) NOT NULL COMMENT 'md5',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `filename` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `filepath` varchar(255) NOT NULL DEFAULT '' COMMENT '+',
  `filesize` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `fileext` varchar(10) NOT NULL DEFAULT '' COMMENT 'Comment',
  `mimetype` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type',
  `group_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `uploadip` varchar(15) NOT NULL DEFAULT '' COMMENT 'IP',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '01-1',
  `create_time` bigint(11) NOT NULL DEFAULT 0,
  `admin_id` int(11) NOT NULL COMMENT 'id',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `audit_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `use` varchar(255) NULL DEFAULT NULL COMMENT 'Comment',
  `download` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_file
-- ----------------------------
INSERT INTO `oa_file` VALUES (1, 'admin', '5125347886f07f48f7003825660117039eb8784f', '563e5e8f48e607ed54461796b0cb4844', 'f95982689eb222b84e999122a50b3780.jpg.jpg', 'f95982689eb222b84e999122a50b3780.jpg', 'https://blog.gougucms.com/storage/202202/f95982689eb222b84e999122a50b3780.jpg', 62609, 'jpg', 'image/jpeg', 0, 1, '127.0.0.1', 1, 1645057433, 1, 0, 1645057433, 'upload', 'thumb', 0);
INSERT INTO `oa_file` VALUES (2, 'admin', '5125347886f07f48f7003825660117039eb8784f', '563e5e8f48e607ed54461796b0cb4844', 'e729477de18e3be7e7eb4ec7fe2f821e.jpg', 'e729477de18e3be7e7eb4ec7fe2f821e.jpg', 'https://blog.gougucms.com/storage/202202/e729477de18e3be7e7eb4ec7fe2f821e.jpg', 62609, 'jpg', 'image/jpeg', 0, 1, '127.0.0.1', 1, 1645057433, 1, 0, 1645057433, 'upload', 'thumb', 0);
INSERT INTO `oa_file` VALUES (3, 'admin', '5125347886f07f48f7003825660117039eb8784f', '563e5e8f48e607ed54461796b0cb4844', '1193f7a1585b9f6e8a97ae17718018b3.jpg', 'images/1193f7a1585b9f6e8a97ae17718018b3.jpg', 'https://blog.gougucms.com/storage/202204/1193f7a1585b9f6e8a97ae17718018b3.jpg', 62609, 'jpg', 'image/jpeg', 0, 1, '127.0.0.1', 1, 1645057433, 1, 0, 1645057433, 'upload', 'thumb', 0);
INSERT INTO `oa_file` VALUES (4, 'admin', '5125347886f07f48f7003825660117039eb8784f', '563e5e8f48e607ed54461796b0cb4844', '0f22a5ba4797b2fa22049ea73e6f779c.jpg', 'images/0f22a5ba4797b2fa22049ea73e6f779c.jpg', 'https://blog.gougucms.com/storage/202202/0f22a5ba4797b2fa22049ea73e6f779c.jpg', 62609, 'jpg', 'image/jpeg', 0, 1, '127.0.0.1', 1, 1645057433, 1, 0, 1645057433, 'upload', 'thumb', 0);

-- ----------------------------
-- Table structure for oa_enterprise
-- ----------------------------
CREATE TABLE `oa_enterprise`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `city` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment',
  `bank` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment',
  `bank_sn` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment',
  `tax_num` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `phone` varchar(20) NOT NULL DEFAULT '' COMMENT 'Comment',
  `address` varchar(200) NOT NULL DEFAULT '' COMMENT 'Comment',
  `remark` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_enterprise
-- ----------------------------
INSERT INTO `oa_enterprise` VALUES (1, 'Item','Item','','','','','','', 1, 1638006751, 0);

-- ----------------------------
-- Table structure for oa_template
-- ----------------------------
CREATE TABLE `oa_template`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT ',',
  `types` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Type:1,2',
  `check_types` int(11) NOT NULL DEFAULT 0 COMMENT 'Type:0',
  `remark` varchar(500) NOT NULL DEFAULT '' COMMENT ',',
  `msg_link` varchar(255) NOT NULL DEFAULT '' COMMENT '()',
  `msg_title_0` varchar(255) NOT NULL DEFAULT '' COMMENT '()',
  `msg_content_0` varchar(500) NOT NULL DEFAULT '' COMMENT '()',
  `msg_title_1` varchar(255) NOT NULL DEFAULT '' COMMENT '()',
  `msg_content_1` varchar(500) NOT NULL DEFAULT '' COMMENT '()',
  `msg_title_2` varchar(255) NOT NULL DEFAULT '' COMMENT '()',
  `msg_content_2` varchar(500) NOT NULL DEFAULT '' COMMENT '()',
  `msg_title_3` varchar(255) NOT NULL DEFAULT '' COMMENT '()',
  `msg_content_3` varchar(500) NOT NULL DEFAULT '' COMMENT '()',
  `email_link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_template
-- ----------------------------
INSERT INTO `oa_template` VALUES (1, 'Item', 'note', 1, 0, '', '/adm/note/view/id/{action_id}', '{from_user}"",View', ':{title}.', '', '', '', '', '', '', '', 1, 1, 1733312491, 1733314809, 0);
INSERT INTO `oa_template` VALUES (2, 'Item', 'leaves', 2, 0, '', '/home/leaves/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733312616, 1733314814, 0);
INSERT INTO `oa_template` VALUES (3, 'Item', 'trips', 2, 0, '', '/home/trips/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733312725, 1733314819, 0);
INSERT INTO `oa_template` VALUES (4, 'Item', 'outs', 2, 0, '', '/home/outs/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733312801, 1733314824, 0);
INSERT INTO `oa_template` VALUES (5, 'Item', 'overtimes', 2, 0, '', '/home/overtimes/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733312801, 1733314828, 0);
INSERT INTO `oa_template` VALUES (6, 'Item', 'seal', 2, 0, '', '/adm/seal/view/id/{action_id}', '{from_user}"",', '"".', '"".', '{create_time}""{date}.', '"".', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313018, 1733314834, 0);
INSERT INTO `oa_template` VALUES (7, 'Item', 'official', 2, 0, '', '/adm/official/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313078, 1733313262, 0);
INSERT INTO `oa_template` VALUES (8, 'Item', 'expense', 2, 0, '', '/finance/expense/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313169, 1733313253, 0);
INSERT INTO `oa_template` VALUES (9, 'Item', 'invoice', 2, 0, '', '/finance/invoice/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313245, 0, 0);
INSERT INTO `oa_template` VALUES (10, 'Item', 'ticket', 2, 0, '', '/finance/ticket/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733313341, 0, 0);
INSERT INTO `oa_template` VALUES (11, 'Item', 'invoicea', 2, 0, '', '/finance/invoice/view_a/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314549, 0, 0);
INSERT INTO `oa_template` VALUES (12, 'Item', 'ticketa', 2, 0, '', '/finance/ticket/view_a/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314607, 0, 0);
INSERT INTO `oa_template` VALUES (13, 'Item', 'contract', 2, 0, '', '/contract/contract/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314701, 0, 0);
INSERT INTO `oa_template` VALUES (14, 'Item', 'purchase', 2, 0, '', '/contract/purchase/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314789, 1753284351, 0);
INSERT INTO `oa_template` VALUES (15, 'Item', 'loan', 2, 0, '', '/finance/loan/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314789, 1753284351, 0);
INSERT INTO `oa_template` VALUES (16, 'Item', 'talent', 2, 0, '', '/user/talent/view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314789, 1753284351, 0);
INSERT INTO `oa_template` VALUES (17, 'Item', 'personal_quit', 2, 0, '', '/user/personal/leave_view/id/{action_id}', '{from_user}"",', '"".', '""', '{create_time}""{date}.', '""', '{create_time}""{date}.', '{from_user}""', '{from_user}{create_time}"",View.', '', 1, 1, 1733314789, 1753284351, 0);
INSERT INTO `oa_template` VALUES (18, 'Personnel Transfer', 'personal_change', 2, 0, '', '/user/personal/change_view/id/{action_id}', '{from_user}"Personnel Transfer",', '"Personnel Transfer".', '"Personnel Transfer"', '{create_time}"Personnel Transfer"{date}.', '"Personnel Transfer"', '{create_time}"Personnel Transfer"{date}.', '{from_user}"Personnel Transfer"', '{from_user}{create_time}"Personnel Transfer",View.', '', 1, 1, 1733314789, 1753284351, 0);

-- ----------------------------
-- Table structure for oa_industry
-- ----------------------------
CREATE TABLE `oa_industry`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_industry
-- ----------------------------
INSERT INTO `oa_industry` VALUES (1, 'Item', 1, 1637987189, 0);
INSERT INTO `oa_industry` VALUES (2, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_industry` VALUES (3, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_industry` VALUES (4, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_industry` VALUES (5, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_industry` VALUES (6, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_industry` VALUES (7, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_industry` VALUES (8, 'Item', 1, 1637987199, 0);

-- ----------------------------
-- Table structure for oa_rewards_cate
-- ----------------------------
CREATE TABLE `oa_rewards_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_rewards_cate
-- ----------------------------
INSERT INTO `oa_rewards_cate` VALUES (1, 'Item', 1, 1637987189, 0);
INSERT INTO `oa_rewards_cate` VALUES (2, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_rewards_cate` VALUES (3, 'Item', 1, 1638088518, 0);
INSERT INTO `oa_rewards_cate` VALUES (4, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_rewards_cate` VALUES (5, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_rewards_cate` VALUES (6, 'Item', 1, 1637987199, 0);

-- ----------------------------
-- Table structure for oa_rewards
-- ----------------------------
CREATE TABLE `oa_rewards`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Employee ID',
  `types` int(1) NOT NULL DEFAULT 0 COMMENT 'Type:12',
  `rewards_cate` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `rewards_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `thing` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:12',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_basic_user
-- ----------------------------
CREATE TABLE `oa_basic_user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `types` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type:1Job title,2Job rank,3',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_basic_user
-- ----------------------------
INSERT INTO `oa_basic_user` VALUES (1, '2', 'Item', 1, 1733384661, 0);
INSERT INTO `oa_basic_user` VALUES (2, '2', 'Item', 1, 1733384671, 0);
INSERT INTO `oa_basic_user` VALUES (3, '2', 'Item', 1, 1733384675, 0);
INSERT INTO `oa_basic_user` VALUES (4, '1', 'Item', 1, 1733384651, 0);
INSERT INTO `oa_basic_user` VALUES (5, '1', 'Item', 1, 1733384651, 0);

-- ----------------------------
-- Table structure for oa_care_cate
-- ----------------------------
CREATE TABLE `oa_care_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_care_cate
-- ----------------------------
INSERT INTO `oa_care_cate` VALUES (1, 'Item', 1, 1637987189, 0);
INSERT INTO `oa_care_cate` VALUES (2, 'Item', 1, 1637987199, 0);
INSERT INTO `oa_care_cate` VALUES (3, 'Item', 1, 1638088518, 0);
INSERT INTO `oa_care_cate` VALUES (4, 'Item', 1, 1637987199, 0);

-- ----------------------------
-- Table structure for oa_care
-- ----------------------------
CREATE TABLE `oa_care`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Employee ID',
  `care_cate` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `care_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `vacation` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `thing` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT 'Status:12',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_flow_module
-- ----------------------------
CREATE TABLE `oa_flow_module`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT ',',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `department_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID()1,2,3',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_flow_module
-- ----------------------------
INSERT INTO `oa_flow_module` VALUES (1, 'Attendance', '', 0, '', 1, 1723277295, 0);
INSERT INTO `oa_flow_module` VALUES (2, 'Administration', '', 0, '', 1, 1723277311, 0);
INSERT INTO `oa_flow_module` VALUES (3, 'Business', '', 0, '', 1, 1723277351, 0);
INSERT INTO `oa_flow_module` VALUES (4, 'Finance', '', 0, '', 1, 1723277356, 0);
INSERT INTO `oa_flow_module` VALUES (5, 'HR', '', 0, '', 1, 1723277368, 0);
INSERT INTO `oa_flow_module` VALUES (6, 'Other', '', 0, '', 1, 1723277374, 0);

-- ----------------------------
-- Table structure for oa_flow_cate
-- ----------------------------
CREATE TABLE `oa_flow_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'TypeName',
  `name` varchar(100) NOT NULL COMMENT 'Type,',
  `module_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_table` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `department_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ID()1,2,3',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `is_copy` int(11) NOT NULL DEFAULT 1 COMMENT 'Comment',
  `is_file` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `is_export` int(11) NOT NULL DEFAULT 0 COMMENT 'PDF',
  `is_back` int(11) NOT NULL DEFAULT 1 COMMENT 'Comment',
  `is_reversed` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `form` tinyint(1) NOT NULL DEFAULT 1 COMMENT ',:1,2',
  `add_url` varchar(255) NOT NULL DEFAULT '' COMMENT ':',
  `view_url` varchar(255) NOT NULL DEFAULT '' COMMENT ':',
  `form_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id:',
  `is_list` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':0 1',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `template_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type';

-- ----------------------------
-- Records of oa_flow_cate
-- ----------------------------
INSERT INTO `oa_flow_cate` VALUES (1, 'Leave', 'leaves', 1, 'leaves', 'icon-kechengziyuanguanli', '', 0, 1, 0, 0, 1, 0, 1, '/home/leaves/add', '/home/leaves/view', 0, 1, 1, 2, 1723604674, 0);
INSERT INTO `oa_flow_cate` VALUES (2, 'Business Trip', 'trips', 1, 'trips', 'icon-jiaoshiguanli', '', 0, 1, 0, 0, 1, 0, 1, '/home/trips/add', '/home/trips/view', 0, 1, 1, 3, 1723799422, 0);
INSERT INTO `oa_flow_cate` VALUES (3, 'Field Work', 'outs', 1, 'outs', 'icon-tuiguangguanli', '', 0, 1, 0, 0, 1, 0, 1, '/home/outs/add', '/home/outs/view', 0, 1, 1, 4, 1723800336, 0);
INSERT INTO `oa_flow_cate` VALUES (4, 'Overtime', 'overtimes', 1, 'overtimes', 'icon-xueshengchengji', '', 0, 1, 0, 0, 1, 0, 1, '/home/overtimes/add', '/home/overtimes/view', 0, 1, 1, 5, 1723800393, 0);
INSERT INTO `oa_flow_cate` VALUES (5, 'Seal Usage', 'seal', 2, 'seal', 'icon-shenpishezhi', '', 0, 1, 0, 0, 1, 0, 1, '/adm/seal/add', '/adm/seal/view', 0, 1, 1, 6, 1723469451, 0);
INSERT INTO `oa_flow_cate` VALUES (6, 'Official Documents', 'official_docs', 2, 'official_docs', 'icon-lunwenguanli', '', 0, 1, 0, 0, 1, 0, 1, '/adm/official/add', '/adm/official/view', 0, 0, 1, 7, 1723469614, 0);
INSERT INTO `oa_flow_cate` VALUES (7, 'Expense', 'expense', 4, 'expense', 'icon-jizhang', '', 0, 1, 0, 0, 1, 0, 1, '/finance/expense/add', '/finance/expense/view', 0, 1, 1, 8, 1723469732, 0);
INSERT INTO `oa_flow_cate` VALUES (8, 'Invoice', 'invoice', 4, 'invoice', 'icon-duizhangdan', '', 0, 1, 0, 0, 1, 0, 1, '/finance/invoice/add', '/finance/invoice/view', 0, 1, 1, 9, 1723469814, 0);
INSERT INTO `oa_flow_cate` VALUES (9, 'Invoice Receipt', 'ticket', 4, 'ticket', 'icon-yingjiaoqingdan', '', 0, 1, 0, 0, 1, 0, 1, '/finance/ticket/add', '/finance/ticket/view', 0, 1, 1, 10, 1724749856, 0);
INSERT INTO `oa_flow_cate` VALUES (10, 'Invoice (Type A)', 'invoicea', 4, 'invoice', 'icon-shoufeipeizhi', '', 0, 1, 0, 0, 1, 0, 1, '/finance/invoice/add_a', '/finance/invoice/view_a', 0, 1, 1, 11, 1725856435, 0);
INSERT INTO `oa_flow_cate` VALUES (11, 'Invoice Receipt (Type A)', 'ticketa', 4, 'ticket', 'icon-bulujiesuan', '', 0, 1, 0, 0, 1, 0, 1, '/finance/ticket/add_a', '/finance/ticket/view_a', 0, 1, 1, 12, 1725856613, 0);
INSERT INTO `oa_flow_cate` VALUES (12, 'Sales Contract', 'contract', 3, 'contract', 'icon-hetongguanli', '', 0, 0, 0, 0, 1, 0, 1, '/contract/contract/add', '/contract/contract/view', 0, 1, 1, 13, 1723469917, 0);
INSERT INTO `oa_flow_cate` VALUES (13, 'Purchase Contract', 'purchase', 3, 'purchase', 'icon-dianshang', '', 0, 0, 0, 0, 1, 0, 1, '/contract/purchase/add', '/contract/purchase/view', 0, 1, 1, 14, 1723470017, 0);
INSERT INTO `oa_flow_cate` VALUES (14, 'Loan', 'loan', 4, 'loan', 'icon-zhangbuguanli', '', 0, 1, 0, 1, 1, 0, 1, '/finance/loan/add', '/finance/loan/view', 0, 1, 1, 15, 1723470017, 0);
INSERT INTO `oa_flow_cate` VALUES (15, 'Recruitment', 'talent', 5, 'talent', 'icon-yuangongdaoru', '', 0, 1, 0, 1, 1, 0, 1, '/user/talent/add', '/user/talent/view', 0, 1, 1, 16, 1729490152, 0);
INSERT INTO `oa_flow_cate` VALUES (16, 'Resignation', 'personal_quit', 5, 'personal_quit', 'icon-yuangongtongji2', '', 0, 1, 0, 1, 1, 0, 1, '/user/personal/leave_add', '/user/personal/leave_view', 0, 1, 1, 17, 1729490152, 0);
INSERT INTO `oa_flow_cate`VALUES (17, 'Personnel Transfer', 'personal_change', 5, 'personal_change', 'icon-yuangongbiandong', '', 0, 1, 0, 1, 1, 0, 1, '/user/personal/change_add', '/user/personal/change_view', 0, 1, 1, 18, 1729490152, 0);

-- ----------------------------
-- Table structure for oa_flow
-- ----------------------------
CREATE TABLE `oa_flow`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT 'Name',
  `cate_id` tinyint(11) NOT NULL DEFAULT 0 COMMENT 'Typeid',
  `check_type` tinyint(4) NOT NULL COMMENT '1,2,3,4',
  `department_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID(0)1,2,3',
  `copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID',
  `flow_list` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'Status 1,0',
  `remark` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `admin_id` int(11) NOT NULL COMMENT 'ID',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_flow_cate
-- ----------------------------
INSERT INTO `oa_flow` VALUES (1, 'Item', 1, 1, '', '', '', 1, '', 1, 1723791655, 0, 0);
INSERT INTO `oa_flow` VALUES (2, 'Item', 2, 1, '', '', '', 1, '', 1, 1723799665, 0, 0);
INSERT INTO `oa_flow` VALUES (3, 'Item', 3, 1, '', '', '', 1, '', 1, 1723800434, 0, 0);
INSERT INTO `oa_flow` VALUES (4, 'Item', 4, 1, '', '', '', 1, '', 1, 1723800446, 0, 0);
INSERT INTO `oa_flow` VALUES (5, 'Item', 5, 1, '', '', '', 1, '', 1, 1723470400, 0, 0);
INSERT INTO `oa_flow` VALUES (6, 'Item', 6, 1, '', '', '', 1, '', 1, 1723470419, 0, 0);
INSERT INTO `oa_flow` VALUES (7, 'Item', 7, 1, '', '', '', 1, '', 1, 1723470468, 0, 0);
INSERT INTO `oa_flow` VALUES (8, 'Item', 8, 1, '', '', '', 1, '', 1, 1723470482, 0, 0);
INSERT INTO `oa_flow` VALUES (9, 'Item', 9, 1, '', '', '', 1, '', 1, 1723470482, 0, 0);
INSERT INTO `oa_flow` VALUES (10, 'Item', 10, 1, '', '', '', 1, '', 1, 1725935073, 0, 0);
INSERT INTO `oa_flow` VALUES (11, 'Item', 11, 1, '', '', '', 1, '', 1, 1725935159, 0, 0);
INSERT INTO `oa_flow` VALUES (12, 'Item', 12, 1, '', '', '', 1, '', 1, 1723470490, 0, 0);
INSERT INTO `oa_flow` VALUES (13, 'Item', 13, 1, '', '', '', 1, '', 1, 1723470501, 0, 0);
INSERT INTO `oa_flow` VALUES (14, 'Item', 14, 1, '', '', '', 1, '', 1, 1723470501, 0, 0);
INSERT INTO `oa_flow` VALUES (15, 'Item', 15, 1, '', '', '', 1, '', 1, 1723470501, 0, 0);
INSERT INTO `oa_flow` VALUES (16, 'Item', 16, 1, '', '', '', 1, '', 1, 1723470501, 0, 0);
INSERT INTO `oa_flow` VALUES (17, 'Item', 17, 1, '', '', '', 1, '', 1, 1723470501, 0, 0);
-- ----------------------------
-- Table structure for oa_flow_step
-- ----------------------------
CREATE TABLE `oa_flow_step`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `flow_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `action_id` int(11) NOT NULL COMMENT 'ID',
  `flow_id` int(11) NOT NULL COMMENT 'id',
  `check_role` tinyint(4) NOT NULL DEFAULT 0 COMMENT ':0,1,2,3,4,5',
  `check_position_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids(1,2,3)',
  `check_types` tinyint(4) NOT NULL DEFAULT 1 COMMENT ':12',
  `sort` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'ID',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_flow_record
-- ----------------------------
CREATE TABLE `oa_flow_record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID',
  `check_table` varchar(255) NOT NULL DEFAULT 'Tables',
  `flow_id` int(11) NOT NULL COMMENT 'id',
  `step_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID',
  `check_files` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'ID',
  `check_time` bigint(11) NOT NULL COMMENT 'Comment',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3',
  `content` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_cost_cate
-- ----------------------------
CREATE TABLE `oa_cost_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'TypeName',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type';

-- ----------------------------
-- Records of oa_cost_cate
-- ----------------------------
INSERT INTO `oa_cost_cate` VALUES (1, 'Item', 1, 1639898199, 0,0);
INSERT INTO `oa_cost_cate` VALUES (2, 'Item', 1, 1639898434, 0,0);
INSERT INTO `oa_cost_cate` VALUES (3, 'Item', 1, 1639898564, 0,0);
INSERT INTO `oa_cost_cate` VALUES (4, 'Item', 1, 1639898564, 0,0);
INSERT INTO `oa_cost_cate` VALUES (5, 'Item', 1, 1639898564, 0,0);
INSERT INTO `oa_cost_cate` VALUES (6, 'Item', 1, 1639898564, 0,0);

-- ----------------------------
-- Table structure for oa_seal_cate
-- ----------------------------
CREATE TABLE `oa_seal_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `keep_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type';

INSERT INTO `oa_seal_cate` VALUES (1, 'Item', 2, 1, '', 1733385406, 0);

-- ----------------------------
-- Table structure for oa_meeting_room
-- ----------------------------
CREATE TABLE `oa_meeting_room`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `keep_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `address` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `device` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `num` int(10) NOT NULL DEFAULT 10 COMMENT 'Comment',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_meeting_records
-- ----------------------------
CREATE TABLE `oa_meeting_records`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(225) NULL DEFAULT NULL COMMENT 'Comment',
  `meeting_date` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `room_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `content` text NOT NULL COMMENT 'Comment',
  `plans` text NOT NULL COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `join_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `sign_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `share_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `anchor_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `recorder_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `remarks` text NOT NULL COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `create_time` bigint(11) NOT NULL DEFAULT 0,
  `update_time` bigint(11) NOT NULL DEFAULT 0,
  `delete_time` bigint(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_car
-- ----------------------------
CREATE TABLE `oa_car`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `oil` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `mileage` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `seats` int(11) NOT NULL DEFAULT 5 COMMENT 'Comment',
  `color` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `vin` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `engine` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `buy_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `thumb` int(11) NOT NULL DEFAULT 5 COMMENT 'Comment',
  `types` int(11) NOT NULL DEFAULT 5 COMMENT 'Type:1,2,3,4,5,6,7,8',
  `driver` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `insure_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `review_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` int(11) NOT NULL DEFAULT 1 COMMENT 'Status:1,,,',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_car_repair
-- ----------------------------
CREATE TABLE `oa_car_repair`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `types` int(1) NOT NULL DEFAULT 1 COMMENT 'Type:1,2',
  `car_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT '()',
  `content` varchar(1000) NULL DEFAULT '' COMMENT '()&',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '()',
  `handled` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `repair_time` bigint(11) NOT NULL DEFAULT 0 COMMENT '()',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = '()';

-- ----------------------------
-- Table structure for oa_car_mileage
-- ----------------------------
CREATE TABLE `oa_car_mileage`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `car_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `mileage` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `handled` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `mileage_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_car_fee
-- ----------------------------
CREATE TABLE `oa_car_fee`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `types` int(1) NOT NULL DEFAULT 1 COMMENT 'Typeid',
  `car_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `fee_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `handled` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `content` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_expense_cate
-- ----------------------------
CREATE TABLE `oa_expense_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'TypeName',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type';

-- ----------------------------
-- Records of oa_expense_cate
-- ----------------------------
INSERT INTO `oa_expense_cate` VALUES (1, 'Item', 1, 1637987189, 0,0);
INSERT INTO `oa_expense_cate` VALUES (2, 'Item', 1, 1637987199, 0,0);
INSERT INTO `oa_expense_cate` VALUES (3, 'Item', 1, 1638088518, 0,0);
INSERT INTO `oa_expense_cate` VALUES (4, 'Item', 1, 1637987199, 0,0);
INSERT INTO `oa_expense_cate` VALUES (5, 'Item', 1, 1637987199, 0,0);
INSERT INTO `oa_expense_cate` VALUES (6, 'Item', 1, 1637987199, 0,0);

-- ----------------------------
-- Table structure for oa_loan
-- ----------------------------
CREATE TABLE `oa_loan`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `subject_id` int(11)  NOT NULL DEFAULT 0 COMMENT 'Comment',
  `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `title` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `types` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'Type:1,2',
  `loan_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `plan_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `content` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `balance_cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `balance_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status 0,1,2',
  `project_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `pay_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status 0,1',
  `pay_admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `pay_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `back_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status 0,1',
  `back_admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `back_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_expense
-- ----------------------------
CREATE TABLE `oa_expense`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `subject_id` int(11)  NOT NULL DEFAULT 0 COMMENT 'Comment',
  `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `income_month` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `expense_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `loan_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `balance_cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `pay_amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `project_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `pay_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status 0,1',
  `pay_admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `pay_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_expense_interfix
-- ----------------------------
CREATE TABLE `oa_expense_interfix`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `exid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `cate_id` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT 'TypeID',
  `remarks` mediumtext  NULL COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_invoice
-- ----------------------------
CREATE TABLE `oa_invoice`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `customer_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `contract_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `project_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `open_status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Status:0 1 2',
  `open_admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `open_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delivery` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `types` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:12',
  `invoice_type` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1,2,3',
  `invoice_subject` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `invoice_title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_tax` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_phone` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_address` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_bank` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_account` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_banking` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `other_file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `enter_amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `enter_status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Status:0 1 2',
  `enter_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_invoice_income
-- ----------------------------
CREATE TABLE `oa_invoice_income`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `enter_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `remarks` mediumtext  NULL COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1 6',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_ticket
-- ----------------------------
CREATE TABLE `oa_ticket`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `supplier_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `purchase_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `customer_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `project_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `open_status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT 'Status:1 2',
  `open_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `invoice_type` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1,2,3',
  `invoice_subject` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `invoice_title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_tax` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_phone` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_address` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_bank` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_account` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `invoice_banking` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `other_file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `pay_amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `cash_type` int(11) UNSIGNED NULL DEFAULT 1 COMMENT 'Type:1,2,3,4,5,6,7,8',
  `pay_status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Status:0 1 2',
  `pay_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_ticket_payment
-- ----------------------------
CREATE TABLE `oa_ticket_payment`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticket_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `pay_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `remarks` mediumtext  NULL COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1 6',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_third_message
-- ----------------------------
CREATE TABLE `oa_third_message`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `msgtype` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type,email,weixin,mobile',
  `types` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1,2,3,4',
  `uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids',
  `dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids',
  `pids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids',
  `content` mediumtext NULL COMMENT 'Comment',
  `send_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_message
-- ----------------------------
CREATE TABLE `oa_message`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `template` varchar(100) NOT NULL DEFAULT '' COMMENT ',,',
  `content` mediumtext  NULL COMMENT 'Comment',
  `file_ids` mediumtext  NULL COMMENT 'Comment',
  `from_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id,0',
  `types` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1,2,3,4',
  `uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids',
  `dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids',
  `pids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids',
  `copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids',
  `msg_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '. id',
  `is_draft` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':1 2',
  `send_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `clear_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `action_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id()',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_msg
-- ----------------------------
CREATE TABLE `oa_msg`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `template` varchar(100) NOT NULL DEFAULT '' COMMENT ',,',
  `content` mediumtext  NULL COMMENT 'Comment',
  `file_ids` mediumtext  NULL COMMENT 'Comment',
  `from_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id,0',
  `to_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `message_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id,0',
  `msg_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '. id',
  `is_star` tinyint(1) NOT NULL DEFAULT 0 COMMENT ':1 0',
  `read_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `clear_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `action_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id()',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_note_cate
-- ----------------------------
CREATE TABLE `oa_note_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT 0 COMMENT 'ID',
  `sort` int(5) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT '1-1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_note_cate
-- ----------------------------
INSERT INTO `oa_note_cate` VALUES (1, 0, 1, 'Item',1, 1637984265, 1637984299,0);
INSERT INTO `oa_note_cate` VALUES (2, 0, 2, 'Item',1, 1637984283, 1637984310,0);

-- ----------------------------
-- Table structure for oa_note
-- ----------------------------
CREATE TABLE `oa_note`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cate_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID',
  `title` varchar(225) NULL DEFAULT NULL COMMENT 'Comment',
  `content` text NOT NULL COMMENT 'Comment',
  `src` varchar(100) NULL DEFAULT NULL COMMENT 'Comment',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT '1-1',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `role_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT ',0,1,2',
  `role_dids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `role_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Start time',
  `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'End time',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `create_time` bigint(11) NOT NULL DEFAULT 0,
  `update_time` bigint(11) NOT NULL DEFAULT 0,
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_note
-- ----------------------------
INSERT INTO `oa_note` VALUES (1, 1, 'OA', '<p>OA,.Settings. . . . . . . . . .,,,,,CRM,ERP,.</p>', 'https://oa.gougucms.com', 1, 2,'',1,'','', 1635696000, 1924876800,1, 1637984962, 1637984975,0);
INSERT INTO `oa_note` VALUES (2, 1, 'OA', '<p>OA,.Settings. . . . . . . . . .</p><p>OA,,,,.</p><p>“hdm588â€,. .</p>', 'https://oa.gougucms.com', 1, 2,'',1,'','', 1635696000, 1924876800,1, 1637984962, 1637984975,0);
INSERT INTO `oa_note` VALUES (3, 1, 'DEV', '<p>DEVIT,. ,.</p><p>:https://www.gougucms.com/home/pages/detail/s/gougudev.html</p><p>:https://gitee.com/gouguopen/dev</p><p>DEV,,,,.</p><p>“hdm588â€,. .</p>', 'https://dev.gougucms.com', 1, 2,'',1,'','', 1635696000, 1924876800,1, 1637984962, 1637984975,0);

-- ----------------------------
-- Table structure for oa_position
-- ----------------------------
CREATE TABLE `oa_position`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `work_price` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `remark` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_position
-- ----------------------------
INSERT INTO `oa_position` VALUES (1, 'Item', 1000, ',', 1, 0, 0);
INSERT INTO `oa_position` VALUES (2, 'Item', 1000, 'Item', 1, 0, 0);
INSERT INTO `oa_position` VALUES (3, 'Item', 500, 'Item', 1, 0, 0);

-- ----------------------------
-- Table structure for oa_position_group
-- ----------------------------
CREATE TABLE `oa_position_group`  (
  `pid` int(11) UNSIGNED NULL DEFAULT NULL COMMENT 'id',
  `group_id` int(11) NULL DEFAULT NULL COMMENT 'id',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  UNIQUE INDEX `pid_group_id`(`pid`, `group_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_position_group
-- ----------------------------
INSERT INTO `oa_position_group` VALUES (1, 1, 1635755739, 0);
INSERT INTO `oa_position_group` VALUES (2, 2, 1638007427, 0);
INSERT INTO `oa_position_group` VALUES (3, 3, 1638007427, 0);

-- ----------------------------
-- Table structure for oa_plan
-- ----------------------------
CREATE TABLE `oa_plan`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `type` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':TypeID',
  `cmid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID',
  `ptid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Start time',
  `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'End time',
  `remind_type` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Type',
  `remind_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `remark` text NOT NULL COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_schedule
-- ----------------------------
CREATE TABLE `oa_schedule`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `cid` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT ':TypeID',
  `cmid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID',
  `ptid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID',
  `tid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT ':ID',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Employee ID',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Start time',
  `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'End time',
  `labor_time` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `labor_type` int(1) NOT NULL DEFAULT 0 COMMENT 'Type:12',
  `remark` text NOT NULL COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_approve
-- ----------------------------
CREATE TABLE `oa_approve`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `content` text NOT NULL COMMENT '//',
  `types` varchar(255) NOT NULL DEFAULT '' COMMENT 'Type',  
  `str_1` varchar(255) NOT NULL DEFAULT '' COMMENT '1',
  `str_2` varchar(255) NOT NULL DEFAULT '' COMMENT '2',
  `str_3` varchar(255) NOT NULL DEFAULT '' COMMENT '3',
  `str_4` varchar(255) NOT NULL DEFAULT '' COMMENT '4',
  `str_5` varchar(255) NOT NULL DEFAULT '' COMMENT '5',
  `str_6` varchar(255) NOT NULL DEFAULT '' COMMENT '6',
  `str_7` varchar(255) NOT NULL DEFAULT '' COMMENT '7',
  `str_8` varchar(255) NOT NULL DEFAULT '' COMMENT '8',
  `str_9` varchar(255) NOT NULL DEFAULT '' COMMENT '9',
  `str_10` varchar(255) NOT NULL DEFAULT '' COMMENT '10',
  `str_11` varchar(255) NOT NULL DEFAULT '' COMMENT '11',
  `str_12` varchar(255) NOT NULL DEFAULT '' COMMENT '12',
  `str_13` varchar(255) NOT NULL DEFAULT '' COMMENT '13',
  `str_14` varchar(255) NOT NULL DEFAULT '' COMMENT '14',
  `str_15` varchar(255) NOT NULL DEFAULT '' COMMENT '15',
  `str_16` varchar(255) NOT NULL DEFAULT '' COMMENT '16',
  `int_1` int(11) NOT NULL DEFAULT 0 COMMENT '1',
  `int_2` int(11) NOT NULL DEFAULT 0 COMMENT '2',
  `int_3` int(11) NOT NULL DEFAULT 0 COMMENT '3',
  `int_4` int(11) NOT NULL DEFAULT 0 COMMENT '4',
  `int_5` int(11) NOT NULL DEFAULT 0 COMMENT '5',
  `int_6` int(11) NOT NULL DEFAULT 0 COMMENT '6',
  `int_7` int(11) NOT NULL DEFAULT 0 COMMENT '7',
  `int_8` int(11) NOT NULL DEFAULT 0 COMMENT '8',
  `int_9` int(11) NOT NULL DEFAULT 0 COMMENT '9',
  `int_10` int(11) NOT NULL DEFAULT 0 COMMENT '10',
  `float_1` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '1(2)',
  `float_2` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '2(2)',
  `float_3` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '3(2)',
  `float_4` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '4(2)',
  `float_5` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '5(2)',
  `float_6` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '6(2)',
  `float_7` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '7(2)',
  `float_8` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '8(2)',
  `float_9` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '9(2)',
  `float_10` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '10(2)',  
  `time_1` bigint(11) NOT NULL DEFAULT 0 COMMENT '1',
  `time_2` bigint(11) NOT NULL DEFAULT 0 COMMENT '2',
  `time_3` bigint(11) NOT NULL DEFAULT 0 COMMENT '3',
  `time_4` bigint(11) NOT NULL DEFAULT 0 COMMENT '4',
  `time_5` bigint(11) NOT NULL DEFAULT 0 COMMENT '5',
  `time_6` bigint(11) NOT NULL DEFAULT 0 COMMENT '6',
  `time_7` bigint(11) NOT NULL DEFAULT 0 COMMENT '7',
  `time_8` bigint(11) NOT NULL DEFAULT 0 COMMENT '8',
  `time_9` bigint(11) NOT NULL DEFAULT 0 COMMENT '9',
  `time_10` bigint(11) NOT NULL DEFAULT 0 COMMENT '10',
  `file_1` varchar(500) NOT NULL DEFAULT '' COMMENT '1,:1,2,3',
  `file_2` varchar(500) NOT NULL DEFAULT '' COMMENT '2,:1,2,3',
  `file_3` varchar(500) NOT NULL DEFAULT '' COMMENT '3,:1,2,3',
  `file_4` varchar(500) NOT NULL DEFAULT '' COMMENT '4,:1,2,3',
  `file_5` varchar(500) NOT NULL DEFAULT '' COMMENT '5,:1,2,3',
  `file_6` varchar(500) NOT NULL DEFAULT '' COMMENT '6,:1,2,3',
  `text_1` text NOT NULL COMMENT '1',
  `text_2` text NOT NULL COMMENT '2',
  `text_3` text NOT NULL COMMENT '3',
  `text_4` text NOT NULL COMMENT '4',
  `text_5` text NOT NULL COMMENT '5',
  `text_6` text NOT NULL COMMENT '6',  
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
  `did` int(11) NOT NULL DEFAULT '0' COMMENT 'ID',
  `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_attendance
-- ----------------------------
CREATE TABLE `oa_attendance`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL COMMENT 'Employee ID',
  `did` int(11) NOT NULL COMMENT 'ID',
  `day_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `time_in_1` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `time_in_2` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `time_out_1` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `time_out_2` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `late_min` int(10) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `leave_min` int(10) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_leaves
-- ----------------------------
CREATE TABLE `oa_leaves`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `types` int(2) NOT NULL DEFAULT '0' COMMENT 'Type:1,2,3,4,5,6,7,8,9',
  `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `start_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2',
  `end_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2',
  `duration` decimal(10, 1) NOT NULL DEFAULT 0.0 COMMENT '()',
  `reason` text NOT NULL COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(11) NOT NULL COMMENT 'ID',
  `did` int(11) NOT NULL COMMENT 'ID',
  `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_trips
-- ----------------------------
CREATE TABLE `oa_trips`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `start_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2',
  `end_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2',
  `duration` decimal(10, 1) NOT NULL DEFAULT 0.0 COMMENT '()',
  `reason` text NOT NULL COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(11) NOT NULL COMMENT 'ID',
  `did` int(11) NOT NULL COMMENT 'ID',
  `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_outs
-- ----------------------------
CREATE TABLE `oa_outs`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `start_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2',
  `end_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2',
  `duration` decimal(10, 1) NOT NULL DEFAULT 0.0 COMMENT '()',
  `reason` text NOT NULL COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(11) NOT NULL COMMENT 'ID',
  `did` int(11) NOT NULL COMMENT 'ID',
  `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_overtimes
-- ----------------------------
CREATE TABLE `oa_overtimes`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `start_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2',
  `end_span` int(10) NOT NULL DEFAULT '0' COMMENT ':1,2',
  `duration` decimal(10, 1) NOT NULL DEFAULT 0.0 COMMENT '()',
  `reason` text NOT NULL COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(11) NOT NULL COMMENT 'ID',
  `did` int(11) NOT NULL COMMENT 'ID',
  `create_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_work
-- ----------------------------
CREATE TABLE `oa_work`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `types` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT 'Type:1 2 3',
  `start_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `end_date` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Comment',
  `to_uids` mediumtext  NULL COMMENT 'ID',
  `works` mediumtext  NULL COMMENT 'Comment',
  `plans` mediumtext  NULL COMMENT 'Comment',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `send_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_work_record
-- ----------------------------
CREATE TABLE `oa_work_record`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `work_id` int(11) UNSIGNED NOT NULL COMMENT 'id',
  `from_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `to_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `send_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `read_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT '0' COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_customer_grade
-- ----------------------------
CREATE TABLE `oa_customer_grade`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `sort` int(01) NOT NULL DEFAULT 0 COMMENT ',',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status: 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_customer_grade
-- ----------------------------
INSERT INTO `oa_customer_grade` VALUES (1, 'Item',0, 1, 1637987189, 0, 0);
INSERT INTO `oa_customer_grade` VALUES (2, 'VIP',0, 1, 1637987199, 0, 0);

-- ----------------------------
-- Table structure for oa_customer_source
-- ----------------------------
CREATE TABLE `oa_customer_source`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `sort` int(01) NOT NULL DEFAULT 0 COMMENT ',',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_customer_source
-- ----------------------------
INSERT INTO `oa_customer_source` VALUES (1, 'Item',0, 1, 1637987189, 0, 0);
INSERT INTO `oa_customer_source` VALUES (2, 'Item',0, 1, 1637987199, 0, 0);
INSERT INTO `oa_customer_source` VALUES (3, 'Item',0, 1, 1637987199, 0, 0);
INSERT INTO `oa_customer_source` VALUES (4, 'Item',0, 1, 1637987199, 0, 0);
INSERT INTO `oa_customer_source` VALUES (5, 'Item',0, 1, 1637987199, 0, 0);
INSERT INTO `oa_customer_source` VALUES (6, 'Item',0, 1, 1637987199, 0, 0);
INSERT INTO `oa_customer_source` VALUES (7, 'Item',0, 1, 1637987199, 0, 0);
INSERT INTO `oa_customer_source` VALUES (8, 'Item',0, 1, 1637987199, 0, 0);

-- ----------------------------
-- Table structure for oa_basic_customer
-- ----------------------------
CREATE TABLE `oa_basic_customer`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `types` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type:1Status,2,3,4,5',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_basic_customer
-- ----------------------------
INSERT INTO `oa_basic_customer` VALUES (1, '1', 'Item', 1, 1732606239, 0);
INSERT INTO `oa_basic_customer` VALUES (2, '1', 'Item', 1, 1732606269, 0);
INSERT INTO `oa_basic_customer` VALUES (3, '1', 'Item', 1, 1732606279, 0);
INSERT INTO `oa_basic_customer` VALUES (4, '1', 'Item', 1, 1732606303, 0);
INSERT INTO `oa_basic_customer` VALUES (5, '1', 'Item', 1, 1732606311, 0);
INSERT INTO `oa_basic_customer` VALUES (6, '2', 'Item', 1, 1732606331, 0);
INSERT INTO `oa_basic_customer` VALUES (7, '2', 'Item', 1, 1732606346, 0);
INSERT INTO `oa_basic_customer` VALUES (8, '2', 'Item', 1, 1732606354, 0);
INSERT INTO `oa_basic_customer` VALUES (9, '3', 'Item', 1, 1732606405, 0);
INSERT INTO `oa_basic_customer` VALUES (10, '3', 'Item', 1, 1732606409, 0);
INSERT INTO `oa_basic_customer` VALUES (11, '3', 'Item', 1, 1732606413, 0);
INSERT INTO `oa_basic_customer` VALUES (12, '3', 'Item', 1, 1732606418, 0);
INSERT INTO `oa_basic_customer` VALUES (13, '4', 'Item', 1, 1732606467, 0);
INSERT INTO `oa_basic_customer` VALUES (14, '4', 'Item', 1, 1732606475, 0);
INSERT INTO `oa_basic_customer` VALUES (15, '4', 'Item', 1, 1732606483, 0);
INSERT INTO `oa_basic_customer` VALUES (16, '4', 'Item', 1, 1732606490, 0);
INSERT INTO `oa_basic_customer` VALUES (17, '4', 'Item', 1, 1732606499, 0);
INSERT INTO `oa_basic_customer` VALUES (18, '4', 'Item', 1, 1732606506, 0);
INSERT INTO `oa_basic_customer` VALUES (19, '4', 'Item', 1, 1732607018, 0);

-- ----------------------------
-- Table structure for oa_customer
-- ----------------------------
CREATE TABLE `oa_customer`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `source_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `grade_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `industry_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `services_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `provinceid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `cityid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `distid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `townid` bigint(20) NOT NULL DEFAULT 0 COMMENT 'id',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `customer_status` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Status:0',
  `intent_status` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Status:0',
  `contact_first` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `belong_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `belong_did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `belong_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `distribute_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `follow_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `next_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `discard_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `share_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `content` mediumtext  NULL COMMENT 'Comment',
  `market` mediumtext  NULL COMMENT 'Comment',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `tax_bank` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `tax_banksn` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `tax_num` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `tax_mobile` varchar(20) NOT NULL DEFAULT '' COMMENT 'Comment',
  `tax_address` varchar(200) NOT NULL DEFAULT '' COMMENT 'Comment',
  `is_lock` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Status:0,1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_customer_trace
-- ----------------------------
CREATE TABLE `oa_customer_trace`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `contact_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `chance_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `types` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `stage` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `content` mediumtext NULL COMMENT 'Comment',
  `follow_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `next_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_customer_contact
-- ----------------------------
CREATE TABLE `oa_customer_contact`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `is_default` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Gender:0,1,2',
  `mobile` char(20) NOT NULL DEFAULT '' COMMENT 'Mobile number',
  `qq` char(20) NOT NULL DEFAULT '' COMMENT 'QQ',
  `wechat` char(20) NOT NULL DEFAULT '' COMMENT 'Comment',
  `email` char(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `department` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `position` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `birthday` varchar(50) NOT NULL DEFAULT '' COMMENT 'Birthday',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `family` mediumtext NULL COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_customer_chance
-- ----------------------------
CREATE TABLE `oa_customer_chance`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `contact_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `services_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `stage` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `content` mediumtext  NULL COMMENT 'Comment',
  `discovery_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `expected_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `expected_amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `belong_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `assist_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_customer_file
-- ----------------------------
CREATE TABLE `oa_customer_file`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) UNSIGNED NOT NULL COMMENT 'id',
  `file_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_property_cate
-- ----------------------------
CREATE TABLE `oa_property_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_property_cate
-- ----------------------------
INSERT INTO `oa_property_cate` VALUES (1, 'Item', 0, 0, '', 1, 0, 1733384708, 1733385234);
INSERT INTO `oa_property_cate` VALUES (2, 'Item', 0, 0, '', 1, 0, 1733385274, 0);

-- ----------------------------
-- Table structure for oa_property_unit
-- ----------------------------
CREATE TABLE `oa_property_unit`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_property_unit
-- ----------------------------
INSERT INTO `oa_property_unit` VALUES (1, 'Item', 0, '', 1, 1733385300, 0);
INSERT INTO `oa_property_unit` VALUES (2, 'Item', 0, '', 1, 1733385307, 0);
INSERT INTO `oa_property_unit` VALUES (3, 'Item', 0, '', 1, 1733385313, 0);
INSERT INTO `oa_property_unit` VALUES (4, 'Item', 0, '', 1, 1733385321, 0);
INSERT INTO `oa_property_unit` VALUES (5, 'Item', 0, '', 1, 1733385328, 0);
INSERT INTO `oa_property_unit` VALUES (6, 'Item', 0, '', 1, 1733385333, 0);

-- ----------------------------
-- Table structure for oa_property_brand
-- ----------------------------
CREATE TABLE `oa_property_brand`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';
-- ----------------------------
-- Records of oa_property_brand
-- ----------------------------
INSERT INTO `oa_property_brand` VALUES (1, 'Item', 0, '', 1, 1733385289, 0);
INSERT INTO `oa_property_brand` VALUES (2, 'Item', 0, '', 1, 1733385289, 0);

-- ----------------------------
-- Table structure for oa_property
-- ----------------------------
CREATE TABLE `oa_property`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `thumb` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `brand_id`int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Name',
  `unit_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `quality_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `buy_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `rate` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `model` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `user_dids` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `user_ids`  varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `content` mediumtext  NULL COMMENT 'Comment',
  `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3',
  `source` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':1,2,3,4',
  `purchase_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0,1,2,3,4',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_property_repair
-- ----------------------------
CREATE TABLE `oa_property_repair`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `property_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `repair_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `content` mediumtext  NULL COMMENT 'Comment',
  `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3',
  `director_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_basic_adm
-- ----------------------------
CREATE TABLE `oa_basic_adm`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `types` varchar(100) NOT NULL DEFAULT '' COMMENT 'Type:1Type,2',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_cost_cate
-- ----------------------------
INSERT INTO `oa_basic_adm` VALUES (1, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (2, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (3, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (4, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (5, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (6, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (7, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (8, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (9, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (10, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (11, '1', 'Item', 1, 1706840194, 0);
INSERT INTO `oa_basic_adm` VALUES (12, '1', 'Item', 1, 1706840194, 0);

-- ----------------------------
-- Table structure for oa_official_docs
-- ----------------------------
CREATE TABLE `oa_official_docs`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `code` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `secrets` int(2) NOT NULL DEFAULT 1 COMMENT ':1,2,3',
  `urgency` int(2) NOT NULL DEFAULT 1 COMMENT ':1,2,3',
  `send_uids` varchar(255) NOT NULL DEFAULT '' COMMENT 'uid',
  `copy_uids` varchar(255) NOT NULL DEFAULT '' COMMENT 'uid',
  `share_uids` varchar(255) NOT NULL DEFAULT '' COMMENT 'uid',
  `content` mediumtext NULL COMMENT 'Comment',
  `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3',
  `draft_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `draft_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_seal
-- ----------------------------
CREATE TABLE `oa_seal`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `seal_cate_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Type', 
  `content` mediumtext NULL COMMENT 'Comment',
  `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3',
  `did` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `num` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `use_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `is_borrow` int(1) NOT NULL DEFAULT 0 COMMENT ':0,1',
  `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1(),2',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_news
-- ----------------------------
CREATE TABLE `oa_news`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(225) NULL DEFAULT NULL COMMENT 'Comment',
  `content` text NOT NULL COMMENT 'Comment',
  `src` varchar(100) NULL DEFAULT NULL COMMENT 'Comment',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `create_time` bigint(11) NOT NULL DEFAULT 0,
  `update_time` bigint(11) NOT NULL DEFAULT 0,
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';


-- ----------------------------
-- Table structure for oa_product_cate
-- ----------------------------
CREATE TABLE `oa_product_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_product_cate
-- ----------------------------
INSERT INTO `oa_product_cate` VALUES (1, 'Item', 0, 0, '', 1, 0, 1733385454, 0);
INSERT INTO `oa_product_cate` VALUES (2, 'Item', 0, 0, '', 1, 0, 1733385467, 0);

-- ----------------------------
-- Table structure for oa_product
-- ----------------------------
CREATE TABLE `oa_product`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `thumb` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `barcode` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `unit` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `specs` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `brand` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `producer` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `base_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `purchase_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `sale_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `content` text NULL COMMENT 'Comment',
  `album_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3',
  `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3',
  `stock` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `is_object` tinyint(1) NOT NULL DEFAULT 1 COMMENT ',12',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_services
-- ----------------------------
CREATE TABLE `oa_services`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `content` text NULL COMMENT 'Comment',
  `sort` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_services
-- ----------------------------
INSERT INTO `oa_services` VALUES (1, 'Item', 0, 999.00, NULL, 0, 1, 1733385487, 1733385493, 0);
INSERT INTO `oa_services` VALUES (2, 'Item', 0, 99.00, NULL, 0, 1, 1733385500, 0, 0);

-- ----------------------------
-- Table structure for oa_supplier
-- ----------------------------
CREATE TABLE `oa_supplier`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `phone` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3',
  `products` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `content` text NULL COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0,1',
  `tax_num` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `tax_mobile` varchar(20) NOT NULL DEFAULT '' COMMENT 'Comment',
  `tax_address` varchar(200) NOT NULL DEFAULT '' COMMENT 'Comment',
  `tax_bank` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment',
  `tax_banksn` varchar(60) NOT NULL DEFAULT '' COMMENT 'Comment',
  `file_license_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `file_idcard_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID card,:1,2,3',
  `file_bankcard_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `file_openbank_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Bank,:1,2,3',
  `tax_rate` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `sort` int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_supplier_contact
-- ----------------------------
CREATE TABLE `oa_supplier_contact`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `is_default` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Gender:0,1,2',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT 'Mobile number',
  `qq` varchar(20) NOT NULL DEFAULT '' COMMENT 'QQ',
  `wechat` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `email` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `department` varchar(50) NOT NULL DEFAULT '' COMMENT 'Comment',
  `position` varchar(50) NOT NULL DEFAULT '' COMMENT 'Job title',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_purchased_cate
-- ----------------------------
CREATE TABLE `oa_purchased_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `desc` varchar(1000) NULL DEFAULT '' COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_purchased_cate
-- ----------------------------
INSERT INTO `oa_purchased_cate` VALUES (1, 'Item', 0, 0, '', 1, 0, 1733385535, 0);
INSERT INTO `oa_purchased_cate` VALUES (2, 'Item', 0, 0, '', 1, 0, 1733385542, 0);

-- ----------------------------
-- Table structure for oa_purchased
-- ----------------------------
CREATE TABLE `oa_purchased`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `thumb` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `barcode` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `unit` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `specs` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `brand` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `producer` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `purchase_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `sale_price` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `content` text NULL COMMENT 'Comment',
  `album_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3',
  `file_ids` varchar(255) NOT NULL DEFAULT '' COMMENT 'ids,:1,2,3',
  `stock` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `is_object` tinyint(1) NOT NULL DEFAULT 1 COMMENT ',12',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';


-- ----------------------------
-- Table structure for oa_contract_cate
-- ----------------------------
CREATE TABLE `oa_contract_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Nickname',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_contract_cate
-- ----------------------------
INSERT INTO `oa_contract_cate` VALUES (1, 'Item', 1, 1637987189, 0,0);
INSERT INTO `oa_contract_cate` VALUES (2, 'Item', 1, 1637987199, 0,0);

-- ----------------------------
-- Table structure for oa_contract
-- ----------------------------
CREATE TABLE `oa_contract`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `cate_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `types` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':123',
  `subject_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `customer_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID,',
  `customer` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `contact_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `contact_mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `contact_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `start_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Start time',
  `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `prepared_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `sign_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `keeper_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', 
  `share_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `sign_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `content` mediumtext  NULL COMMENT 'Comment',
  `is_tax` tinyint(1) NOT NULL DEFAULT 0 COMMENT ':0,1',
  `tax` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `stop_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `stop_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `stop_remark` mediumtext  NULL COMMENT 'Comment',
  `void_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `void_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `void_remark` mediumtext  NULL COMMENT 'Comment',
  `archive_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `archive_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_purchase
-- ----------------------------
CREATE TABLE `oa_purchase`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `cate_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `types` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':123',
  `subject_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `supplier_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `supplier` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `contact_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `contact_mobile` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `contact_address` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `start_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Start time',
  `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `prepared_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `sign_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `keeper_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment', 
  `share_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `sign_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `cost` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `content` mediumtext  NULL COMMENT 'Comment',
  `stop_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `stop_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `stop_remark` mediumtext  NULL COMMENT 'Comment',
  `void_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `void_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `void_remark` mediumtext  NULL COMMENT 'Comment',
  `archive_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `archive_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `remark` mediumtext  NULL COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Status:0,1,2,3,4',
  `check_flow_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id',
  `check_step_sort` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `check_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_last_uid` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `check_history_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_copy_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID,:1,2,3',
  `check_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_step
-- ----------------------------
CREATE TABLE `oa_step`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `sort` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_step
-- ----------------------------
INSERT INTO `oa_step` VALUES (1, 'Item', 0,1, 1637987189, 0,0);
INSERT INTO `oa_step` VALUES (2, 'Item', 0,1, 1637987189, 0,0);
INSERT INTO `oa_step` VALUES (3, 'Item', 0,1, 1637987189, 0,0);
INSERT INTO `oa_step` VALUES (4, 'Item', 0,1, 1637987189, 0,0);
INSERT INTO `oa_step` VALUES (5, 'Item', 0,1, 1637987189, 0,0);

-- ----------------------------
-- Table structure for oa_work_cate
-- ----------------------------
CREATE TABLE `oa_work_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'TypeName',
  `sort` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type';

-- ----------------------------
-- Records of oa_work_cate
-- ----------------------------
INSERT INTO `oa_work_cate` VALUES (1, 'Item', 0,1, 1637987189, 0);
INSERT INTO `oa_work_cate` VALUES (2, 'Item',0, 1, 1637987199, 0);
INSERT INTO `oa_work_cate` VALUES (3, 'Item',0, 1, 1637987199, 0);
INSERT INTO `oa_work_cate` VALUES (4, 'Item',0, 1, 1637987199, 0);
INSERT INTO `oa_work_cate` VALUES (5, 'Item',0, 1, 1637987199, 0);
INSERT INTO `oa_work_cate` VALUES (6, 'Item',0, 1, 1637987199, 0);
INSERT INTO `oa_work_cate` VALUES (7, 'Item',0, 1, 1637987199, 0);
INSERT INTO `oa_work_cate` VALUES (8, 'Item',0, 1, 1637987199, 0);

-- ----------------------------
-- Table structure for oa_project_cate
-- ----------------------------
CREATE TABLE `oa_project_cate`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Nickname',
  `sort` int(10) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_work_cate
-- ----------------------------
INSERT INTO `oa_project_cate` VALUES (1, 'Item', 0, 1, 1733385561, 0, 0);
INSERT INTO `oa_project_cate` VALUES (2, 'Item', 0, 1, 1733385567, 0, 0);

-- ----------------------------
-- Table structure for oa_project
-- ----------------------------
CREATE TABLE `oa_project`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `code` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `cate_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `customer_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `contract_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `director_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `start_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Start time',
  `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:0,1,2,3,4',
  `content` mediumtext  NULL COMMENT 'Comment',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_project_step
-- ----------------------------
CREATE TABLE `oa_project_step`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL COMMENT 'ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `director_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'ID',
  `uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ID () 1,2,3',
  `sort` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'ID',
  `is_current` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `start_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Start time',
  `end_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'End time',
  `remark` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_project_step_record
-- ----------------------------
CREATE TABLE `oa_project_step_record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID',
  `step_id` int(11) NOT NULL DEFAULT 0 COMMENT 'ID',
  `check_uid` int(11) NOT NULL DEFAULT 0 COMMENT 'ID',
  `check_time` bigint(11) NOT NULL COMMENT 'Comment',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '123',
  `content` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_project_user
-- ----------------------------
CREATE TABLE `oa_project_user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `project_id` int(11) UNSIGNED NOT NULL COMMENT 'id',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_project_task
-- ----------------------------
CREATE TABLE `oa_project_task`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `before_task` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `project_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `work_id` int(1) NOT NULL DEFAULT 0 COMMENT 'Type',
  `step_id` int(1) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `plan_hours` decimal(10, 1) NOT NULL DEFAULT 0.00 COMMENT 'Comment',
  `end_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time',
  `over_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'End time',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `director_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '()',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `assist_admin_ids` varchar(500) NOT NULL DEFAULT '' COMMENT ',:1,2,3',
  `priority` tinyint(1) NOT NULL DEFAULT 1 COMMENT ':1,2,3,4',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:1,2,3,4,5',
  `done_ratio` int(2) NOT NULL DEFAULT 0 COMMENT ':0,20,40,50,60,80',
  `content` mediumtext  NULL COMMENT 'Comment',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_project_document
-- ----------------------------
CREATE TABLE `oa_project_document`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `project_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'ids',
  `content` mediumtext  NULL COMMENT 'Comment',
  `md_content` mediumtext  NULL COMMENT 'markdown',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_project_file
-- ----------------------------
CREATE TABLE `oa_project_file`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `module` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `topic_id` int(11) UNSIGNED NOT NULL COMMENT 'id',
  `file_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_disk
-- ----------------------------
CREATE TABLE `oa_disk`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `did` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `types` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Type:0,1,2',
  `action_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `group_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `name` varchar(200) NOT NULL DEFAULT '' COMMENT 'Name',
  `file_ext` varchar(200) NOT NULL DEFAULT '' COMMENT 'Name',
  `file_size` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `is_star` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  `clear_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_disk_group
-- ----------------------------
CREATE TABLE `oa_disk_group`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name',
  `admin_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `director_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `group_uids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_disk_group
-- ----------------------------
INSERT INTO `oa_disk_group` VALUES (1000, 'Item', 1, '', '', 1749030795, 1749031338, 0);
INSERT INTO `oa_disk_group` VALUES (1001, 'Item', 1, '', '', 1749030795, 1749031338, 0);
INSERT INTO `oa_disk_group` VALUES (1002, 'Item', 1, '', '', 1749030795, 1749031338, 0);
INSERT INTO `oa_disk_group` VALUES (1003, 'Item', 1, '', '', 1749030795, 1749031338, 0);


-- ----------------------------
-- Table structure for oa_article
-- ----------------------------
CREATE TABLE `oa_article`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `origin_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `file_ids` varchar(500) NOT NULL DEFAULT '' COMMENT 'Comment',
  `content` text NOT NULL COMMENT 'Comment',
  `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0,
  `update_time` bigint(11) NOT NULL DEFAULT 0,
  `delete_time` bigint(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_edit_log
-- ----------------------------
CREATE TABLE `oa_edit_log`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `field` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `action_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `second_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `old_content` mediumtext  NULL COMMENT 'Comment',
  `new_content` mediumtext  NULL COMMENT 'Comment',
  `create_time` bigint(11) NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_comment
-- ----------------------------
CREATE TABLE `oa_comment`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `module` varchar(100) NOT NULL DEFAULT '' COMMENT 'Comment',
  `topic_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `to_uids` varchar(100) NOT NULL DEFAULT '' COMMENT '@id',
  `content` mediumtext  NULL COMMENT 'Comment',
  `md_content` mediumtext  NULL COMMENT 'markdown',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Table structure for oa_comment_read
-- ----------------------------
CREATE TABLE `oa_comment_read`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `comment_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'id',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000 CHARACTER SET = utf8mb4 COMMENT = 'Comment';


-- ----------------------------
-- Table structure for oa_mobile_bar
-- ----------------------------
CREATE TABLE `oa_mobile_bar`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Bar';

-- ----------------------------
-- Records of oa_mobile_bar
-- ----------------------------
INSERT INTO `oa_mobile_bar` VALUES (1, 'Item', 'icon-gongzuotai1', '/qiye/index/index', 0, 1, 1723277311, 1733147213);
INSERT INTO `oa_mobile_bar` VALUES (2, 'Item', 'icon-kehu', '/qiye/customer/index', 0, 1, 1723277311, 1733147238);
INSERT INTO `oa_mobile_bar` VALUES (3, 'Item', 'icon-hetong2', '/qiye/contract/index', 0, 1, 1723277351, 1733147266);
INSERT INTO `oa_mobile_bar` VALUES (4, 'Item', 'icon-xiangmu1', '/qiye/project/index', 0, 1, 1723277356, 1733147298);
INSERT INTO `oa_mobile_bar` VALUES (5, 'Item', 'icon-xiaoxi1', '/qiye/msg/index', 0, 1, 1723277368, 1733147331);

-- ----------------------------
-- Table structure for oa_mobile_types
-- ----------------------------
CREATE TABLE `oa_mobile_types`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `bgcolor` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Type';

-- ----------------------------
-- Records of oa_mobile_types
-- ----------------------------
INSERT INTO `oa_mobile_types` VALUES (1, 'Item', '', 'blue', 0, 1, 1723277311, 0);
INSERT INTO `oa_mobile_types` VALUES (2, 'Item', '', 'green', 0, 1, 1723277311, 0);
INSERT INTO `oa_mobile_types` VALUES (3, 'Item', '', 'yellow', 0, 1, 1723277351, 0);
INSERT INTO `oa_mobile_types` VALUES (4, 'Item', '', 'purple', 0, 1, 1723277356, 0);

-- ----------------------------
-- Table structure for oa_mobile_menu
-- ----------------------------
CREATE TABLE `oa_mobile_menu`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `bgcolor` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Comment',
  `types` int(11) NOT NULL DEFAULT 0 COMMENT 'Type',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT ':',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Status:-1 0 1',
  `create_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `update_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Comment',
  `delete_time` bigint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Deleted at',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = 'Comment';

-- ----------------------------
-- Records of oa_mobile_menu
-- ----------------------------
INSERT INTO `oa_mobile_menu` VALUES (1, 'Item', 'icon-shenpi','blue', '/qiye/approve/apply', 1, 0, 1, 1733146294, 1733152760, 0);
INSERT INTO `oa_mobile_menu` VALUES (2, 'Item', 'icon-wodeshenpi1','blue', '/qiye/approve/mylist', 1, 0, 1, 1733152749, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (3, 'Item', 'icon-chulishenpi','blue', '/qiye/approve/checklist', 1, 0, 1, 1733152798, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (4, 'Item', 'icon-chaosong','blue', '/qiye/approve/copylist', 1, 0, 1, 1733152823, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (5, 'Item', 'icon-richeng','green', '/qiye/index/calendar', 2, 0, 1, 1733152855, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (6, 'Item', 'icon-jilu','green', '/qiye/index/schedule', 2, 0, 1, 1733152878, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (7, 'Item', 'icon-huibao','green', '/qiye/index/work', 2, 0, 1, 1733152906, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (8, 'Item', 'icon-gonggaotongzhi','yellow', '/qiye/index/note', 3, 0, 1, 1733152965, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (9, 'Item', 'icon-gongsixinwen','yellow', '/qiye/index/news', 3, 0, 1, 1733152993, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (10, 'Item', 'icon-huiyijiyao','yellow', '/qiye/index/meeting', 3, 0, 1, 1733152993, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (11, 'Item', 'icon-a-baoxiao3','purple', '/qiye/finance/expense', 4, 0, 1, 1733153019, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (12, 'Item', 'icon-kaipiao','purple', '/qiye/finance/invoice', 4, 0, 1, 1733153047, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (13, 'Item', 'icon-shoupiao','purple', '/qiye/finance/ticket', 4, 0, 1, 1733153077, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (14, 'Item', 'icon-huikuan','purple', '/qiye/finance/income', 4, 0, 1, 1733153106, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (15, 'Item', 'icon-fukuan','purple', '/qiye/finance/payment', 4, 0, 1, 1733153131, 0, 0);
INSERT INTO `oa_mobile_menu` VALUES (16, 'Item', 'icon-a-baoxiao2','purple', '/qiye/finance/loan', 4, 0, 1, 1733153131, 0, 0);
