基于java的物流信息管理系统（计算机毕业设计）

数据库设计

---

CREATE TABLE admin (

id int(11) NOT NULL auto_increment,

userName varchar(100) default ‘’,

userPw varchar(100) default ‘’,

rname varchar(100) default ‘’,

zhi varchar(100) default ‘’,

tel varchar(100) default ‘’,

age varchar(100) default ‘’,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE car (

id int(11) NOT NULL auto_increment,

pai varchar(100) default ‘’,

size varchar(100) default ‘’,

type varchar(100) default ‘’,

state varchar(100) default ‘’,

info varchar(100) default ‘’,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE chuku (

id int(11) NOT NULL auto_increment,

danhao varchar(100) default ‘’,

kuname varchar(200) default ‘’,

info varchar(100) default ‘’,

appuser varchar(100) default ‘’,

date varchar(100) default ‘’,

car varchar(100) default ‘’,

tokuname varchar(200) default ‘’,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE daninfo (

id int(11) NOT NULL auto_increment,

yunid int(11) default NULL,

danhao varchar(100) default ‘’,

state varchar(100) default ‘’,

date varchar(100) default ‘’,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE ku (

id int(11) NOT NULL auto_increment,

name varchar(100) default ‘’,

address varchar(200) default ‘’,

fuze varchar(100) default ‘’,

tel varchar(100) default ‘’,

beizhu varchar(500) default ‘’,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I

CREATE TABLE message (

id int(11) NOT NULL auto_increment,

msg longtext,

appuser varchar(100) default ‘’,

date varchar(100) default ‘’,

reply longtext,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO message VALUES (21,‘你们的联系方式是多少’,‘zhangsan’,‘2016-02-24 15:55:09’,‘010-123456’);

CREATE TABLE news (

id int(11) NOT NULL auto_increment,

title varchar(100) default ‘’,

date varchar(100) default ‘’,

info longtext,

appuser varchar(100) default ‘’,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE qian (

id int(11) NOT NULL auto_increment,

danhao varchar(200) default NULL,

qname varchar(200) default NULL,

qdate varchar(200) default NULL,

jsr varchar(200) default NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE ruku (

id int(11) NOT NULL auto_increment,

danhao varchar(100) default ‘’,

kuname varchar(100) default ‘’,

info longtext,

appuser varchar(100) default ‘’,

date varchar(100) default ‘’,

car varchar(100) default ‘’,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE userinfo (