/*
MySQL Data Transfer
Source Host: localhost
Source Database: bfw
Target Host: localhost
Target Database: bfw
Date: 2015/5/5 0:31:58
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_seting_info
-- ----------------------------
CREATE TABLE `account_seting_info` (
`account_id` int(11) NOT NULL auto_increment,
`user_number` varchar(100) default NULL,
`account_name` varchar(100) default NULL,
`account_crad` varchar(100) default NULL,
`account_man` varchar(100) default NULL,
`account_datetime` datetime default NULL,
`account_type` varchar(50) default NULL,
`account_currency` varchar(50) default NULL,
`account_money` double default NULL,
`account_desc` varchar(2000) default NULL,
PRIMARY KEY (`account_id`),
KEY `FK_Reference_5` (`user_number`),
CONSTRAINT `FK_Reference_5` FOREIGN KEY (`user_number`) REFERENCES `user_info` (`user_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for asset_managerment
-- ----------------------------
CREATE TABLE `asset_managerment` (
`asset_id` int(11) NOT NULL auto_increment,
`user_number` varchar(100) default NULL,
`asset_name` varchar(100) default NULL,
`asset_type` varchar(100) default NULL,
`asset_source` varchar(100) default NULL,
`asset_number` varchar(100) default NULL,
`asset_money` double default NULL,
`asset_datetime` datetime default NULL,
`asset_state` varchar(10) default NULL,
`asset_desc` varchar(2000) default NULL,
PRIMARY KEY (`asset_id`),
KEY `FK_Reference_6` (`user_number`),
CONSTRAINT `FK_Reference_6` FOREIGN KEY (`user_number`) REFERENCES `user_info` (`user_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for data_dictionaries_info
-- ----------------------------
CREATE TABLE `data_dictionaries_info` (
`data_info_id` int(11) NOT NULL auto_increment,
`data_type_id` int(11) default NULL,
`data_info_name` varchar(100) default NULL,
`data_info_mark` varchar(10) default NULL,
`data_info_seq` int(11) default NULL,
PRIMARY KEY (`data_info_id`),
KEY `FK_Reference_2` (`data_type_id`),
CONSTRAINT `FK_Reference_2` FOREIGN KEY (`data_type_id`) REFERENCES `data_dictionaries_type` (`data_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for data_dictionaries_type
-- ----------------------------
CREATE TABLE `data_dictionaries_type` (
`data_type_id` int(11) NOT NULL auto_increment,
`data_type_name` varchar(100) default NULL,
`data_type_mark` varchar(10) default NULL,
PRIMARY KEY (`data_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for debt_categories
-- ----------------------------
CREATE TABLE `debt_categories` (
`debt_categories_id` int(11) NOT NULL auto_increment,
`account_id` int(11) default NULL,
`debt_categories_datetime` datetime default NULL,
`debt_categories_type` varchar(100) default NULL,
`debt_borrow_money` double default NULL,
`debt_borrow_man` varchar(100) default NULL,
`debt_categories_man` varchar(100) default NULL,
`debt_categories_currency` varchar(50) default NULL,
`debt_desc` varchar(2000) default NULL,
PRIMARY KEY (`debt_categories_id`),
KEY `FK_Reference_9` (`account_id`),
CONSTRAINT `FK_Reference_9` FOREIGN KEY (`account_id`) REFERENCES `account_seting_info` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for deposit_info
-- ----------------------------
CREATE TABLE `deposit_info` (
`deposit_id` int(11) NOT NULL auto_increment,
`account_id` int(11) default NULL,
`deposit_datetime` datetime default NULL,
`deposit_bank_name` varchar(100) default NULL,
`deposit_source_funds` varchar(100) default NULL,
`deposit_amount` double default NULL,
`deposit_man` varchar(100) default NULL,
`deposit_desc` varchar(2000) default NULL,
PRIMARY KEY (`deposit_id`),
KEY `FK_Reference_7` (`account_id`),
CONSTRAINT `FK_Reference_7` FOREIGN KEY (`account_id`) REFERENCES `account_seting_info` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for diary_mangement_info
-- ----------------------------
CREATE TABLE `diary_mangement_info` (
`diary_mangement_id` int(11) NOT NULL auto_increment,
`user_number` varchar(100) default NULL,
`warther_type_id` int(11) default NULL,
`diary_type_id` int(11) default NULL,
`mood_id` int(11) default NULL,
`diary_mangement_datetime` datetime default NULL,
`diary_mangement_title` varchar(200) default NULL,
`diary_mangement_content` varchar(2000) default NULL,
PRIMARY KEY (`diary_mangement_id`),
KEY `FK_Reference_16` (`user_number`),
KEY `FK_Reference_20` (`warther_type_id`),
KEY `FK_Reference_21` (`diary_type_id`),
KEY `FK_Reference_22` (`mood_id`),
CONSTRAINT `FK_Reference_16` FOREIGN KEY (`user_number`) REFERENCES `user_info` (`user_number`),
CONSTRAINT `FK_Reference_20` FOREIGN KEY (`warther_type_id`) REFERENCES `warther_type` (`warther_type_id`),
CONSTRAINT `FK_Reference_21` FOREIGN KEY (`diary_type_id`) REFERENCES `diary_type` (`diary_type_id`),
CONSTRAINT `FK_Reference_22` FOREIGN KEY (`mood_id`) REFERENCES `mood_manegement` (`mood_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for diary_type
-- ----------------------------
CREATE TABLE `diary_type` (
`diary_type_id` int(11) NOT NULL auto_increment,
`user_number` varchar(100) default NULL,
`diary_type_name` varchar(100) default NULL,
`diary_type_desc` varchar(1000) default NULL,
`diary_type_mark` varchar(10) default NULL,
PRIMARY KEY (`diary_type_id`),
KEY `FK_Reference_17` (`user_number`),
CONSTRAINT `FK_Reference_17` FOREIGN KEY (`user_number`) REFERENCES `user_info` (`user_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for family_info
-- ----------------------------
CREATE TABLE `family_info` (
`family_id` int(11) NOT NULL auto_increment,
`user_number` varchar(100) default NULL,
`family_name` varchar(100) default NULL,
`family_sex` varchar(10) default NULL,
`family_age` int(11) default NULL,
`family_birthday` varchar(50) default NULL,
`family_relationship` varchar(50) default NULL,
PRIMARY KEY (`family_id`),
KEY `FK_Reference_1` (`user_number`),
CONSTRAINT `FK_Reference_1` FOREIGN KEY (`user_number`) REFERENCES `user_info` (`user_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for finamcicl_planning
-- ----------------------------
CREATE TABLE `finamcicl_planning` (
`plan_id` int(11) NOT NULL auto_increment,
`user_number` varchar(100) default NULL,
`plan_name` varchar(100) default NULL,
`plan_goal` varchar(100) default NULL,
`plan_total_money` double default NULL,
`plan_current` double default NULL,
`planning_cycle` varchar(100) default NULL,
`plan_monthly` varchar(100) default NULL,
`plan_execute_time` datetime default NULL,
`plan_starttime` datetime default NULL,
`plan_endtime` datetime default NULL,
`plan_desc` varchar(2000) default NULL,
PRIMARY KEY (`plan_id`),
KEY `FK_Reference_10` (`user_number`),
CONSTRAINT `FK_Reference_10` FOREIGN KEY (`user_number`) REFERENCES `user_info` (`user_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for friends_management_info
-- ----------------------------
CREATE TABLE `friends_management_info` (
`friends_id` int(11) NOT NULL auto_increment,
`group_seting_id` int(11) default NULL,
`friends_name` varchar(100) default NULL,
`friends_sex` varchar(10) default NULL,
`friends_age` int(11) default NULL,
`friends_birthday` varchar(100) default NULL,
`friends_email` varchar(100) default NULL,
`friends_phone` varchar(100) default NULL,
`friends_
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
项目模块内容: 1、日记管理(天气,心情,日记类型,查询日记) 2、公共记录(资料网站记录,火车票网站) 3、知识库管理 4、人脉管理(好友、同事、家人) 5、个人财产管理(收入、支出、理财计划、我的财产记录、我的债务、家庭预算) 6、日程管理(工作计划和时间的管理) 7、工作台(报表) 7、个人信息管理平台系统 Spring+SpringMVC+MyBatis(半自动化ORM)+MySQL+jQuery EasyUI 技能储备:jQuery EasyUI+MyBatis 增加、修改、删除、查询示例 需求分析 物理模型PDM(数据库设计) 具体编码
资源推荐
资源详情
资源评论
收起资源包目录
基于Springmvc+Spring+Mybatis+Jqueryeasyui个人信息管理平台.rar (3个子文件)
基于Springmvc+Spring+Mybatis+Jqueryeasyui个人信息管理平台
文档
bfw.sql 33KB
个人信息管理平台.pdm 188KB
代码
self.rar 24.24MB
共 3 条
- 1
资源评论
跟风舞烟学编程
- 粉丝: 47
- 资源: 52
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功