2. 创建表customer-product-orders

最新推荐文章于 2023-11-29 18:06:55 发布

lost star in dark

最新推荐文章于 2023-11-29 18:06:55 发布

阅读量622

点赞数

分类专栏：数据库课程

本文链接：https://blog.csdn.net/weixin_43939570/article/details/105334761

版权

数据库课程专栏收录该内容

96 篇文章 108 订阅

订阅专栏

在这里插入图片描述

CREATE TABLE customer (
	cid INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	cname VARCHAR (50) NOT NULL,
	caddress VARCHAR (50) NOT NULL,
	ccity VARCHAR (50) NOT NULL,
	cstate VARCHAR (20) NOT NULL,
	czip VARCHAR (20) NOT NULL,
	ccountry VARCHAR (20) NULL,
	ccontact VARCHAR (20) NULL,
	cemail VARCHAR (20) NULL
);

CREATE TABLE product (
	pid INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	pname VARCHAR (50) NOT NULL,
	pprice DECIMAL (8, 2) NOT NULL,
	pdesc VARCHAR (100) NULL,
	pcount INT (11) NOT NULL DEFAULT '0'
);

CREATE TABLE orders (
	oid INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	pid INT (11) NOT NULL,
	cid INT (11) NOT NULL,
	CONSTRAINT pid  FOREIGN KEY(pid) REFERENCES product(pid),
	CONSTRAINT cid  FOREIGN KEY(cid) REFERENCES customer(cid),
	ocount INT (11) NOT NULL DEFAULT '1',
	oprice DECIMAL (8, 2) NOT NULL,
	odate TIMESTAMP
);