【正文】 ...........................................................................31 T_QUERY ..........................................................................................................................................32 T_RELATIONHIS .............................................................................................................................33 T_PERSONALMESSAGE.................................................................................................................34 T_ROLE .............................................................................................................................................34 T_RESOURCE ...................................................................................................................................35 T_REMINDER ...................................................................................................................................36 T_REMOTESERVERT......................................................................................................................37 T_REPOSITORY ...............................................................................................................................37 T_REPORTCONFIG..........................................................................................................................38 T_SUPERUSER .................................................................................................................................39 T_SHORTMESSAGE_RECEIVED ..................................................................................................40 T_SHORTMESSAGE_SUBMIT .......................................................................................................40 T_SQLSENTENCE............................................................................................................................41 T_STYLEREPOSITORY...................................................................................................................42 T_STATELABEL...............................................................................................................................42 T_SPECIALDAY ...............................................................................................................................43 T_STANDARDDAY .........................................................................................................................44 T_TASK .............................................................................................................................................45 T_TASK_DAYSOFWEEK................................................................................................................47 T_TABLECOLUMN..........................................................................................................................47 T_USER..............................................................................................................................................48 T_VALIDATEREPOSITORY ...........................................................................................................49 T_VIEW .............................................................................................................................................49 T_APPLICATION_SUPERUSER_SET............................................................................................51 T_REPORT_MAPPING_SET ...........................................................................................................52 T_DOMAIN_APPLICATION_SET ..................................................................................................52 T_DOMAIN_SUPERUSER_SET......................................................................................................52 T_USER_DEPARTMENT_SET........................................................................................................53廣州市天翎網(wǎng)絡(luò)科技有限公司 數(shù)據(jù)庫結(jié)構(gòu)說明書第 4 頁 T_USER_ROLE_SET ........................................................................................................................53 T_PENDING_ACTOR_SET..............................................................................................................536 索引 ......................................................................................................54廣州市天翎網(wǎng)絡(luò)科技有限公司 數(shù)據(jù)庫結(jié)構(gòu)說明書第 1 頁1 目的本文檔是整個(gè)平臺數(shù)據(jù)庫結(jié)構(gòu)做一個(gè)詳細(xì)說明，對數(shù)據(jù)的約定和規(guī)則、以及物理設(shè)計(jì)的數(shù)據(jù)實(shí)體的關(guān)系和實(shí)體的描述、數(shù)據(jù)庫的模型做詳細(xì)的說明。如圖所示：其中：? 設(shè)計(jì)時(shí)數(shù)據(jù)——包含 Form、View、WorkFlow 的設(shè)計(jì)模板，僅在系統(tǒng)設(shè)計(jì)時(shí)被改變和存儲；? 授權(quán)類數(shù)據(jù)——包含 User、Role、Dept 信息，表現(xiàn)用戶的基本信息、角色信息、組織架構(gòu)，以及定義對系統(tǒng)各功能模塊的訪問權(quán)限；? 運(yùn)行時(shí)數(shù)據(jù)——包含 Counter、Document、WorkFlow State 數(shù)據(jù)，分別存儲計(jì)數(shù)器、文檔、工作流狀態(tài)。 t_superuser)T_REPORT_MAPPING_SET 對多關(guān)聯(lián)表(t_reportconfig amp。 t_domain)T_DOMAIN_SUPERUSER_SET 對多關(guān)聯(lián)表(t_domain amp。 t_user)T_USER_ROLE_SET 對多關(guān)聯(lián)表(t_user amp。 t_actorrt)廣州市天翎網(wǎng)絡(luò)科技有限公司 數(shù)據(jù)庫結(jié)構(gòu)說明書第 6 頁5 數(shù)據(jù)庫模型 T_APPLICATION 數(shù)據(jù)名稱 數(shù)據(jù)類型 數(shù)據(jù)長度 約束范圍 是否為空 主鍵/外鍵 說明ID VARCHAR2 1020 否 主鍵 主鍵標(biāo)識DBUSERNAME VARCHAR2 1020 是 審批限制VIDEODEMO VARCHAR2 1020 是 演示視頻DESCRIPTION VARCHAR2 1020 是 描述SORTID VARCHAR2 1020 是 排序號RESOURCEPATH VARCHAR2 1020 是 資源路徑HOMEPAGE VARCHAR2 1020 是 主頁ISDEFAULTSITE NUMBER (22,1) 是 外鍵 默認(rèn)主頁(t_page)關(guān)聯(lián)，關(guān)聯(lián)關(guān)系多對一DBDRIVER VARCHAR2 1020 是 數(shù)據(jù)驅(qū)動(dòng)SERVERADDRESS VARCHAR2 1020 是 應(yīng)用地址DBPASSWORD VARCHAR2 1020 是 數(shù)據(jù)密碼NAME VARCHAR2 1020 是 應(yīng)用名SERVERPORT NUMBER (22,10) 是 應(yīng)用的端口WELCOMEPAGE VARCHAR2 1020 是 歡迎頁廣州市天翎網(wǎng)絡(luò)科技有限公司 數(shù)據(jù)庫結(jié)構(gòu)說明書第 7 頁DBURL VARCHAR2 1020 是 數(shù)據(jù)的 URLLOGOURL VARCHAR2 1020 是 應(yīng)用 LOGINAPPLICATIONID VARCHAR2 1020 是 應(yīng)用標(biāo)識DOMAINNAME VARCHAR2 1020 是 域名ISPUBLISHED NUMBER (22,1) 是 是否發(fā)布DBTIMEOUT VARCHAR2 1020 是 連接超時(shí)INDEXTEMPLATE VARCHAR2 1020 是 主頁模板DBTYPE VARCHAR2 1020 是 數(shù)據(jù)庫類型DBPOOLSIZE VARCHAR2 1020 是 連接池 T_ACTORRT數(shù)據(jù)名稱 數(shù)據(jù)類型 數(shù)據(jù)長度 約束范圍 是否為空 主鍵/外鍵 說明ID VARCHAR2 1020 否 主鍵 主鍵標(biāo)識PENDING NUMBER (22,10) 是 是