【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-initTable.sql,希望本篇文章对您学习有所帮助。
DROP TABLE nation;
CREATE TABLE nation (
nationcode VARCHAR2(50) NOT NULL,
nationname VARCHAR2(40),
PRIMARY KEY(nationcode)
);
DROP TABLE city;
CREATE TABLE city (
citycode VARCHAR2(20) NOT NULL,
nationcode VARCHAR2(50) NOT NULL,
provincecode VARCHAR2(20) NOT NULL,
cityname VARCHAR2(30),
PRIMARY KEY(citycode, nationcode, provincecode)
);
DROP TABLE province;
CREATE TABLE province (
provincecode VARCHAR2(20) NOT NULL,
nationcode VARCHAR2(50) NOT NULL,
provincename VARCHAR2(50),
PRIMARY KEY(provincecode, nationcode)
);
DROP TABLE clients;
CREATE TABLE clients (
clientname VARCHAR2(20) NOT NULL,
sex VARCHAR2(5),
phone VARCHAR2(12),
mobile VARCHAR2(20),
address VARCHAR2(100),
http VARCHAR2(50),
citycode VARCHAR2(20),
PRIMARY KEY(clientname)
);