地理信息系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)文檔

WEBGIS-POWER系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)文檔WEBGIS-POWER系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)文檔田萬龍?zhí)锶f龍文檔編號(hào)：TWL-WEBGIS-POWER-DATABASEV1-1配電地理信息系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)文檔田萬龍20087一、基礎(chǔ)數(shù)據(jù)表詳細(xì)數(shù)據(jù)字典表名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER290否PARENTIDNUMBER290否LAYERNUMBER100否CODE_TYPEVARCHAR2255是CODE_CODEVARCHAR2255是CODE_DESCRIPTIONVARCHAR2255是CODE_TOPTYPEVARCHAR2255是CODE_NAMEVARCHAR2255是OTHERVARCHAR2255是LINK_PAGEVARCHAR2255是'page_right.asp'TABLE_NAMEVARCHAR2255是INITSTATENUMBER10是0MODEL_NAMEVARCHAR2255是ISEQUIPNUMBER10是COLORVARCHAR250是IMAGEVARCHAR250是TABVARCHAR250是DIS_220NUMBER100是DIS_110NUMBER100是DIS_35NUMBER100是數(shù)據(jù)字典分類表名稱名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值TAB_IDNUMBER60否PARENT_TAB_IDNUMBER60是TAB_NAMETAB_NAMEVARCHAR220否TAB_DESCRIBEVARCHAR220是COLS_ISBUILTCHAR1否0用戶自定義數(shù)據(jù)表（DATA_STORED_TAB ）名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER100否TAB_IDNUMBER60否VCHAR1VARCHAR210是NUM1NUMBER100是DATE1VARCHAR210是VCHAR2VARCHAR210是NUM2NUMBER100是DATE2VARCHAR210是VCHAR3VARCHAR210是NUM3NUMBER100是DATE3VARCHAR210是VCHAR4VARCHAR210是NUM4NUMBER100是DATE4VARCHAR210是VCHAR5VARCHAR210是NUM5NUMBER100是DATE5VARCHAR210是VCHAR6VARCHAR210是NUM6NUMBER100是DATE6VARCHAR210是VCHAR7VARCHAR210是NUM7NUMBER100是DATE7VARCHAR210是VCHAR8VARCHAR210是NUM8NUMBER100是DATE8VARCHAR210是VCHAR9VARCHAR210是NUM9NUMBER100是DATE9VARCHAR210是VCHAR10VARCHAR210是NUM10NUMBER100是DATE10VARCHAR210是VCHAR11VARCHAR210是NUM11NUMBER100是DATE11VARCHAR210是VCHAR12VARCHAR210是NUM12NUMBER100是DATE12VARCHAR210是VCHAR13VARCHAR210是NUM13NUMBER100是DATE13VARCHAR210是VCHAR14VARCHAR210是NUM14NUMBER100是DATE14VARCHAR210是VCHAR15VARCHAR210是NUM15NUMBER100是DATE15VARCHAR210是VCHAR16VARCHAR210是NUM16NUMBER100是DATE16VARCHAR210是VCHAR17VARCHAR210是NUM17NUMBER100是DATE17VARCHAR210是VCHAR18VARCHAR210是NUM18NUMBER100是DATE18VARCHAR210是VCHAR19VARCHAR210是NUM19NUMBER100是DATE19VARCHAR210是VCHAR20VARCHAR210是NUM20NUMBER100是DATE20VARCHAR210是VCHAR21VARCHAR210是NUM21NUMBER100是DATE21VARCHAR210是VCHAR22VARCHAR210是NUM22NUMBER100是DATE22VARCHAR210是VCHAR23VARCHAR210是NUM23NUMBER100是DATE23VARCHAR210是VCHAR24VARCHAR210是NUM24NUMBER100是DATE24VARCHAR210是VCHAR25VARCHAR210是NUM25NUMBER100是DATE25VARCHAR210是VCHAR26VARCHAR210是NUM26NUMBER100是DATE26VARCHAR210是VCHAR27VARCHAR210是NUM27NUMBER100是DATE27VARCHAR210是VCHAR28VARCHAR210是NUM28NUMBER100是DATE28VARCHAR210是VCHAR29VARCHAR210是NUM29NUMBER100是DATE29VARCHAR210是VCHAR30VARCHAR210是NUM30NUMBER100是DATE30VARCHAR210是VCHAR31VARCHAR210是NUM31NUMBER100是DATE31VARCHAR210是VCHAR32VARCHAR210是NUM32NUMBER100是DATE32VARCHAR210是VCHAR33VARCHAR210是NUM33NUMBER100是DATE33VARCHAR210是VCHAR34VARCHAR210是NUM34NUMBER100是DATE34VARCHAR210是VCHAR35VARCHAR210是NUM35NUMBER100是DATE35VARCHAR210是VCHAR36VARCHAR210是NUM36NUMBER100是DATE36VARCHAR210是VCHAR37VARCHAR210是NUM37NUMBER100是DATE37VARCHAR210是VCHAR38VARCHAR210是NUM38NUMBER100是DATE38VARCHAR210是VCHAR39VARCHAR210是NUM39NUMBER100是DATE39VARCHAR210是VCHAR40VARCHAR210是NUM40NUMBER100是DATE40VARCHAR210是VCHAR41VARCHAR210是NUM41NUMBER100是DATE41VARCHAR210是VCHAR42VARCHAR210是NUM42NUMBER100是DATE42VARCHAR210是VCHAR43VARCHAR210是NUM43NUMBER100是DATE43VARCHAR210是VCHAR44VARCHAR210是NUM44NUMBER100是DATE44VARCHAR210是VCHAR45VARCHAR210是NUM45NUMBER100是DATE45VARCHAR210是VCHAR46VARCHAR210是NUM46NUMBER100是DATE46VARCHAR210是VCHAR47VARCHAR210是NUM47NUMBER100是DATE47VARCHAR210是VCHAR48VARCHAR210是NUM48NUMBER100是DATE48VARCHAR210是VCHAR49VARCHAR210是NUM49NUMBER100是DATE49VARCHAR210是VCHAR50VARCHAR210是NUM50NUMBER100是DATE50VARCHAR210是系統(tǒng)操作日志表名稱名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER290是USER_CODEVARCHAR250是USER_COMVARCHAR220是LOGIN_TIMEDATE7是LOGIN_IPVARCHAR220是角色權(quán)限表（GIS_GROUP_PERM）名稱名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER100否GROUP_CODEVARCHAR220否PERM_CODEVARCHAR250否角色定義表（GIS_SYS_GROUP）名稱名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER100否GROUP_CODEVARCHAR220否GROUP_NAMEVARCHAR240否GROUP_DESCVARCHAR2500是權(quán)限定義表（GIS_SYS_PERM）名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值PERM_CODEVARCHAR250否PERM_TYPEVARCHAR250否PERM_NAMEVARCHAR2100否名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值用戶定義表（GIS_SYS_USER名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER100否USER_CODEVARCHAR220否USER_NAMEVARCHAR240否USER_DESCVARCHAR2500是ISSUPERVARCHAR21否'0'PASSWORDVARCHAR28否用戶角色表（GIS_USER_GROUP）名稱名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER100否USER_CODEVARCHAR220否GROUP_CODEVARCHAR240否樹形數(shù)據(jù)存儲(chǔ)表（TREES）名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDCHAR50否TGLEVELVARCHAR250是TGTEXTVARCHAR2100是TGHREFVARCHAR2100是TGTARGETVARCHAR250是TGICONVARCHAR250是TGSHORTCUTVARCHAR250是TGDATEVARCHAR250是TGLIKEAFOLDERVARCHAR250是TGACLVARCHAR250是二、地圖相關(guān)表GPS導(dǎo)入數(shù)據(jù)存儲(chǔ)表（IMPORT_GPS_TAB）名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值G_IDNUMBER200是G_XNUMBER1812是G_YNUMBER1812是G_ZNUMBER1812是G_CREATE_TIMEDATE7是G_ISDRAWNUMBER10是G_DRAW_TIMEDATE7是地圖打印紙張配置表（MAP_PRINT_SETUP）名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值P_NAMEVARCHAR2100是P_WNUMBER182是P_HNUMBER182是地圖與數(shù)據(jù)庫信息同步表（MAP_SYNCH_TAB）名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值S_IDNUMBER200是S_SIDNUMBER200是S_KINDVARCHAR250是S_LAYERVARCHAR250是S_FKEYNUMBER300是S_OLDVALUEVARCHAR2250是S_NEWVALUEVARCHAR2250是S_CREATE_TIMEDATES_CREATE_TIMEDATE7是S_ISDONENUMBER10是S_DONE_TIMEDATE7是線路導(dǎo)線表名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值L_IDNUMBER200否W_IDNUMBER200否L_TYPEVARCHAR250是L_ISSUBNUMBER10是L_LENGTHNUMBER200是L_START_TOWERNUMBER200是L_END_TOWERNUMBER200是交跨信息表名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值S_IDNUMBER200否S_CODEVARCHAR2100是S_NAMEVARCHAR2100是S_ANGLENUMBER60是S_HEIGHTNUMBER60是S_TYPEVARCHAR250是S_WIDNUMBER200是S_DISTNUMBER200是S_XNUMBER1812是S_YNUMBER1812是S_LAYERVARCHAR250是S_FKEYNUMBER300是S_START_TOWERNUMBER200是S_END_TOWERS_END_TOWERNUMBER200是變電站信息表名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值S_IDNUMBER60否S_CODEVARCHAR2100是S_NAMEVARCHAR2100是S_SHORTNAMEVARCHAR2100是S_LAYERVARCHAR250是S_FKEYNUMBER300是S_POSVARCHAR21000是S_VOLNUMBER10是S_ASSET_SUBJECTNUMBER10是S_CHECK_SUMNUMBER60是S_FEE_SUMNUMBER60是名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值桿塔信息表名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值T_IDNUMBER200否T_CODEVARCHAR2100是T_NAMEVARCHAR2100是T_TYPEVARCHAR250是T_HEIGHTNUMBER60是T_XNUMBER1812是T_YNUMBER1812是T_POSVARCHAR2100是T_LADFORMVARCHAR2100是T_MATERIALNUMBER60是T_ENDVARCHAR210是T_DEEPNUMBER41是T_LENTHNUMBER102是T_ANGLENUMBER102是T_LINE_DISTANCENUMBER62是T_LINE_AVARCHAR210是T_LINE_BVARCHAR210是T_LINE_CVARCHAR210是T_DRAWLINE_TYPENUMBER10是T_DRAWLINE_SECTIONVARCHAR232是T_DRAWLINE_NUMBERNUMBER50是T_ASSET_SUBJECTNUMBER10是T_HAVE_BRANCHNUMBER10是T_LINE_SJ_LENNUMBER102是T_SJ_ANGLENUMBER102是T_NAGNUMBER10是T_NZ_XHNUMBER10是T_LINE_STYLENUMBER50是T_HIGH_LOWERCHAR1是T_MAP_ZNUMBER102是變壓器信息表（TRANSFORMER_TAB ）名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值T_IDNUMBER200否T_CODEVARCHAR2100是T_NAMEVARCHAR2100是T_LAYERVARCHAR250是T_FKEYNUMBER300是T_XNUMBER1812是T_YNUMBER1812是線路電壓等級(jí)表（WIRE_TYPE_TAB）名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值WIDVARCHAR230是WNAMEVARCHAR2100是WIDXNUMBER0是線路信息表（WIRE名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值W_IDNUMBER200否W_CODEVARCHAR2100是W_NAMEVARCHAR2100是W_MAINWIDNUMBER200是W_PARENTNUMBER200是W_FIRSTTNUMBER200是W_SUBIDNUMBER200是W_KINDVARCHAR230是W_LINE_TYPEVARCHAR250是W_LENGTHNUMBER200是W_LAYERVARCHAR250是W_FKEYNUMBER300是W_ISBREAKNUMBER10是W_ISDRAWNUMBER10是W_VOLNUMBER10是W_TRANSTATIONNUMBER60是W_RUN_DATEDATE7是W_BELONG_BUREAUVARCHAR210是W_ASSET_SUBJECTNUMBER10是W_BULID_YNCHAR1是W_TRANS_IDVARCHAR230是桿塔、線路對(duì)應(yīng)表（WIRE_TOWER_TAB ）名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER290否W_IDNUMBER200否T_IDNUMBER200是T_LAYERVARCHAR250是T_FKEYNUMBER300是T_ORDERNUMBER60是T_DISTANCENUMBER200是T_CODEVARCHAR2255是T_NAMEVARCHAR2255是T_ISBREAKNUMBER10是WT_PHRASE_IDVARCHAR2255是WT_COMMON_SIGNVARCHAR2255是WT_LINE_POSITIONVARCHAR2255是WT_SIGNVARCHAR2255是WT_DBLROUTE_IN_BACKUPVARCHAR2255是WT_MAPXNUMBER3020是WT_MAPYNUMBER3020是WT_FIDNUMBER是WT_ADDNUMNUMBER100是WT_MAPZNUMBER3020是WT_LAYERVARCHAR2100是IS_PHRASECHANGEDNUMBER10是0三、MIS相關(guān)表圖片文檔表名稱 數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER290否DEVICE_IDNVARCHAR2255否PIC_TYPEVARCHAR210是PIC_DATALONGRAW0是PIC_COMMONVARCHAR2255是PIC_CTTYPEVARCHAR2100是nullPIC_NAMEVARCHAR2100是PIC_PICTYPEVARCHAR2100是IS_DMVARCHAR2255是UPTIMEVARCHAR2255是PIC_IDVARCHAR2255是DEVICE_TYPEVARCHAR220是名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值數(shù)據(jù)字段對(duì)應(yīng)描述表名稱數(shù)據(jù)類型大小小數(shù)位可否為空?默認(rèn)值IDNUMBER290否TAB_NAMENVARCHAR2255是COL_NAMENVARCHAR2255是COL_GBNAMENVARCHAR2255是COL_DATATYPENVARCHAR2255是COL_BINDSQLNVARCHAR2255是COL_BINDEXPRESSNVARCHAR2255是COL_ISHIDECHAR1是0COL_ISUSECHAR1是0COL_CANSORTCHAR1是0COL_WIDTHNUMBER100是10COL_INPUTWIDTHNUMBER100是10COL_DEFAULTVALUENVARCHAR