surface 8  Order details （lineitem）

New table source code ：

CREATE TABLE region(
	regionkey INT PRIMARY KEY,
	name CHAR(25),
	comment VARCHAR(150)
);
CREATE TABLE nation(
	nationkey INT PRIMARY KEY,
	name CHAR(25),
	regionkey INT,
	comment VARCHAR(150),
	FOREIGN KEY(regionkey) REFERENCES region(regionkey)
);
CREATE TABLE supplier(
	suppkey INT PRIMARY KEY,
	name CHAR(100),
	address VARCHAR(100),
	nationkey INT,
	phone CHAR(30),
	acctbal NUMERIC(12,2),
	comment VARCHAR(100),
	FOREIGN KEY(nationkey) REFERENCES nation(nationkey)
);
CREATE TABLE part(
	partkey INT PRIMARY KEY,
	name VARCHAR(100),
	mfgr CHAR(50),
	brand CHAR(50),
	type VARCHAR(25),
	size INT,
	container CHAR(10),
	retailprice NUMERIC(8,2),
	comment VARCHAR(20)
);
CREATE TABLE partsupp(
	partkey INT,
	suppkey INT,
	availqty INT,
	supplycost NUMERIC(10,2),
	comment VARCHAR(200),
	PRIMARY KEY(partkey,suppkey),
	FOREIGN KEY(partkey) REFERENCES part(partkey),
	FOREIGN KEY(suppkey) REFERENCES supplier(suppkey)
);
CREATE TABLE customer(
	custkey INT PRIMARY KEY,
	name VARCHAR(25),
	address VARCHAR(40),
	nationkey INT,
	phone CHAR(30),
	acctbal NUMERIC(12,2),
	mktsegment CHAR(10),
	comment VARCHAR(100),
	FOREIGN KEY(nationkey) REFERENCES nation(nationkey)
);
CREATE TABLE orders(
	orderkey INT PRIMARY KEY,
	custkey INT,
	orderstatus CHAR(1),
	totalprice NUMERIC(10,2),
	orderdate DATE,
	orderpriority CHAR(15),
	clerk CHAR(16),
	shippriority CHAR(1),
	comment VARCHAR(60),
	FOREIGN KEY(custkey) REFERENCES customer(custkey)
);
CREATE TABLE lineitem(
	orderkey INT,
	partkey INT,
	suppkey INT,
	linenumber INT,
	quantity INT,
	extendedprice NUMERIC(8,2),
	discount NUMERIC(3,2),
	tax NUMERIC(3,2),
	returnflag CHAR(1),
	linestatus CHAR(1),
	shipdate DATE,
	commitdate DATE,
	receiptdate DATE,
	shipinstruct CHAR(25),
	shipmode CHAR(10),
	comment VARCHAR(40),
	PRIMARY KEY(orderkey,linenumber),
	FOREIGN KEY(partkey,suppkey) REFERENCES partsupp(partkey,suppkey)
);

3.3 according to  qq  In the group “ Data import tutorial .rar”, Put the data of each table （.csv  Format ） Import to the created table , The import order is in the order of table creation

experimental data （orders The date data of the table needs to be used after the format is modified , The modified format in the link below ）

link ：https://pan.baidu.com/s/1PMH0_sg-ibD-Gzddfu9HWA 
Extraction code ：11yn