product.sql

通过编写一个商品信息管理的小系统

use jspdev;
create table category (
	catid varchar(30) not null,
	name varchar(80) null,
	descn varchar(255) null,
	constraint pk_category primary key (catid)
);

create table products (
    productid varchar(10) not null,
    category varchar(30) not null,
    name varchar(80) null,
    producer varchar(50) null,
    price float not null,
    descn varchar(255) null,
    constraint pk_products primary key (productid),
        constraint fk_products_1 foreign key (category)
        references category (catid)
);
INSERT INTO category VALUES ('computer','计算机','计算机');
INSERT INTO category VALUES ('english','英语','英语');
INSERT INTO products VALUES ('isbn-4-6','computer', 'J2EE企业级应用开发','电子工业出版社',59.90,'一本非好的书');
INSERT INTO products VALUES ('isbn-4-3','english','英语500句','xxx出版社',56.0,'还不错');