J2EE大学生C2C网上交易平台(hibernate+spring+struts2) Edit Add topics 附上数据库结构
/* Navicat Premium Data Transfer
Source Server : mysql Source Server Type : MySQL Source Server Version : 50717 Source Host : localhost Source Database : WebShop
Target Server Type : MySQL Target Server Version : 50717 File Encoding : utf-8
Date: 03/23/2017 20:41:43 PM */
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0;
-- Table structure for BANNER
DROP TABLE IF EXISTS BANNER; CREATE TABLE BANNER ( BANNDERID int(11) NOT NULL AUTO_INCREMENT, BANNERIMAGE varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (BANNDERID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Table structure for CONTACTLEAVE
DROP TABLE IF EXISTS CONTACTLEAVE; CREATE TABLE CONTACTLEAVE ( CONTACTID int(11) NOT NULL AUTO_INCREMENT, SENDUSER int(11) DEFAULT NULL, MESSAGE varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, MOBILEPHONE varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, GOOD int(11) DEFAULT NULL, PRIMARY KEY (CONTACTID), KEY FK_10e0205b68d749f88bcb0f5b5ac (SENDUSER), KEY FK_957bf93608e94148b908df432f0 (GOOD), CONSTRAINT FK_10e0205b68d749f88bcb0f5b5ac FOREIGN KEY (SENDUSER) REFERENCES USER (USER_ID), CONSTRAINT FK_957bf93608e94148b908df432f0 FOREIGN KEY (GOOD) REFERENCES GOOD (GOODID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Table structure for GOOD
DROP TABLE IF EXISTS GOOD; CREATE TABLE GOOD ( GOODID int(11) NOT NULL AUTO_INCREMENT, GOODNAME varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, GOODNUM int(11) DEFAULT NULL, FORMERPRICE double DEFAULT NULL, SALEPRICE double DEFAULT NULL, ISSALE tinyint(1) DEFAULT NULL, CREATEDATE date DEFAULT NULL, GOODTYPE int(11) DEFAULT NULL, GOODFROM int(11) DEFAULT NULL, GOODDESCRIPTION varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, GOODUSER int(11) DEFAULT NULL, PHONENUMBER varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, IMAGES varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, GOODWATCHNUM int(11) DEFAULT NULL, FIRSTIMAGE varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, ISGET tinyint(1) DEFAULT NULL, PRIMARY KEY (GOODID), KEY FK_a84479e264874788b15c9a4132f (GOODUSER), CONSTRAINT FK_a84479e264874788b15c9a4132f FOREIGN KEY (GOODUSER) REFERENCES USER (USER_ID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Table structure for GOODCOMPLETE
DROP TABLE IF EXISTS GOODCOMPLETE; CREATE TABLE GOODCOMPLETE ( GOODCOMPLETEID int(11) NOT NULL AUTO_INCREMENT, OWNERUSER int(11) DEFAULT NULL, GOODID int(11) DEFAULT NULL, PRIMARY KEY (GOODCOMPLETEID), KEY FK_2585867b89bb4a978b3d8528e70 (OWNERUSER), KEY FK_242371958c264fe2b7fc35548b0 (GOODID), CONSTRAINT FK_242371958c264fe2b7fc35548b0 FOREIGN KEY (GOODID) REFERENCES GOOD (GOODID), CONSTRAINT FK_2585867b89bb4a978b3d8528e70 FOREIGN KEY (OWNERUSER) REFERENCES USER (USER_ID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Table structure for STUDENT
DROP TABLE IF EXISTS STUDENT; CREATE TABLE STUDENT ( SID bigint(20) NOT NULL, STUDENTNAME varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, USER int(11) DEFAULT NULL, PRIMARY KEY (SID), KEY FK_72a11cc5adc141548e3bb275f9c (USER), CONSTRAINT FK_72a11cc5adc141548e3bb275f9c FOREIGN KEY (USER) REFERENCES USER (USER_ID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Table structure for USER
DROP TABLE IF EXISTS USER; CREATE TABLE USER ( USER_ID int(11) NOT NULL AUTO_INCREMENT, USER_USERNAME varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, USER_PASSWORD varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, REGISTER_DATE date DEFAULT NULL, DENIED tinyint(1) DEFAULT NULL, MANAGER tinyint(1) DEFAULT NULL, VERIFY tinyint(1) DEFAULT NULL, HEADIMAGE varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, EMAIL varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, ISEMAILVERIFY tinyint(1) DEFAULT NULL, PRIMARY KEY (USER_ID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Table structure for USERLEAVEMESSAGE
DROP TABLE IF EXISTS USERLEAVEMESSAGE; CREATE TABLE USERLEAVEMESSAGE ( USERLEAVEMESSAGEID int(11) NOT NULL AUTO_INCREMENT, GOOD int(11) DEFAULT NULL, CREATEDATE date DEFAULT NULL, CONTEXT varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, USER int(11) DEFAULT NULL, PRIMARY KEY (USERLEAVEMESSAGEID), KEY FK_c3a79b4de4b840edab01666b713 (GOOD), KEY FK_8f7fbafb87e24e95a917344941d (USER), CONSTRAINT FK_8f7fbafb87e24e95a917344941d FOREIGN KEY (USER) REFERENCES USER (USER_ID), CONSTRAINT FK_c3a79b4de4b840edab01666b713 FOREIGN KEY (GOOD) REFERENCES GOOD (GOODID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET FOREIGN_KEY_CHECKS = 1;