create database TPC_H
use TPC_H
CREATE TABLE Region
(Rno CHAR(9) PRIMARY KEY,
Rname CHAR(20) UNIQUE,
Rcomment CHAR(50)
);
CREATE TABLE Nation
(Nn CHAR(9) PRIMARY KEY,
Nname CHAR(20) UNIQUE,
Rno CHAR(9),
Ncomment CHAR(50)
);
CREATE TABLE Supplier
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20) UNIQUE,
Saddress CHAR(50),
Nno CHAR(9),
Sphone CHAR(11),
Sacctbal CHAR(20),
Scomment CHAR(50)
);
CREATE TABLE Part
(Pno CHAR(9) PRIMARY KEY,
Pname CHAR(20) UNIQUE,
Pmfgr CHAR(20),
Pbrand CHAR(20),
Ptype CHAR(20),
Pcontainer CHAR(50),
Pretailprice CHAR(10),
Pcomment CHAR(50)
);
CREATE TABLE Partsupp
(PSno CHAR(9) PRIMARY KEY,
Sno CHAR(9),
PSavailqty CHAR(20),
PSsupplycost CHAR(20),
PScomment CHAR(500)
);
CREATE TABLE Customer
(Cno CHAR(9) PRIMARY KEY,
Cname CHAR(20) UNIQUE,
Caddress CHAR(20),
Cnationkey CHAR(20),
Cphone CHAR(11),
Cacctbal CHAR(20),
Cmktsegment CHAR(20),
Ccomment CHAR(50)
);
CREATE TABLE Orders
(Ono CHAR(9) PRIMARY KEY,
Cno CHAR(9),
Ooredrstatus CHAR(20),
Ototalprice CHAR(20),
Oorderdate CHAR(20),
Oorderpriority CHAR(20),
Oclerk CHAR(20),
Oshippriority CHAR(20),
Ocomment CHAR(50)
);
CREATE TABLE Lineitem
(Ono CHAR(9),
Pno CHAR(9),
Sno CHAR(9),
Llinenumbre CHAR(9),
Lquantity CHAR(9),
Lextendedprice CHAR(9),
Ldiscount CHAR(9),
Ltax CHAR(9),
Lreturnflag CHAR(9),
Lshipdate CHAR(9),
Lcommiddate CHAR(9),
Lreceiptdate CHAR(9),
Lshipinstruct CHAR(9),
Lshipmode CHAR(9),
Lcomment CHAR(50)
);
create database TPC_Huse TPC_HCREATE TABLE Region(Rno CHAR(9) PRIMARY KEY,Rname CHAR(20) UNIQUE,
最新推荐文章于 2024-07-06 01:00:05 发布