项目数据库设计

CREATE DATABASE IF NOT EXISTS`pet_shop`
DEFAULT CHARACTER SET utf8 ;
USE `pet_shop`;
Table structure for table `accouent`
DROP TABLE IF EXISTS `accouent`;
CREATE TABLE `accouent` (
`id` int(4) NOT NULL,
`deal_type` int(4) NOT NULL,
`pet_id` int(4) NOT NULL,
`seller_id` int(4) NOT NULL,
`buyer_id` int(4) NOT NULL,
`price` int(4) DEFAULT NULL,
`deal_tame` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Data for the table `accouent`
Table structure for table `master`
DROP TABLE IF EXISTS `master`;
CREATE TABLE `master` (
`id` int(4) NOT NULL,
`name` varchar(10) DEFAULT NULL,
`password` varchar(10) DEFAULT NULL,
`money` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Data for the table `master`
Table structure for table `pet`
DROP TABLE IF EXISTS `pet`;
CREATE TABLE `pet` (
`id` int(4) NOT NULL,
`name` varchar(50) DEFAULT NULL,
`type_name` varchar(20) DEFAULT NULL,
`health` int(4) DEFAULT NULL,
`love` int(4) DEFAULT NULL,
`birthday` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`ower_id` int(4) DEFAULT NULL,
`store` int(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Data for the table `pet`
Table structure for table `pet_store`
DROP TABLE IF EXISTS `pet_store`;
CREATE TABLE `pet_store` (
`id` int(4) NOT NULL,
`name` varchar(10) DEFAULT NULL,
`password` varchar(10) DEFAULT NULL,
`balance` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Data for the table `pet_store`
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS ,
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS,
40111 SET SQL_NOTES=@OLD_SQL_NOTES;