create_cart_bo.sql

来自「很多学校」· SQL 代码 · 共 52 行

drop table order_item_bo;
drop table user_order_bo;
drop table user_bo;
drop table product_bo;
create table user_bo(

	id number primary key,
	name varchar2(32) not null unique,
	password varchar2(32) not null,
	address varchar2(512),
	postcode varchar2(10),
	email varchar2(32),
	home_phone varchar2(32)
);

insert into user_bo values(1,'tarena','tarena','hangzhou','322019','[e-mail]','123456');

create table product_bo (
	id number primary key,
	name varchar2(32) not null,
	description varchar2(64),
	price number(8,2) not null
);


insert into product_bo values(1,'pencil','笔类',2.00);
insert into product_bo values(2,'pen','笔类',5.00);
insert into product_bo values(3,'三毛','书',84.00);
insert into product_bo values(4,'notebook','本子',2.00);
insert into product_bo values(5,'mp3','电子类',199.00);
insert into product_bo values(6,'李宁','衣服',566.00);
insert into product_bo values(7,'法拉利','车类',600000.00);



create table user_order_bo(
	
	id number primary key,
	status number,
	user_id number references user_bo(id),
	cost number(10,2)

);

create table order_item_bo(
	
	id number primary key,
	amount number,
	product_id number references product_bo(id),
	order_id number references user_order_bo(id)
);