搜索
OA数据库说明项目名称OA文件名OA数据库说明数据库类型MICROSOFT—2005表数量115更新日期2010-8-514:44:46PhysicalDiagram_1清单:表名解释ARCHIVE个人档案ASKS调查问卷ASKSCONTENT调查问卷条数ASKSCONTENTDETAIL调查问卷选项ASPCLASS页面权限表ASPCLASSLEVELASPClassLevelATTACHMENTAttachmentATTACHMENTSAttachmentsATTEND_DUTYAttend_DutyATTENDANCEAttenDanceATTENDANCEROLEAttenDanceRoleATTENDNOTEAttendNoteBBSBBSBBSBACKBBSBackBBSBIGTYPEBBSBigTYPEBBSSMAILTYPEBBSSmailTYPECARSCarsCARSKEEPCarsKeepCARUSECarUseCONTRACTContractCONTROLLOERControlloerCRMCRMCRM_CONTACTCrm_ContactCRM_CUSTOMERCrm_CustomerCRM_CUSTOMERTCrm_CustomerTCRM_LINKMANCrm_LinkmanCRM_MEMOCrm_MemoDELIVERYGOODSDeliveryGoodsDEPARTMENTDepartmentDEPTROLEDeptRoleDTPROPERTIESdtpropertiesDUTYSDutysDUTYTYPESDutyTypesDWdwFILESFilesFLOWBASEFlowBaseFLOWBASEFORMCONTENTFlowBaseFormContentFLOWBASESTEPFlowBaseStepFLOWBASETYPEFlowBaseTypeFLOWCOUNTERSIGNSTEPFlowCountersignStepFLOWLOGFlowLogFLOWOVERTIMEFlowOverTimeFLOWRUNFlowRunFLOWRUNCOLUMNSFlowRunColumnsFLOWRUNMARKFlowRunMarkFLOWSAVEFlowSaveFLOWSTEPTIMEFlowStepTimeFOLDERSFoldersFOODSFoodsHOTELSHotelsINFOADNEWSINFOADNewsINFONEWSINFONewsINSTALLHISInstallHisINTERFACEInterfaceMAILSMailsMAINTAINMaintainMEETINGmeetingMEETINGMANAGERSMeetingManagersMEETINGROOMSMeetingRoomsMEETINGRUNMeetingRunMODELModelMYTABLEMyTableOFFICEDOCDESTROYOfficeDocDestroyOFFICEDOCRUNOfficeDocRunOFFICEDOCRUNMARKOfficeDocRunMarkOFFICEDOCSTATEOfficeDocStatePINGTDUTYSpingtdutysPOSITIONCRPositionCRPOST_TELPost_TelPROJ_BUGproj_bugPROJ_COMMENTproj_commentPROJ_FILEproj_filePROJ_FILE_LOGproj_file_logPROJ_FILE_SORTproj_file_sortPROJ_FORUMproj_forumPROJ_PRIVproj_privPROJ_PROJECTproj_projectPROJ_TASKproj_taskPROJ_TASK_LOGproj_task_logPROVIDERProviderPROVIDER_LINKMANProvider_LinkmanPTptPUTDUTYSPuTdutysRECEIVESReceivesREPAIRSRepairsROLEMODELRoleModelROLLROOMSRollRoomsROLLSRollsSALE_PRODUCTSale_ProductSALE_SERVICESale_ServiceSALESsalesSCHEDULEscheduleSMSSmsSMSSERVERSMSServerSUPPLY_HISTORYSupply_HistorySUPPLY_ORDERSupply_OrderSUPPLY_ORDER_LINESupply_Order_LineSYS_CODESys_CodeSYS_FUNCTIONSys_FunctionSYS_LOGSys_LogSYS_MENUSys_MenuSYS_PARASys_ParaTABLEUSERtableuserUNITUnitUSER_PRIVUser_PrivUSERFLOWMODELUserFlowModelUSERSUsersUSERS2Users2USERS3Users3USETHINGSUseThingsUSETHINGSTYPEUseThingsTypeUSETHINGSUSEUseThingsUseWEBMAILPROFILEWebMailProfile表名:ARCHIVE解释:ArchiveARCHIVE(Archive)是否主键字段名字段描述数据类型长度可空约束缺省值备注是IDIDVARCHAR(50)50档案编号NAMEnameVARCHAR(50)50是姓名STATEstateVARCHAR(50)50是在职状态SEXsexCHAR(2)2是性别BIRTHDAYbirthdayVARCHAR(50)50是生日NATIONnationVARCHAR(50)50是民族IDCARDIDcardVARCHAR(50)50是身份证号码MARRYmarryCHAR(4)4是婚否POLITICALpoliticalVARCHAR(50)50是政治面貌JGJGVARCHAR(50)50是籍贯REGISTERregisterVARCHAR(50)50是地址DEGREEdegreeVARCHAR(50)50是学历PROFESSIONALprofessionalVARCHAR(50)50是职称SCHOOLschoolVARCHAR(50)50是毕业院校SPECIALspecialVARCHAR(50)50是专业WORKTIMEworktimeVARCHAR(50)50是参加工作时间THISWORKTIMEthisworktimeVARCHAR(50)50是加入本单位时间TYPEtypeVARCHAR(50)50是员工类型POSITIONpositionVARCHAR(50)50是职务FAMILYPHONEfamilyphoneVARCHAR(50)50是家庭电话TELEPHONEtelephoneVARCHAR(50)50是移动电话EMAILemailVARCHAR(50)50是电子邮件FAMILYADDRfamilyaddrVARCHAR(100)100是家庭住址CONTRACTBEGINcontractbeginVARCHAR(50)50是合同期起始CONTRACTENDcontractendVARCHAR(50)50是合同期结束ZZRQZZRQVARCHAR(50)50是转正日期GWBDQKGWBDQKVARCHAR(200)200是岗位变动情况JYBJJYBJVARCHAR(200)200是教育背景GZJLGZJLVARCHAR(200)200是工作简历SHGXSHGXVARCHAR(200)200是社会关系JCJLJCJLVARCHAR(200)200是奖惩记录ZWQKZWQKVARCHAR(200)200是职务情况PXJLPXJLVARCHAR(200)200是培训记录DBJLDBJLVARCHAR(200)200是担保记录LDHTQDQKLDHTQDQKVARCHAR(200)200是劳动合同签订情况SBJNQKSBJNQKVARCHAR(200)200是社保缴纳情况TJJLTJJLVARCHAR(200)200是体检记录BZBZVARCHAR(200)200是备注FJFJVARCHAR(200)200是附件文档ZPZPIMAGE是照片BMBMVARCHAR(50)50是？？[返回]表名:ASKS解释:AsksASKS(Asks)是否主键字段名字段描述数据类型长度可空约束缺省值备注是IDIDINT调查idDCNRDCNRVARCHAR(350)350是调查内容DCRDCRVARCHAR(150)150是调查人DCSJDCSJDATETIME是getdate()调查时间[返回]表名:ASKSCONTENT解释:AsksContentASKSCONTENT(AsksContent)是否主键字段名字段描述数据类型长度可空约束缺省值备注是IDIDINT调查选项ASKIDAskIDINT是调查idASKCOUNTAskCountINT是投票条数ASKNRAskNRVARCHAR(150)150是选项内容[返回]表名:ASKSCONTENTDETAIL解释:AsksContentDetailASKSCONTENTDETAIL(AsksContentDetail)是否主键字段名字段描述数据类型长度可空约束缺省值备注是ACDIDACDIDINT问题选项ASKIDAskIDINT是调查idASKCONTENTIDAskContentIDVARCHAR(500)500是调查内容idUSERIDUserIDINT是调查人id[返回]表名:ASPCLASS解释:页面权限表ASPCLASS(ASPClass)是否主键字段名字段描述数据类型长度可空约束缺省值备注IDIDINT主键LMLMVARCHAR(150)150是页面地址JSJSVARCHAR(50)50是页面名称MIDMIDINT是父id[返回]表名:ASPCLASSLEVEL解释:ASPClassLevelASPCLASSLEVEL(ASPClassLevel)是否主键字段名字段描述数据类型长度可空约束缺省值备注IDIDBIGINT主键SYRIDSYRIDINT是ASPCLASSIDASPClassIDINT是父idASPCLASSNAMEASPClassNameVARCHAR(50)50是页面名称[返回]表名:ATTACHMENT解释:我的文档ATTACHMENT(Attachment)是否主键字段名字段描述数据类型长度可空约束缺省值备注ATTACHIDAttachIdINTTYPETypeINTATTACHMENTIDAttachmentIdNVARCHAR(50)50NAMENameNVARCHAR(100)100USERIDUserIdNVARCHAR(20)20ADDTIMEAddTimeDATETIMETOTALSIZETotalSizeINTDELETEFLAGDeleteFlagBIT[返回]表名:ATTACHMENTS解释:AttachmentsATTACHMENTS(Attachments)是否主键字段名字段描述数据类型长度可空约束缺省值备注是ATTACHMENTIDAttachmentIDINTNAMENameVARCHAR(50)50是URLUrlVARCHAR(255)255是TYPETypeVARCHAR(50)50是CONTAINContainINT是MAILIDMailIDINT是UIDUIDINT是[返回]表名:ATTEND_DUTY解释:Attend_DutyATTEND_DUTY(Attend_Duty)是否主键字段名字段描述数据类型长度可空约束缺省值备注DUTYIDDutyIdINTUSERIDUserIdNVARCHAR(20)20REGISTERTYPERegisterTypeINTREGIST