kesion科讯数据库结构.doc

PDM信息项目名称示例项目目录文件名kesion.pdm数据库类型MICROSOFT表数量159PDM所在目录C:Documents and SettingsAdministratorMy Documents更新日期2014-5-8 16:34:28模块列表PhysicalDiagram_1PhysicalDiagram_1清单:表名解释KS_ADIPLISTKS_AdiplistKS_ADMINKS_AdminKS_ADPLACEKS_ADPlaceKS_ADVERTISEKS_AdvertiseKS_ANNOUNCEKS_AnnounceKS_ARTICLEKS_ArticleKS_ASKANSWERKS_AskAnswerKS_ASKCLASSKS_AskClassKS_ASKFAVORITEKS_AskFavoriteKS_ASKGRADEKS_AskGradeKS_ASKPOSTS1KS_AskPosts1KS_ASKTOPICKS_AskTopicKS_ASKZJKS_AskZJKS_BLOGKS_BlogKS_BLOGCLASSKS_BlogClassKS_BLOGCOMMENTKS_BlogCommentKS_BLOGINFOKS_BlogInfoKS_BLOGMESSAGEKS_BlogMessageKS_BLOGMUSICKS_BlogMusicKS_BLOGSKINKS_BlogSkinKS_BLOGTEMPLATEKS_BlogTemplateKS_BLOGTYPEKS_BlogTypeKS_BLOGVISITORKS_BlogVisitorKS_CHANNELKS_ChannelKS_CLASSKS_ClassKS_CLASSBRANDKS_ClassBrandKS_CLASSBRANDRKS_ClassBrandRKS_COMMENTKS_CommentKS_CONFIGKS_ConfigKS_DELIVERYKS_DeliveryKS_DELIVERYTYPEKS_DeliverytypeKS_DIGGKS_DiggKS_DIGGLISTKS_DiggListKS_DOWNLOADKS_DownLoadKS_DOWNPARAMKS_DownParamKS_DOWNSERKS_DownSerKS_ENTERPRISEKS_EnterpriseKS_ENTERPRISEADKS_EnterPriseADKS_ENTERPRISECLASSKS_EnterPriseClassKS_ENTERPRISENEWSKS_EnterpriseNewsKS_ENTERPRISEZSKS_EnterpriseZSKS_FAVORITEKS_FavoriteKS_FEEDBACKKS_FeedbackKS_FIELDKS_FieldKS_FLASHKS_FlashKS_FORMKS_FormKS_FORMFIELDKS_FormFieldKS_FRIENDKS_FriendKS_GQKS_GQKS_GQTYPEKS_GQTypeKS_GROUPBUYKS_GroupBuyKS_GROUPBUYCLASSKS_GroupBuyClassKS_GUESTBOARDKS_GuestBoardKS_GUESTBOOKKS_GuestBookKS_GUESTCATEGORYKS_GuestCategoryKS_GUESTCOMMENTKS_GuestCommentKS_GUESTMEDALKS_GuestMedalKS_GUESTREPLYKS_GuestReplyKS_INNERLINKKS_InnerLinkKS_ITEMINFOKS_ItemInfoKS_ITEMINFORKS_ItemInfoRKS_ITEMSIGNKS_ItemSignKS_JOB_COMPANYKS_Job_CompanyKS_JOB_EDUKS_Job_EduKS_JOB_HYZWKS_Job_HyzwKS_JOB_INTERVIEWKS_Job_InterviewKS_JOB_LETTERKS_Job_LetterKS_JOB_LISTKS_Job_ListKS_JOB_RESUMEKS_Job_ResumeKS_JOB_RESUMESCKS_Job_ResumeSCKS_JOB_SCHOOLKS_Job_SchoolKS_JOB_TEMPLATEKS_Job_TemplateKS_JOB_ZWKS_Job_ZWKS_JSFILEKS_JSFileKS_KEYWORDSKS_KeyWordsKS_LABELKS_LabelKS_LABELFOLDERKS_LabelFolderKS_LINKKS_LinkKS_LINKFOLDERKS_LinkFolderKS_LOGKS_LogKS_LOGCONSUMKS_LogConsumKS_LOGDELIVERKS_LogDeliverKS_LOGEDAYSKS_LogEdaysKS_LOGINVOICEKS_LogInvoiceKS_LOGMONEYKS_LogMoneyKS_LOGPOINTKS_LogPointKS_LOGSCOREKS_LogScoreKS_MALLSCOREKS_MallScoreKS_MALLSCOREORDERKS_MallScoreOrderKS_MEDIASERVERKS_MediaServerKS_MESSAGEKS_MessageKS_MOODLISTKS_MoodListKS_MOODPROJECTKS_MoodProjectKS_MOVIEKS_MovieKS_MOVIEONLINEKS_MovieOnlineKS_MOVIEPARAMKS_MovieParamKS_MSCLASSKS_MSClassKS_MSSCLASSKS_MSSClassKS_MSSINGERKS_MSSingerKS_MSSONGLISTKS_MSSongListKS_MSSONGWORDKS_MSSongWordKS_MSSPECIALKS_MSSpecialKS_MSSPECIALCOMMENTKS_MSSpecialCommentKS_MSUSERADDWORDKS_MSUserAddWordKS_NOTDOWNKS_NotDownKS_ONLINEKS_OnlineKS_ORDERKS_OrderKS_ORDERITEMKS_OrderItemKS_ORIGINKS_OriginKS_PAYMENTPLATKS_PaymentPlatKS_PAYMENTTYPEKS_PaymentTypeKS_PHOTOKS_PhotoKS_PHOTOCLASSKS_PhotoClassKS_PHOTOVOTEKS_PhotoVoteKS_PHOTOXCKS_PhotoxcKS_PHOTOZPKS_PhotozpKS_PKGDKS_PKGDKS_PKZTKS_PKZTKS_PRODUCTKS_ProductKS_PROIMAGESKS_ProImagesKS_PROMOTEDPLANKS_PromotedPlanKS_PROPRICEKS_ProPriceKS_PROVINCEKS_ProvinceKS_SHOPBUNDLESALEKS_ShopBundleSaleKS_SHOPBUNDLESELECTKS_ShopBundleSelectKS_SHOPCOUPONKS_ShopCouponKS_SHOPCOUPONUSERKS_ShopCouponUserKS_SHOPLIMITBUYKS_ShopLimitBuyKS_SHOPPACKAGEKS_ShopPackageKS_SHOPPACKAGEPROKS_ShopPackageProKS_SHOPPACKAGESELECTKS_ShopPackageSelectKS_SHOPPINGCARTKS_ShoppingCartKS_SHOPUNIONKS_ShopUnionKS_SHOPUNIONRKS_ShopUnionRKS_SITECOUNTKS_SiteCountKS_SJKS_SJKS_SJCLASSKS_SJClassKS_SJRNDTEMPKS_SJRndTempKS_SJRNDZJKS_SJRndZJKS_SJSCOREKS_SJScoreKS_SJTKKS_SJTKKS_SPECIALKS_SpecialKS_SPECIALCLASSKS_SpecialClassKS_SPECIALRKS_SpecialRKS_TEAMKS_TeamKS_TEAMCLASSKS_TeamClassKS_TEAMTOPICKS_TeamTopicKS_TEAMUSERSKS_TeamUsersKS_TEMPLATEKS_TemplateKS_UPLOADFILESKS_UploadFilesKS_USERKS_UserKS_USERCARDKS_UserCardKS_USERCLASSKS_UserClassKS_USERFORMKS_UserFormKS_USERGROUPKS_UserGroupKS_USERLOGKS_UserLogKS_USERMAILKS_UserMailKS_VOTEKS_VoteKS_WAPTEMPLATEKS_WapTemplate表名:KS_ADIPLIST 解释:KS_Adiplist KS_ADIPLIST(KS_Adiplist)是否主键字段名字段描述数据类型长度可空约束缺省值备注IDidCOUNTERADIDadidINTEGER是TIMEtimeDATETIME是IPipTEXT(50)50是CLASSclassINTEGER是返回表名:KS_ADMIN 解释:KS_Admin KS_ADMIN(KS_Admin)是否主键字段名字段描述数据类型长度可空约束缺省值备注ADMINIDAdminIDCOUNTERUSERNAMEUserNameTEXT(50)50是PASSWORDPassWordTEXT(50)50是PRUSERNAME前台用户TEXT(50)50是REALNAME真实姓名TEXT(20)20是SEX性别TEXT(2)2是TELPHONE电话TEXT(15)15是EMAIL邮箱TEXT(50)50是DESCRIPTIONDescriptionTEXT(255)255是ADDDATEAddDateDATETIME是LASTLOGINIPLastLoginIPTEXT(50)50是LASTLOGINTIMELastLoginTimeDATETIME是LASTLOGOUTTIMELastLogoutTimeDATETIME是LOGINTIMESLoginTimesINTEGER是LOCKEDLockedBYTE是SUPERTFSuperTFTEXT(10)10是GROUPIDGroupIDINTEGER是返回表名:KS_ADPLACE 解释:KS_ADPlace KS_ADPLACE(KS_ADPlace)是否主键字段名字段描述数据类型长度可空约束缺省值备注PLACEplaceCOUNTERPLACENAMEplacenameTEXT(50)50是PLACELEIplaceleiINTEGER是PLACEHEIplaceheiTEXT(50)50是PLACEWIDplacewidTEXT(50)50是SHOW_FLAGshow_flagINTEGER是返回表名:KS_ADVERTISE 解释:KS_Advertise KS_ADVERTISE(KS_Advertise)是否主键字段名字段描述数据类型长度可空约束缺省值备注IDidCOUNTERSITENAMEsitenameTEXT(50)50是INTROintroMEMO是ACTactINTEGER是CLASSclassINTEGER是PLACEplaceINTEGER是GIF_URLgif_urlMEMO是URLurlMEMO是WINDOWwindowINTEGER是SHOWshowINTEGER是SHOWSshowsINTEGER是CLICKclickINTEGER是CLICKSclicksINTEGER是TIMEtimeDATETIME是LASTTIMElasttimeDATETIME是REGTIMEregtimeDATETIME是XSLEIxsleiTEXT(10)10是HEIheiTEXT(50)50是WIDwidTEXT(50)50是ADORDERIDAdOrderIDINTEGER是返回表名:KS_ANNOUNCE 解释:KS_Announce KS_ANNOUNCE(KS_Announce)是否主键字段名字段描述数据类型长度可空约束缺省值备注IDIDCOUNTERCHANNELIDChannelIDINTEGER是TITLETitleTEXT(255)255是CONTENTContentMEMO是AUTHORAuthorTEXT(50)50是ADDDATEAddDateDATETIME是NEWESTTFNewestTFINTEGER是返回表名:KS_ARTICLE 解释:KS_Article KS_ARTICLE(KS_Article)是否主键字段名字段描述数据类型长度可空约束缺省值备注ID自动编号COUNTERTID对应的栏目IDTEXT(25)25是KEYWORDS文章关键字TEXT(255)255是TITLETYPETitleTypeTEXT(30)30是TITLE简短标题TEXT(200)200是FULLTITLE完整标题TEXT(255)255是INTRO文章导读MEMO是SHOWCOMMENT是否显示评论链接BYTE是TITLEFONTCOLOR加颜色TEXT(30)30是TITLEFONTTYPETitleFontTypeTEXT(30)30是ARTICLECONTENT文章内容MEMO是AUTHOR作者TEXT(50)50是ORIGIN来源TEXT(50)50是RANK等级TEXT(10)10是HITS点击数INTEGER是ADDDATE添加日期DATETIME是JSID自由JS IDTEXT(200)200是TEMPLATEID模板IDTEXT(255)255是FNAME生成的文件名TEXT(200)200是REFRESHTF生成标志BYTE是PICNEWS图片文章标志BYTE是CHANGES标题文章BYTE是RECOMMEND推荐BYTE是ROLLS滚动文章标志BYTE是STRIP头条文章标志BYTE是POPULAR热门文章标志BYTE是VERIFIC审核状态 0 投稿 1已审 2草稿 3被退回BYTE是SLIDE幻灯片文章标志BYTE是ISVIDEO含有视频BYTE是COMMENT推荐文章标志BYTE是ISTOP是否固顶BYTE是DELTF删除标志BYTE是INFOPURVIEW查看权限0继承栏目权限,1所有会员,2指定会员组BYTE是ARRGROUPID指定会员组的查看权限TEXT(100)100是READPOINT阅读点数INTEGER是CHARGETYPE重复收费方式0不重复收费1距离上次收费时间2会员重复阅读此文章3上述两者都满足时重新收费4上述两者任一个满足时就重新收费5每阅读一次就重复收费一次BYTE是PITCHTIME重复收费小时数INTEGER是READTIMES重复收费查看次数INTEGER是DIVIDEPERCENT与投稿者的分成比例INTEGER是HITSBYDAYHitsByDayINTEGER是HITSBYWEEKHitsByWeekINTEGER是HITSBYMONTHHitsByMonthINTEGER是LASTHITSTIMELastHitsTimeDATETIME是PHOTOURLPhotoUrlTEXT(255)255是INPUTERInputerTEXT(50)50是PAGETITLEPageTitleMEMO是WAPTEMPLATEIDWapTemplateIDTEXT(255)255是ISSIGN是否需要签收BYTE是SIGNUSER需要签收的用户MEMO是SIGNDATELIMIT签收时间限制BYTE是SIGNDATEEND最迟签收时间DATETIME是PROVINCEProvinceTEXT(100)100是CITYCityTEXT(200)200是MAPMARKERMapMarkerTEXT(255)255是POSTIDPostIDINTEGER是POSTTABLEPostTableTEXT(100)100是返回表名:KS_ASKANSWER 解释:KS_AskAnswer KS_ASKANSWER(KS_AskAnswer)是否主键字段名字段描述数据类型长度可空约束缺省值备注ANSWERIDAnswerIDCOUNTERTOPICIDTopicIDINTEGER是CLASSIDClassIDINTEGER是CLASSNAMEclassnameTEXT(50)50是USERNAMEUserNameTEXT(50)50是POSTUSERNAMEPostUsernameTEXT(50)50是TITLEtitleTEXT(255)255是ANSWERTIMEAnswerTimeDATETIME是POSTTABLEPostTableTEXT(50)50是ANSWERNUMAnswerNumINTEGER是ANSWERMODEAnswerModeBYTE是TOPICMODETopicModeBYTE是返回表名:KS_ASKCLASS 解释:KS_AskClass KS_ASKCLASS(KS_AskClass)是否主键字段名字段描述数据类型长度可空约束缺省值备注CLASSIDclassidINTEGER是CLASSNAMEClassNameTEXT(50)50是READMEReadmeTEXT(255)255是ROOTIDrootidINTEGER是DEPTHdepthINTEGER是ORDERSordersINTEGER是PARENTIDparentidINTEGER是PARENTSTRparentstrTEXT(255)255是CHILDchildINTEGER是ASKMASTERAskmasterTEXT(255)255是C_SETTINGc_settingMEMO是ASKPENDNUMAskPendNumINTEGER是ASKDONENUMAskDoneNumINTEGER是ASKVOTENUMAskVoteNumINTEGER是ASKSHARENUMAskshareNumINTEGER是返回表名:KS_ASKFAVORITE 解释:KS_AskFavorite KS_ASKFAVORITE(KS_AskFavorite)是否主键字段名字段描述数据类型长度可空约束缺省值备注FAVORIDfavoridCOUNTERUSERNAMEUserNameTEXT(50)50是TOPICIDTopicIDINTEGER是FAVORTIMEFavorTimeDATETIME是TYPEFLAGTypeflagBYTE是返回表名:KS_ASKGRADE 解释:KS_AskGrade KS_ASKGRADE(KS_AskGrade)是否主键字段名字段描述数据类型长度可空约束缺省值备注GRADEIDGradeIDCOUNTERUSERTITLEUserTitleTEXT(50)50是SCOREScoreINTEGER是ICOIcoTEXT(50)50是CLUBPOWERClubPowerMEMO是CLUBPOSTNUMClubPostNumINTEGER是COLORcolorTEXT(30)30是TYPEFLAGTypeFlagBYTE是SPECIALSpecialBYTE是返回表名:KS_ASKPOSTS1 解释:KS_AskPosts1 KS_ASKPOSTS1(KS_AskPosts1)是否主键字段名字段描述数据类型长度可空约束缺省值备注POSTSIDpostsidCOUNTERTOPICIDTopicIDINTEGER是CLASSIDclassidINTEGER是USERNAMEUserNameTEXT(50)50是TOPICtopicTEXT(255)255是CONTENTcontentMEMO是ADDTEXTaddTextMEMO是POSTTIMEPostTimeDATETIME是DONETIMEDoneTimeDATETIME是LENGTHlengthINTEGER是STARstarINTEGER是SATISsatisBYTE是LOCKTOPICLockTopicBYTE是POSTSMODEPostsModeBYTE是VOTENUMVoteNumINTEGER是PLUSPlusINTEGER是MINUSMinusINTEGER是POSTIPPostIPTEXT(100)100是REPORTReportINTEGER是返回表名:KS_ASKTOPIC 解释:KS_AskTopic KS_ASKTOPIC(KS_AskTopic)是否主键字段名字段描述数据类型长度可空约束缺省值备注TOPICIDTopicIDCOUNTERCLASSIDclassidINTEGER是USERNAMEUserNameTEXT(50)50是CLASSNAMEclassnameTEXT(50)50是TITLEtitleTEXT(255)255是EXPIREDExpiredINTEGER是CLOSEDClosedINTEGER是POSTTABLEPostTableTEXT(30)30是DATEANDTIMEDateAndTimeDATETIME是LASTPOSTTIMELastPostTimeDATETIME是EXPIREDTIMEExpiredTimeDATETIME是LOCKTOPICLockTopicBYTE是REWARDRewardINTEGER是HITSHitsINTEGER是POSTNUMPostNumINTEGER是COMMENTNUMCommentNumINTEGER是TOPICMODETopicModeBYTE是ASKEDMODEAskedModeBYTE是HIGHLIGHTHighlightINTEGER是BROADCASTBroadcastINTEGER是ANONYMOUSAnonymousBYTE是ISTOPIsTopBYTE是SUPPLEMENTsupplementINTEGER是RECOMMENDRecommendBYTE是ASKUSERIDAskUserIDINTEGER是返回表名:KS_ASKZJ 解释:KS_AskZJ KS_ASKZJ(KS_AskZJ)是否主键字段名字段描述数据类型长度可空约束缺省值备注IDidCOUNTERUSERIDuseridINTEGER是USERNAMEusernameTEXT(255)255是REALNAMErealnameTEXT(255)255是BIRTHDAYbirthdayTEXT(255)255是QQQQTEXT(50)50是MSNMSNTEXT(100)100是USERFACEUserFaceTEXT(200)200是TELTelTEXT(100)100是PROVINCEProvinceTEXT(100)100是CITYCityTEXT(100)100是DANWEIDanWeiTEXT(100)100是TYPENAMETypeNameTEXT(255)255是SCFLSCFLMEMO是INTROIntroMEMO是IDCARDIDCardTEXT(100)100是RYZRYZTEXT(100)100是ADDDATEAddDateDATETIME是STATUSStatusINTEGER是SEXSexTEXT(50)50是RECOMMENDRecommendINTEGER是返回表名:KS_BLOG 解释:KS_Blog KS_BLOG(KS_Blog)是否主键字段名字段描述数据类型长度可空约束缺省值备注BLOGIDBlogIDCOUNTERUSERIDUserIDINTEGER是USERNAME用户名TEXT(100)100是BLOGNAME博客名称TEXT(255)255是DOMAIN二级域名前缀TEXT(100)100是LOGOlogo地址TEXT(255)255是CLASSID站点类型INTEGER是DESCRIPT站点描述MEMO是ANNOUNCE公告MEMO是CONTENTLEN日志默认部分显示字数INTEGER是LISTBLOGNUM每页显示日志篇数INTEGER是LISTLOGNUM显示最新日志篇数INTEGER是LISTREPLAYNUM显示最新回复条数INTEGER是LISTGUESTNUM显示最新留言条数INTEGER是TEMPLATEID博客模板INTEGER是ADDDATE创建时间DATETIME是RECOMMEND是否推荐0推荐1不推荐INTEGER是STATUS站点状态：0未审1已审2锁定INTEGER是HITS访问人数INTEGER是BANNERBannerTEXT(255)255是返回表名:KS_BLOGCLASS 解释:KS_BlogClass KS_BLOGCLASS(KS_BlogClass)是否主键字段名字段描述数据类型长度可空约束缺省值备注CLASSIDClassIDCOUNTERCLASSNAMEClassNameTEXT(100)100是ORDERIDorderidINTEGER是返回表名:KS_BLOGCOMMENT 解释:KS_BlogComment KS_BLOGCOMMENT(KS_BlogComment)是否主键字段名字段描述数据类型长度可空约束缺省值备注IDIDCOUNTERLOGID日志IDINTEGER是TITLE标题TEXT(255)255是CONTENT评论内容MEMO是USERNAME日志归属者TEXT(50)50是ANOUNNAME评论人的昵称TEXT(50)50是HOMEPAGE个人主页TEXT(200)200是USERIPIPTEXT(200)200是ADDDATE发表时间DATETIME是REPLAY回复内容MEMO是REPLAYDATE回复时间DATETIME是READTFReadTFBYTE是返回表名:KS_BLOGINFO 解释:KS_BlogInfo KS_BLOGINFO(KS_BlogInfo)是否主键字段名字段描述数据类型长度可空约束缺省值备注IDIDCOUNTERUSERIDUserIDINTEGER是USERNAME用户名TEXT(50)50是TYPEID日志类型INTEGER是CLASSID我的分类INTEGER是TITLE日志标题TEXT(255)255是TAGS标签tagsTEXT(255)255是CONTENT日志内容MEMO是PASSWORD日志密码TEXT(50)50是HITS点击次数INTEGER是ADDDATE发表时间DATETIME是FACE日志心情INTEGER是WEATHER天气图标TEXT(50)50是STATUS状态0正常1草稿2锁定INTEGER是BEST是否精华 1是2不是INTEGER是ISTALKIsTalkINTEGER是TOTALPUTTotalPutINTEGER是PHOTOURLPhotoUrlTEXT(200)200是返回表名:KS_BLOGMESSAGE 解释:KS_BlogMessage KS_BLOGMESSAGE(KS_BlogMessage)是否主键字段名字段描述数据类型长度可空约束缺省值备注IDIDCOUNTERTITLE标题TEXT(255)255是CONTENT回复内容MEMO是USERNAME日志归属者TEXT(50)50是ANOUNNAME评论人的昵称TEXT(50)50是HOMEPAGE个人主页TEXT(200)200是USERIPIPTEXT(200)200是ADDDATE发表时间DATETIME是REPL