/*!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
