人力资源管理系统
select * from AppSettings --定时下载数据任务配置表BSC
select * from AppUserToken --用户信息表
select * from ArtificialGroup --空表
select * from ArtificialGroupEmp --空表
select * from AspNet_SqlCacheTablesForChangeNotification --表HRDepartment、HREmployee、HRMenu、HRParaSettingItems、HRPost创建时间表
select * from AssemblyArrange --分类打包表
select * from AssemblyRequest --打包请求表
select * from AssemblyRoomInfo --垃圾表
select * from AssemblySummary --垃圾表
select * from AssetCaiGouDetail --2017年06月之前的垃圾表
select * from AssetQuYu --区域表
select * from AssetWeiZhi --位置表
select * from AttendanceDayReport --未知表
select * from AttEmpInfo --考勤数据表
select * from AttDayRptSortColumn --考勤日报中控制按钮表
select * from AttLog --考勤机日志记录
select * from AttMacEmp --职员考勤更新情况表
select * from AttMachine --设备列表
select * from AttMachineEx --设备同步下载信息表
select * from AutoPlanSendEmailLog
select * from AutoTasks
select * from BilChkWorkDayChg
select * from BilChkWorkDayChg_All
select * from BilChkWorkDayChg_All_D
select * from BilChkWorkDayChg_D
select * from Boardroom_Apply --董事会会议室申请
select * from Boardroom_Mediator
select * from Boardroom_Register --董事会会议室登记
select * from Boardroom_Sign --董事会会议室签名
select * from BookCategory --书箱分类
select * from BookInfo
select * from BookInLibrary
select * from BookLendReturn
select * from BookOutLibrary
select * from bz_isAccept
select * from CangKu --仓库信息表
select * from CardStyle --名片类型表 鸿太升图片
select * from CarVisitor --访客车辆信息表
select * from CheLiang --车辆登记信息表BSC
select * from CheLiangChuXian --车辆出险表
select * from CheLiangJiaYou --车辆加油表
select * from CheLiangJieJiaRi --节假日车辆状态表
select * from CheLiangLunTai --车辆轮胎表
select * from CheLiangLunTaiDiaoYong --车辆轮胎调用表
select * from CheLiangMieHuoQi --车辆灭火器点检表
select * from CheLiangNianJian --车辆年检信息表
select * from CheLiangShenQing --车辆申请信息表BSC
select * from CheLiangSiJi --车辆实际使用人信息表BSC
select * from CheLiangStatus --车辆状态信息表
select * from CheLiangWeiXiu --车辆维修信息表
select * from CheLiangWeiXiuGongYingShang ---车辆维修供应商信息表
select * from CheLiangWeiZhang --车辆违章登记表
select * from CheLiangYouka --车辆油卡表
select * from CheLiangYoukaChongZhi --车辆油卡充值表
select * from CheLiangZhouLi --车辆周历
select * from chengben --成本表
select * from ClockGroup --设备门禁组列表BSC 29
select * from ClockGroupEmp --设备组与设备关联表BSC
select * from ClockGroupQuanXian --门禁权限组
select * from ClockGroupSelect --门禁组选择设备表BSC
select * from CompanyManage --公司信息管理
select * from DataType --空表
select * from DayRptSalary14 --空表
select * from DD --数据字典 BSC
select * from deletejson --删除信息表组织架构 BSC
select * from Dept_BCGroup --空表
select * from deptBianzhi --部门编制空表
select * from DeptChengBen --部门成本空表
select * from DeptGroup --部门组 空表
select * from DeptGroupName --部门组名
select * from DeptImage --部门图片空表
select * from DeptImageShow --部门图片展示表
select * from DeptJieGouArea --部门结构区域表BSC
select * from DeptJieGouCategory --部门结构分类表
select * from DeptJieGouClass --部门结构管理层级表BSC
select * from DeptJieGouLevel --部门结构级别空表
select * from DeptJieGouPosition --部门结构职位空表
select * from DeptJieGouRank --部门结构等级表BSC
select * from DeptJieGouRankBind --部门结构等级与管理层级关联表BSC
select * from DeptJieGouRankBindName --部门结构绑定名称表
select * from deptKaohe --部门考核表
select * from DeptLaZu --空表
select * from DeptLaZuChengBen --空表
select * from DeptManage --空表
select * from DeptShuoMingShu --垃圾表
select * from DeptTemplate --部门模板 垃圾表
select * from DeptZhiNeng --部门职能
select * from deptZhize --空表
select * from DiaoDongDan --调动单空表
select * from DisbursedAttMachine --考勤机分布空表
select * from dkdate --打卡日期表BSC
select * from EmpColumnAccess --员工列权限访问表BSC
select * from EmpColumnsOrder --员工列权限顺序表BSC
select * from EmpContract --员工合同表BSC
select * from EmpJQ --员工假期表BSC
select * from EmpMovingTrack --员工移动跟踪BSC
select * from Empxiaofei1 --员工消费卡余额表BSC
select * from EmpXiaoFeiKa --员工消费卡管理表BSC
select * from EmpXiaoFeiKaBuBan --员工卡补办信息表BSC
select * from EmpXiaoFeiKaChongZhi --员工卡充值信息表BSC
select * from EmpXiaoFeiKaJiFenGuiZe --员工卡消费积分规则表
select * from EmpXiaoFeiKaQianBao --员工消费卡钱包表BSC
select * from EmpXiaoFeiKaTuiKa --员工退卡信息表BSC
select * from EmpXiaoFeiKaTuiKuan --员工消费卡退款表BSC
select * from Entourage --随行人信息表BSC
select * from ERPAnPai --ERP 安排表BSC
select * from ERPAutoPlan --空表
select * from FaFangType --发放类型 薪资表BSC
select * from GroupMember
select * from GetTableSeach --等到班次表
select * from gksx --员工部门职位日期表BSC
select * from HasChangPwd --员工更改密码记录表
select * from HR_OA10 --OA办理表BSC 24列
select * from HR_OA11 --OA办理表BSC 6列
select * from HR_OA15 --出差单审核进行表
select * from HR_OA16 --空表HR_OA17、HR_OA18、HR_OA19、HR_OA197、HR_OA2、HR_OA20、HR_OA21、HR_OA24 、HR_OA25
select * from HR_OA22 --外出培训审批表BSC
select * from HR_OA23 --出差审批表BSC
select * from HR_OA26 --补卡审批表BSC
select * from HR_OA27 --空表
select * from HR_OA28 --出差审批表BSC
select * from HR_OA29 --会议室预约表BSC
select * from HR_OA3 --空表
select * from HR_OA30 --空表
select * from HR_OA31 --供应商来访A类预约表
select * from HR_OA32 --供应商来访非A类预约表
select * from HR_OA33 --人事异动审批表
select * from HR_OA34 --薪资异动审批表
select * from HR_OA35 --社保申请审批表
select * from HR_OA36 --空表
select * from HR_OA37 --空表
select * from HR_OA38 --空表
select * from HR_OA39 --体系授控申请审批表
select * from HR_OA4
select * from HR_OA40
select * from HR_OA41 --薪资试用期转正审批
select * from HR_OA42 --宿舍申请审批表
select * from HR_OA43 --空表
select * from HR_OA45 --人办需求表审批表
select * from HR_OA46 --空表
select * from HR_OA47 --空表
select * from HR_OA48 --空表
select * from HR_OA49 --空表
select * from HR_OA50 --空表
select * from HR_OA51 --空表
select * from HR_OA52 --货物放行
select * from HR_OA53 --垃圾放行条
select * from HR_OA5 --ERP权限反审申请单
select * from HR_OA54 --垃圾废品放行条
select * from HR_OA55 --空表
select * from HR_OA56 --空表
select * from HR_OA57 --空表
select * from HR_OA58 --快递放行条
select * from HR_OA6 --空表
select * from HR_OA7 --空表
select * from HR_OA8 --电脑维护申请单
select * from HR_OA81 --空表
select * from HR_OA82 --空表
select * from HR_OA83 --空表
select * from HR_OA84 --空表
select * from HR_OA85 --空表
select * from HR_OA86 --空表
select * from HR_OA87 --空表
select * from HR_OA88 --空表
select * from HR_OA89 --空表
select * from HR_OA9 --空表
select * from HR_OA90 --空表
select * from HR_SellKindReg --无用表
select * from HR_SellTddReg --无用表
select * from HR_TiChengReg --无用表
select * from HR_TiChengSQReg --无用表
select * from HR360 --无用表
select * from HR360Fen --无用表
select * from HR360Lv --无用表
select * from HR360title --无用表
select * from HRAbsentRegistration --空表
select * from HRAchievement --无用表
select * from HRAction --动作表BSC
select * from HRAdjustRestDetails --无用表
select * from HRAdjustRestRegistration --无用表
select * from HRAgent --无用表
select * from HRAPPAdressSet --APP设置表BSC
select * from HRAPPHTml --无用表
select * from HRApproval --OA审核层级表BSC
select * from HRAsk4LvRegistration --无用表
select * from HRAssessDetails --访问细节表BSC
select * from HRAssessDetailsRpt --空表
select * from HRAssessPreson --无用表
select * from HRAssessRpt --空表
select * from HRAssessType --无用表
select * from HRATM --银行信息表
select * from HRAttendanceSystem --考勤规则标准表BSC
select * from HRAttendanceSystemPannel --系统默认考勤规则表BSC
select * from HRAttendPost --回复帖子统计表
select * from HRAttr_T --空表
select * from HRAttrDayRpt --考勤日报表BSC
select * from HRAttrDayRpt_D --无用表
select * from HRAttrDayRptFieldOrder --考勤日报表字段顺序表
select * from HRAttrDaySjRpt --无用表
select * from HRAttrMonthRpt --考勤月报表BSC
select * from HRAttrMonthRpt6 --无用表
select * from HRAttrMonthRptFieldOrder --考勤月报表字段顺序表BSC
select * from HRAward --空表
select * from HRBanCi --排班表BSC
select * from HRBanciDept --班次部门对应表BSC
select * from HRBasChkWTOfDaySql --考勤处理类型索引表BSC
select * from HRBasDorm --宿舍管理表BSC
select * from HRBasDorm_D --宿舍入住表BSC
select * from HRBasDorm_D_D --宿舍入住表加备注BSC
select * from HRbasdormLeave --宿舍退宿表BSC
select * from HRBasEmpAddFieldPersonalize --人员信息字段表
select * from HRBasEmpAddiField --职员新增字段表
select * from HRBasEmpAddIFieldGroup --职员新增字段分组表
select * from HRBasSalaryRule --薪资规则表BSC
select * from HRBasSetChkWTOfDay --日考勤配置字段表BSC
select * from HRBasSetChkWTOfMonth --月考勤配置字段表BSC
select * from HRBasSetSalCol --薪资配置字段表BSC
select * from HRBasSetSalCol_zb --薪资配置字段表
select * from HRBasSetSalColDay --日薪资配置字段表
select * from HRBasSetSalName --配置薪资单位名称BSC
select * from HRBasSetSalPara --薪资表参数表BSC
select * from HRBasSetWorkTime --空表
select * from HRBasSuSheWX --空表
select * from HRBasSuSheZP --空表
select * from HRBCGroup --空表
select * from HRBCQX --空表
select * from HRBCZ_Rule_Emp --字段对应表
select * from HRbixiukecheng --空表
select * from HRBKDJ --考勤补卡登记表BSC
select * from HRBook --人资书表
select * from HRBookMeal --无用表
select * from HRBormKF_D --未知用途BSC
select * from HRBriefing --空表
select * from HRBusinessRegistration --出差登记无用表
select * from HRBusinessTjM --商务统计月表 无用
select * from HRBuTieAmt --无用表,补贴金额表
select * from HRCalendar --日历表BSC
select * from HRCate --人事资料证书表BSC
select * from HRCategory --考勤周期分类表BSC
select * from HRCertificate --空表
select * from HRClassesNumber --班别表BSC
select * from HRClassGroup --班组表BSC
select * from HRClassGroupList --班别班组表BSC
select * from HRClassGroupRule --班别班组规则表BSC
select * from HRClassStage --班次时间阶段表BSC
select * from HRClockInEmp --员工信息上传门禁设备时间表BSC
select * from HRClocks --门禁列表
select * from HRClsRuleDetails --门禁规则详细信息表
select * from HRCofoTable --新员工入职向导员工编号流水号表BSC
select * from HRCompCalendar --公司考勤日历BSC
select * from HRCompWorkTime --公司工作时间表BSC
select * from HRComTradeContract --公司竞业合同表
select * from HRConcurrent --人事兼职表BSC
select * from HRConfidenContract --保密协议签订表
select * from HRCuCaiReg --出差登记表BSC
select * from HRDailyVariation --空表
select * from HRDataType --数据类型表
select * from HrDBBackInfo --无用表
select * from HrDBBackJobInfo --无用表
select * from HRDepartment --部门表BSC
select * from HRDepartment_bz --空表
select * from HRDepartment_cx --空表
select * from HRDepartmentPlan --空表
select * from HRDepartmentTest --无用表
select * from HRDeptDate_ls --空表
select * from HRDeptMB --无用表
select * from HRdjxz
select * from HRDKData --打卡数据记录表BSC
select * from HRDKData_D --无用表
select * from HRDKData1 --无用表
select * from HRDKQXData --考勤请假审核表
select * from HRDlcRecord --空表
select * from HRDlpPlatformColumns --空表
select * from HRDormArticle --宿舍物品表BSC
select * from HRDuiTiao --对调表BSC
select * from HREatTime --吃饭时间控制表BSC
select * from HREatTimeBindEmp --消费机绑定吃饭时间控制表BSC
select * from HREmb --空表
select * from hrempcard --员工卡状态表
select * from hrempcardtype --员工卡状态表
select * from HREmpChgSalary --无用表
select * from HREmpInterview --空表
select * from HREmployee --员工信息表BSC
select * from HREmployeeFangtan --无用表
select * from HREmpRevol --无用表
select * from hrempRiZhi --系统操作日志表BSC
select * from HREmpScheduling --空表
select * from HREmpScheduling_PL --无用表
select * from HRExpItem --无用表
select * from HRfafang --无用表
select * from HRGDP --无用表HRfanganjixiao--发放绩效表 HRFAGroup HRfanganzbzd HRFAOrgEid HRFeatRegister HRFeiYongBaoXiao
select * from HRGoods --货物类别表
select * from HRGridReport --表单报表BSC
select * from HRGroupMenu --菜单角色表BSC
select * from HRGuangGao --广告表
select * from HRidcard --无用表
select COUNT(*) from HRIDCardBrush --身份证无用表
select * from HrItemsTable --未知表
select * from HRJieKuan --借款表
select * from HRJiaBanReg --加班登记表
select * from HRJobContract --工作协议表
select * from HRLangeuage --系统语言表
select * from HRMDKReg --考勤出差登记BC
select * from HRMenu --HR菜单表BSC
select * from HRMenuStyle --HR菜单类型表BSC
select * from HRMjdk --门禁打卡数据表BSC
select * from HRMobileEmployeeGroupMenu --移动办公组菜单授权对应表
select * from HRMobileEmployeeMenu ---移动办公菜单授权表
select * from HRMobileMenuGroup --移动办公APP分组表
select * from HRNianJia --年假表
select * from HROAListPaixu --OA界面菜单排序BSC
select * from HRParameterSetting --HR系统参数设定表
select * from HRParaSettingItems --HR系统参数设定明细表
select * from HRPersonAssistantFile --人员资产字段表
select * from HRPersonAssistantFileCol
select * from HRPersonnelFieldDefine --人员字段默认表
select * from HRPersonnelFieldOrder --人员字段顺序表
select * from HRPhoneMemCount --电话成员数量
select * from HRPhoneMumberControl --成品表
select * from HRPost --职位表BSC
select * from HRPracticeContract --实习签约表
select * from HRRecuitmentFieldDefine --简历字段默认表
select * from HRReportConfig --报表配置字段表
select * from HRRole --角色表BSC
select * from HRsalaryMonthFieldOrder --月薪资字段顺序表
select * from HRRwdOrPnish --奖惩登记表BSC
select * from HRSelfPlatformSet --个人自助平台图标链接设定BSC
select * from HRShebaozj --无用表
select * from HRSourceStore --资源库表
select * from HRSPEmail --空表
select * from HRStay --空表
select * from HRSummaryPlan --无用表
select * from HRSuSheSDDJ --宿舍水电登记表
select * from HRSwot --无用表
select * from HRSwotFenxi --无用表
select * from HRSwotType --无用表
select * from HRTeacher --讲师表BSC
select * from HRTemperaturesReg --无用表
select * from HRTemplateProject --无用表
select * from HRTempOTDetails --无用表
select * from HRTempOTRegistration --无用表
select * from HRTiaoXiu --调休时间表
select * from HRTiaoXiulist --空表
select * from HRTiaoXiuReg --调休申请表
select * from HRTimeWork --无用表
select * from HRTjProject --无用表
select * from HRTrade --无用表
select * from HRTrainContract --培训合约
select * from HRTrainJingli --空表
select * from HRTrainRecord --空表
select * from HRTrainSign --培训签到表
select * from HRTreeList --EHR系统架构表
select * from HRUppedRatio --无用表
select * from HRUsedCard --无用表
select * from HRUsedCardTransfer --无用表
select * from HRUser --EHR用户表BSC
select * from HRUserBg --无用表
select * from HRWaiCu --空表
select * from HRWbEmployeeInfo --无用表
select * from HRWbGt --无用表
select * from HRWbLearning --无用表
select * from HRWbRcK --无用表
select * from HRWbTelRecord --无用表
select * from HRWbTrainJingli --无用表
select * from HRWbWorkExperience --无用表
select * from HRWbZj --无用表
select * from HRWorkClothes --工衣空表
select * from HRWorkDept --空表
select * from HRWorkExperience --空表
select * from HRWorkInjuries --空表
select * from HRWorkRule --考勤规则BSC
select * from HRWorkTimeList --空表
select * from HRWorkTimeList_D --工作日历排班BSC
select * from HRXFRecord --消费记录表BSC
select * from HRXiaoJia --空表销假
select * from ImportTmpTab_656 --加班导入表BSC
select * from insetjson --插入人员信息Json表
select * from Interface --空表
select * from InterviewRecord --无用表
select * from JBcontrol --加班控制表空表
select * from JbSq --加班申请审批表
select * from JbSq_temp --空表
select * from JbTx--无用表
select * from jiabandan --加班表BSC
select * from jiabandan2 --加班表
select * from jixiao1 --无用表
select * from JQZK --BSC未知表
select * from kqry --BSC未知表
select * from LsJbZk --历史加班状况表BSC
select * from lwlz --BSC人员入职登记表
select * from lwlz2 --BSC人员入职登记表未知表
select * from lwlz3 --BSC人员入职登记表
select * from lwlz4 --BSC人员入职登记表
select * from LZ --BSC人员信息表
select * from LZ1 --BSC人员信息表
select * from LZ2 --BSC人员信息表无用
select * from MenuIsChanged --菜单是否有改变
select * from OAAaddMJ --OA门禁申请审批表
select * from OAApp --OAAPP激活表
select * from OACGWPSQdan --OA采购物品申请单
select * from OAcheliangWXBYD --OA车辆维修报表
select * from OAcheliangWXBYSQD
select * from OAchuchaiYC --OA出差单
select * from OAdiannaoweihu --电脑维修申请单表
select * from OADiaodong --OA调动申请单
select * from OAExpressSend --快递寄送申请单
select * from OAFeiAadd --非A门禁申请单
select * from OAgongzuof --工作服申请单
select * from OAHuiYiYD --会议室预定表
select * from OAHuoWuFXT --货物放行条表
select * from OAJGJYuDing --酒店预定表
select * from OAjingdiefangsqb --金蝶反审单表
select * from OAKBGyidong --跨部门异常单表
select * from OAKBMDiaodong --跨部门调动申请单
select * from OAlaifangryjyA --来访A类申请表
select * from OAlaifangryjyFa --来访非A类申请表
select * from OALBJDD --来办单位登记表
select * from OApaizhaoSQD --拍照申请表
select * from OAPCD --派车单
select * from OAPeisunkecjlb --培训课程
select * from OAQiTaWuPinFXT --其它物品放行条
select * from OAQKSQD --未知
select * from OARSZLchaxun
select * from OASGSQD
select * from OASQERP --ERP申请表
select * from OAsusheFXT --宿舍放行条
select * from OAtuisuSQ --入退宿申请表
select * from OATXD
select * from OAwaichuPsqb --外出培训单
select * from OAWJxiuding --文件修订表
select * from OAWQSQ --外勤申请单
select * from OAXBFSQ --
select * from OAxinziYD --薪资异动单
select * from OAxinziYDLC --薪资异动单
select * from OAyanglaoBX --养老保险申请表
select * from OAyidongxinzi --异动薪资申请表
select * from OAYPYSG --月度办公物品
select * from OAZhaoPin --招聘申请单
select * from OftenFunction --OA常用功能
select * from PageStyle --页面风格
select * from pc2machinesEx --机器扩展表
select * from PeiXunGuanLiFaZheng
select * from PeiXunGuanLiGongYingShang
select * from PeiXunGuanLiJiangShiNei
select * from PushAccount --推送账号
select * from PushFail --推送失败记录
select * from PushFail_ios --推送失败记录iOS
select * from PushMsg --推送消息
select * from QjDj --请假登记表
select * from QueryScheme --查询模式表
select * from RegCardRecord --发卡记录表
select * from RegisterCheck --登记检查表
select * from RptSalary1 --薪资表
select * from RptSalarySummary --空表
select * from RptSalary_Year --空表
select * from rwss
select * from SalaryEmp --空表
select * from SalarySetting --空表
select * from SalaryType --空表
select * from SalFixedItem --薪资固定条目表
select * from SalFixedItem_D --薪资固定条目表
select * from SB3 --BSC未知表
select * from SecureArea
select * from SecureParam --保险参数
select * from SecureTableColumn
select * from SecurityRpt --社保报表
select * from shiyongqi --试用期人员表
select * from ssxx --
select * from ssxx1
select * from ssxx11
select * from ssxx12
select * from Supplier --供应商列表
select * from sushe --宿舍登记列表
select * from sushexinxi --宿舍信息
select * from T_GroupMember--未知组成员
select * from T_ProductPrice --T_TrainThoughts、T_PersonPieceWage、T_PersonQuestionnaire、T_PieceWage、T_PrintCardSetting、T_Project、T_ProjectPross无用表
select * from tbExportProjectList --导出表项目列表
select * from tbExportProjectPaiXu --排休表导出项目
select * from temptable --tbSuccessUserSession、TC_DianPu、TC_DianPuMemberManage、TeachMedia无用表 --tbFileList 空表
select * from T_PrintCardSetting
select * from T_BlackList --黑名单
select * from T_CardChange --T_DelayPushMsg空表
select * from T_GroupPiece --T_EmployeePositive、T_EmployeeTurnStandard、T_FactorInfo、T_GroupPiece无用表