use SuperMarket
go
create table GoodsType
(
TypeId int identity(1,1) primary key,
TypeName nvarchar(50) not null
)
go
create table Goods
(
GoodsId int identity(1,1) primary key,
GoodsName nvarchar(50) not null,
Price float not null,
TypeId int not null,
ProdureCounts int not null
foreign key(TypeId) references GoodsType(TypeID)
)
go