致远OA-V5.6SP1数据字典

Model:CTP2.0Report:Report4Author:SeeyonVersion:Date:2015-10-22Summary:SybasePowerDesignerLogicalDataModelReportLogicalDataModelCTP2.0ReportReport4TableofContentsThe'TableofContents'fieldneedstobeupdated!SybasePowerDesigner2015-10-22Page2of285LogicalDataModelCTP2.0PowerDesigner2015-10-22Page3IV5数据字典I.1ALL-IN-ONE用户绑定表CodeU8PLUGIN_AIOUSER_MAPPINGCommentAll-In-One用户绑定表NameCodeDataTypeMandatoryComment主键IDIDLongintegerTRUE主键ID用户IDOAUSER_IDLongintegerTRUE主键OA用户IDALL-IN-ONE登录名AIO_LOGIN_NAMEVariablecharacters(50)TRUEALL-IN-ONE登录名ALL-IN-ONE密码AIO_PWDVariablecharacters(50)FALSEALL-IN-ONE密码I.2CA管理CodeCA_ACCOUNTCommentCA管理NameCodeDataTypeMandatoryCommentIDIDLongintegerTRUE主键IDCA证书唯一标识KEY_NUMVariablecharacters(255)FALSECA证书唯一标识人员IDMEMBER_IDLongintegerTRUE人员ID模块WHICH_MODULEVariablecharacters(255)FALSE模块停启用状态CA_STATENumber(3)TRUE停启用状态，0-停用1-启用是否必须使用CA登录CA_ENABLENumber(3)TRUE是否必须使用CA登录，0-否1-是移动设备访问是否受控制MOBILE_ENABLENumber(3)TRUE移动设备访问是否受控制，0-否1-是登陆时是否同时检查账号密码CHECK_ENABLENumber(3)TRUE登陆时是否同时检查账号密码，0-否1-是I.3CMP应用授权信息管理CodeCMP_APP_AUTHENTICATIONCommentCMP应用授权信息管理NameCodeDataTypeMandatoryCommentIDIDLongintegerTRUEID被授权用户IDUSER_IDLongintegerFALSE被授权用户ID被授权用户名称USER_NAMEVariablecharacters(1024)FALSE被授权用户名称LogicalDataModelCTP2.0PowerDesigner2015-10-22Page4应用IDAPP_IDLongintegerTRUE应用ID应用类型APP_TYPEIntegerTRUE应用类型，1=html应用，2=原生应用应用开启状态APP_STATUSIntegerTRUE应用开启状态，1=启用，2=禁用ACCOUNT_IDACCOUNT_IDLongintegerFALSEDEPARTMENT_IDDEPARTMENT_IDLongintegerFALSEI.4CTP_EVERYBODYWORK_DATACodeCTP_EVERYBODYWORK_DATACommentNameCodeDataTypeMandatoryCommentIDIDLongintegerTRUEMEMBER_IDMEMBER_IDLongintegerTRUEACCESS_TOKENACCESS_TOKENVariablecharacters(50)TRUETOKEN_TYPETOKEN_TYPEVariablecharacters(20)TRUE暂不支持REFRESH_TOKENREFRESH_TOKENVariablecharacters(50)TRUEEXPIRES_INEXPIRES_INLongintegerTRUEAPPLY_TIMEAPPLY_TIMEDate&TimeTRUEREFRESH_TIMEREFRESH_TIMEDate&TimeTRUEEWACCOUNTEWACCOUNTVariablecharacters(50)FALSEEXPAND_S1EXPAND_S1Variablecharacters(50)FALSEEXPAND_S2EXPAND_S2Variablecharacters(50)FALSEEXPAND_L1EXPAND_L1LongintegerFALSEEXPAND_L2EXPAND_L2LongintegerFALSEI.5DEE属性表CodeCTP_SECTION_DEE_PROPSCommentDEE属性表NameCodeDataTypeMandatoryComment主键IDIDLongintegerTRUE主键ID栏目IDDEE_SECTION_IDLongintegerTRUE栏目ID属性名称PROP_NAMEVariablecharacters(255)FALSE属性名称属性值PROP_VALUEVariablecharacters(255)FALSE属性值属性类型PROP_METAVariablecharacters(255)FALSE属性类型LogicalDataModelCTP2.0PowerDesigner2015-10-22Page5是否显示ISSHOWShortintegerFALSE是否显示：1-隐藏0-显示排序SORTVariablecharacters(255)TRUE排序I.6DEE授权表CodeCTP_SECTION_DEE_SECURITYCommentDEE授权表NameCodeDataTypeMandatoryComment主键IDIDLongintegerTRUE主键ID栏目IDDEE_SECTION_IDLongintegerTRUE栏目ID实体IDENTITY_IDLongintegerTRUE实体ID实体类型ENTITY_TYPEVariablecharacters(255)TRUE实体类型排序号SORTShortintegerFALSE排序号I.7DEE栏目表CodeCTP_SECTION_DEECommentDEE栏目表NameCodeDataTypeMandatoryComment主键IDIDLongintegerTRUE主键ID交换任务IDFLOW_IDLongintegerTRUE交换任务ID模块名称MODULE_NAMEVariablecharacters(50)TRUE模块名称栏目默认高度PAGE_HEIGHTShortintegerTRUE栏目默认高度栏目名称DEE_SECTION_NAMEVariablecharacters(255)TRUE栏目名称交换任务显示名称FLOW_DISNAMEVariablecharacters(255)TRUE交换任务显示名称PORTALSTYLEPORTALSTYLEVariablecharacters(255)TRUEPORTALSTYLECHARTSTYLECHARTSTYLEVariablecharacters(255)FALSECHARTSTYLEI.8HTML专业签章迁移增加表CodeCTP_ISIGNATURE_HTMLCommentHTML专业签章迁移增加表NameCodeDataTypeMandatoryComment主键IDIDLongintegerTRUE主键ID文档IDDOCUMENT_IDLongintegerFALSE文档IDLogicalDataModelCTP2.0PowerDesigner2015-10-22Page6签章数据SIGNATURELongbinaryFALSE签章数据用户IDUSER_IDLongintegerFALSE用户ID主机名HOST_NAMEVariablecharacters(50)FALSE主机名签章时间SIGN_DATEDate&TimeFALSE签章时间公文HTML签章功能DOCUMENT_TYPEShortintegerFALSE公文HTML签章功能I.9HTML签章CodeSIGNET_HTM_DOCUMENTCommenthtml签章NameCodeDataTypeMandatoryCommentIDIDLongintegerTRUEID文单IDSUMMARY_IDLongintegerTRUE文单ID字段名称FIELD_NAMEVariablecharacters(50)FALSE字段名称签章数据FIELD_VALUETextFALSE签章数据用户名称USER_NAMEVariablecharacters(50)FALSE用户名称签名主机HOST_NAMEVariablecharacters(50)FALSE签名主机签章时间DATE_TIMEDate&TimeFALSE签章时间是否系统落款用户可选AFFAIR_IDLongintegerFALSE是否系统落款用户可选签批类型SIGNET_TYPEShortintegerFALSE签批类型：0：html签批，1:公文文单落款签批I.10HTML签章历史CodeSIGNET_HISTORYCommenthtml签章历史NameCodeDataTypeMandatoryCommentIDIDLongintegerTRUEID文单IDSUMMARY_IDLongintegerFALSE文单ID字段名称FIELD_NAMEVariablecharacters(50)FALSE字段名称签章名称MARK_NAMEVariablecharacters(255)FALSE签章名称用户名称USER_NAMEVariablecharacters(50)FALSE用户名称签名主机HOST_NAMEVariablecharacters(50)FALSE签名主机签章时间DATE_TIMEDate&TimeFALSE签章时间序列号MARK_GUIDVariablecharacters(128)FALSE序列号LogicalDataModelCTP2.0PowerDesigner2015-10-22Page7I.11JK_BLOB_TRIGGERSCodeJK_BLOB_TRIGGERSCommentjk前缀的是第三方表NameCodeDataTypeMandatoryCommentTRIGGER_NAMETRIGGER_NAMEVariablecharacters(80)TRUETRIGGER_GROUPTRIGGER_GROUPVariablecharacters(80)TRUEBLOB_DATABLOB_DATALongbinaryFALSEI.12JK_CALENDARSCodeJK_CALENDARSCommentjk前缀的是第三方表NameCodeDataTypeMandatoryCommentCALENDAR_NAMECALENDAR_NAMEVariablecharacters(80)TRUECALENDARCALENDARLongbinaryTRUEI.13JK_CRON_TRIGGERSCodeJK_CRON_TRIGGERSCommentjk前缀的是第三方表NameCodeDataTypeMandatoryCommentTRIGGER_NAMETRIGGER_NAMEVariablecharacters(80)TRUETRIGGER_GROUPTRIGGER_GROUPVariablecharacters(80)TRUECRON_EXPRESSIONCRON_EXPRESSIONVariablechara