– Records of customerbillclear

– 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

最后

光给面试题不给答案不是我的风格。这里面的面试题也只是凤毛麟角，还有答案的话会极大的增加文章的篇幅，减少文章的可读性

**[CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频】](

)**

Java面试宝典2021版

最常见Java面试题解析（2021最新版）

2021企业Java面试题精选

本文已被CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+真实项目实战+最新讲解视频】收录，自学编程路线及系列技术文章等资源持续更新中…

ay_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

最后

光给面试题不给答案不是我的风格。这里面的面试题也只是凤毛麟角，还有答案的话会极大的增加文章的篇幅，减少文章的可读性

**[CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频】](

)**

Java面试宝典2021版

[外链图片转存中…(img-jY2CIwIA-1631260714405)]

[外链图片转存中…(img-TA1kwJM1-1631260714407)]

最常见Java面试题解析（2021最新版）

[外链图片转存中…(img-SdZsHYis-1631260714409)]

[外链图片转存中…(img-hoAbXPBv-1631260714410)]

2021企业Java面试题精选

[外链图片转存中…(img-wKvf88p0-1631260714411)]

[外链图片转存中…(img-FAcChw3G-1631260714413)]

本文已被CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+真实项目实战+最新讲解视频】收录，自学编程路线及系列技术文章等资源持续更新中…