/*
Navicat MySQL Data Transfer
Source Server : local
Source Server Version : 50553
Source Host : localhost:3306
Source Database : jujo
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2019-03-21 14:58:54
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for house
-- ----------------------------
DROP TABLE IF EXISTS `house`;
CREATE TABLE `house` (
`id` int(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
`type` char(30) NOT NULL COMMENT '户型',
`area` char(5) NOT NULL COMMENT '面积',
`orientation` char(30) NOT NULL COMMENT '朝向',
`age` int(4) unsigned NOT NULL COMMENT '房龄',
`floor` int(3) NOT NULL COMMENT '楼层',
`property` varchar(30) NOT NULL COMMENT '产权',
`renovation` varchar(300) NOT NULL COMMENT '装修',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of house
-- ----------------------------
INSERT INTO `house` VALUES ('1', '三室一厅', '110', '南北朝向', '8', '12', '商品房', '精装修');
INSERT INTO `house` VALUES ('2', '两室一厅', '86.6', '南北朝向', '3', '8', '商品房', '毛坯');
INSERT INTO `house` VALUES ('8', '两室一厅', '82.6平', '南北朝向', '1', '14', '商品房', '精装修');
INSERT INTO `house` VALUES ('7', '三室两厅', '160平米', '东西朝向', '3', '6', '商品房', '毛坯');
INSERT INTO `house` VALUES ('6', '一室一厅', '60平米', '朝东', '0', '9', '经济房', '毛坯');
INSERT INTO `house` VALUES ('9', '一室一厅', '56平米', '西南朝向', '6', '10', '经济房', '精装修');
INSERT INTO `house` VALUES ('10', '两室一厅', '88平米', '正西朝向', '2', '1', '商品房', '毛坯');
INSERT INTO `house` VALUES ('11', '一室一厅', '60平米', '朝东', '3', '4', '经济房', '精装修');
INSERT INTO `house` VALUES ('12', '三室两厅', '160平米', '东西朝向', '3', '13', '商品房', '毛坯');
INSERT INTO `house` VALUES ('13', '两室一厅', '82.6平', '南北朝向', '1', '21', '商品房', '精装修');
-- ----------------------------
-- Table structure for staff
-- ----------------------------
DROP TABLE IF EXISTS `staff`;
CREATE TABLE `staff` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
`name` varchar(30) NOT NULL COMMENT '姓名',
`age` int(3) unsigned NOT NULL COMMENT '年龄',
`sex` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '性别:1男0女',
`position` varchar(20) NOT NULL COMMENT '职位',
`mobile` char(11) NOT NULL COMMENT '手机',
`hiredate` int(10) unsigned NOT NULL COMMENT '入职时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of staff
-- ----------------------------