小區(qū)物業(yè)管理系統(tǒng)分析畢業(yè)論文-資料下載頁(yè)
2025-06-28 18:23本頁(yè)面
【正文】 Change改變用途Char2PBuildnum棟號(hào)Int4Roomnum房間號(hào)Int4Outtime出戶(hù)時(shí)間Datetime8PResidentname小區(qū)名稱(chēng)Char20P表15建筑情況表：字段名意義數(shù)據(jù)類(lèi)型寬度NULL主鍵CardNumber戶(hù)卡編號(hào)Char16PAddress地址Varchar60PResidentname小區(qū)名Char20Buildnum棟號(hào)Int4Roomnum房間號(hào)Int4Arearank地段等級(jí)Char10PStructrank結(jié)構(gòu)等級(jí)Char10PStarttime開(kāi)工時(shí)間Datetime8POvertime竣工時(shí)間Datetime8PArcharea建筑面積Numeric9(18,2)PUsearea使用面積Numeric9(18,2)PDwellarea居住面積Numeric9(18,2)PVeraarea陽(yáng)臺(tái)面積Numeric9(18,2)PRoom間數(shù)Int4PFloor所在層數(shù)Int4PTub浴盆Char10PWindow窗向Char4PWindowinst窗戶(hù)情況Char10PGroundinst地面情況Char10PToiletinst廁所情況Char10PRoominst屋面情況Char10PBuildstylenum戶(hù)型編號(hào)Char10PRemark備注Char50PGas煤氣Char2PDrain給排水Char2PStorehouse倉(cāng)庫(kù)Char2PCheating暖氣Char2PWashbowl面盆Char2PClosestool坐便Char2PRoomcellar室內(nèi)地下室Char2PParlor客廳Char2PDiningroom餐廳Char2PClveranda封閉陽(yáng)臺(tái)Char2PUnclveranda未封閉陽(yáng)臺(tái)Char2PAlcove壁櫥Char2P表16棟卡情況表：字段名意義數(shù)據(jù)類(lèi)型寬度NULL主鍵Buildnum棟號(hào)Int4PAddress地址Varchar60PResidentname小區(qū)名Char20PAssetname資產(chǎn)名稱(chēng)Char30PAssetnum資產(chǎn)編碼Char10PFund資金Char10PArcharea建筑面積Numeric9(18,2)PUsearea使用面積Numeric9(18,2)PDwellarea居住面積Numeric9(18,2)PVeraarea陽(yáng)臺(tái)面積Numeric9(18,2)PAddarea附層面積Numeric9(18,2)PRecoveryarea人防面積Numeric9(18,2)PBdoornum建筑戶(hù)數(shù)Int4PDdoornum居住戶(hù)數(shù)Int4POne單室戶(hù)數(shù)Int4PTwo雙室戶(hù)數(shù)Int4PThree三室戶(hù)數(shù)Int4PFour四室戶(hù)數(shù)Int4PExposedto朝向Char10PTfloor層數(shù)Int4PRoomnum房間數(shù)Int4PUnitnum單元數(shù)Int4PArearank地段等級(jí)Char10PStructrank機(jī)構(gòu)等級(jí)Char10PWallinst屋面狀況Char10PGroundinst地面狀況Char10POrivalue原值Numeric9(18,2)PBuildfee建安費(fèi)Numeric9(18,2)POtherfee其他費(fèi)Numeric9(18,2)PProjectnum工程編號(hào)Char10Building建設(shè)單位Char40Construction施工單位Char40Starttime開(kāi)工時(shí)間Datetime8POvertime竣工時(shí)間Datetime8PIntime入住時(shí)間Datetime8PAvailyear效用年限Int4PUseyear使用年用Int4PMindnum大修次數(shù)Int4PMinditem大修項(xiàng)目Char50PMindtime大修時(shí)間Datetime8PTabletime建表日期Datetime8P表17戶(hù)型表：字段名意義數(shù)據(jù)類(lèi)型寬度NULL主鍵Buildstylenum戶(hù)型編號(hào)Char10PBuildstyle戶(hù)型Char10Explain戶(hù)型說(shuō)明VarChar60PArearank地段等級(jí)Char10PStructrank結(jié)構(gòu)等級(jí)Char10PStarttime開(kāi)工時(shí)間Datetime8POvertime竣工時(shí)間Datetime8PArcharea建筑面積Numeric9(18,2)PUsearea使用面積Numeric9(18,2)PDwellarea居住面積Numeric9(18,2)PVeraarea陽(yáng)臺(tái)面積Numeric9(18,2)PRoom間數(shù)Int4PFloor所在層數(shù)Int4PTub浴盆Char10PWindow窗向Char10PWindowinst窗戶(hù)情況Char10PGroundinst地面情況Char10PToiletinst廁所情況Char10PRoominst屋面情況Char10PRemark備注Char50PGas煤氣Char2PDrain給排水Char2PStorehouse倉(cāng)庫(kù)Char2PCheating暖氣Char2PWashbowl面盆Char2PClosestool坐便Char2PRoomcellar室內(nèi)地下室Char2PParlor客廳Char2PDiningroom餐廳Char2PClveranda封閉陽(yáng)臺(tái)Char2PUnclveranda未封閉陽(yáng)臺(tái)Char2PAlcove壁櫥Char2Ppicture建筑圖Image16P表1
電大資料相關(guān)推薦
鄂ICP備17016276號(hào)-1