【正文】 執(zhí)行DISPLAYVIEW VARCHAR2 1020 是 視圖的 URLAPPLICATION VARCHAR2 1020 是 應用標識ACTIONURL VARCHAR2 1020 是 ACTION 的 URLREPORT VARCHAR2 1020 是 報表的 URLACTIONCLASS VARCHAR2 1020 是 資源類 URL廣州市天翎網(wǎng)絡科技有限公司 數(shù)據(jù)庫結構說明書第 38 頁SORTID VARCHAR2 1020 是 排序號IMPMAPPINGCONFIG VARCHAR2 1020 是 Excel 的導入標識ISPROTECTEDS NUMBER (22,1) 是 是否受保護MODULE VARCHAR2 1020 是 模塊標識MOBILEICO VARCHAR2 1020 是 手機圖片地址TYPE VARCHAR2 1020 是 類型 T_REMINDER數(shù)據(jù)名稱 數(shù)據(jù)類型 數(shù)據(jù)長度 約束范圍 是否為空 主鍵/外鍵 說明ID VARCHAR2 1020 否 主鍵 主鍵標識FILTERSCRIPT VARCHAR2 1020 是 腳本MODULEID VARCHAR2 1020 是 模塊標識TITLE VARCHAR2 1020 是 標題STYLE VARCHAR2 1020 是 樣式TYPE VARCHAR2 1020 是 類型ORDERBY VARCHAR2 1020 是 排序字段SUMMARYFIELDNAMES VARCHAR。 t_domain)T_DOMAIN_SUPERUSER_SET 對多關聯(lián)表(t_domain amp。如圖所示：其中：? 設計時數(shù)據(jù)——包含 Form、View、WorkFlow 的設計模板，僅在系統(tǒng)設計時被改變和存儲；? 授權類數(shù)據(jù)——包含 User、Role、Dept 信息，表現(xiàn)用戶的基本信息、角色信息、組織架構，以及定義對系統(tǒng)各功能模塊的訪問權限；? 運行時數(shù)據(jù)——包含 Counter、Document、WorkFlow State 數(shù)據(jù)，分別存儲計數(shù)器、文檔、工作流狀態(tài)。3 數(shù)據(jù)庫物理設計數(shù)據(jù)存儲分成三總類型，設計時數(shù)據(jù)、授權類數(shù)據(jù)、運行時數(shù)據(jù)。amp。amp。amp。amp。myApps柔性定制平臺數(shù)據(jù)庫結構說明書廣州市天翎網(wǎng)絡科技有限公司版權所有廣州市天翎網(wǎng)絡科技有限公司 數(shù)據(jù)庫結構說明書第 2 頁目 錄1 目的 ........................................................................................................12 約定和規(guī)則 .............................................................................................13 數(shù)據(jù)庫物理設計 ......................................................................................14 數(shù)據(jù)庫模型設計 ......................................................................................2 數(shù)據(jù)實體關系 .............................................................................................................................................2 主題域：應用 ......................................................................................................................................2 主題域：表 ,視圖 .................................................................................................................................2 主題域：組織架構 ..............................................................................................................................3 數(shù)據(jù)實體描述 ..............................................................................................................................................35 數(shù)據(jù)庫模型 .............................................................................................6 T_APPLICATION................................................................................................................................6 _ACTORRT..........................................................................................................................................7 T_ACTIVITY .......................................................................................................................................8 T_ACTORHIS......................................................................................................................................9 T_APPVALIDATE ..............................................................................................................................9 T_BILLDEFI ......................................................................................................................................11 T_COMMONINFO ............................................................................................................................10 T_COMPONENT ...............................................................................................................................12 T_CROSSREPORT............................................................................................................................13 T_CALENDAR ..................................................................................................................................14 T_COUNTER .....................................................................................................................................14 T_COLUMNMAPPING.....................................................................................................................16 T_DEPARTMENT .............................................................................................................................17 T_DYNAFORM_FORM....................................................................................................................18 T_DOCUMENT .................................................................................................................................20 T_DATAPREPARE ...........................................................................................................................22 T_DATASOURCE .............................................................................................................................23 T_DOMAIN .......................................................................................................................................23 T_DOMAINLEVEL...........................................................................................................................24 T_FLOWSTATERT ...........................................................................................................................24 T_HELPER.........................................................................................................................................25 T_HOMEPAGE..................................................................................................................................25廣州市天翎網(wǎng)絡科技有限公司 數(shù)據(jù)庫結構說明書第 3 頁 T_IMAGEREPOSITORY ..................................................................................................................26 T_MODULE.......................................................................................................................................26 T_MAPPCONFIG_IMPEXCEL ...............................................................