/*
Navicat Premium Data Transfer
Source Server : 127
Source Server Type : MySQL
Source Server Version : 50726
Source Host : localhost:3306
Source Schema : test
Target Server Type : MySQL
Target Server Version : 50726
File Encoding : 65001
Date: 20/12/2021 17:38:42
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- Table structure for apartment
DROP TABLE IF EXISTS apartment
;
CREATE TABLE apartment
(
id
int(11) NOT NULL AUTO_INCREMENT,
num
varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '编号',
address
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '地址',
b_id
int(10) NULL DEFAULT NULL COMMENT '所属公寓楼',
c_num
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
d_num
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
create_time
datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- Table structure for apartment_build
DROP TABLE IF EXISTS apartment_build
;
CREATE TABLE apartment_build
(
id
int(11) NOT NULL AUTO_INCREMENT,
num
varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '编号',
address
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '地址',
manger_id
int(10) NULL DEFAULT NULL COMMENT '经理ID',
create_time
datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- Table structure for contract
DROP TABLE IF EXISTS contract
;
CREATE TABLE contract
(
id
int(11) NOT NULL,
k_id
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '签的公寓id',
q_time
datetime(0) NULL DEFAULT NULL COMMENT '签订时间',
s_time
datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
kmoney
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
mmoney
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- Table structure for fault
DROP TABLE IF EXISTS fault
;
CREATE TABLE fault
(
id
int(11) NOT NULL,
k_id
varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '公寓id',
s_time
datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
message
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '问题描述',
u_type
smallint(2) NULL DEFAULT 2 COMMENT '1完成2未完成',
end_time
datetime(0) NULL DEFAULT NULL COMMENT '完成时间',
about_content
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '完成工作内容',
PRIMARY KEY (id
) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- Table structure for staff
DROP TABLE IF EXISTS staff
;
CREATE TABLE staff
(
id
int(11) NOT NULL,
u_num
varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '员工编号',
u_name
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
u_phone
int(11) NULL DEFAULT NULL,
u_type
smallint(3) NULL DEFAULT NULL COMMENT '1维修工2经理',
kill
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '技能',
PRIMARY KEY (id
) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- Table structure for tenant
DROP TABLE IF EXISTS tenant
;
CREATE TABLE tenant
(
id
int(11) NOT NULL,
u_num
varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '租客编号',
u_name
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
u_phone
int(11) NULL DEFAULT NULL,
u_card
varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
about_name
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
about_phone
varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;