1、图3-19清晰的表达了各个数据库之间的关系，反映了系统各个实体之间的关系。图3-19 数据实体关系图3.3.2数据库逻辑设计根据数据库的概念设计，进一步得到数据库的逻辑结构，如表3-1至表3-14所示2。1. 管理员列表表3-1 administrator 字段名数据类型是否为空主外键约束默认值描述adminidint(4)No主键管理员编号adminnameint(4)NoNULL管理员账户adminpwdvarchar(50)NoNULL管理员密码emailvarchar(50)YesNULL邮箱telephonevarchar(50)YesNULL电话realnamevarchar(50
2、)NoNULL真实姓名privilegevarchar(50)NoNULL管理员权限用户表表3-2 user 字段名数据类型是否为空主外键约束默认值描述uidint(4)No主键用户编号unnamevarchar(50)NoNULL用户名upwdvarchar(50)NoNULL用户密码emailvarchar(50)NoNULL邮箱cityvarchar(50)NoNULL城市uscoreint(4)NoNULL积分isbookedint(4)NoNULL邮件服务registetimedatetimeNoNULL注册时间2. 商品表表3-3 product 字段名数据类型是否为空主外键约束默
3、认值描述pidint(4)No主键商品编号pnnamevarchar(50)NoNULL商品名ptypeint(4)No外键NULL商品类型pquantityint(4)NoNULL数量opricefloatNoNULL原价cpricefloatNoNULL现价starttimedatetimeNoNull开始时间deadlinedatetimeNoNULL团购时间pnumint（4）NoNULL最大数量lnumint(4)NoNULL最小数量sidint(4)No外键NULL商家编号showimgvarchar(50)NoNull列表图片image1varchar(50)YesNull详情图
4、片1image2varchar(50)YesNull详情图片2image3varchar(50)YesNull详情图片3image4varchar(50)YesNull详情图片4description1textYesNull详情描述1description2textYesNull详情描述2description3textYesNull详情描述33. 商家表表3-4 saler 字段名数据类型是否为空主外键约束默认值描述sidint(4)NoYes商家编号snamevarchar(50)NoNULL商家名称steltvarchar(50)NoNULL商家电话saddressvarchar(50)
5、NoNULL商家地址4. 订单表表3-5 orders 字段名数据类型是否为空主外键约束默认值描述oidint(4)No主键订单编号uidint(4)No外键NULL用户编号stateidint(4)No外键NULL状态编号onumint(4)NoNULL购买数量uaddressvarchar(50)NoNULL配送地址udatedatetimeNoNULL购买时间numbervarchar(50)NoNULL订单号5. 订单状态类型表3-6 orderstate 字段名数据类型是否为空主外键约束默认值描述stateidint(4)No主键状态编号statenamevarchar(50)NoN
6、ULL状态名6. 订单和商品联系集表3-7 oder_product 字段名数据类型是否为空主外键约束默认值描述opidint(4)No主键联系集编号oidint(4)No外键NULL订单编号pidint(4)No外键NULL商家编号subnumint(4)NoNULL购买数量subpricefloatNoNULL购买价格7. 论坛大类表3-8 diszone 字段名数据类型是否为空主外键约束默认值描述dzidint(4)No主键类型编号dznamevarchar(50)NoNULL类型名称8. 论坛模块表3-9 dismodule 字段名数据类型是否为空主外键约束默认值描述midint(4)
7、No主键模块编号dzidint(4)No外键NULL大类编号mnamevarchar(50)NoNULL模块名hostvarchar(50)NoNULL版主名9. 论坛主题表3-10 distheme 字段名数据类型是否为空主外键约束默认值描述thidint(4)No主键主题编号uidint(4)No外键NULL用户编号mid匀焀眀愀瀀瀀栀琀洀氀渁通/Mi前台访问/p-1261445.html185.191.171.170缍勈竨劰开礀琀愀最樀椀氀椀吀稀椀氀椀愀漀栀琀洀氀5Sqwap前台访问/p-2842221.html220.181.108.1600缏簔%椀瀀栀琀洀氀舃溲/前台访问/c-000
8、1200004-80-99230-0-0-0-0-9-1-1.html121.233.177.980缑絀%最瀀栀琀洀氀饒閒/Mg前台访问/p-1370891.html40.77.167.1580缓繬匀焀眀愀瀀瀀栀琀洀氀夃淺頚5gwap前台访问/BookRead.aspx?id=2842221111.206.222.1950缕胄億最瀀栀琀洀氀洀5gwap前台访问/BookRead.aspx?id=2859039111.206.221.1030缗胄最搀栀琀洀氀渁/Mg前台访问/p-1135323.html54.36.148.2120缙勈臰儀洀猀椀琀攀洀愀瀀栀琀洀氀/Mg前台访问/d-1456328
9、.html40.77.167.1580缛地茜椀搀栀琀洀氀饒氲/Ie前台访问/d-60762.html123.183.224.310缝葈顔最茀眀愀瀀漀漀欀刀攀愀搀愀猀瀀砀椀搀/Ki前台访问/p-158239.html123.183.224.1720缟蕴最瀀栀琀洀氀琀/Kg前台访问/p-151622.html123.183.224.660缡蝉蕴捈礀鄀挀栀琀洀氀渁琚/a前台访问/BookRead.aspx?id=285942127.199.185.460缣蕴%最瀀栀琀洀氀洀琚5gwap前台访问/BookRead.aspx?id=2789866111.206.198.510缥勈蕴彮最瀀栀琀洀氀饒琝渒/
10、前台访问/c-0000800005-41-4880-0-0-0-0-3-0-2.html112.123.40.1050缧勈蚠彮匀漀眀愀瀀瀀栀琀洀氀/Mg前台访问/d-2669310.html117.86.150.350缩蚠%椀瀀栀琀洀氀/Mg前台访问/p-2829642.html156.234.98.260缫勈蟌砞猀贀挀栀琀洀氀5gwap前台访问/BookRead.aspx?id=2859041111.206.198.760缭裸%億最瀀栀琀洀氀舃溲/Mi前台访问/p-2849364.html220.181.108.850缯訤茀挀栀琀洀氀饒/Qm前台访问/sitemap-864.html62.2
11、10.188.2400缱勈譐銰攀瀀栀琀洀氀饒倝悲/Mi前台访问/p-2704065.html222.190.222.790缳譐%億最瀀栀琀洀氀饒倝/Mg前台访问/p-1695941.html40.77.167.1580缵勈譐銰咕匀漀眀愀瀀搀栀琀洀氀簀/s前台访问/c-00008-11-613-0-0-0-0-2-0-1.html182.96.51.1170缷豼%億椀瀀栀琀洀氀簀/Mg前台访问/p-2769571.html116.179.32.340缹趨%最瀀栀琀洀氀饒/Mi前台访问/p-1280741.html47.101.165.1660缻勈趨蝉欀瀀栀琀洀氀饒/Me前台访问/p-276814
12、5.html54.36.149.690缽軔匀焀眀愀瀀瀀栀琀洀氀泓/u前台访问/tag/tanhaoqiangc.html27.199.185.460缿勈退愀缀漀漀欀刀攀愀搀愀猀瀀砀椀搀饒/y前台访问/c-00002-984-65746-0-0-0-0-3-0-1.html183.166.135.1180罁鄬最瀀栀琀洀氀夃淺退5gwap前台访问/BookRead.aspx?id=2859040111.206.221.1080罃鉘%最搀栀琀洀氀饒堝/Qm前台访问/sitemap-903.html62.210.188.2400罅鉘匀漀眀愀瀀瀀栀琀洀氀饒堝/Me前台访问/p-2763534.html5
13、4.36.149.210罇勈鉘眀錀挀栀琀洀氀饒萝/Ki前台访问/p-413497.html123.183.224.1700罉勈鎄茀鴀挀栀琀洀氀舃溲/So前台访问/order-269434.html116.179.32.1740罋關%最搀栀琀洀氀舃溲/u前台访问/c-00002-26-2690-0-0-0-0-1-1-1.html117.67.99.2380罍勈霈貢最瀀栀琀洀氀一耀/Mk前台访问/p-2702084.html220.178.227.1810罏勈霈挀瀀栀琀洀氀ard-working.重点语法：宾语从句结构：主语 + 谓语动词 + 宾语从句(主语 + 谓语动词 + 宾语/表语)例句：
14、-im good at english. he says. (改为加宾语从句的复合句) -he says im good at english.注意：主句是一般现在时态，宾语从句的时态不受其影响。 例句：he says im good at english now. he says i was good at mathematics when i was young. 主句是过去时态，宾语从句也要用过去时态。 例句：he said i was good at mathematics when i was young yesterday. he said i was good at englis
15、h now yesterday. 宾语从句是客观真理时永远用一般现在时态。 例句：our teacher says 24 hours make a day. our teacher said the sun gives us so many energy yesterday. 动词原形不能作主语，必须用其 -ing 形式。 例句：she said helping others changed her life.重点短语：direct speech 直接引语 reported speech = indirect speech 间接引语 first of all = at first 首先 pas
16、s on 传递 be supposed to do sth. 应该做某事 be good at = do well in 在某方面做得好 in good health 身体健康 get over 克服 open up 打开 care for = take care of = look after 照料；照顾 not any more = not any longer = no longer 不再 have a cold 感冒 end-of-year exam 年终考试 get nervous 变得紧张 forget to do sth. 忘记做某事（该事未做） forget doing sth. 忘记做某事（该事已做）
