最新軟件項(xiàng)目管理概要設(shè)計(jì)說(shuō)明書免費(fèi)下載-資料下載頁(yè)
2025-04-15 12:17本頁(yè)面
【正文】 lse Table6: enemeyInfoAlias: 天敵信息Description: Column NameAliasDatatypeSizePrimary KeyForeign KeyDefault ValueDescriptione_no天敵編號(hào)inttruetrue e_name天敵名稱nvarchar(255)255falsefalse e_nemen天敵學(xué)名nvarchar(255)255falsefalse e_tyepno天敵類型號(hào)intfalsetrue e_feature天敵特征ntextfalsefalse e_locate天敵地理分布ntextfalsefalse e_habit天敵生活習(xí)性ntextfalsefalse e_prevent天敵保護(hù)方法ntextfalsefalse e_image天敵圖片nvarchar(255)255falsefalse e_show是否首頁(yè)顯示tinyintfalsefalse Table7: enemyTypeAlias: 天敵類型Description: Column NameAliasDatatypeSizePrimary KeyForeign KeyDefault ValueDescriptionen_typeno天敵類型號(hào)inttruefalse en_typename天敵類型名varchar(40)40falsefalse Table8: userPMAlias: 用戶發(fā)表留言Description: Column NameAliasDatatypeSizePrimary KeyForeign KeyDefault ValueDescriptionupm_themeno主題編號(hào)inttruefalse upm_name用戶名nchar(20)20falsetrue upm_theme主題nchar(100)100falsefalse upm_time發(fā)表時(shí)間datetimefalsefalse upm_content內(nèi)容nchar(100)100falsefalse Table9: userRMAlias: 用戶回復(fù)留言Description: Column NameAliasDatatypeSizePrimary KeyForeign KeyDefault ValueDescriptionurm_no回復(fù)編號(hào)inttruefalse urm_themeno主題編號(hào)intfalsetrue urm_time回復(fù)時(shí)間datetimefalsefalse urm_content內(nèi)容nchar(100)100falsefalse urm_name用戶名nchar(20)20falsetrue Table10: newcpInfoAlias: 新害蟲信息Description: Column NameAliasDatatypeSizePrimary KeyForeign KeyDefault ValueDescriptionncp_no編號(hào)inttruefalse ncp_introduce簡(jiǎn)介nchar(100)100falsefalse ncp_username用戶名nchar(20)20falsetrue mark標(biāo)記intfalsefalse0 Table11: PredatorAlias: 天敵和害蟲匹配Description: Column NameAliasDatatypeSizePrimary KeyForeign KeyDefault ValueDescriptionep_eno天敵編號(hào)inttruefalse ep_pno害蟲編號(hào)inttruefalse Table12: pcLinkAlias: 害蟲與蟲病匹配Description: Column NameAliasDatatypeSizePrimary KeyForeign KeyDefault ValueDescriptionpc_pno害蟲編號(hào)inttruefalse pc_o柑橘蟲病編號(hào)inttruefalse Table13: PhotosOfPestAlias: 害蟲相冊(cè)Description: Column NameAliasDatatypeSizePrimary KeyForeign KeyDefault ValueDescriptionppno照片編號(hào)intfalsefalse cp_no害蟲編號(hào)intfalsetrue cp_image害蟲圖片nvarchar(255)255falsefalse Table14: PhotosOfEnemyAlias: 天敵相冊(cè)Description: Column NameAliasDatatypeSizePrimary KeyForeign KeyDefault ValueDescriptionpeno圖片編號(hào)intfalsefalse e_no天敵編號(hào)intfalsetrue e_image天敵圖片nvarchar(255)255falsefalse 視圖設(shè)計(jì)天敵捕食查詢視圖：如圖14所示。圖 14 害蟲與天敵捕食信息查詢視圖英文名：Veplink；別名：害蟲天敵匹配；引用基本表英文名：cpInfo、cpType、epLink、enemyInfo；引用基本表別名：柑橘害蟲信息、柑橘害蟲類別、天敵與害蟲匹配、天敵信息。
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1