環(huán)境管理數(shù)據(jù)庫(kù)設(shè)計(jì)

1、環(huán)境管理數(shù)據(jù)表設(shè)計(jì)文檔環(huán)境管理數(shù)據(jù)表目錄（Condition）編號(hào)表名說(shuō)明1wygl_condition_CleanMaster環(huán)境衛(wèi)生記錄表2wygl_condition_CleanDetail環(huán)境清潔明細(xì)表3wygl_condition_Breed綠化品種檔案表4wygl_condition_AfforestMaster綠化記錄主表5wygl_condition_AfforestDetail綠化記錄子表環(huán)境管理1、環(huán)境衛(wèi)生記錄表：(wygl_condition_CleanMaster)Primary Key：PrecinctID + AreaIDFriend Key：PrecinctID

2、Primary Table：wygl_res_PrecinctFriend Key：AreaID Primary Table：wygl_system_GeneralCodeFriend Key：AreaType Primary Table：wygl_system_GeneralCode編號(hào)字段名字段類(lèi)型寬度默認(rèn)值為空中文描述1PrecinctIDVarChar20No所在管理區(qū)編號(hào)2AreaIDIntNo衛(wèi)生區(qū)域代碼3AreaTypeIntNo衛(wèi)生區(qū)域類(lèi)別代碼4MasterIDVarChar20該衛(wèi)生區(qū)的責(zé)任人代碼5FromTimeDatetime清潔時(shí)間從(hh:ss)6ToTimeDate

3、time至 (hh:ss)7LastCleanDateDatetime最后一次清潔時(shí)間(yyyy/mm/dd hh:ss)8CleanCycleInt清潔周期為X天；提供自動(dòng)提示功能；9CleanRequestVarChar250工作要求10RemarkVarChar250備注2、環(huán)境清潔明細(xì)表：(wygl_condition_CleanDetail)Primary Key：PrecinctID + AreaID + CleanDateFriend Key：PrecinctID + AreaID Primary Table：wygl_condition_CleanMasterFriend Ke

4、y：CleanID Primary Table：wygl_system_GeneralCode編號(hào)字段名字段類(lèi)型寬度默認(rèn)值為空中文描述1PrecinctIDVarChar20No所在管理區(qū)編號(hào)2AreaIDIntNo衛(wèi)生區(qū)域代碼3CleanDateDatetimeNo清潔日期(yyyy/mm/dd hh:ss)4CleanByVarChar20No清潔人代碼，缺省為該衛(wèi)生區(qū)的責(zé)任人；5CheckDateDatetimeNo檢查日期(yyyy/mm/dd)6CleanIDIntNo清潔檢查項(xiàng)目代碼7CleanStatusChar1清潔情況；0 = 差 1 = 中 2 = 好8CheckByVar

5、Char20檢查人代碼9RemarkVarChar250備注3、綠化品種檔案表：(wygl_condition_Breed)Primary Key：PrecinctID + BreedID Friend Key：PrecinctID Primary Table：wygl_res_PrecinctFriend Key：BreedID Primary Table：wygl_system_GeneralCode編號(hào)字段名字段類(lèi)型寬度默認(rèn)值為空中文描述1PrecinctIDVarChar20No所在管理區(qū)編號(hào)2BreedIDIntNo綠化品種代碼3BreedNameVarChar50No綠化品種名稱(chēng)4

6、SpecificationVarChar250規(guī)格5HabitVarChar250習(xí)性6FertilizeIntervalInt施肥時(shí)間間隔X天；7FertilizeLastDateDatetime上次施肥時(shí)間；8WaterIntervalInt澆水時(shí)間間隔X天；9WaterLastDateDatetime上次澆水時(shí)間；10TakeChargeByVarChar20責(zé)任人代碼11RequestVarChar250工作要求12RemarkVarChar250備注4、綠化記錄主表：(wygl_condition_AfforestMaster)Primary Key：PrecinctID + Aff

7、orestDateFriend Key：PrecinctID Primary Table：wygl_res_Precinct編號(hào)字段名字段類(lèi)型寬度默認(rèn)值為空中文描述1PrecinctIDVarChar20No管理區(qū)編號(hào)2AfforestDateDatetimeNo記錄時(shí)間3TtlAreaDecimal18,2總占地面積，從資源檔案中讀入(只讀)；4TtlAfforestAreaDecimal18,2綠化總面積(只讀)；5AfforestPersentDecimal18,2綠化率：綠化總面積/總占地面積(只讀)6TtlAmountDecimal18,2綠化總費(fèi)用；(只讀)7RemarkVarCh

8、ar250備注5、綠化記錄子表：(wygl_condition_AfforestDetail)Primary Key：PrecinctID + AfforestDate + LineNosFriend Key：PrecinctID + AfforestDate Primary Table：wygl_condition_AfforestMasterFriend Key：PrecinctID + BreedID Primary Table：wygl_condition_BreedFriend Key：Unit Primary Table：wygl_system_GeneralCode編號(hào)字段名字段類(lèi)型寬度默認(rèn)值為空中文描述1PrecinctIDVarChar20No管理區(qū)編號(hào)2AfforestDateDatetimeNo記錄時(shí)間3LineNosIntNo行號(hào)4BreedIDIntNo綠化品種代碼5SpecificationVarChar50規(guī)格6Quanti