创建表goods,goodsImage,goodsNature
/*==============================================================*/
/* Table: goods */
/*==============================================================*/
create table goods (
goodsID number not null,
typeID number,
goodsName varchar2(20),
main_img_url varchar2(100),
costPrice number(7,2),
realPrice number(7,2),
constraint PK_GOODS primary key (goodsID)
);
/*==============================================================*/
/* Table: goodsImage */
/*==============================================================*/
create table goodsImage (
imageID number not null,
goodsID number,
NatureID number,
imageURL varchar2(50),
constraint PK_GOODSIMAGE primary key (imageID)
);
/*==============================================================*/
/* Table: goodsNature */
/*==============================================================*/
create table goodsNature (
NatureID number not null,
goodsID number,
goodsCount number,
goodsColor varchar2(10),
goodsSize varchar2(5),
constraint PK_GOODSNATURE primary key (NatureID)
);
创建约束
/*==============================================================*/
/* Table: goods */
/*==============================================================*/
create table goods (
goodsID number not null,
typeID number,
goodsName varchar2(20),
main_img_url varchar2(100),
costPrice number(7,2),
realPrice number(7,2),
constraint PK_GOODS primary key (goodsID)
);
/*==============================================================*/
/* Table: goodsImage */
/*==============================================================*/
create table goodsImage (
imageID number not null,
goodsID number,
NatureID number,
imageURL varchar2(50),
constraint PK_GOODSIMAGE primary key (imageID)
);
/*==============================================================*/
/* Table: goodsNature */
/*==============================================================*/
create table goodsNature (
NatureID number not null,
goodsID number,
goodsCount number,
goodsColor varchar2(10),
goodsSize varchar2(5),
constraint PK_GOODSNATURE primary key (NatureID)
);
创建约束
alter table goods
add constraint FK_GOODS_REFERENCE_GOODSTYP foreign key (typeID)
references goodsType (typeID);
alter table goodsImage
add constraint FK_GOODSIMA_REFERENCE_GOODS foreign key (goodsID)
references goods (goodsID) on delete cascade not deferrable;//级联删除
alter table goodsNature
add constraint FK_GOODSNAT_REFERENCE_GOODS foreign key (goodsID)
references goods (goodsID) on delete cascade not deferrable;
删除前
执行语句delete from goods where goodsid=1后