基于 springboot 开发的国际物流管理系统，花费近一年时间整理的 Java 核心知识清单
– Table structure for customerinfo
DROP TABLE IF EXISTS customerinfo;
CREATE TABLE customerinfo (
customer_code varchar(50) NOT NULL,
address varchar(50) DEFAULT NULL,
customer varchar(50) DEFAULT NULL,
customer_type varchar(50) DEFAULT NULL,
email varchar(50) DEFAULT NULL,
enterprise_property varchar(50) DEFAULT NULL,
enterprise_size varchar(50) DEFAULT NULL,
fax varchar(50) DEFAULT NULL,
linkman varchar(50) DEFAULT NULL,
linkman_mobile varchar(50) DEFAULT NULL,
phone varchar(50) DEFAULT NULL,
post_code varchar(50) DEFAULT NULL,
PRIMARY KEY (customer_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of customerinfo
– Table structure for customerreceiptinfo
DROP TABLE IF EXISTS customerreceiptinfo;
CREATE TABLE customerreceiptinfo (
id int(11) NOT NULL AUTO_INCREMENT,
carry_bill_event_id int(11) NOT NULL,
check_goods_record varchar(50) DEFAULT NULL,
customer varchar(50) DEFAULT NULL,
goods_bill_code varchar(50) DEFAULT NULL,
receive_goods_date date DEFAULT NULL,
receive_goods_person varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of customerreceiptinfo
– Table structure for driveramount
DROP TABLE IF EXISTS driveramount;
CREATE TABLE driveramount (
driver_code varchar(50) NOT NULL,
add_carriage_total double NOT NULL,
carry_fee_total double NOT NULL,
total double NOT NULL,
PRIMARY KEY (driver_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of driveramount
– Table structure for driverclear
DROP TABLE IF EXISTS driverclear;
CREATE TABLE driverclear (
back_bill_code varchar(50) NOT NULL,
add_carriage double DEFAULT NULL,
balance double DEFAULT NULL,
balance_time date DEFAULT NULL,
balance_type varchar(50) DEFAULT NULL,
bind_insurance double DEFAULT NULL,
carry_fee double DEFAULT NULL,
dispatch_service_fee double DEFAULT NULL,
driver_code varchar(50) DEFAULT NULL,
insurance double DEFAULT NULL,
need_payment double DEFAULT NULL,
payed_money double DEFAULT NULL,
prepay_money double DEFAULT NULL,
PRIMARY KEY (back_bill_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of driverclear
– Table structure for driverinfo
DROP TABLE IF EXISTS driverinfo;
CREATE TABLE driverinfo (
id varchar(50) NOT NULL,
address varchar(50) DEFAULT NULL,
allow_carry_volume double DEFAULT NULL,
allow_carry_weight double DEFAULT NULL,
birthday date DEFAULT NULL,
biz_licence varchar(50) DEFAULT NULL,
car_dept varchar(50) DEFAULT NULL,
car_dept_tel varchar(50) DEFAULT NULL,
car_frame_no varchar(50) DEFAULT NULL,
car_length varchar(50) DEFAULT NULL,
car_no varchar(50) DEFAULT NULL,
car_type varchar(50) DEFAULT NULL,
car_width varchar(50) DEFAULT NULL,
company_car bit(1) NOT NULL,
drive_licence varchar(50) DEFAULT NULL,
driver_name varchar(50) DEFAULT NULL,
engine_no varchar(50) DEFAULT NULL,
gender varchar(50) DEFAULT NULL,
goods_height varchar(50) DEFAULT NULL,
id_card varchar(50) DEFAULT NULL,
insurance_card varchar(50) DEFAULT NULL,
phone varchar(50) DEFAULT NULL,
remark varchar(50) DEFAULT NULL,
run_licence varchar(50) DEFAULT NULL,
state varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of driverinfo
– Table structure for employee
DROP TABLE IF EXISTS employee;
CREATE TABLE employee (
employee_code varchar(50) NOT NULL,
birthday date DEFAULT NULL,
department varchar(50) DEFAULT NULL,
employee_name varchar(50) DEFAULT NULL,
gender varchar(50) DEFAULT NULL,
position varchar(50) DEFAULT NULL,
PRIMARY KEY (employee_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of employee
– Table structure for employeeuser
DROP TABLE IF EXISTS employeeuser;
CREATE TABLE employeeuser (
id int(11) NOT NULL AUTO_INCREMENT,
employee_id int(11) NOT NULL,
user_id int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of employeeuser
– Table structure for employeewage
DROP TABLE IF EXISTS employeewage;
CREATE TABLE employeewage (
id int(11) NOT NULL AUTO_INCREMENT,
allowance double NOT NULL,
basic_wage double NOT NULL,
date date DEFAULT NULL,
employee varchar(50) DEFAULT NULL,
`employee
_code` varchar(50) NOT NULL,
station_wage double NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of employeewage
– Table structure for extraclear
DROP TABLE IF EXISTS extraclear;
CREATE TABLE extraclear (
id int(11) NOT NULL AUTO_INCREMENT,
balance_date date DEFAULT NULL,
balance_money double DEFAULT NULL,
balance_type varchar(50) DEFAULT NULL,
remark varchar(50) DEFAULT NULL,
subject_name varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of extraclear
– Table structure for extraincome
DROP TABLE IF EXISTS extraincome;
CREATE TABLE extraincome (
id int(11) NOT NULL AUTO_INCREMENT,
income_month varchar(255) DEFAULT NULL,
money double NOT NULL,
name varchar(50) DEFAULT NULL,
write_date date DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of extraincome
– Table structure for financefee
DROP TABLE IF EXISTS financefee;
CREATE TABLE financefee (
id int(11) NOT NULL AUTO_INCREMENT,
fee double NOT NULL,
payout_month varchar(255) DEFAULT NULL,
write_date date DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of financefee
– Table structure for functionwithgroup
DROP TABLE IF EXISTS functionwithgroup;
CREATE TABLE functionwithgroup (
id int(11) NOT NULL AUTO_INCREMENT,
function_id int(11) NOT NULL,
group_id int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
– Records of functionwithgroup
INSERT INTO functionwithgroup VALUES (‘1’, ‘1’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘2’, ‘2’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘3’, ‘3’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘4’, ‘4’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘5’, ‘5’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘6’, ‘6’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘7’, ‘7’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘8’, ‘8’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘9’, ‘9’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘10’, ‘10’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘11’, ‘11’, ‘1’);
– Table structure for function_
DROP TABLE IF EXISTS function_;
CREATE TABLE function_ (
id int(11) NOT NULL AUTO_INCREMENT,
page_function varchar(50) DEFAULT NULL,
page_name varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
– Records of function_
INSERT INTO function_ VALUES (‘1’, null, ‘票据管理’);
INSERT INTO function_ VALUES (‘2’, null, ‘接货管理’);
INSERT INTO function_ VALUES (‘3’, null, ‘配车管理’);
INSERT INTO function_ VALUES (‘4’, null, ‘到货管理’);
INSERT INTO function_ VALUES (‘5’, null, ‘中转管理’);
INSERT INTO function_ VALUES (‘6’, null, ‘结算管理’);
INSERT INTO function_ VALUES (‘7’, null, ‘客户服务’);
INSERT INTO function_ VALUES (‘8’, null, ‘监控分析’);
INSERT INTO function_ VALUES (‘9’, null, ‘成本核算’);
INSERT INTO function_ VALUES (‘10’, null, ‘应用管理’);
INSERT INTO function_ VALUES (‘11’, null, ‘系统管理’);
– Table structure for goodsbill
DROP TABLE IF EXISTS goodsbill;
CREATE TABLE goodsbill (
goods_bill_code varchar(50) NOT NULL,
accept_procedure_rate varchar(50) DEFAULT NULL,
accept_station varchar(100) DEFAULT NULL,
carriage double DEFAULT NULL,
carry_goods_fee double DEFAULT NULL,
employee_code varchar(50) DEFAULT NULL,
fact_deal_date date DEFAULT NULL,
fetch_goods_mode varchar(50) DEFAULT NULL,
help_accept_payment double DEFAULT NULL,
if_audit bit(1) DEFAULT NULL,
if_settle_accounts bit(1) DEFAULT NULL,
insurance double DEFAULT NULL,
money_of_change_pay double DEFAULT NULL,
pay_kickback double DEFAULT NULL,
pay_mode varchar(50) DEFAULT NULL,
predelivery_date date DEFAULT NULL,
receive_goods_addr varchar(50) DEFAULT NULL,
receive_goods_customer varchar(50) DEFAULT NULL,
receive_goods_customer_addr varchar(50) DEFAULT NULL,
receive_goods_customer_code varchar(50) DEFAULT NULL,
receive_goods_customer_tel varchar(50) DEFAULT NULL,
reduce_fund double DEFAULT NULL,
remark varchar(50) DEFAULT NULL,
send_goods_addr varchar(50) DEFAULT NULL,
send_goods_customer varchar(50) DEFAULT NULL,
send_goods_customer_addr varchar(50) DEFAULT NULL,
send_goods_customer_no varchar(50) DEFAULT NULL,
send_goods_customer_tel varchar(50) DEFAULT NULL,
send_goods_date date DEFAULT NULL,
transfer_fee double DEFAULT NULL,
transfer_station varchar(50) DEFAULT NULL,
validity bit(1) DEFAULT NULL,
write_bill_person varchar(50) DEFAULT NULL,
write_date date DEFAULT NULL,
PRIMARY KEY (goods_bill_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of goodsbill
– Table structure for goodsbillevent
DROP TABLE IF EXISTS goodsbillevent;
CREATE TABLE goodsbillevent (
goods_bill_id varchar(50) NOT NULL,
event_name varchar(50) NOT NULL,
occur_time datetime(6) DEFAULT NULL,
remark varchar(50) NOT NULL,
PRIMARY KEY (goods_bill_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of goodsbillevent
– Table structure for goodsreceiptinfo
DROP TABLE IF EXISTS goodsreceiptinfo;
CREATE TABLE goodsreceiptinfo (
id int(11) NOT NULL AUTO_INCREMENT,
check_goods_record varchar(50) DEFAULT NULL,
driver_name varchar(50) DEFAULT NULL,
goods_revert_code varchar(50) DEFAULT NULL,
rceive_goods_date date DEFAULT NULL,
receive_goods_person varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of goodsreceiptinfo
– Table structure for incomemonthlytemp
DROP TABLE IF EXISTS incomemonthlytemp;
CREATE TABLE incomemonthlytemp (
id int(11) NOT NULL AUTO_INCREMENT,
biz_fee double NOT NULL,
biz_income double NOT NULL,
car_carriage double NOT NULL,
carriage_money double NOT NULL,
convey_wage double NOT NULL,
finance_fee double NOT NULL,
house_rent double NOT NULL,
income double NOT NULL,
insurance_money double NOT NULL,
manage_fee double NOT NULL,
month varchar(255) DEFAULT NULL,
office_fee double NOT NULL,
other double NOT NULL,
payout double NOT NULL,
phone_fee double NOT NULL,
profit double NOT NULL,
unbiz_income double NOT NULL,
wage double NOT NULL,
water_elec_fee double NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
– Records of incomemonthlytemp
INSERT INTO incomemonthlytemp VALUES (‘1’, ‘500’, ‘0’, ‘500’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘2018-11’, ‘0’, ‘0’, ‘500’, ‘0’, ‘-500’, ‘0’, ‘0’, ‘0’);
– Table structure for lineoverall
DROP TABLE IF EXISTS lineoverall;
CREATE TABLE lineoverall (
id int(11) NOT NULL AUTO_INCREMENT,
all_carriage_total double NOT NULL,
deal_goods_station varchar(50) DEFAULT NULL,
insurance_total double NOT NULL,
load_station varchar(50) DEFAULT NULL,
times int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of lineoverall
– Table structure for managefee
DROP TABLE IF EXISTS managefee;
CREATE TABLE managefee (
id int(11) NOT NULL AUTO_INCREMENT,
house_rent double NOT NULL,
office_fee double NOT NULL,
other_payout double NOT NULL,
payout_month varchar(255) DEFAULT NULL,
phone_fee double NOT NULL,
water_elec_fee double NOT NULL,
write_date date DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of managefee
– Table structure for proxyfeeclear
DROP TABLE IF EXISTS proxyfeeclear;
CREATE TABLE proxyfeeclear (
goods_bill_code varchar(50) NOT NULL,
account_receivable double DEFAULT NULL,
balance_date date DEFAULT NULL,
commision_rate float DEFAULT NULL,
commision_receivable double DEFAULT NULL,
customer_code varchar(50) DEFAULT NULL,
fact_receive_fund double DEFAULT NULL,
goods_pay_change double DEFAULT NULL,
received_commision double DEFAULT NULL,
PRIMARY KEY (goods_bill_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of proxyfeeclear
– Table structure for region
DROP TABLE IF EXISTS region;
CREATE TABLE region (
id int(11) NOT NULL AUTO_INCREMENT,
city varchar(50) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
– Records of region
INSERT INTO region VALUES (‘1’, ‘南京’);
INSERT INTO region VALUES (‘2’, ‘常州’);
INSERT INTO region VALUES (‘3’, ‘镇江’);
INSERT INTO region VALUES (‘4’, ‘无锡’);
INSERT INTO region VALUES (‘5’, ‘苏州’);
INSERT INTO region VALUES (‘6’, ‘上海’);
– Table structure for routeinfo
DROP TABLE IF EXISTS routeinfo;
CREATE TABLE routeinfo (
id int(11) NOT NULL AUTO_INCREMENT,
distance double NOT NULL,
end_station int(11) DEFAULT NULL,
fetch_time double NOT NULL,
pass_station varchar(100) DEFAULT NULL,
start_station int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of routeinfo
– Table structure for sentlist
DROP TABLE IF EXISTS sentlist;
CREATE TABLE sentlist (
id int(11) NOT NULL AUTO_INCREMENT,
back_cost double NOT NULL,
car_card_no varchar(50) DEFAULT NULL,
cash_pay double NOT NULL,
driver_name varchar(50) DEFAULT NULL,
goods_code varchar(50) DEFAULT NULL,
goods_name varchar(50) DEFAULT NULL,
goods_revert_bill_code varchar(50) DEFAULT NULL,
help_accept_fund varchar(50) DEFAULT NULL,
mobile varchar(50) DEFAULT NULL,
pickup_pay double NOT NULL,
piece_amount int(11) NOT NULL,
remark varchar(50) DEFAULT NULL,
send_goods_customer varchar(50) DEFAULT NULL,
send_goods_customer_tel varchar(50) DEFAULT NULL,
transfer_destination varchar(50) DEFAULT NULL,
user_id int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of sentlist
– Table structure for transfercominfo
DROP TABLE IF EXISTS transfercominfo;
CREATE TABLE transfercominfo (
id int(11) NOT NULL AUTO_INCREMENT,
city varchar(50) DEFAULT NULL,
company_name varchar(50) DEFAULT NULL,
detail_address varchar(200) DEFAULT NULL,
link_phone varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of transfercominfo
– Table structure for transferinfo
DROP TABLE IF EXISTS transferinfo;
CREATE TABLE transferinfo (
id int(11) NOT NULL AUTO_INCREMENT,
after_transfer_bill varchar(50) DEFAULT NULL,
check_time date DEFAULT NULL,
description varchar(50) DEFAULT NULL,
goods_bill_code varchar(50) DEFAULT NULL,
transfer_addr varchar(50) DEFAULT NULL,
transfer_check varchar(50) DEFAULT NULL,
transfer_company varchar(50) DEFAULT NULL,
transfer_fee double DEFAULT NULL,
transfer_station varchar(50) DEFAULT NULL,
transfer_station_tel varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of transferinfo
– Table structure for user
还未添加个人签名 2021.03.18 加入
还未添加个人简介
评论