基于Springmvc+Spring+Mybatis+Jqueryeasyui个人信息管理平台（数据库+源码）-适合毕设

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