一、系统介绍
1.软件环境
Java：jdk1.8
Mysql：8.0.11
Tomcat：8.0.28
2.系统功能
系统管理
1.修改密码
2.用户管理
3.权限管理
4.数据备份与恢复
5.系统数据初始化
基础信息管理
1.代码库
2.业主信息
3.客户管理
4.房源档案管理
租赁管理
1.合同管理
2.租金到期提醒
3.合同到期提醒
财务管理
1.租金收款管理
2.押金管理
3.收费管理
统计报表
1.租金收款按月统计
2.客户交租汇总表
3.合同档案明细表
4.日常收费明细表
5.日常收费汇总表
6.收租统计表
7.押金收退款统计表
3.数据库
/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50532 Source Host : localhost:3306 Source Database : housedatabase Target Server Type : MYSQL Target Server Version : 50532 File Encoding : 65001 Date: 2014-07-04 16:15:26 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `accessory` -- ---------------------------- DROP TABLE IF EXISTS `accessory`; CREATE TABLE `accessory` ( `accessory_id` int(11) NOT NULL DEFAULT '0', `accessory_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `contract_number` varchar(20) COLLATE utf8_bin DEFAULT NULL, `accessory_data` longblob, PRIMARY KEY (`accessory_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of accessory -- ---------------------------- -- ---------------------------- -- Table structure for `clientinfo` -- ---------------------------- DROP TABLE IF EXISTS `clientinfo`; CREATE TABLE `clientinfo` ( `client_id` int(11) NOT NULL AUTO_INCREMENT, `client_number` varchar(10) COLLATE utf8_bin DEFAULT NULL, `client_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `client_sex` varchar(2) COLLATE utf8_bin DEFAULT NULL, `client_IDNumber` varchar(18) COLLATE utf8_bin DEFAULT NULL, `client_phoneNumber` varchar(30) COLLATE utf8_bin DEFAULT NULL, `client_address` varchar(250) COLLATE utf8_bin DEFAULT NULL, `client_companyName` varchar(250) COLLATE utf8_bin DEFAULT NULL, `client_memo` varchar(255) COLLATE utf8_bin DEFAULT NULL, `client_legalPerson` varchar(50) COLLATE utf8_bin DEFAULT NULL, `client_legalPersonIDNumber` varchar(50) COLLATE utf8_bin DEFAULT NULL, `client_licenseNumber` varchar(50) COLLATE utf8_bin DEFAULT NULL, `client_employeeNumber` longtext COLLATE utf8_bin, `client_MobileNumber` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`client_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1707 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of clientinfo -- ---------------------------- INSERT INTO `clientinfo` VALUES ('1587', '0001', '马建斌', '', ' ', '1388801XXX', ' ', '', ' ', '', '', '', '', '138909911XX'); INSERT INTO `clientinfo` VALUES ('1589', '0002', '昆明宇通科技有限公司', null, null, '1388801XXX', '昆明经济技术开发区', '张三丰', ' ', '', '', '', '', '138909911XX'); INSERT INTO `clientinfo` VALUES ('1590', '0003', '昆明强林科技有限公司', null, null, '1388801XXX', '昆明市人民中路218号', '张强林', ' ', '', '', '', '', '138909911XX'); INSERT INTO `clientinfo` VALUES ('1592', '0004', '昆明智宇商务有限公司', null, null, '1388801XXX', '昆明市西昌路915S号', '张林', ' ', '张强', '532333', '15525252', 0xE587BAE7BAB3203538323532353232, '138909911XX'); INSERT INTO `clientinfo` VALUES ('1691', '0005', '宇能商务有限公司', null, null, '1388801XXX', ' ', '', ' ', '', '', '', '', '138909911XX'); INSERT INTO `clientinfo` VALUES ('1700', '0006', '何丽真', null, null, ' ', ' ', '', ' ', '', '', '', '', '138909911XX'); INSERT INTO `clientinfo` VALUES ('1701', '0007', '赵二', null, null, '8989XXX', '本市', '赵二', '演示', '532331197807090223', '赵二', '530102550122109', 0xE697A0E99B87E59198, '1581209XXXX'); INSERT INTO `clientinfo` VALUES ('1702', '0008', '张三', null, null, '0228989XXX', '本市', '张三', '演示', '', '张三', '', '', '1581209XXXX'); INSERT INTO `clientinfo` VALUES ('1703', '0009', '刘四', null, null, '8989XXX', '本市', '刘四', '演示', '', '刘四', '', '', '1581209XXXX'); INSERT INTO `clientinfo` VALUES ('1704', '0010', '何强', null, null, '8989XXX', '本市', '何强', '演示', '', '何强', '', '', '1581209XXXX'); INSERT INTO `clientinfo` VALUES ('1705', '011', '张飞', null, null, '022-88596911', '138****5674', '', '', '', '', '', '', ''); -- ---------------------------- -- Table structure for `columnset` -- ---------------------------- DROP TABLE IF EXISTS `columnset`; CREATE TABLE `columnset` ( `cloumn_id` int(11) NOT NULL DEFAULT '0', `cloumn_form` varchar(38) COLLATE utf8_bin DEFAULT NULL, `cloumn_number` int(11) DEFAULT NULL, `cloumn_width` int(11) DEFAULT NULL, `cloumn_title` varchar(100) COLLATE utf8_bin DEFAULT NULL, `cloumn_view` tinyint(4) DEFAULT NULL, PRIMARY KEY (`cloumn_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of columnset -- ---------------------------- INSERT INTO `columnset` VALUES ('38', '物品档案表', '0', '90', null, '1'); INSERT INTO `columnset` VALUES ('39', '物品档案表', '1', '3480', '名称', '1'); INSERT INTO `columnset` VALUES ('40', '物品档案表', '2', '2250', '规格', '1'); INSERT INTO `columnset` VALUES ('41', '物品档案表', '3', '1725', '数量', '1'); INSERT INTO `columnset` VALUES ('42', '物品档案表', '4', '1425', '单价', '1'); INSERT INTO `columnset` VALUES ('43', '物品档案表', '5', '1890', '总价值', '1'); INSERT INTO `columnset` VALUES ('44', '物品档案表', '6', '2205', '备注', '1'); INSERT INTO `columnset` VALUES ('45', '物业档案表', '0', '900', null, '1'); INSERT INTO `columnset` VALUES ('46', '物业档案表', '1', '900', '代码', '1'); INSERT INTO `columnset` VALUES ('47', '物业档案表', '2', '900', '名称', '1'); INSERT INTO `columnset` VALUES ('48', '物业档案表', '3', '900', '开发商', '1'); INSERT INTO `columnset` VALUES ('49', '楼宇档案表', '0', '900', null, '1'); INSERT INTO `columnset` VALUES ('50', '楼宇档案表', '1', '900', '编号', '1'); INSERT INTO `columnset` VALUES ('51', '楼宇档案表', '2', '1290', '名称', '1'); INSERT INTO `columnset` VALUES ('52', '楼宇档案表', '3', '2415', '所属物业', '1'); INSERT INTO `columnset` VALUES ('53', '楼宇档案表', '4', '2610', '类型', '1'); INSERT INTO `columnset` VALUES ('54', '楼宇档案表', '5', '900', '占地面积', '1'); INSERT INTO `columnset` VALUES ('55', '楼宇档案表', '6', '900', '建筑面积', '1'); INSERT INTO `columnset` VALUES ('56', '楼宇档案表', '7', '900', '位置', '1'); INSERT INTO `columnset` VALUES ('57', '楼宇档案表', '8', '900', '简介', '1'); INSERT INTO `columnset` VALUES ('58', '客户列表', '0', '435', null, '1'); INSERT INTO `columnset` VALUES ('59', '客户列表', '1', '900', '编号', '1'); INSERT INTO `columnset` VALUES ('60', '客户列表', '2', '2130', '名称', '1'); INSERT INTO `columnset` VALUES ('61', '客户列表', '3', '1860', '电话号码', '1'); INSERT INTO `columnset` VALUES ('62', '客户列表', '4', '1770', '手机号码', '1'); INSERT INTO `columnset` VALUES ('63', '客户列表', '5', '2385', '住址', '1'); INSERT INTO `columnset` VALUES ('64', '客户列表', '6', '900', '联系人', '1'); INSERT INTO `columnset` VALUES ('65', '客户列表', '7', '1440', '法人姓名', '1'); INSERT INTO `columnset` VALUES ('66', '客户列表', '8', '1905', '法人身份证号', '1'); INSERT INTO `columnset` VALUES ('67', '客户列表', '9', '2370', '营业执照号', '1'); INSERT INTO `columnset` VALUES ('68', '客户列表', '10', '900', '雇员情况', '1'); INSERT INTO `columnset` VALUES ('69', '客户列表', '11', '3165', '备注', '1'); INSERT INTO `columnset` VALUES ('71', '合同档案列表', '0', '525', null, '1'); INSERT INTO `columnset` VALUES ('72', '合同档案列表', '1', '900', '房屋名称', '0'); INSERT INTO `columnset` VALUES ('73', '合同档案列表', '2', '1125', '合同编号', '1'); INSERT INTO `columnset` VALUES ('74', '合同档案列表', '3', '3435', '客户名称', '1'); INSERT INTO `columnset` VALUES ('75', '合同档案列表', '4', '1665', '合同状态', '1'); INSERT INTO `columnset` VALUES ('76', '合同档案列表', '5', '1260', '起租日期', '1'); INSERT INTO `columnset` VALUES ('77', '合同档案列表', '6', '1485', '止租日期', '1'); INSERT INTO `columnset` VALUES ('78', '合同档案列表', '7', '900', '租期(月)', '1'); INSERT INTO `columnset` VALUES ('79', '合同档案列表', '8', '900', '日租金(日/㎡)', '0'); INSERT INTO `columnset` VALUES ('80', '合同档案列表', '9', '900', '面积', '0'); INSERT INTO `columnset` VALUES ('81', '合同档案列表', '10', '1275', '月租金', '1'); INSERT INTO `columnset` VALUES ('82', '合同档案列表', '11', '2145', '总金额', '1'); INSERT INTO `columnset` VALUES ('83', '合同档案列表', '12', '3930', '备注', '1'); INSERT INTO `columnset` VALUES ('84', '合同房源列表', '0', '540', '编号', '1'); INSERT INTO `columnset` VALUES ('85', '合同房源列表', '1', '1860', '名称', '1'); INSERT INTO `columnset` VALUES ('86', '合同房源列表', '2', '1875', '物业名称', '1'); INSERT INTO `columnset` VALUES ('87', '合同房源列表', '3', '900', '所属楼宇', '1'); INSERT INTO `columnset` VALUES ('88', '合同房源列表', '4', '3225', '业主', '1'); INSERT INTO `columnset` VALUES ('89', '合同房源列表', '5', '540', '户型', '1'); INSERT INTO `columnset` VALUES ('90', '合同房源列表', '6', '900', '朝向', '1'); INSERT INTO `columnset` VALUES ('91', '合同房源列表', '7', '540', '楼层', '1'); INSERT INTO `columnset` VALUES ('92', '合同房源列表', '8', '540', '结构', '1'); INSERT INTO `columnset` VALUES ('93', '合同房源列表', '9', '540', '面积', '1'); INSERT INTO `columnset` VALUES ('94', '合同房源列表', '10', '2520', '备注', '1'); INSERT INTO `columnset` VALUES ('95', '合同交款列表', '0', '90', null, '0'); INSERT INTO `columnset` VALUES ('96', '合同交款列表', '1', '1500', '录单日期', '1'); INSERT INTO `columnset` VALUES ('97', '合同交款列表', '2', '1065', '单据编号', '1'); INSERT INTO `columnset` VALUES ('98', '合同交款列表', '3', '1245', '收款人', '1'); INSERT INTO `columnset` VALUES ('99', '合同交款列表', '4', '3075', '摘要', '1'); INSERT INTO `columnset` VALUES ('100', '合同交款列表', '5', '990', '发票号码', '1'); INSERT INTO `columnset` VALUES ('101', '合同交款列表', '6', '2745', '租金起止日期', '1'); INSERT INTO `columnset` VALUES ('102', '合同交款列表', '7', '1725', '金 额', '1'); INSERT INTO `columnset` VALUES ('103', '合同交款列表', '8', '4920', '款项类别', '1'); INSERT INTO `columnset` VALUES ('104', '合同物品列表', '0', '2220', '房屋名称', '1'); INSERT INTO `columnset` VALUES ('105', '合同物品列表', '1', '2910', '物品名称', '1'); INSERT INTO `columnset` VALUES ('106', '合同物品列表', '2', '450', '规格', '1'); INSERT INTO `columnset` VALUES ('107', '合同物品列表', '3', '450', '数量', '1'); INSERT INTO `columnset` VALUES ('108', '合同物品列表', '4', '450', '单价', '1'); INSERT INTO `columnset` VALUES ('109', '合同物品列表', '5', '630', '总价值', '1'); INSERT INTO `columnset` VALUES ('110', '合同物品列表', '6', '3960', '备注', '1'); INSERT INTO `columnset` VALUES ('111', '房屋档案表', '0', '420', null, '1'); INSERT INTO `columnset` VALUES ('112', '房屋档案表', '1', '900', '编号', '1'); INSERT INTO `columnset` VALUES ('113', '房屋档案表', '2', '900', '名称', '1'); INSERT INTO `columnset` VALUES ('114', '房屋档案表', '3', '900', '物业名称', '1'); INSERT INTO `columnset` VALUES ('115', '房屋档案表', '4', '900', '所属楼宇', '1'); INSERT INTO `columnset` VALUES ('116', '房屋档案表', '5', '900', '朝向', '1'); INSERT INTO `columnset` VALUES ('117', '房屋档案表', '6', '900', '户型', '1'); INSERT INTO `columnset` VALUES ('118', '房屋档案表', '7', '900', '业主', '1'); INSERT INTO `columnset` VALUES ('119', '房屋档案表', '8', '900', '楼层', '1'); INSERT INTO `columnset` VALUES ('120', '房屋档案表', '9', '900', '结构', '1'); INSERT INTO `columnset` VALUES ('121', '房屋档案表', '10', '900', '面积', '1'); INSERT INTO `columnset` VALUES ('122', '房屋档案表', '11', '900', '状态', '1'); INSERT INTO `columnset` VALUES ('123', '房屋档案表', '12', '900', '备注', '1'); INSERT INTO `columnset` VALUES ('124', '历史租户', '0', '435', null, '1'); INSERT INTO `columnset` VALUES ('125', '历史租户', '1', '900', '房屋名称', '0'); INSERT INTO `columnset` VALUES ('126', '历史租户', '2', '900', '合同编号', '1'); INSERT INTO `columnset` VALUES ('127', '历史租户', '3', '4065', '客户名称', '1'); INSERT INTO `columnset` VALUES ('128', '历史租户', '4', '900', '合同状态', '1'); INSERT INTO `columnset` VALUES ('129', '历史租户', '5', '900', '起租日期', '1'); INSERT INTO `columnset` VALUES ('130', '历史租户', '6', '900', '止租日期', '1'); INSERT INTO `columnset` VALUES ('131', '历史租户', '7', '900', '租期(月)', '1'); INSERT INTO `columnset` VALUES ('132', '历史租户', '8', '900', '日租金(日/㎡)', '0'); INSERT INTO `columnset` VALUES ('133', '历史租户', '9', '900', '面积', '0'); INSERT INTO `columnset` VALUES ('134', '历史租户', '10', '2370', '月租金', '1'); INSERT INTO `columnset` VALUES ('135', '历史租户', '11', '1665', '总金额', '1'); INSERT INTO `columnset` VALUES ('136', '历史租户', '12', '3030', '备注', '1'); INSERT INTO `columnset` VALUES ('137', '业主列表', '0', '900', null, '1'); INSERT INTO `columnset` VALUES ('138', '业主列表', '1', '1500', '编号', '1'); INSERT INTO `columnset` VALUES ('139', '业主列表', '2', '2505', '业主名称', '1'); INSERT INTO `columnset` VALUES ('140', '业主列表', '3', '2310', '电话号码', '1'); INSERT INTO `columnset` VALUES ('141', '业主列表', '4', '2610', '住址', '1'); INSERT INTO `columnset` VALUES ('142', '业主列表', '5', '3300', '备注', '1'); INSERT INTO `columnset` VALUES ('143', '租金档案表', '0', '435', null, '1'); INSERT INTO `columnset` VALUES ('144', '租金档案表', '1', '1230', '房屋名称', '1'); INSERT INTO `columnset` VALUES ('145', '租金档案表', '2', '1665', '录单日期', '1'); INSERT INTO `columnset` VALUES ('146', '租金档案表', '3', '1665', '单据编号', '1'); INSERT INTO `columnset` VALUES ('147', '租金档案表', '4', '1455', '合同编号', '1'); INSERT INTO `columnset` VALUES ('148', '租金档案表', '5', '2460', '客户名称', '1'); INSERT INTO `columnset` VALUES ('149', '租金档案表', '6', '900', '发票号码', '1'); INSERT INTO `columnset` VALUES ('150', '租金档案表', '7', '1305', '摘要', '1'); INSERT INTO `columnset` VALUES ('151', '租金档案表', '8', '1365', '起始日期', '1'); INSERT INTO `columnset` VALUES ('152', '租金档案表', '9', '1365', '终止日期', '1'); INSERT INTO `columnset` VALUES ('153', '租金档案表', '10', '1455', '金额', '1'); INSERT INTO `columnset` VALUES ('154', '租金档案表', '11', '900', '收款人', '1'); INSERT INTO `columnset` VALUES ('155', '租金档案表', '12', '1830', '收款方式', '1'); INSERT INTO `columnset` VALUES ('156', '押金档案表', '0', '405', null, '1'); INSERT INTO `columnset` VALUES ('157', '押金档案表', '1', '1350', '录单日期', '1'); INSERT INTO `columnset` VALUES ('158', '押金档案表', '2', '900', '单据编号', '1'); INSERT INTO `columnset` VALUES ('159', '押金档案表', '3', '1425', '合同编号', '1'); INSERT INTO `columnset` VALUES ('160', '押金档案表', '4', '2790', '客户名称', '1'); INSERT INTO `columnset` VALUES ('161', '押金档案表', '5', '1770', '摘要', '1'); INSERT INTO `columnset` VALUES ('162', '押金档案表', '6', '2850', '金额', '1'); INSERT INTO `columnset` VALUES ('163', '押金档案表', '7', '1725', '收款人', '1'); INSERT INTO `columnset` VALUES ('164', '押金档案表', '8', '2685', '收款方式', '1'); INSERT INTO `columnset` VALUES ('165', '押金退款档案表', '0', '255', null, '1'); INSERT INTO `columnset` VALUES ('166', '押金退款档案表', '1', '1005', '录单日期', '1'); INSERT INTO `columnset` VALUES ('167', '押金退款档案表', '2', '1395', '单据编号', '1'); INSERT INTO `columnset` VALUES ('168', '押金退款档案表', '3', '795', '合同编号', '1'); INSERT INTO `columnset` VALUES ('169', '押金退款档案表', '4', '2505', '客户名称', '1'); INSERT INTO `columnset` VALUES ('170', '押金退款档案表', '5', '2505', '摘要', '1'); INSERT INTO `columnset` VALUES ('171', '押金退款档案表', '6', '1500', '金额', '1'); INSERT INTO `columnset` VALUES ('172', '押金退款档案表', '7', '900', '经办人', '1'); INSERT INTO `columnset` VALUES ('173', '押金退款档案表', '8', '0', null, '1'); INSERT INTO `columnset` VALUES ('174', '押金退款档案表', '9', '0', null, '1'); INSERT INTO `columnset` VALUES ('175', '交费记录', '0', '615', '选择', '1'); INSERT INTO `columnset` VALUES ('176', '交费记录', '1', '900', '费用期间', '1'); INSERT INTO `columnset` VALUES ('177', '交费记录', '2', '1515', '科目名称', '1'); INSERT INTO `columnset` VALUES ('178', '交费记录', '3', '1335', '房屋名称', '1'); INSERT INTO `columnset` VALUES ('179', '交费记录', '4', '2280', '客户名称', '1'); INSERT INTO `columnset` VALUES ('180', '交费记录', '5', '2040', '计费周期始', '1'); INSERT INTO `columnset` VALUES ('181', '交费记录', '6', '1935', '计费周期止', '1'); INSERT INTO `columnset` VALUES ('182', '交费记录', '7', '900', '起数', '1'); INSERT INTO `columnset` VALUES ('183', '交费记录', '8', '900', '止数', '1'); INSERT INTO `columnset` VALUES ('184', '交费记录', '9', '900', '用量', '1'); INSERT INTO `columnset` VALUES ('185', '交费记录', '10', '1230', '计费标准', '1'); INSERT INTO `columnset` VALUES ('186', '交费记录', '11', '1200', '金额', '1'); INSERT INTO `columnset` VALUES ('187', '交费记录', '12', '900', '是否收款', '1'); INSERT INTO `columnset` VALUES ('188', '交费记录', '13', '900', '收款人', '1'); INSERT INTO `columnset` VALUES ('189', '交费记录', '14', '1380', '收款日期', '1'); INSERT INTO `columnset` VALUES ('190', '交费记录', '15', '900', '收款方式', '1'); INSERT INTO `columnset` VALUES ('191', '交费记录', '16', '900', '合同编号', '1'); -- ---------------------------- -- Table structure for `contractdelay` -- ---------------------------- DROP TABLE IF EXISTS `contractdelay`; CREATE TABLE `contractdelay` ( `contractDelay_id` int(11) NOT NULL, `contract_number` varchar(20) COLLATE utf8_bin DEFAULT NULL, `startRentDate` datetime DEFAULT NULL, `oldEndRentDate` datetime DEFAULT NULL, `oldTotalAmount` decimal(19,4) DEFAULT NULL, `delay_month` int(11) DEFAULT NULL, `delay_day` int(11) DEFAULT NULL, `newEndRentDate` datetime DEFAULT NULL, `operatePeople` varchar(20) COLLATE utf8_bin DEFAULT NULL, `addRent` decimal(19,2) DEFAULT NULL, `newTotalAmount` decimal(19,2) DEFAULT NULL, `signDate` datetime DEFAULT NULL, PRIMARY KEY (`contractDelay_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of contractdelay -- ---------------------------- -- ---------------------------- -- Table structure for `contractinfo` -- ---------------------------- DROP TABLE IF EXISTS `contractinfo`; CREATE TABLE `contractinfo` ( `contract_id` int(11) NOT NULL AUTO_INCREMENT, `contract_number` varchar(20) COLLATE utf8_bin DEFAULT NULL, `client_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `contract_state` varchar(10) COLLATE utf8_bin DEFAULT NULL, `startRentDate` date DEFAULT NULL, `endRentDate` date DEFAULT NULL, `leaseTime_month` int(11) DEFAULT NULL, `leaseTime_day` int(11) DEFAULT NULL, `leaseMoney_month` decimal(19,4) DEFAULT NULL, `totalAmount` decimal(19,4) DEFAULT NULL, `leaseMoney_day` decimal(19,4) DEFAULT NULL, `contract_memo` varchar(255) COLLATE utf8_bin DEFAULT NULL, `contractEnd_date` datetime DEFAULT NULL, `contractEnd_reason` varchar(50) COLLATE utf8_bin DEFAULT NULL, `contractEnd_operatePeople` varchar(10) COLLATE utf8_bin DEFAULT NULL, `contractCancel_date` datetime DEFAULT NULL, `contractCancel_reason` varchar(50) COLLATE utf8_bin DEFAULT NULL, `contractCancel_operatePeople` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`contract_id`), KEY `contract_number` (`contract_number`) ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of contractinfo -- ---------------------------- INSERT INTO `contractinfo` VALUES ('7', '10002', '马建斌', '终止', '2014-07-01', '2014-07-31', '12', '0', '500.0000', '6000.0000', '0.0000', '合同房号:红军街112号 ', null, null, null, null, null, null); INSERT INTO `contractinfo` VALUES ('9', '10004', '张明', '生效', '2013-09-26', '2013-11-26', '100', '0', '100.0000', '1200.0000', '0.0000', '', null, null, null, null, null, null); INSERT INTO `contractinfo` VALUES ('11', '10005', '昆明智宇商务有限公司', '生效', '2013-10-26', '2013-12-26', '12', '0', '1800.0000', '21600.0000', '0.0000', '', null, null, null, null, null, null); INSERT INTO `contractinfo` VALUES ('12', '10006', '宇能商务有限公司', '终止', '2010-03-08', '2012-11-07', '12', '0', '500.0000', '6000.0000', '0.0000', '', null, null, null, null, null, null); INSERT INTO `contractinfo` VALUES ('13', '10007', '北京科技公司', '终止', '2013-06-01', '2013-06-30', '100', '0', '100.0000', '1200.0000', '0.0000', null, null, null, null, null, null, null); INSERT INTO `contractinfo` VALUES ('54', '10001', '宇能商务有限公司', '生效', '2014-06-24', '2014-07-24', '1', null, '6000.0000', '6000.0000', null, '', null, null, null, null, null, null); INSERT INTO `contractinfo` VALUES ('55', '10003', '昆明智宇商务有限公司', '生效', '2014-07-09', '2014-07-09', '12', null, '12.0000', '144.0000', null, '12', null, null, null, null, null, null); INSERT INTO `contractinfo` VALUES ('62', '10008', '张飞', '生效', '2013-07-08', '2014-07-17', '12', null, '12.0000', '144.0000', null, 'hah', null, null, null, null, null, null); INSERT INTO `contractinfo` VALUES ('63', '10009', '昆明强林科技有限公司', '生效', '2014-07-16', '2014-08-07', '1', null, '555.0000', '555.0000', null, '55555', null, null, null, null, null, null); -- ---------------------------- -- Table structure for `coststatistic` -- ---------------------------- DROP TABLE IF EXISTS `coststatistic`; CREATE TABLE `coststatistic` ( `costStatistic_id` int(11) NOT NULL AUTO_INCREMENT, `costStatistic_subject` int(20) DEFAULT NULL, `costStatistic_startTime` date DEFAULT NULL, `costStatistic_endTime` date DEFAULT NULL, `costStatistic_contractID` varchar(50) COLLATE utf8_bin DEFAULT NULL, `costStatistic_clientName` varchar(50) COLLATE utf8_bin DEFAULT NULL, `costStatistic_houseNumber` varchar(50) COLLATE utf8_bin DEFAULT NULL, `costStatistic_startNumber` int(50) DEFAULT NULL, `costStatistic_endNumber` int(50) DEFAULT NULL, `costStatistic_quantity` int(50) DEFAULT NULL, `costStatistic_price` float(50,4) DEFAULT NULL, `costStatistic_amount` decimal(50,6) DEFAULT NULL, `costStatistic_receipt` int(1) DEFAULT NULL, `costStatistic_receiptMan` varchar(50) COLLATE utf8_bin DEFAULT NULL, `costStatistic_receiptDate` datetime DEFAULT NULL, `costStatistic_period` date DEFAULT NULL, `costStatistic_receiptType` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`costStatistic_id`), KEY `costStatistic_subject` (`costStatistic_subject`), CONSTRAINT `costSubject` FOREIGN KEY (`costStatistic_subject`) REFERENCES `costsubject` (`costSubject_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of coststatistic -- ---------------------------- INSERT INTO `coststatistic` VALUES ('0', '12', '2014-06-01', '2014-06-30', '0003', '马建斌', '0092', '0', '0', '0', '1.5000', '150.000000', '1', '', '2014-06-01 00:00:00', '2014-02-01', null); INSERT INTO `coststatistic` VALUES ('1', '12', '2014-06-01', '2014-06-30', '0004', '马建斌', '0093', '0', '0', '0', '2.0000', '200.000000', '1', '管理员', '2014-06-01 00:00:00', '2014-02-01', '信用卡'); INSERT INTO `coststatistic` VALUES ('2', '12', '2014-06-01', '2014-06-30', '0003', '马建斌', '0098', '0', '0', '0', '0.5500', '59.400000', '1', '管理员', '2014-06-30 00:00:00', '2015-03-01', '支付宝'); INSERT INTO `coststatistic` VALUES ('3', '14', '2010-01-01', '2010-03-31', '0002', '马建斌', '0001', null, null, '6000', '0.0300', '180.000000', '1', '管理员', '2012-09-15 00:00:00', '2010-03-01', '现金'); INSERT INTO `coststatistic` VALUES ('4', '13', '2010-01-01', '2010-03-16', '0002', '马建斌', '0001', null, '68', '68', '0.5500', '37.400000', '1', '刘强', '2012-09-15 00:00:00', '2010-03-01', '现金'); INSERT INTO `coststatistic` VALUES ('5', '12', '2012-09-15', '2012-10-14', '0005', '昆明宇通科技有限公司', '0002,0096', null, null, '65', '1.0500', '68.250000', '0', '管理员', '2012-10-10 00:00:00', '2012-09-01', null); INSERT INTO `coststatistic` VALUES ('7', '13', '2014-01-01', '2014-07-31', '0004', '张明', '0097', '100', '350', '250', '1.0000', '250.000000', '1', '管理员', '2014-07-01 00:00:00', '2014-04-01', '现金'); INSERT INTO `coststatistic` VALUES ('8', '12', '2014-07-01', '2014-07-31', '0002', '马建斌', '00002', '0', '0', '0', '0.5000', '54.000000', '1', '', '2014-07-01 00:00:00', '2014-07-01', null); INSERT INTO `coststatistic` VALUES ('9', '12', '2014-07-01', '2014-07-31', '0002', '马建斌', '0001', '0', '0', '0', '0.8000', '80.000000', '1', '管理员', '2014-07-30 00:00:00', '2014-03-01', '银行'); -- ---------------------------- -- Table structure for `costsubject` -- ---------------------------- DROP TABLE IF EXISTS `costsubject`; CREATE TABLE `costsubject` ( `costSubject_id` int(11) NOT NULL, `costSubject_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `costSubject_price` decimal(20,2) DEFAULT NULL, `costSubject_type` varchar(50) COLLATE utf8_bin DEFAULT NULL, `costSubject_firstTime` datetime DEFAULT NULL, PRIMARY KEY (`costSubject_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of costsubject -- ---------------------------- INSERT INTO `costsubject` VALUES ('12', '物业管理费', '1.05', '按面积', '2010-03-02 00:00:00'); INSERT INTO `costsubject` VALUES ('13', '电费', '0.70', '按面积', '2014-06-03 00:00:00'); INSERT INTO `costsubject` VALUES ('14', '违约金', '0.03', '按合同额百分比', '2010-03-16 00:00:00'); INSERT INTO `costsubject` VALUES ('15', '垃圾费', '5.00', '按面积', '2014-06-26 00:00:00'); INSERT INTO `costsubject` VALUES ('17', '测试', '1.00', '按面积', '2014-06-04 00:00:00'); -- ---------------------------- -- Table structure for `deposit` -- ---------------------------- DROP TABLE IF EXISTS `deposit`; CREATE TABLE `deposit` ( `deposit_id` int(11) NOT NULL AUTO_INCREMENT, `receipts_number` varchar(15) COLLATE utf8_bin DEFAULT NULL, `receipts_type` varchar(15) COLLATE utf8_bin DEFAULT NULL, `recordDate` datetime DEFAULT NULL, `receiptPeople` varchar(20) COLLATE utf8_bin DEFAULT NULL, `contract_number` varchar(20) COLLATE utf8_bin DEFAULT NULL, `billNumber` varchar(15) COLLATE utf8_bin DEFAULT NULL, `deposit_memo` varchar(200) COLLATE utf8_bin DEFAULT NULL, `deposit_amount` decimal(19,4) DEFAULT NULL, `deposit_type` int(11) DEFAULT NULL, `deposit_main` varchar(50) COLLATE utf8_bin DEFAULT NULL, `receipt_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`deposit_id`), KEY `pc` (`contract_number`), CONSTRAINT `pc` FOREIGN KEY (`contract_number`) REFERENCES `contractinfo` (`contract_number`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of deposit -- ---------------------------- INSERT INTO `deposit` VALUES ('0', '0001', '押金收款', '2014-07-16 00:00:00', '管理员', '10002', null, '', '6000.0000', '0', null, '支付宝'); INSERT INTO `deposit` VALUES ('1', '0002', '押金收款', '2014-07-15 00:00:00', '管理员', '10006', null, '徐子超', '1800.0000', null, null, 'null'); INSERT INTO `deposit` VALUES ('3', 'TKD-0001', '押金退款', '2014-07-30 00:00:00', '管理员', '10006', null, '退手续费100元', '100.0000', null, null, null); INSERT INTO `deposit` VALUES ('4', 'TKD-0002', '押金退款', '2014-07-16 00:00:00', '管理员', '10006', null, '电饭锅', '33.0000', null, null, null); INSERT INTO `deposit` VALUES ('14', '0003', '押金收款', '2014-07-24 00:00:00', '管理员', '10004', null, '你好', '90000.0000', null, null, 'null'); INSERT INTO `deposit` VALUES ('15', '0004', '押金收款', '2014-06-18 11:30:58', '管理员', '10004', null, '你好', '10001.0000', null, null, null); -- ---------------------------- -- Table structure for `developers` -- ---------------------------- DROP TABLE IF EXISTS `developers`; CREATE TABLE `developers` ( `developer_id` int(11) NOT NULL AUTO_INCREMENT, `developer_number` varchar(4) COLLATE utf8_bin DEFAULT NULL, `developer_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `developer_spellName` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`developer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of developers -- ---------------------------- INSERT INTO `developers` VALUES ('3', '0001', '昆明灵豚科技有限公司', null); INSERT INTO `developers` VALUES ('5', '0003', '河北省', null); INSERT INTO `developers` VALUES ('6', '0004', '软件园', null); INSERT INTO `developers` VALUES ('7', '0005', '工业大学', null); INSERT INTO `developers` VALUES ('8', '0006', '计算机学院', null); INSERT INTO `developers` VALUES ('9', '0007', '计算机科学与软件学院', null); -- ---------------------------- -- Table structure for `equipment` -- ---------------------------- DROP TABLE IF EXISTS `equipment`; CREATE TABLE `equipment` ( `equip_id` int(11) NOT NULL AUTO_INCREMENT, `equip_number` varchar(4) COLLATE utf8_bin DEFAULT NULL, `equip_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `equip_spellName` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`equip_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of equipment -- ---------------------------- INSERT INTO `equipment` VALUES ('1', '0001', '水表', null); INSERT INTO `equipment` VALUES ('3', '0002', '卫生设施', null); INSERT INTO `equipment` VALUES ('10', '0003', '配电设施', null); INSERT INTO `equipment` VALUES ('11', '0004', '其他', null); -- ---------------------------- -- Table structure for `floorinfo` -- ---------------------------- DROP TABLE IF EXISTS `floorinfo`; CREATE TABLE `floorinfo` ( `floorInfo_id` int(11) NOT NULL AUTO_INCREMENT, `floorInfo_number` varchar(4) COLLATE utf8_bin DEFAULT NULL, `floorInfo_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `floorInfo_propertyname` varchar(50) COLLATE utf8_bin DEFAULT NULL, `floorInfo_type` varchar(50) COLLATE utf8_bin DEFAULT NULL, `floorInfo_floorAera` varchar(20) COLLATE utf8_bin DEFAULT NULL, `floorInfo_coveredAera` varchar(20) COLLATE utf8_bin DEFAULT NULL, `floorInfo_site` varchar(50) COLLATE utf8_bin DEFAULT NULL, `floorInfo_memo` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`floorInfo_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4427 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of floorinfo -- ---------------------------- INSERT INTO `floorinfo` VALUES ('0', '0001', '红军街', '我的物业', '其他', '', '', '', ''); INSERT INTO `floorinfo` VALUES ('1', '0002', '商务楼', '昆明世纪城', '厂房', '', '', '', ''); INSERT INTO `floorinfo` VALUES ('4423', '0003', '府前街', '我的物业', '办公', '', '', '', ''); INSERT INTO `floorinfo` VALUES ('4424', '0004', '青云路', '天明物业', '职工宿舍', '', '', '', ''); INSERT INTO `floorinfo` VALUES ('4425', '0005', '迎水道', '海泰物业', '职工宿舍', '', '', '', ''); -- ---------------------------- -- Table structure for `floortype` -- ---------------------------- DROP TABLE IF EXISTS `floortype`; CREATE TABLE `floortype` ( `floorType_id` int(11) NOT NULL AUTO_INCREMENT, `floorType_number` varchar(4) COLLATE utf8_bin DEFAULT NULL, `floorType_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `floorType_spellName` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`floorType_id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of floortype -- ---------------------------- INSERT INTO `floortype` VALUES ('8', '0001', '厂房', null); INSERT INTO `floortype` VALUES ('9', '0002', '办公', null); INSERT INTO `floortype` VALUES ('10', '0003', '职工宿舍', null); INSERT INTO `floortype` VALUES ('11', '0004', '其他', null); -- ---------------------------- -- Table structure for `goodsstock` -- ---------------------------- DROP TABLE IF EXISTS `goodsstock`; CREATE TABLE `goodsstock` ( `goods_id` int(11) NOT NULL AUTO_INCREMENT, `goods_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `goods_standard` varchar(50) COLLATE utf8_bin DEFAULT NULL, `goods_number` int(11) DEFAULT NULL, `goods_price` decimal(19,0) DEFAULT NULL, `goods_totalAmount` decimal(19,0) DEFAULT NULL, `goods_memo` varchar(250) COLLATE utf8_bin DEFAULT NULL, `House_number` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`goods_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of goodsstock -- ---------------------------- INSERT INTO `goodsstock` VALUES ('1', '饮水机', '台', '2', '80', '160', '无', '0001'); INSERT INTO `goodsstock` VALUES ('2', '电视机', null, '1', '5800', '5800', null, '0002'); INSERT INTO `goodsstock` VALUES ('3', '洗衣机', '台', '1', '1200', '1200', '', '0003'); INSERT INTO `goodsstock` VALUES ('4', '洗衣机', '台', '1', '1200', '1200', '', '0004'); -- ---------------------------- -- Table structure for `housedirection` -- ---------------------------- DROP TABLE IF EXISTS `housedirection`; CREATE TABLE `housedirection` ( `houseD_id` int(11) NOT NULL AUTO_INCREMENT, `houseD_number` varchar(4) COLLATE utf8_bin DEFAULT NULL, `houseD_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `houseD_spellName` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`houseD_id`) ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of housedirection -- ---------------------------- INSERT INTO `housedirection` VALUES ('17', '0001', '坐南朝北', null); INSERT INTO `housedirection` VALUES ('18', '0002', '坐北朝南', null); INSERT INTO `housedirection` VALUES ('19', '0003', '坐东朝西', null); INSERT INTO `housedirection` VALUES ('22', '0004', '坐西朝东', null); INSERT INTO `housedirection` VALUES ('27', '0005', '东', null); INSERT INTO `housedirection` VALUES ('28', '0006', '南', null); INSERT INTO `housedirection` VALUES ('29', '0007', '西', null); INSERT INTO `housedirection` VALUES ('30', '0008', '北', null); -- ---------------------------- -- Table structure for `houserepair` -- ---------------------------- DROP TABLE IF EXISTS `houserepair`; CREATE TABLE `houserepair` ( `houseRepair_id` int(11) NOT NULL, `houseRepair_date` datetime DEFAULT NULL, `renHouse_id` int(11) DEFAULT NULL, `houseRepair_context` varchar(200) COLLATE utf8_bin DEFAULT NULL, `houseRepair_repairCompany` varchar(50) COLLATE utf8_bin DEFAULT NULL, `houseRepair_spend` decimal(19,2) DEFAULT NULL, `houseRepair_memo` varchar(200) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`houseRepair_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of houserepair -- ---------------------------- -- ---------------------------- -- Table structure for `housestructure` -- ---------------------------- DROP TABLE IF EXISTS `housestructure`; CREATE TABLE `housestructure` ( `houseS_id` int(11) NOT NULL AUTO_INCREMENT, `houseS_number` varchar(4) COLLATE utf8_bin DEFAULT NULL, `houseS_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `houseS_spellName` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`houseS_id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of housestructure -- ---------------------------- INSERT INTO `housestructure` VALUES ('10', '0001', '瓦木', null); INSERT INTO `housestructure` VALUES ('11', '0002', '混合', null); INSERT INTO `housestructure` VALUES ('12', '0003', '框架', null); INSERT INTO `housestructure` VALUES ('13', '0004', '剪框', null); INSERT INTO `housestructure` VALUES ('14', '0005', '水泥', null); -- ---------------------------- -- Table structure for `housetype` -- ---------------------------- DROP TABLE IF EXISTS `housetype`; CREATE TABLE `housetype` ( `houseType_id` int(11) NOT NULL AUTO_INCREMENT, `houseType_number` varchar(4) COLLATE utf8_bin DEFAULT NULL, `houseType_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `houseType_spellName` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`houseType_id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of housetype -- ---------------------------- INSERT INTO `housetype` VALUES ('11', '0001', '单层', null); INSERT INTO `housetype` VALUES ('12', '0002', '双层', null); INSERT INTO `housetype` VALUES ('13', '0003', '多层', null); INSERT INTO `housetype` VALUES ('14', '0004', '单套', null); INSERT INTO `housetype` VALUES ('15', '0005', '双套', null); INSERT INTO `housetype` VALUES ('16', '0006', '多套', null); INSERT INTO `housetype` VALUES ('17', '0007', '其他', null); -- ---------------------------- -- Table structure for `lesson` -- ---------------------------- DROP TABLE IF EXISTS `lesson`; CREATE TABLE `lesson` ( `lesson_id` int(11) NOT NULL DEFAULT '0', `lesson_number` varchar(20) COLLATE utf8_bin DEFAULT NULL, `lesson_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `lesson_ownFloor` varchar(50) COLLATE utf8_bin DEFAULT NULL, `lesson_propertyName` varchar(50) COLLATE utf8_bin DEFAULT NULL, `lesson_direction` varchar(20) COLLATE utf8_bin DEFAULT NULL, `lesson_houseType` varchar(20) COLLATE utf8_bin DEFAULT NULL, `lesson_master` varchar(20) COLLATE utf8_bin DEFAULT NULL, `lesson_floor` varchar(10) COLLATE utf8_bin DEFAULT NULL, `lesson_structure` varchar(20) COLLATE utf8_bin DEFAULT NULL, `lesson_rentState` varchar(20) COLLATE utf8_bin DEFAULT NULL, `lesson_memo` varchar(50) COLLATE utf8_bin DEFAULT NULL, `lesson_pitch` varchar(2) COLLATE utf8_bin DEFAULT NULL, `lesson_aera` varchar(20) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`lesson_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of lesson -- ---------------------------- INSERT INTO `lesson` VALUES ('2737', '0001', '红军街112号', '红军街', '我的物业', '', '', '', '', '', '未出租', '', '假', '56'); INSERT INTO `lesson` VALUES ('2738', '0002', '红军街113号', '红军街', '我的物业', '', '', '', '', '', '已出租', '', '假', '65'); INSERT INTO `lesson` VALUES ('2743', '0096', 'A-120', '商务楼', '昆明世纪城', '坐南朝北', '单层', '浙江省农业科学院柑桔研究所', '1', '框架', '已出租', '', '假', ''); INSERT INTO `lesson` VALUES ('2744', '0097', 'A-121', '商务楼', '昆明世纪城', '坐南朝北', '单层', '浙江省农业科学院柑桔研究所', '3', '框架', '已出租', '', '假', '0'); INSERT INTO `lesson` VALUES ('2745', '0098', 'A-122', '商务楼', '昆明世纪城', '坐南朝北', '单层', '浙江省农业科学院柑桔研究所', '2', '瓦木', '已出租', '', '假', '0'); INSERT INTO `lesson` VALUES ('2746', '0099', 'A-123', '商务楼', '昆明世纪城', '坐南朝北', '单层', '浙江省农业科学院柑桔研究所', '2', '瓦木', '已出租', '', '假', ''); INSERT INTO `lesson` VALUES ('2750', '0100', 'A-125', '红军街', '我的物业', '坐南朝北', '单层', '', '1', '瓦木', '已出租', '', '假', '0'); INSERT INTO `lesson` VALUES ('2753', '0101', 'A-125', '红军街', '我的物业', '', '', '', '', '', '未出租', '', '假', '0'); -- ---------------------------- -- Table structure for `ownerinfo` -- ---------------------------- DROP TABLE IF EXISTS `ownerinfo`; CREATE TABLE `ownerinfo` ( `owner_id` int(11) NOT NULL AUTO_INCREMENT, `owner_number` varchar(10) COLLATE utf8_bin DEFAULT NULL, `owner_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `owner_sex` varchar(2) COLLATE utf8_bin DEFAULT NULL, `owner_IDNumber` varchar(18) COLLATE utf8_bin DEFAULT NULL, `owner_phoneNumber` varchar(30) COLLATE utf8_bin DEFAULT NULL, `owner_address` varchar(50) COLLATE utf8_bin DEFAULT NULL, `owner_memo` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`owner_id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of ownerinfo -- ---------------------------- INSERT INTO `ownerinfo` VALUES ('1', '51', '李浩然', '男', '0101', '110', '山东省', null); INSERT INTO `ownerinfo` VALUES ('3', '51', '刘小曼', '女', '0202', '120', '河北省', null); INSERT INTO `ownerinfo` VALUES ('7', '53', '刘伟', '女', '0301', '114', '塘沽', null); INSERT INTO `ownerinfo` VALUES ('8', '54', '徐子超', '男', '1102', '119', '江西省', null); INSERT INTO `ownerinfo` VALUES ('10', '55', '刑亚文', '女', '0401', '911', '河南省', null); INSERT INTO `ownerinfo` VALUES ('12', '56', '刘承', '女', '0502', '10068', '黑龙江', null); INSERT INTO `ownerinfo` VALUES ('13', '57', '鲍宁', '男', '0303', '1008611', '山东省', null); INSERT INTO `ownerinfo` VALUES ('14', '58', '卢青', '女', '0911', '12706', '河北省', null); -- ---------------------------- -- Table structure for `propertyinfo` -- ---------------------------- DROP TABLE IF EXISTS `propertyinfo`; CREATE TABLE `propertyinfo` ( `property_id` int(11) NOT NULL AUTO_INCREMENT, `property_number` varchar(10) COLLATE utf8_bin DEFAULT NULL, `property_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `peoperty_developers` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`property_id`) ) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of propertyinfo -- ---------------------------- INSERT INTO `propertyinfo` VALUES ('0', '0001', '我的物业', ''); INSERT INTO `propertyinfo` VALUES ('1', '0002', '昆明世纪城', ''); INSERT INTO `propertyinfo` VALUES ('120', '003', '天津', '河北省'); -- ---------------------------- -- Table structure for `receiptway` -- ---------------------------- DROP TABLE IF EXISTS `receiptway`; CREATE TABLE `receiptway` ( `receipt_id` int(11) NOT NULL AUTO_INCREMENT, `receipt_code` varchar(10) COLLATE utf8_bin DEFAULT NULL, `receipt_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`receipt_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of receiptway -- ---------------------------- INSERT INTO `receiptway` VALUES ('1', '0001', '现金'); INSERT INTO `receiptway` VALUES ('2', '0002', '银行'); INSERT INTO `receiptway` VALUES ('3', '0003', '支付宝'); -- ---------------------------- -- Table structure for `rentclientsum` -- ---------------------------- DROP TABLE IF EXISTS `rentclientsum`; CREATE TABLE `rentclientsum` ( `clientname` varchar(20) COLLATE utf8_bin NOT NULL, `datanumber` varchar(20) COLLATE utf8_bin NOT NULL, `contractnumber` varchar(20) COLLATE utf8_bin NOT NULL, `recorddate` datetime NOT NULL, `contractsumoney` varchar(20) COLLATE utf8_bin NOT NULL, `abstract` varchar(30) COLLATE utf8_bin NOT NULL, `startdate` datetime NOT NULL, `enddate` datetime NOT NULL, `givemoney` varchar(20) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`clientname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of rentclientsum -- ---------------------------- -- ---------------------------- -- Table structure for `rentdetail` -- ---------------------------- DROP TABLE IF EXISTS `rentdetail`; CREATE TABLE `rentdetail` ( `rentD_id` int(11) NOT NULL AUTO_INCREMENT, `rentD_receiptNumber` varchar(15) COLLATE utf8_bin DEFAULT NULL, `rentD_receiptProgram` varchar(40) COLLATE utf8_bin DEFAULT NULL, `rentD_totalAmount` decimal(19,2) DEFAULT NULL, `rentD_memo` varchar(200) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`rentD_id`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of rentdetail -- ---------------------------- INSERT INTO `rentdetail` VALUES ('1', '10001', '租金', '6000.00', null); INSERT INTO `rentdetail` VALUES ('2', '10002', '租金', '21600.00', null); INSERT INTO `rentdetail` VALUES ('3', '10003', '租金', '21600.00', null); INSERT INTO `rentdetail` VALUES ('4', '10004', '租金', '25346.00', null); INSERT INTO `rentdetail` VALUES ('6', '10005', '租金', '2000.00', null); INSERT INTO `rentdetail` VALUES ('7', '10006', '租金', '1300.00', null); INSERT INTO `rentdetail` VALUES ('8', '10007', '租金', '2620.00', null); INSERT INTO `rentdetail` VALUES ('15', '10008', '租金', '1200.00', null); -- ---------------------------- -- Table structure for `renthouseinfor` -- ---------------------------- DROP TABLE IF EXISTS `renthouseinfor`; CREATE TABLE `renthouseinfor` ( `rentHouse_id` int(11) NOT NULL AUTO_INCREMENT, `rentHouse_number` varchar(20) COLLATE utf8_bin DEFAULT NULL, `rentHouse_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `rentHouse_belongFloor` varchar(50) COLLATE utf8_bin DEFAULT NULL, `property_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `rentHouse_direction` varchar(20) COLLATE utf8_bin DEFAULT NULL, `rentHouse_type` varchar(20) COLLATE utf8_bin DEFAULT NULL, `rentHouse_master` varchar(20) COLLATE utf8_bin DEFAULT NULL, `rentHouse_floor` varchar(10) COLLATE utf8_bin DEFAULT NULL, `rentHouse_structure` varchar(20) COLLATE utf8_bin DEFAULT NULL, `rentHouse_state` varchar(20) COLLATE utf8_bin DEFAULT NULL, `rentHouse_memo` varchar(50) COLLATE utf8_bin DEFAULT NULL, `rentHouse_pitch` varchar(2) COLLATE utf8_bin DEFAULT NULL, `rentHouse_aera` varchar(20) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`rentHouse_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2758 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of renthouseinfor -- ---------------------------- INSERT INTO `renthouseinfor` VALUES ('2737', '0001', '红军街112号', '红军街', '我的物业', '', '', '', '', '', '未出租', '', '假', '56'); INSERT INTO `renthouseinfor` VALUES ('2738', '0002', '红军街113号', '红军街', '我的物业', '', '', '', '', '', '已出租', '', '假', '65'); INSERT INTO `renthouseinfor` VALUES ('2743', '0003', 'A-120', '商务楼', '昆明世纪城', '坐南朝北', '单层', '浙江省农业科学院柑桔研究所', '1', '框架', '已出租', '', '假', ''); INSERT INTO `renthouseinfor` VALUES ('2744', '0004', 'A-121', '商务楼', '昆明世纪城', '坐南朝北', '单层', '浙江省农业科学院柑桔研究所', '3', '框架', '已出租', '', '假', '0'); INSERT INTO `renthouseinfor` VALUES ('2745', '0005', 'A-122', '商务楼', '昆明世纪城', '坐南朝北', '单层', '浙江省农业科学院柑桔研究所', '2', '瓦木', '已出租', '', '假', '0'); INSERT INTO `renthouseinfor` VALUES ('2746', '0006', 'A-123', '商务楼', '昆明世纪城', '坐南朝北', '单层', '浙江省农业科学院柑桔研究所', '2', '瓦木', '已出租', '', '假', ''); INSERT INTO `renthouseinfor` VALUES ('2750', '0007', 'A-125', '红军街', '我的物业', '坐南朝北', '单层', '', '1', '瓦木', '已出租', '', '假', '0'); INSERT INTO `renthouseinfor` VALUES ('2753', '0008', 'A-125', '红军街', '我的物业', '', '', '', '', '', '未出租', '', '假', '0'); INSERT INTO `renthouseinfor` VALUES ('2755', '0009', '商务楼11-01', '商务楼', '昆明世纪城', '坐南朝北', '单层', '刘小曼', '1', '瓦木', '未出租', '', null, '150'); -- ---------------------------- -- Table structure for `rentmoney` -- ---------------------------- DROP TABLE IF EXISTS `rentmoney`; CREATE TABLE `rentmoney` ( `rentM_id` int(11) NOT NULL AUTO_INCREMENT, `rentM_receiptNumber` varchar(15) COLLATE utf8_bin DEFAULT NULL, `rentM_receiptType` varchar(15) COLLATE utf8_bin DEFAULT NULL, `rentM_recordDate` datetime DEFAULT NULL, `rentM_receiptPeople` varchar(20) COLLATE utf8_bin DEFAULT NULL, `contract_number` varchar(20) COLLATE utf8_bin DEFAULT NULL, `billNumber` varchar(15) COLLATE utf8_bin DEFAULT NULL, `rentM_memo` varchar(200) COLLATE utf8_bin DEFAULT NULL, `startRentDate` datetime DEFAULT NULL, `endRentDate` datetime DEFAULT NULL, `rentM_sign` tinyint(4) DEFAULT NULL, `receipt_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`rentM_id`) ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of rentmoney -- ---------------------------- INSERT INTO `rentmoney` VALUES ('14', '10001', '租金收款', '2013-07-11 00:00:00', '管理员', '10001', null, null, '2013-07-01 00:00:00', '2013-07-31 00:00:00', null, null); INSERT INTO `rentmoney` VALUES ('15', '10002', '租金收款', '2014-07-22 00:00:00', '管理员', '10002', '456789', '', '2014-07-03 00:00:00', '2014-07-23 00:00:00', null, '银行'); INSERT INTO `rentmoney` VALUES ('19', '10003', '租金收款', '2012-10-21 00:00:00', '管理员', '10003', '', '', '2010-03-08 00:00:00', '2012-11-07 00:00:00', '0', '银行'); INSERT INTO `rentmoney` VALUES ('21', '10004', '租金收款', '2014-12-08 00:00:00', '管理员', '10004', '', '', '2014-07-02 00:00:00', '2014-12-24 00:00:00', null, '银行'); INSERT INTO `rentmoney` VALUES ('22', '10005', '租金收款', '2014-02-08 00:00:00', '管理员', '10005', '', '', '2014-01-02 00:00:00', '2014-07-24 00:00:00', null, '银行'); INSERT INTO `rentmoney` VALUES ('46', '10006', null, '2014-07-10 00:00:00', '管理员', '10008', '23', '23', '2014-06-03 00:00:00', '2014-07-10 00:00:00', null, '银行'); INSERT INTO `rentmoney` VALUES ('47', '10007', null, '2014-06-10 00:00:00', '管理员', '10008', '23', '23', '2014-06-03 00:00:00', '2014-07-10 00:00:00', null, '银行'); -- ---------------------------- -- Table structure for `rentroom` -- ---------------------------- DROP TABLE IF EXISTS `rentroom`; CREATE TABLE `rentroom` ( `rentR_id` int(11) NOT NULL AUTO_INCREMENT, `rentR_contractNumber` varchar(20) COLLATE utf8_bin DEFAULT NULL, `rentR_roomNumber` varchar(20) COLLATE utf8_bin DEFAULT NULL, `rentR_roomName` varchar(30) COLLATE utf8_bin DEFAULT NULL, `rentR_ownFloor` varchar(50) COLLATE utf8_bin DEFAULT NULL, `rentR_monthRent` decimal(19,2) DEFAULT NULL, PRIMARY KEY (`rentR_id`) ) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of rentroom -- ---------------------------- INSERT INTO `rentroom` VALUES ('2', '10007', '777', 'A_132', null, '1234.00'); INSERT INTO `rentroom` VALUES ('10', '10002', '0001', 'A-121', null, '1230.00'); INSERT INTO `rentroom` VALUES ('11', '10003', '0098', 'A-122', null, '2330.00'); INSERT INTO `rentroom` VALUES ('12', '10004', '0097', 'A-124', null, '32.00'); INSERT INTO `rentroom` VALUES ('19', '10005', '0002', 'A-126', null, '22220.00'); INSERT INTO `rentroom` VALUES ('55', '10001', '00003', 'A-555', null, '6000.00'); INSERT INTO `rentroom` VALUES ('126', '10006', '666', 'A-131', null, '1200.00'); INSERT INTO `rentroom` VALUES ('147', '10008', null, null, null, '23.00'); INSERT INTO `rentroom` VALUES ('148', '10008', null, null, null, '23.00'); -- ---------------------------- -- Table structure for `user` -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `user_pwd` varchar(50) COLLATE utf8_bin DEFAULT NULL, `user_manage` tinyint(4) DEFAULT NULL, `user_info` tinyint(4) DEFAULT NULL, `rentManage` tinyint(4) DEFAULT NULL, `financeManage` tinyint(4) DEFAULT NULL, `dataManage` tinyint(4) DEFAULT NULL, `statisticForm` tinyint(4) DEFAULT NULL, `registerDate` datetime DEFAULT NULL, `lastDate` datetime DEFAULT NULL, `startDays` int(11) DEFAULT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('2', '管理员', '8888', '1', '1', '1', '1', '1', '1', '2014-06-08 11:19:12', '2014-06-13 09:09:32', '5'); INSERT INTO `user` VALUES ('10', '张三', '8888', '0', '1', '0', '0', '1', '0', null, null, null); INSERT INTO `user` VALUES ('11', 'zs', '1234', '1', '0', '0', '0', '0', '0', null, null, null);
