网站详细设计文档

网站详细 设计 领导形象设计圆作业设计ao工艺污水处理厂设计附属工程施工组织设计清扫机器人结构设计 文档 买易通网站详细设计文档 Document Version 1.0 Author Module Bill Lu Architecture & Batch Script Huili Tang User Interface Jun Feng Database & Document Integration Wick Wu Logical Layer Yonghe Yao User Interface Create Date 2005-6-1 Last Update Date 2005-6-1 版权所有? 2010 Myetone 1 内部保密 买易通网站详细设计文档 文档目录 1. 概述(Summary) .............................................................................................................................. 5 1.1 文档目的(Introduction) ..................................................................................................... 5 1.2 背景(Background).............................................................................................................. 5 1.3 相关文档(Related Documents) ......................................................................................... 5 2. 系统架构(System Architecture) .................................................................................................... 6 2.1 系统性能(Performance) .................................................................................................... 6 2.2 运行环境(Environment) .................................................................................................... 6 2.3 基本概念(Concepts) .......................................................................................................... 6 2.4 程序模块结构(Module Structure) .................................................................................... 6 2.5 后台脚本处理过程(Batch Process) ................................................................................. 6 2.6 人工处理过程(Manual Process) ....................................................................................... 6 2.7 系统容错设计(Application Exceptions) .......................................................................... 6 3. 用户界面设计(User Interface Design) ......................................................................................... 7 4. 逻辑层设计(Logic Layer Design) ................................................................................................. 8 4.1 系统类结构及关系 ............................................................................................................ 8 4.1.1 总述: ....................................................................................................................... 8 4.1.2 CategorySystem. .................................................................................................. 10 4.1.3 ProductSystem. .................................................................................................... 13 4.1.4 AccountSystem. ................................................................................................... 15 4.1.5 ReviewSystem...................................................................................................... 19 4.1.6 StoreSystem.......................................................................................................... 20 4.2 各主要算法实现流程...................................................................................................... 21 4.2.1 Overview. ............................................................................................................. 21 4.2.2 Category Related. ................................................................................................ 21 4.2.3 Product Related .................................................................................................... 23 4.2.4 Review Related. ................................................................................................... 27 2 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 4.2.5 User Related. ........................................................................................................ 27 4.2.6 Store Related ........................................................................................................ 27 5. 数据库设计(Database Design) .................................................................................................... 28 5.1 Database summary ........................................................................................................... 28 5.2 TBL_ACCOUNT ............................................................................................................. 30 5.3 TBL_ACCOUNT_LOGON ............................................................................................ 32 5.4 TBL_APPLYCHANGE .................................................................................................. 33 5.5 TBL_ARTICLE ............................................................................................................... 34 5.6 TBL_ARTICLE_BODY.................................................................................................. 35 5.7 TBL_BATCH ................................................................................................................... 36 5.8 TBL_CATEGORY .......................................................................................................... 37 5.9 TBL_CONDITION .......................................................................................................... 39 5.10 TBL_LIST ........................................................................................................................ 40 5.11 TBL_PRODUCT.............................................................................................................. 41 5.12 TBL_PRODUCT_CHANGE .......................................................................................... 43 5.13 TBL_PROPERTY ............................................................................................................ 44 5.14 TBL_PROPERTY_CHANGE ........................................................................................ 45 5.15 TBL_PROPERTY_GROUP............................................................................................ 46 5.16 TBL_PROPERTY_LIST ................................................................................................. 47 5.17 TBL_PROPERTY_VALUE............................................................................................ 48 5.18 TBL_RATING ................................................................................................................. 49 5.19 TBL_REVIEW ................................................................................................................. 50 5.20 TBL_REVIEW_BODY ................................................................................................... 52 5.21 TBL_STORE .................................................................................................................... 53 5.22 TBL_STORE_LOGON ................................................................................................... 55 5.23 TBL_TOPIC ..................................................................................................................... 56 5.24 TMP_TRUST ................................................................................................................... 57 6. 后台脚本设计(Batch Script Design) .......................................................................................... 58 版权所有? 2010 Myetone 3 内部保密 买易通网站详细设计文档 7. 名词解释(Terminology) ............................................................................................................... 59 7.1 关系网(Web of Trust) ...................................................................................................... 59 7.2 开放式目录管理(Open Taxonomy) ............................................................................... 59 4 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 1. (Summary) 1.1 (Introduction) 1.2 (Background) 1.3 (Related Documents) 版权所有? 2010 Myetone 5 内部保密 买易通网站详细设计文档 2. (System Architecture) 2.1 (Performance) 2.2 (Environment) 2.3 (Concepts) 2.4 (Module Structure) 2.5 (Batch Process) 2.6 (Manual Process) 2.7 (Application Exceptions) 6 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 3. (User Interface Design) 版权所有? 2010 Myetone 7 内部保密 买易通网站详细设计文档 4. (Logic Layer Design) 4.1 4.1.1 : 8 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 MyETone.com里我们抽象出5个实体对象，分别是Category, Product, User, Review和Store,. 作为整个Business Façade里面的主要功能块，User Interface Layer 通过调用实体对象的功能 版权所有? 2010 Myetone 9 内部保密 买易通网站详细设计文档 函数完成操作。Business Façade层经过Business Rule层的数据检查，通过Data Access层以 Common Layer定义的数据结构实现对数据库的访问。 Business Façade 5个实体对象对应的Class名称分别是CategorySystem, ProductSystem, AccountSystem, ReviewSystem, StoreSystem. 下面是各个Class实现的主要接口列表。 4.1.2 CategorySystem. Function: CreateCategory Para: [int] parentID, //所在的父目录位置； [string] catName, //要创建的目录名称； [CategoryData.CategoryType] catType, //目录类型，枚举类型{ NotLeaf = 0, Leaf = 1} [string] remark ， //备注； Return: -1; //创建失败 [int] Id ; //创建得到新的categoryid ; Description: 创建一个新的category。 Function: GetCategoryByID Para: [int] categoryID, // [CategoryData] category //[out] Category Data Return: Void Description: 通过CategoryID得到category详细 Function GetChildren Para: [int] categoryID, [CategoryData] category //[out] Category Data. 10 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 Return : Void Description: 返回目录的子目录，如果是叶子节点，返回空。 Function GetParents Para: [int] categoryID, [CategoryData] category //[out] 按照从Root到该category’s 的 Parent的顺序排列的目录集， Return: void Description: 根据CategoryID得到该Category的所有长辈，按照由高到低的顺序排列 Function GetTopLevelCategories Para: [CategoryData] category //[out],得到Top Level的目录集合，按照从左到右的顺序排列。 Return :Void Description : 得到顶层目录集合，按照显示顺序排序过的。 Function GetRecommendCategories Para: [int] categoryID,//指定目录的id. [int] itemCount, //推荐目录的个数 [CategoryData] category//[out] 得到推荐目录的列表，并按显示顺序排列 Return: void Description: Function UpdateCategory Para: [CategoryData] category// 要修改的Category Data. 版权所有? 2010 Myetone 11 内部保密 买易通网站详细设计文档 Return: [Bool]//True for Success, False for failed. Description: 更改目录的信息。 Function: SetLinkCategory Para: [int] srcCategoryID, [int] destCategoryID Return: [Bool]//True for Success, False for failed. Description: 设定Link Category, if Linkid>0 means this category was linked to Linkid. Function : GetRecommendProductsByID Para: [int] categoryID, [ProductData] product //[out] Return: void Description: 得到目录对应的推荐商品列表 Function : GetRecommendStoresByID Para: [int] categoryID, [ProductData] product //[out] Return: void Description: 得到目录对应的推荐商品列表 Function : GetBestReviewerByID 12 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 Para： [int] categoryID, [AccountData] account// [out] Return: Void Description :得到目录对应的最佳评论员。 4.1.3 ProductSystem. Function CreateProduct Para: [ProductData] product Return: [bool]// true for success; false for failed. Decription : Create Product. Function GetAllProductsInCategory Para: [int] categoryID, [ProductData] product//[out]产品信息。 Return: void Description: 得到目录下的所有产品信息列表。 Function GetProductByID Para: [int] productID, [ProductData] product 版权所有? 2010 Myetone 13 内部保密 买易通网站详细设计文档 Return:void Description: 通过productID得到产品的信息。 Fucntion GetProductReviews Para: [int] accountID, [int] productID, [ReviewData] review//Review Dataset Return: void Description: 得到产品的Review信息，该信息已经按照显示顺序排序过。[不包括Review Body],Reviews written by accountid or whom accountid trusted will shown front. Function GetProductsByConditions Para: [Conditions] conditions, //{Marked By Wick , Contitions have not defined} [ProductData] product Return:void Description: 根据Contitions, 返回product的数据集，conditions是个条件列表。 Function GetProductsByKeyword Para: [string] keyword, [int] catgoryID, [ProductData] product //[out],返回的数据集 Return:void Description: 根据关键字返回product dataset Function GetProductProperties 14 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 Para: [int] productID, [PropertyData] property Return: void Description: 得到产品的propertyData集。PropertyData 按照类型分组，先是组名称，接着是组数据。 一次在页面列出。详细的数据 格式 pdf格式笔记格式下载页码格式下载公文格式下载简报格式下载 等待制定。 Function: UpdateProduct Para: [ProductData] product Return: bool //True for Success; False for failed. Description : 修改product数据。 4.1.4 AccountSystem. Function: AddBlockList Para: [int] accountID, [int] blockerID Return: int // -1 faled ListID for success. Description: 为accountID用户Block新的blockID。 Function AddTrustList Para: [int] accountID, [int] trusterID Return: int //-1 failed ListID for this record if Succeed 版权所有? 2010 Myetone 15 内部保密 买易通网站详细设计文档 Description: 为accountID用户添加新的Trust记录。 Function AddWishCategory Para: [int] accountID, [int] categoryID Return: int //-1 for failed ListID for Success. Description:用户添加新的Wish Category. Function: AddWishProduct Para: [int] accountID, [int] productID Return: int// -1 for failed ListID for success. Description: 用户添加收藏的产品。 Function： CreateAccount Para： [string] logonname, [string] password Return: bool // True for success; False for failed. Description: 创建新用户 Function： GetAccountByID Para： [int] accountID, [AccountData] account //[out] Return: Void 16 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 Description: 通过id得到用户的数据. Function : AccountLogon Para : [string] logon, [string] passwd Return: bool // true for Login Successfully False for login failed Description: 用户登陆验证 Function : GetAccountReviews Para: [int] accountID, [ReviewData] review //[out]Sorted Review Data Return: void Description: 得到指定用户的Reviews. Function : GetTrusteesList Para : [int] accountID, [ListData] list//[out] Return : void Description: 得到制定用户信任的用户数据。 Function： GetTrustersList Para： [int] accountID, [ListData] list //[out] Return : void Description: 得到信任该用户的用户数据 版权所有? 2010 Myetone 17 内部保密 买易通网站详细设计文档 Function :GetWishCategories Para: [int] accountID, [ListData] list //[out] Return: void Description: 得到用户收藏的目录信息列表。 Function :GetWishProducts Para: [int] accountID, [ListData] list//[out] Return: void Description: 得到用户收藏的商品信息 Function :RemoveList Para: [int] listID //列表项， trust,block,or wish category,wish products. Return: bool // True for succeed False for failed. Description: 从list表里删除选项。 Function： UpdateAccount Para： [AccountData] account Return: bool // True for succeed, False for failed. Description:修改帐号的参数信息。 18 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 Function : ChangePassword Para: [int] accountID, [string] oldPassword, [string] newPassword Return： bool://True for succeed; False for failed. Description:修改密码。 4.1.5 ReviewSystem. Function: CreateReview Para: [ReviewData] review Return:bool // True for success; False for failed. Description:创建新的Review. Function :GetReivewRatings Para [int] reviewID Return: ReviewData // 返回Review的详细 评价 LEC评价法下载LEC评价法下载评价量规免费下载学院评价表文档下载学院评价表文档下载 。 Description: 得到Review的评论和rating信息列表。 Function: GetReviewByID Para : [int] reviewID // Return: [ReviewData] // Description: 根据某个Review的ID返回该Review的信息[包括Review Body] Function: UpdateReview Para: [ReviewData] review 版权所有? 2010 Myetone 19 内部保密 买易通网站详细设计文档 Return: [bool] // True for success, False for failed; Description: Update Review的信息。 4.1.6 StoreSystem. function CreateStore Para: [StoreData] store Return:[bool] // True for success, False for fail. Description: 创建store. Function GetStoreByID Para : [int] storeID Return: [StoreData] // Description:通过storeid得到store的信息。 Function : GetStoreByLogon Para: [string] logon, [string] passwd Return: [StoreData] Description: 根据商店登录名和密码获取商店信息 Function: GetStoreReviews Para: [int] storeID Return: [ReviewData] Description: 不包括ReviewBody. 20 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 Function: UpdateStore Para: [StoreData] store Return:[bool] // True for success, False for failed. Description: update Store Info. Business Rules 4.2 4.2.1 Overview. 4.2.2 Category Related. 1.1 Category List 非叶子Category伪代码算法： If not login status Begin If Cached(Page) Begin showCachePage. //Public View 使用缓存 Return; End; End; //显示非叶子节点的层次目录结构 CategoryData category1 = GetChildren(CurrentCategoryID) For each category1 版权所有? 2010 Myetone 21 内部保密 买易通网站详细设计文档 Begin ShowCategoryTitle(category1.row); SubCategoryID = category1.CategoryID CategoryData category2 = GetChildren(SubCategoryID); For each category2 Begin ShowCategoryTitle(category2.row); End; End; Cache(Page); 叶子节点 If publicView Status = true Begin If Cached(page) then Begin showCachePage. Exit; End; End; ListRefineFilter() // Refer to 2.2 Refine Results By Filter; ListProducts() // Refer to 2.1 List Products. 1.2 Text Navigation //Actually is function GetParents in CategorySystem; DataTable dt; CategoryData category = GetCategoryByID(categoryid); String path = category.row.CATEGORYCODE; 22 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 For each 4 chars in path Begin ID = strtoint(4chars); CategoryData row = GetCategoryByID(ID); dt.addrow(row) End; Return dt; 1.3 // 得到Category对应的Properties列表 GetCategoryProperties(categoryID) Begin Sql = ‘select p.*,g.groupname, from TBL_Property p, TBL_Property_Group g where p.categoryid = categoryID and g.categoryid=categoryID and case p.groupid: when p.goupid>0 then g.groupid=p.groupid’; Result = execute(Sql); Return(Result); End; 1.4 //得到Product的Property和value GetProductProperty(productID) Begin End; 1.5 4.2.3 Product Related 2.1 List Products. //伪代码 版权所有? 2010 Myetone 23 内部保密 买易通网站详细设计文档 CheckCachePageForPublicView(); RefineResultsByFilter(); //Refer to 2.2 ProductData product = GetAllProductsInCategory(catgoryID) Foreach Product ShowProductInfo; 2.2 Refine Results by filter Step A.B.C Step A: Get Contitions Properties. //得到要列出的Property Name, 如品牌，价格，厂家 PropertyArr ＝GetConditionTitles(categoryID) Begin Sql = ‘select distinct con.propertyid, p.propertyName from TBL_Condition con, Tbl_Property p where categoryid=categoryID’ Result = Execute(Sql); Return (Result); End; SelectedPropertyArr = GetSelectedFromLinkParam. ShowPropertyArr = PropertyArr – SelectedPropertyArr; StepB: Show conditions from Step A; Foreach ShowPropertyArr do Begin ShowConditionTitle ListArr = GetConditionListItems(categoryID, ShowPropertyArr[propertyID]) ShowConditionsOfListArr; 24 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 End; //得到要显示的属性的列表，如价格列表。 GetConditionListItems(categoryID, propertyID) Begin Sql = ‘select * from TBL_Condition where categoryid=CategoryID and propertyid=propertyID order by displayOrder’; End; StepC: GetProductsListByConditions. Sql = ‘select * from product where ‘ For each SelectConditionsArr Begin Sql= sql + ‘and’ +SelectConditionsArr[] End; ProductData product = Execute(Sql); ListProducts(); 2.3 List Product Reviews. 2.3.1 ShowReviewsList 版权所有? 2010 Myetone 25 内部保密 买易通网站详细设计文档 2.4 Rate Product. 26 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 2.5 Search Product TBD 4.2.4 Review Related. 3.1 Read Review 3.2 Write Review 3.3 Rate Review 4.2.5 User Related. 4.1 Registration 4.2 Member Page (self); 4.3 Member Page(other) 4.3 Role and Rank 4.2.6 Store Related 版权所有? 2010 Myetone 27 内部保密 买易通网站详细设计文档 5. (Database Design) 5.1 Database summary 23 0 231 23 0 4 1 10 1 4 1 25 1 2 1 19 1 8 1 6 1 5 1 4 1 6 1 8 1 8 1 21 1 7 1 6 1 18 1 28 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 10 1 2 1 13 1 7 1 4 1 34 1 版权所有? 2010 Myetone 29 内部保密 买易通网站详细设计文档 5.2 TBL_ACCOUNT INTEGER Not allowed CHAR(32) Allowed CHAR(32) Allowed CHAR(8) Allowed CHAR(32) Allowed CHAR(4) Allowed CHAR(4) Allowed CHAR(64) Allowed CHAR(8) Allowed CHAR(16) Allowed CHAR(16) Allowed SMALLINT Allowed INTEGER Allowed INTEGER Allowed CHAR(128) Allowed CHAR(128) Allowed CHAR(16) Allowed TIMESTAMP Allowed TIMESTAMP Allowed TIMESTAMP Allowed BOOL Allowed BOOL Allowed BOOL Allowed 30 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 BOOL Allowed BOOL Allowed BOOL Allowed BOOL Allowed BOOL Allowed BOOL Allowed BOOL Allowed INTEGER Allowed INTEGER Allowed CHAR(32) Allowed CHAR(32) Allowed AccountId Ascending 版权所有? 2010 Myetone 31 内部保密 买易通网站详细设计文档 5.3 TBL_ACCOUNT_LOGON INTEGER Not allowed CHAR(20) Not allowed CHAR(20) Not allowed SMALLINT Not allowed AccountID Ascending 32 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.4 TBL_APPLYCHANGE INTEGER Not allowed INTEGER Not allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed TIMESTAMP Allowed ApplyID Ascending 版权所有? 2010 Myetone 33 内部保密 买易通网站详细设计文档 5.5 TBL_ARTICLE INTEGER Not allowed CHAR(64) Not allowed SMALLINT Not allowed SMALLINT Not allowed INTEGER Not allowed SMALLINT Allowed TIMESTAMP Allowed TIMESTAMP Allowed TIMESTAMP Allowed INTEGER Allowed INTEGER Allowed INTEGER Allowed SMALLINT Allowed ArticleID Ascending 34 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.6 TBL_ARTICLE_BODY INTEGER Not allowed CHAR(32767) Allowed ArticleID Ascending 版权所有? 2010 Myetone 35 内部保密 买易通网站详细设计文档 5.7 TBL_BATCH INTEGER Not allowed SMALLINT Not allowed CHAR(64) Not allowed INTEGER Allowed INTEGER Allowed INTEGER Allowed SMALLINT Allowed TIMESTAMP Allowed TIMESTAMP Allowed CHAR(64) Allowed BatchID Ascending 36 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.8 TBL_CATEGORY INTEGER Not allowed CHAR(16) Not allowed CHAR(32) Not allowed INTEGER Not allowed SMALLINT Not allowed INTEGER Allowed CHAR(128) Allowed CHAR(16) Allowed CHAR(16) Allowed CHAR(16) Allowed CHAR(16) Allowed CHAR(16) Allowed INTEGER Allowed SMALLINT Allowed SMALLINT Allowed TIMESTAMP Allowed TIMESTAMP Allowed CHAR(128) Allowed CategoryID Ascending 版权所有? 2010 Myetone 37 内部保密 买易通网站详细设计文档 38 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.9 TBL_CONDITION INTEGER Not allowed INTEGER Not allowed INTEGER Allowed CHAR(64) Allowed SMALLINT Allowed CHAR(64) Allowed ConditionID Ascending 版权所有? 2010 Myetone 39 内部保密 买易通网站详细设计文档 5.10 TBL_LIST INTEGER Not allowed INTEGER Not allowed SMALLINT Not allowed INTEGER Not allowed SMALLINT Allowed TIMESTAMP Allowed TIMESTAMP Allowed ListID Ascending 40 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.11 TBL_PRODUCT INTEGER Not allowed CHAR(64) Not allowed INTEGER Allowed CHAR(128) Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed NUMERIC(10,2) Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed TIMESTAMP Allowed TIMESTAMP Allowed CHAR(128) Allowed INTEGER Allowed INTEGER Allowed CHAR(32) Allowed CHAR(32) Allowed 版权所有? 2010 Myetone 41 内部保密 买易通网站详细设计文档 ProductID Ascending 42 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.12 TBL_PRODUCT_CHANGE INTEGER Not allowed INTEGER Not allowed CHAR(64) Allowed INTEGER Allowed CHAR(128) Allowed NUMERIC(10,2) Allowed SMALLINT Allowed CHAR(128) Allowed PKID Ascending 版权所有? 2010 Myetone 43 内部保密 买易通网站详细设计文档 5.13 TBL_PROPERTY INTEGER Not allowed INTEGER Not allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed CHAR(32) Not allowed CHAR(32) Allowed CHAR(128) Allowed PropertyID Ascending 44 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.14 TBL_PROPERTY_CHANGE INTEGER Not allowed INTEGER Not allowed INTEGER Not allowed NUMERIC(10,2) Allowed SMALLINT Allowed CHAR(64) Allowed PKID Ascending 版权所有? 2010 Myetone 45 内部保密 买易通网站详细设计文档 5.15 TBL_PROPERTY_GROUP INTEGER Not allowed INTEGER Not allowed CHAR(32) Not allowed SMALLINT Allowed GroupID Ascending 46 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.16 TBL_PROPERTY_LIST INTEGER Not allowed INTEGER Not allowed SMALLINT Not allowed SMALLINT Allowed CHAR(32) Not allowed ListID Ascending 版权所有? 2010 Myetone 47 内部保密 买易通网站详细设计文档 5.17 TBL_PROPERTY_VALUE INTEGER Not allowed INTEGER Not allowed INTEGER Not allowed NUMERIC(10,2) Allowed SMALLINT Allowed CHAR(64) Allowed ProductPropertyID Ascending 48 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.18 TBL_RATING INTEGER Not allowed SMALLINT Allowed INTEGER Allowed INTEGER Allowed SMALLINT Allowed SMALLINT Allowed TIMESTAMP Allowed CHAR(64) Allowed RatingID Ascending 版权所有? 2010 Myetone 49 内部保密 买易通网站详细设计文档 5.19 TBL_REVIEW INTEGER Not allowed SMALLINT Not allowed INTEGER Not allowed CHAR(64) Not allowed INTEGER Not allowed CHAR(32) Allowed CHAR(32) Allowed CHAR(128) Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed BOOL Allowed SMALLINT Allowed TIMESTAMP Allowed TIMESTAMP Allowed ReviewID Ascending 50 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 版权所有? 2010 Myetone 51 内部保密 买易通网站详细设计文档 5.20 TBL_REVIEW_BODY INTEGER Not allowed CHAR(32767) Allowed ReviewID Ascending 52 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.21 TBL_STORE INTEGER Not allowed CHAR(32) Not allowed CHAR(128) Allowed CHAR(128) Allowed CHAR(4) Allowed CHAR(4) Not allowed CHAR(64) Allowed CHAR(16) Allowed CHAR(16) Allowed CHAR(16) Allowed CHAR(64) Allowed INTEGER Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed SMALLINT Allowed TIMESTAMP Allowed TIMESTAMP Allowed SMALLINT Allowed INTEGER Allowed INTEGER Allowed 版权所有? 2010 Myetone 53 内部保密 买易通网站详细设计文档 CHAR(32) Allowed CHAR(32) Allowed StoreID Ascending 54 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.22 TBL_STORE_LOGON INTEGER Not allowed CHAR(20) Not allowed CHAR(20) Not allowed SMALLINT Not allowed StoreID Ascending 版权所有? 2010 Myetone 55 内部保密 买易通网站详细设计文档 5.23 TBL_TOPIC INTEGER Not allowed CHAR(64) Not allowed INTEGER Allowed SMALLINT Allowed BOOL Allowed INTEGER Allowed SMALLINT Allowed CHAR(64) Allowed TIMESTAMP Allowed TIMESTAMP Allowed TopicID Ascending 56 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 5.24 TMP_TRUST INTEGER Not allowed INTEGER Not allowed INTEGER Not allowed INTEGER Allowed PKID Ascending 版权所有? 2010 Myetone 57 内部保密 买易通网站详细设计文档 6. (Batch Script Design) 58 版权所有?2010 Myetone 内部保密 买易通网站详细设计文档 7. (Terminology) 7.1 (Web of Trust) 7.2 (Open Taxonomy) 版权所有? 2010 Myetone 59 内部保密