智慧物业系统支持微信公众号、小程序、PC、H5、智能硬件多端.zip

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; CREATE TABLE `ejyy_ask_for_leave` ( `id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `created_by` bigint(20) NOT NULL, `workflow_id` bigint(20) NOT NULL, `begin_date` bigint(20) NOT NULL, `reason` varchar(128) NOT NULL, `total` float NOT NULL, `success` tinyint(1) DEFAULT NULL, `cancel` tinyint(1) NOT NULL DEFAULT 0, `step` int(11) NOT NULL, `canceled_at` bigint(13) DEFAULT NULL, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_ask_for_leave_flow` ( `id` bigint(20) NOT NULL, `parent_id` bigint(20) NOT NULL, `step` int(11) NOT NULL, `node_type` tinyint(4) NOT NULL, `workflow_node_id` bigint(20) NOT NULL, `applicant_assign` tinyint(1) NOT NULL DEFAULT 0, `relation_user_id` bigint(20) DEFAULT NULL, `finish` tinyint(1) NOT NULL DEFAULT 0, `refuse_reason` varchar(128) DEFAULT NULL, `finished_at` bigint(13) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_building_info` ( `id` int(11) NOT NULL, `community_id` bigint(20) NOT NULL, `type` tinyint(4) NOT NULL COMMENT '1 住宅 ；2 车位； 3仓房; 4 商户；5 车库', `area` varchar(26) DEFAULT NULL COMMENT '单位后台控制 如 区 期', `building` varchar(26) DEFAULT NULL COMMENT '只有type为1时生效', `unit` varchar(26) DEFAULT NULL COMMENT '单元号', `number` varchar(26) NOT NULL COMMENT '门牌号', `construction_area` float NOT NULL, `created_by` bigint(20) NOT NULL, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_community_info` ( `id` bigint(20) NOT NULL, `name` varchar(12) NOT NULL, `banner` varchar(128) DEFAULT NULL, `phone` varchar(11) NOT NULL, `province` varchar(12) NOT NULL, `city` varchar(12) NOT NULL, `district` varchar(12) NOT NULL, `created_by` bigint(20) NOT NULL, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_community_remote_open_door_log` ( `id` bigint(20) NOT NULL, `door_id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `wechat_mp_user_id` bigint(20) NOT NULL, `success` tinyint(4) NOT NULL DEFAULT 0, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_community_setting` ( `id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `access_nfc` tinyint(1) NOT NULL DEFAULT 0, `access_remote` tinyint(1) NOT NULL DEFAULT 0, `access_qrcode` tinyint(1) NOT NULL DEFAULT 0, `carport_max_car` int(11) NOT NULL DEFAULT 1, `garage_max_car` int(11) NOT NULL DEFAULT 1, `fitment_pledge` tinyint(1) NOT NULL DEFAULT 0 COMMENT '装修保证金' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_complain` ( `id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `type` tinyint(1) NOT NULL COMMENT '1 投诉 2建议', `wechat_mp_user_id` bigint(20) DEFAULT NULL, `property_company_user_id` bigint(20) DEFAULT NULL, `category` int(1) DEFAULT NULL COMMENT '1 卫生问题；2 噪音问题；3 服务态度；4 违建； 5 占用消防通道； 6 社区设施； 7 其他', `description` varchar(200) NOT NULL, `complain_imgs` varchar(200) DEFAULT NULL, `dispose_subscribed` tinyint(1) NOT NULL DEFAULT 0, `confrim_subscribed` tinyint(1) NOT NULL DEFAULT 0, `finish_subscribed` tinyint(1) NOT NULL DEFAULT 0, `allot_user_id` bigint(20) DEFAULT NULL, `alloted_at` bigint(13) DEFAULT NULL, `dispose_user_id` bigint(13) DEFAULT NULL, `dispose_reply` varchar(200) DEFAULT NULL, `dispose_content` varchar(200) DEFAULT NULL, `dispose_imgs` varchar(200) DEFAULT NULL, `disposed_at` bigint(13) DEFAULT NULL, `finished_at` bigint(13) DEFAULT NULL, `merge_id` bigint(20) DEFAULT NULL, `step` tinyint(1) NOT NULL DEFAULT 1, `rate` tinyint(1) DEFAULT NULL, `rate_content` varchar(200) DEFAULT NULL, `rated_at` bigint(13) DEFAULT NULL, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_contract` ( `id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `title` varchar(56) NOT NULL, `category_id` bigint(20) NOT NULL, `first_party` varchar(56) NOT NULL, `first_party_linkman` varchar(8) NOT NULL, `first_party_phone` varchar(11) NOT NULL, `second_party` varchar(56) DEFAULT NULL, `second_party_linkman` varchar(8) DEFAULT NULL, `second_party_phone` varchar(11) DEFAULT NULL, `second_party_wechat_mp_user_id` bigint(20) DEFAULT NULL, `begin_time` bigint(13) NOT NULL, `finish_time` bigint(13) NOT NULL, `contract_fee` float NOT NULL, `created_by` bigint(20) NOT NULL, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_contract_category` ( `id` bigint(20) NOT NULL, `name` varchar(32) NOT NULL, `description` varchar(128) DEFAULT NULL, `created_by` bigint(20) NOT NULL, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_contract_item` ( `id` bigint(20) NOT NULL, `contract_id` bigint(20) NOT NULL, `title` varchar(56) NOT NULL, `descritpion` varchar(128) DEFAULT NULL, `building_id` bigint(20) DEFAULT NULL, `attachment_url` varchar(128) DEFAULT NULL, `attachment_name` varchar(128) DEFAULT NULL, `fee` float NOT NULL, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_convenient` ( `id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `title` varchar(30) NOT NULL, `location` varchar(128) NOT NULL, `phone` varchar(11) NOT NULL, `created_by` bigint(20) NOT NULL, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_employee_sign_record` ( `id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `date` bigint(13) NOT NULL, `begin` bigint(13) NOT NULL, `begin_lat` double NOT NULL, `begin_lng` double NOT NULL, `begin_accuracy` int(11) NOT NULL, `finish` bigint(13) DEFAULT NULL, `finish_lat` double DEFAULT NULL, `finish_lng` double DEFAULT NULL, `finish_accuracy` int(11) DEFAULT NULL, `created_by` bigint(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_employee_sign_setting` ( `id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `lng` double NOT NULL, `lat` double NOT NULL, `distance` int(11) NOT NULL, `latest` tinyint(1) NOT NULL DEFAULT 1, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_epidemic` ( `id` bigint(20) NOT NULL, `wechat_mp_user_id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `building_id` bigint(20) NOT NULL, `tour_code` tinyint(1) NOT NULL COMMENT '1 绿色 2 黄色 3 红色', `temperature` float NOT NULL, `return_hometown` tinyint(1) NOT NULL DEFAULT 0, `return_from_province` varchar(12) DEFAULT NULL, `return_from_city` varchar(12) DEFAULT NULL, `return_from_district` varchar(12) DEFAULT NULL, `created_by` bigint(20) NOT NULL, `created_at` bigint(13) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_feedback` ( `id` bigint(20) NOT NULL, `wechat_mp_user_id` bigint(20) NOT NULL, `type` tinyint(1) NOT NULL DEFAULT 1, `subject` varchar(20) NOT NULL, `content` varchar(200) NOT NULL, `created_at` bigint(13) NOT NULL, `reply` varchar(200) DEFAULT NULL, `reply_user_id` bigint(20) DEFAULT NULL, `replyed_at` bigint(13) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE `ejyy_fitment` ( `id` bigint(20) NOT NULL, `community_id` bigint(20) NOT NULL, `building_id` bigint(20) NOT NULL, `wechat_mp_user_id` bigint(20) NOT NULL, `step` tinyint(1) NOT NULL DEFAULT 1, `agree_user_id` bigint(20) DEFAULT NULL, `agre