档案管理数据表结构文档.docx

档案管理数据库表结构文档1、 dbo.Archive_Detail_Receive序号字段名称 字段说明类型及长度属性备注1id intNo null主键、自增2Receive_Type 类型intNull3Receive_Worker 档案人 nvarchar(50)Null4Receive_WorkerName 档案人Namenvarchar(50)Null5Receive_Party 经办人nvarchar(50)Null6Receive_PartyName 经办人Namenvarchar(50)Null7Receive_BillDate 录单日期datetimeNull8Receive_Branch 来件单位nvarchar(50)Null9Receive_FileName 材料名称nvarchar(50)Null10Receive_FileCode 转递文号nvarchar(50)Null11Receive_Date 来件时间datetimeNull12Receive_People 送件人nvarchar(50)Null13Receive_PeopleTel 借阅人电话nvarchar(50)Null14Receive_Remark 备注nvarchar(MAX)Null15Receive_BillCode 单据号nvarchar(50)Null16Receive_BillSpell 单据简拼nvarchar(50)Null17Receive_AuditingMode 审批方式nvarchar(50)Null18Receive_AuditingPeople 审批人nvarchar(50)Null19Receive_FactAuditingPeople 实际审批人nvarchar(50)Null20Receive_AuditingDate 审批日期nvarchar(50)Null21Receive_AuditingRes 审批意见nvarchar(50)Null22Receive_AuditingState 审批结果intNull22Receive_filetype 大类归属 nvarchar(MAX)Null23Receive_FenShu 份数nvarchar(50)Null24Receive_YeShu 页数nvarchar(50)Null35Receive_TheOriginal 正本数intNull36Receive_ACopyOfThe 副本数intNull37Receive_Approver 批准人nvarchar(50)Null38Receive_ExtractPeople 摘抄人nvarchar(50)Null39Receive_ExtractTheScope 摘抄范围nvarchar(50)Null40Receive_shangchuanfujian 上传附件nvarchar(MAX)Null41Receive_Returndate 归还日期datetimeNull42Receive_Returnpeople 归还人nvarchar(50)Null43Receive_Numberdays 借阅天数intNull44Receive_Zypx 自由排序intNull45Receive_Leihaonvarchar(50)Null2、 dbo.Base_RecordTendClass序号字段名称字段说明类型及长度属性备注1idintNo null主键2RC_numbernvarchar(50)Null3RC_parentnumbernvarchar(50)Null4RC_codenvarchar(50)Null5RC_SonCountintNull6RC_IfTypeintNulll7RC_namenvarchar(500)Null8RC_FirstLetternvarchar(500)Null9RC_currentTypenchar(10)Null10RC_remarknvarchar(MAX)Null11RC_taxisintNull12RC_NumberCodenvarchar(50)Null3、 dbo.Base_Worker序号字段名称 字段说明类型及长度属性备注1idintNo null主键、自增2Worker_department 所在部门nvarchar(50)Null3Worker_departmentNamenvarchar(50)Null4Worker_number 编码nvarchar(50)Null5Worker_IfType 是否修改intNull6Worker_parentnumber 父类编码nvarchar(MAX)Null7Worker_code 工资号nvarchar(50)Null8Worker_FirstLetter 简拼nvarchar(50)Null9Worker_name 姓名nvarchar(MAX)Null10Worker_Leadernvarchar(50)Null11Worker_Branrolenvarchar(MAX)Null12Worker_sex 性别nchar(2)Null13Worker_folk 名族nvarchar(50)Null14Worker_gjdq 国籍地区nvarchar(50)Null15Worker_photo 联系电话nvarchar(50)Null16Worker_jjPhone 紧急人电话nvarchar(50)Null17Worker_jiguan 籍贯nchar(15)Null18Worker_xzdz 现住地址nvarchar(MAX)Null19Worker_yb 邮编nvarchar(50)Null20Worker_bornTime 出生时间intNull21Worker_ID_Card 身份证号码nchar(18)Null22Worker_zhfzbm 证件发证部门nvarchar(50)Null23Worker_marriagetype 婚否nchar(10)Null24Worker_postalcode 参与积分计算nchar(10)Null25Worker_MailAllSize 参与积分考核bigintNull26Worker_HeadImgUrl 上传照片nvarchar(MAX)Null27Worker_LicenseImgUrlnvarchar(MAX)Null28Worker_IsLockUp 是否被锁住nvarchar(MAX)Null29Worker_dangan 档案号nvarchar(50)Null30Worker_bianzhi 编制号nvarchar(50)Null31Worker_zzmm 政治面貌nvarchar(50)Null32Worker_geren 个人身份nvarchar(50)Null33Worker_jrdwxs 进入单位形式nvarchar(50)Null34Worker_rxsj 入校时间intNull35Worker_zaigang 在岗状态nvarchar(50)Null36Worker_boshihou 博士后经历nvarchar(50)Null37Worker_Names 曾用名nvarchar(50)Null38Worker_zaibian 在编单位nvarchar(MAX)Null39Worker_jjlxr 紧急联系人nvarchar(MAX)Null40Worker_kxly 现从事领域nvarchar(MAX)Null41Worker_sflx 身份证类型nvarchar(MAX)Null42Worker_jszgz 学历单位nchar(10)Null43Worker_gcyjrc 高层次引进nchar(10)Null44Worker_ID_Attendance 指纹号nvarchar(50)Null45Worker_pgsj 聘岗时间intNull46Worker_cjgzsj 参加工作时间IntNull47Worker_IfWork 是否在职nvarchar(50)Null48Worker_pwdnvarchar(50)Null49Worker_currentTypenchar(10)Null50Worker_MenuTypeintNull51Worker_Menunvarchar(50)Null52Worker_hailiuxue 海外留学经历nvarchar(50)Null53Worker_hwxw 海外学位nvarchar(50)Null54Worker_001ShouldAddnvarchar(50)Null55Worker_ShortCutnvarchar(MAX)Null56Worker_StartingState 起薪状态nvarchar(50)Null57Worker_sfsjt 是否双肩挑nvarchar(50)Null58Worker_Interruptservice 工龄增减nvarchar(50)Null59Worker_Date 加入时间intNull60Worker_SalaryStatus 工资身份nvarchar(50)Null61Worker_AccrueAge 应计学龄nvarchar(50)Nulll62Worker_bzlb 在编情况nvarchar(50)Null63Worker_keshi 起薪年月nvarchar(50)Null64Worker_kqlb 考情类别nvarchar(50)Null65Worker_ygzdwnvarchar(MAX)Null66Worker_role1nvarchar(MAX)Null67Worker_MenuOrdernvarchar(MAX)Null68Worker_rolenvarchar(MAX)Null69Worker_specialnchar(15)Null70Worker_jobnvarchar(MAX)Null71Worker_GroupLeaderintNull72Worker_kaoqinnvarchar(50)Null73Worker_fafangnvarchar(50)Null74worker_baknvarchar(50)Null75Worker_RetiredTime 退休时间intNull76Worker_Masternvarchar(50)Null77Worker_role2nvarchar(MAX)Null78Worker_EndTimeintNull79Worker_Remark 备注nvarchar(MAX)Null80Worker_XinJi 薪级nvarchar(50)Null81Worker_Rofs 学历归属nvarchar(50)Null82Worker_Degree 学位nvarchar(50)Null83Worker_JobLevel 岗位级别nvarchar(50)Null84Worker_JobLevelType 岗位类别nvarchar(50)Null85Worker_JobLevelTime 岗位年限intNull86Worker_WT 职称系列nvarchar(50)Null87Worker_XinJi1 薪级nvarchar(50)Null88Worker_XinJi2 薪级nvarchar(50)Null89Worker_IsExteriorMail 是否外部邮件nvarchar(50)Null90Worker_MailNum 邮件数量nvarchar(50)Null91Worker_PreOperation 附件nvarchar(MAX)Null92Worker_MailIDnvarchar(255)Null93Worker_POPServernvarchar(100)Null94Worker_POPPortintNull95Worker_POPIsSSLintNull96Worker_SMTPServernvarchar(100)Null97Worker_SMTPPortintNull98Worker_SMTPIsSSLintNull99Worker_MailUsernvarchar(100)Null100Worker_MailPwdnvarchar(100)Null101Worker_IsBackUpintNull102Worker_FileSource 档案来源nvarchar(50)Null103Worker_FileType 档案状态nvarchar(50)Null104Worker_Roll 转出单位nvarchar(50)Null105Worker_Administrativenvarchar(MAX)Null106Worker_ProfessionalNamenvarchar(MAX)Null107Worker_AtTheTimenvarchar(MAX)Null108Worker_officetermnvarchar(MAX)Null109Worker_reviewMonthlynvarchar(MAX)Null110Worker_PostNamenvarchar(MAX)Null111Worker_RenCaiTypenvarchar(MAX)Null112Worker_Changes 人事变动nvarchar(50)Null113worker_endtimebaknvarchar(50)Null114Worker_Belonging 学历归属nvarchar(MAX)Null115Worker_XLnvarchar(50)Null116Worker_TheBlood 学缘nvarchar(MAX)Null117Worker_daoshitype 导师类型nvarchar(50)Null118Worker_BegintimeRofs 学历学位时间intNull119Worker_Specialty 专业nvarchar(50)Null4、 dbo.Archive_WebApply序号字段名称字段说明类型及长度属性备注1idintNo null主键、自增2Apply_BillCode 单据号nvarchar(50)Null3Apply_User 申请人nvarchar(50)Null4Apply_UserName 申请人Namenvarchar(50)Null5Apply_Party 干部nvarchar(50)Null6Apply_PartyName 干部Namenvarchar(50)Null7Apply_Date 日期datetimeNull8Apply_Bran 申请人单位nvarchar(50)Null9Apply_Remark 申请理由nvarchar(MAX)Null10Apply_AuditingMode 审批方式nvarchar(50)Null11Apply_AuditingPeople 审批人 nvarchar(50)Null12Apply_FactAuditingPeople 实际审批人nvarchar(50)Null13Apply_AuditingDate 审批日期nvarchar(50)Null14Apply_AuditingRes 审批意见nvarchar(50)Null15Apply_AuditingState 审批结果intNull16Apply_FeedbackFile 反馈附件nvarchar(MAX)Null17Apply_Feedback 反馈nvarchar(MAX)Null18Apply_ProveFilenvarchar(MAX)Null5、 dbo.Archive_Detail_ReceiveWarn序号字段名称 字段说明类型及长度属性备注1idintNo null主键、自增2Receive_From 来自哪的提醒nvarchar(50)Null3Receive_ChangeUser 信息变更人nvarchar(50)Null4Receive_ChangeUserName 变更人Namenvarchar(50)Null5Receive_Party 操作员Nubernvarchar(50)Null6Receive_PartyName 操作员Namenvarchar(50)Null7Receive_Date 日期datetimeNull8Receive_IfReceive 是否接收intNull9Receive_File 附件nvarchar(MAX)Null10Receive_EndDate 到期日期datetimeNull11Archive_Receive_id 档案借阅IdintNull6、 dbo.Base_Long序号字段名称 字段说明类型及长度属性备注1idmoneyNo null主键2File_DJha