美食数据库.docx
- 文档编号:15643323
- 上传时间:2023-07-06
- 格式:DOCX
- 页数:15
- 大小:17.15KB
美食数据库.docx
《美食数据库.docx》由会员分享,可在线阅读,更多相关《美食数据库.docx(15页珍藏版)》请在冰点文库上搜索。
美食数据库
-----美食类别
createtablecate_type(
IDnumber(6)notnullprimarykey,
type_namevarchar2(200)uniquenotnull
);
droptablecate_type
createsequenceID
startwith1
incrementby1
maxvalue29
nocycle
nocache
noorder;
dropsequenceID
createorreplacetriggerIDiden
beforeinsertoncate_type
foreachrow
declaretmpnumber;
begin
selectID.currval
intotmp
fromdual;
endIDiden;
insertintocate_typevalues(ID.nextval,'普通会员');
insertintocate_typevalues(ID.nextval,'管理员');
insertintocate_typevalues(ID.nextval,'美食资讯');
insertintocate_typevalues(ID.nextval,'美食趣味分享');
insertintocate_typevalues(ID.nextval,'养生之道');
insertintocate_typevalues(ID.nextval,'肉类');
insertintocate_typevalues(ID.nextval,'蔬菜');
insertintocate_typevalues(ID.nextval,'调味料');
insertintocate_typevalues(ID.nextval,'肉菜');
insertintocate_typevalues(ID.nextval,'素菜');
insertintocate_typevalues(ID.nextval,'甜品');
insertintocate_typevalues(ID.nextval,'评论');
select*fromcate_type
createviewv_cateasselect*fromcate_type;
-----会员表
createtablemem(
mem_idnumber(6)notnullprimarykey,
mem_namevarchar2(20)uniquenotnull,
mem_pwdvarchar2(50)notnull,
mem_sexvarchar2(4)default('男')check(mem_sexin('男','女'))notnull,
mem_ageinteger,
IDnumber(6),
constraintcatet_mem_fkforeignkey(ID)
referencescate_type(ID)
);
droptablemem;
dropsequencemem_id
createsequencemem_id
startwith100
incrementby1
maxvalue199
nocycle
nocache
noorder;
createorreplacetriggermemiden
beforeinsertonmem
foreachrow
declaretmpnumber;
begin
selectmem_id.currval
intotmp
fromdual;
endmemiden;
droptriggermmiden
insertintomemvalues(mem_id.nextval,'图图','tt123','男',6,1);
insertintomemvalues(mem_id.nextval,'妹妹','mm123','女',4,1);
insertintomemvalues(mem_id.nextval,'爸爸','bb123','男',34,2);
insertintomemvalues(mem_id.nextval,'妈妈','mm123','女',31,2);
insertintomemvalues(mem_id.nextval,'咪咪','mmm123','女',1,1);
select*frommem
deletefrommemwheremem_name='咪咪'
--------------管理员表
createtablesmem(
smem_idnumber(6)notnullprimarykey,
smem_namevarchar2(20)uniquenotnull,
smem_pwdvarchar2(50)notnull,
mem_idnumber(6),
constraintsmem_mem_fkforeignkey(mem_id)
referencesmem(mem_id)
);
droptablesmem
createsequencesmem_id
startwith30
incrementby1
maxvalue99
nocycle
nocache
noorder;
dropsequencesmem_id
createorreplacetriggersmemiden
beforeinsertonsmem
foreachrow
declaretmpnumber;
begin
selectsmem_id.currval
intotmp
fromdual;
endsmemiden;
insertintosmemvalues(smem_id.nextval,'妈妈','mm123',102);
insertintosmemvalues(smem_id.nextval,'爸爸','mm123',103);
deletefromsmemwheresmem_name='妈妈'
select*fromsmem
----美食资讯
createtablecate_food(
cateFood_idnumber(6)notnullprimarykey,
cateFood_namevarchar2(200)uniquenotnull,
cateFood_descvarchar2(800)notnull,
mem_idnumber(6),
constraintcatef_mem_fkforeignkey(mem_id)
referencesmem(mem_id)
);
droptablecate_food
dropsequencecateFood_id
createsequencecateFood_id
startwith200
incrementby1
maxvalue299
nocycle
nocache
noorder;
createorreplacetriggercatefiden
beforeinsertoncate_food
foreachrow
declaretmpnumber;
begin
selectcateFood_id.currval
intotmp
fromdual;
endcatefiden;
insertintocate_foodvalues(cateFood_id.nextval,'生抽老抽区别','生抽老抽都是经过酿造发酵加工的酱油。
老抽是加入了焦糖色,颜色很深,一般给食品着色,味道有种鲜美微甜的感觉。
生抽一般是烹调用的,吃起来比较咸。
',102);
insertintocate_foodvalues(cateFood_id.nextval,'鱼肉怎么样才能去掉土味','除了去掉腥险,洗掉黑膜和血污外,还有一点非常重要就是浸泡。
多换几次水直至水色清澈无污物为止。
',103);
select*fromcate_food
-----美食趣味分享
createtablecate_cul(
cateCul_idnumber(6)notnullprimarykey,
cateCul_namevarchar2(200)uniquenotnull,
cateCul_descvarchar2(800)notnull,
mem_idnumber(6),
constraintcatec_mem_fkforeignkey(mem_id)
referencesmem(mem_id)
);
createsequencecateCul_id
startwith300
incrementby1
maxvalue399
nocycle
nocache
noorder;
dropsequencecateCul_id
createorreplacetriggercateciden
beforeinsertoncate_cul
foreachrow
declaretmpnumber;
begin
selectcateCul_id.currval
intotmp
fromdual;
endcateciden;
insertintocate_culvalues(cateCul_id.nextval,'淮扬菜','淮扬菜注重刀工,刀法细腻,口味清淡,主要菜品有红烧狮子头,软兜长鱼,平桥豆腐,文楼汤包等。
',102);
insertintocate_culvalues(cateCul_id.nextval,'羊肉泡馍做法','有四种:
单走,干拔,口汤,水围城。
单走馍与汤单独上桌,馍掰到汤中,食后单喝一碗鲜汤。
干拔,煮好碗中不见汤。
口汤,泡馍吃完后就剩一口汤。
水围城,汤宽。
',102);
select*fromcate_cul
-------养生之道
createtablecate_hel(
cateHel_idnumber(6)notnullprimarykey,
cateHel_namevarchar2(200)uniquenotnull,
cateHel_descvarchar2(800)notnull,
mem_idnumber(6),
constraintcateh_mem_fkforeignkey(mem_id)
referencesmem(mem_id)
);
createsequencecateHel_id
startwith400
incrementby1
maxvalue499
nocycle
nocache
noorder;
dropsequencecateHel_id
createorreplacetriggercatehiden
beforeinsertoncate_hel
foreachrow
declaretmpnumber;
begin
selectcateHel_id.currval
intotmp
fromdual;
endcatehiden;
insertintocate_helvalues(cateHel_id.nextval,'剩菜危害','宁剩荤菜不剩蔬菜,蔬菜在存储过程中容易产生亚硝酸盐等有害物质,会损害人体消化系统,严重的还会引起恶心腹泻等中毒现象。
',103);
insertintocate_helvalues(cateHel_id.nextval,'健康减肥','清晨起来先喝一大杯温开水,有清肠胃和排毒作用。
早餐可以牛奶加面包。
中餐清单一点,可以尝试一些粗粮,少一点油和盐。
晚餐切忌多吃,多亲近蔬果',102);
select*fromcate_hel
-----美食资讯类别
createtablecatype(
IDnumber(6),
constraintcaty_catet_fkforeignkey(ID)
referencescate_type(ID),
caty_idnumber(6)notnull,
caty_namevarchar2(200)uniquenotnull
);
insertintocatypevalues(3,200,'生抽老抽区别');
insertintocatypevalues(3,201,'鱼肉怎么样才能去掉土味');
insertintocatypevalues(4,300,'淮扬菜');
insertintocatypevalues(4,301,'羊肉泡馍做法');
insertintocatypevalues(5,400,'剩菜危害');
insertintocatypevalues(5,401,'健康减肥');
select*fromcatype
----肉类表
createtablemeet(
meet_idnumber(6)notnullprimarykey,
meet_namevarchar2(200)uniquenotnull,
meet_descvarchar2(800)notnull
);
droptablemeet
createsequencemeet_id
startwith500
incrementby1
maxvalue549
nocycle
nocache
noorder;
dropsequencemeet_id
createorreplacetriggermeetiden
beforeinsertonmeet
foreachrow
declaretmpnumber;
begin
selectmeet_id.currval
intotmp
fromdual;
endmeetiden;
insertintomeetvalues(meet_id.nextval,'鸡肉','鸡肉肉质细嫩,滋味鲜美,对营养不良,畏寒怕冷,乏力疲劳,月经不调,贫血,虚弱等有很好的食疗作用。
');
insertintomeetvalues(meet_id.nextval,'鱼肉','鱼肉,肉质细嫩鲜美,营养丰富的特点,是一些维生素,矿物质的良好来源。
');
select*frommeet
----蔬菜类
createtablevege(
vege_idnumber(6)notnullprimarykey,
vege_namevarchar2(200)uniquenotnull,
vege_descvarchar2(800)notnull
);
createsequencevege_id
startwith550
incrementby1
maxvalue600
nocycle
nocache
noorder;
createorreplacetriggervegeiden
beforeinsertonvege
foreachrow
declaretmpnumber;
begin
selectvege_id.currval
intotmp
fromdual;
endvegeiden;
insertintovegevalues(vege_id.nextval,'青椒','解热,预防癌症,增加食欲,帮助消化,降脂减肥。
');
insertintovegevalues(vege_id.nextval,'芹菜','平肝清热,解毒宣肺,健胃利血,清肠利便,润肺止咳,降低血压');
select*fromvege;
----调味类
createtableflav(
flav_idnumber(6)notnullprimarykey,
flav_namevarchar2(200)uniquenotnull,
flav_descvarchar2(800)notnull
);
createsequenceflav_id
startwith601
incrementby1
maxvalue649
nocycle
nocache
noorder;
createorreplacetriggerflaviden
beforeinsertonflav
foreachrow
declaretmpnumber;
begin
selectflav_id.currval
intotmp
fromdual;
endflaviden;
insertintoflavvalues(flav_id.nextval,'食用油','食用油人们生活的必需品,提供人体热能和必需脂肪酸,促进脂溶性维生素吸收的重要食物');
insertintoflavvalues(flav_id.nextval,'食盐','人类和动物生存必须的物质,但过量的情况下会对动物和植物造成损害。
');
select*fromflav
-----食材
createtableregi(
IDnumber(6),
constraintregi_catet_fkforeignkey(ID)
referencescate_type(ID),
regi_idnumber(6)notnull,
regi_namevarchar2(200)uniquenotnull
);
droptableregi
insertintoregivalues(6,500,'鸡肉食材');
insertintoregivalues(6,501,'鱼肉食材');
insertintoregivalues(7,550,'青椒食材');
insertintoregivalues(7,551,'芹菜食材');
insertintoregivalues(8,601,'食用油食材');
insertintoregivalues(8,602,'食盐食材');
select*fromregi
-------食谱
createtablereci(
reci_idnumber(6)notnullprimarykey,
reci_namevarchar2(200)uniquenotnull,
reci_regivarchar2(500)notnull,
reci_descvarchar2(800)notnull,
mem_idnumber(6),
constraintreci_mem_fkforeignkey(mem_id)
referencesmem(mem_id),
IDnumber(6),
constraintreci_catet_fkforeignkey(ID)
referencescate_type(ID)
);
droptablereci
createsequencereci_id
startwith650
incrementby1
maxvalue800
nocycle
nocache
noorder;
createorreplacetriggerreciiden
beforeinsertonreci
foreachrow
declaretmpnumber;
begin
selectreci_id.currval
intotmp
fromdual;
endreciiden;
insertintorecivalues(reci_id.nextval,'青椒炒鸡肉','鸡肉,青椒,盐,食用油','鸡肉切成小块,用盐,生抽,糖,料酒腌15分钟,大火下一半油和蒜末,爆香加入鸡肉,8成熟盛起,剩下油和蒜末爆香放入青椒块,青椒变软加入鸡肉,最后撒入适当的盐调味。
',102,9);
select*fromreci
----评论
createtablecomm(
mem_idnumber(6),
constraintcomm_mem_fkforeignkey(mem_id)
referencesmem(mem_id),
IDnumber(6),
constraintcomm_catet_fkforeignkey(ID)
referencescate_type(ID),
comm_idnumber(6)notnull,
comm_textvarchar2(1000)
);
insertintocommvalues(102,3,200,'终于明白了老抽和生抽的区别点赞!
!
!
');
insertintocommvalues(100,9,650,'下次让妈妈做青椒炒肉,图图最爱妈妈做的饭了!
!
!
');
select*fromcomm
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 美食 数据库
![提示](https://static.bingdoc.com/images/bang_tan.gif)