createtable.sql

网上购物系统用SSH实现的

CREATE TABLE country (
  id number(3),
  name varchar2(20) constraint country_name_nn not null,
  constraint country_id_pk primary key(id)
);    
INSERT INTO country VALUES (1,'中国');
INSERT INTO country VALUES (2,'中国香港');
INSERT INTO country VALUES (3,'中国台湾');

CREATE TABLE province(
  id number(6),
  name varchar2(20) constraint province_name_nn not null,
  countryId number(3),
  constraint province_id_pk primary key(id)
);
INSERT INTO province VALUES (1, '安徽', 1);
INSERT INTO province VALUES (2, '北京', 1);
INSERT INTO province VALUES (3, '重庆', 1);
INSERT INTO province VALUES (4, '福建', 1);
INSERT INTO province VALUES (5, '广东', 1);
INSERT INTO province VALUES (6, '甘肃', 1);
INSERT INTO province VALUES (7, '广西', 1);
INSERT INTO province VALUES (8, '贵州', 1);
INSERT INTO province VALUES (9, '河南', 1);
INSERT INTO province VALUES (10, '湖北', 1);
INSERT INTO province VALUES (11, '河北', 1);
INSERT INTO province VALUES (12, '海南', 1);
INSERT INTO province VALUES (13, '香港', 1);
INSERT INTO province VALUES (14, '黑龙江', 1);
INSERT INTO province VALUES (15, '湖南', 1);
INSERT INTO province VALUES (16, '吉林', 1);
INSERT INTO province VALUES (17, '江苏', 1);
INSERT INTO province VALUES (18, '江西', 1);
INSERT INTO province VALUES (19, '辽宁', 1);
INSERT INTO province VALUES (20, '澳门', 1);
INSERT INTO province VALUES (21, '内蒙古', 1);
INSERT INTO province VALUES (22, '宁夏', 1);
INSERT INTO province VALUES (23, '青海', 1);
INSERT INTO province VALUES (24, '四川', 1);
INSERT INTO province VALUES (25, '山东', 1);
INSERT INTO province VALUES (26, '上海', 1);
INSERT INTO province VALUES (27, '陕西', 1);
INSERT INTO province VALUES (28, '山西', 1);
INSERT INTO province VALUES (29, '天津', 1);
INSERT INTO province VALUES (30, '台湾', 1);
INSERT INTO province VALUES (31, '新疆', 1);
INSERT INTO province VALUES (32, '西藏', 1);
INSERT INTO province VALUES (33, '云南', 1);
INSERT INTO province VALUES (34, '浙江', 1);
INSERT INTO province VALUES (35, '其它', 1);
INSERT INTO province VALUES (36, '中国香港', 2);
INSERT INTO province VALUES (37, '中国台湾', 3);

create table category(
categoryid number(10),
name varchar2(128) constraint category_name_nn not null,
description varchar2(512),
constraint category_id_pk primary key(categoryid)
);

insert into category(categoryid,name,description) values(1,'计算机', '软件与程序设计相关');
insert into category(categoryid,name,description) values(2,'英语', '英语相关图书');
insert into category(categoryid,name,description) values(3,'文学', '文学作品图书集');

create table product (
productid number(16),
name varchar2(64) constraint product_name_nn not null,
description varchar2(4000),
basePrice number(12,2) constraint product_price_nn not null,
categoryid number(10),
author varchar2(128) constraint product_author_nn not null,
publish varchar2(256) constraint product_publish_nn not null,
pages number(6),
images varchar2(128),