create table Member
	(
	MemberNo NUMBER,
	Name VARCHAR(50),
	Address VARCHAR(50),
	CONSTRAINT MemberNo_pk PRIMARY KEY (MemberNo)
	)
/
create table Ping_Order
	(
	OrderNo NUMBER,
	MemberNo NUMBER,
	OrderDate DATE,
	AmountRemitted NUMBER,
	CONSTRAINT OrderNo_pk PRIMARY KEY (OrderNo),
	CONSTRAINT order_member_fk FOREIGN KEY (MemberNo)
	REFERENCES Member(MemberNo)
	)
/
create table OrderLine
	(
	OrderNo NUMBER,
	CatalogNo NUMBER,
	Quantity NUMBER,
	CONSTRAINT OrderLine_pk PRIMARY KEY (OrderNo, CatalogNo),
	CONSTRAINT line_order_fk FOREIGN KEY (OrderNo)
	REFERENCES Ping_Order(OrderNo),
	CONSTRAINT line_wine_fk FOREIGN KEY (CatalogNo)
	REFERENCES Wine(CatalogNo)
	)
/
create table Wine
	(
	CatalogNo NUMBER,
	Name VARCHAR(50),
	Winery VARCHAR(50),
	VintageYear DATE,
	PricePerBottle NUMBER,
	CONSTRAINT Wine_pk PRIMARY KEY (CatalogNo)
	)
/