Slurm记账数据库数据字典
表名称：acct_coord_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30Y0 accttinytext255 N usertinytext255 N 索引名范例包含字段PRIMARYPrimaryacct(42),user(42)userNormaluser(42)表名称：acct_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30Y0 flagsint(10) unsigned 100Y0 nametinytext255 N descriptiontext65535 N organizationtext65535 N 索引名范例包含字段PRIMARYPrimaryname(42)表名称：cluster_assoc_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 commenttext65535 YNULL flagsint(10) unsigned 100N0 is_deftinyint(4) 30N0 id_assocint(10) unsigned 100N usertinytext255 N'' accttinytext255 N partitiontinytext255 N'' parent_accttinytext255 N'' id_parentint(10) unsigned 100N lineagetext65535 YNULL lftint(11) 100N0 rgtint(11) 100N0 sharesint(11) 100N1 max_jobsint(11) 100YNULL max_jobs_accrueint(11) 100YNULL min_prio_threshint(11) 100YNULL max_submit_jobsint(11) 100YNULL max_tres_pjtext65535 N'' max_tres_pntext65535 N'' max_tres_mins_pjtext65535 N'' max_tres_run_minstext65535 N'' max_wall_pjint(11) 100YNULL grp_jobsint(11) 100YNULL grp_jobs_accrueint(11) 100YNULL grp_submit_jobsint(11) 100YNULL grp_trestext65535 N'' grp_tres_minstext65535 N'' grp_tres_run_minstext65535 N'' grp_wallint(11) 100YNULL priorityint(10) unsigned 100YNULL def_qos_idint(11) 100YNULL qosblob65535 N'' delta_qosblob65535 N'' 索引名范例包含字段PRIMARYPrimaryid_assocudexUniqueuser(42),acct(42),partition(42)lftNormallftaccountNormalacct(42)表名称：cluster_assoc_usage_day_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 idint(10) unsigned 100N id_tresint(11) 100N1 time_startbigint(20) unsigned 200N alloc_secsbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryid,id_tres,time_startarchive_purgeNormalmod_time表名称：cluster_assoc_usage_hour_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 idint(10) unsigned 100N id_tresint(11) 100N1 time_startbigint(20) unsigned 200N alloc_secsbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryid,id_tres,time_startarchive_purgeNormalmod_time表名称：cluster_assoc_usage_month_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 idint(10) unsigned 100N id_tresint(11) 100N1 time_startbigint(20) unsigned 200N alloc_secsbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryid,id_tres,time_startarchive_purgeNormalmod_time表名称：cluster_event_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别time_startbigint(20) unsigned 200N time_endbigint(20) unsigned 200N0 node_nametinytext255 N'' extratext65535 YNULL cluster_nodestext65535 N'' instance_idtext65535 YNULL instance_typetext65535 YNULL reasontinytext255 N reason_uidint(10) unsigned 100N4294967294 stateint(10) unsigned 100N0 trestext65535 N'' 索引名范例包含字段PRIMARYPrimarynode_name(42),time_startrollupNormaltime_start,time_end,statearchive_purgeNormaltime_end表名称：cluster_job_env_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别hash_inxbigint(20) unsigned 200N last_usedtimestamp Ncurrent_timestamp() env_hashtext65535 N env_varslongtext4294967295 YNULL 索引名范例包含字段PRIMARYPrimaryhash_inxenv_hash_inxUniqueenv_hash(66)表名称：cluster_job_script_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别hash_inxbigint(20) unsigned 200N last_usedtimestamp Ncurrent_timestamp() script_hashtext65535 N batch_scriptlongtext4294967295 YNULL 索引名范例包含字段PRIMARYPrimaryhash_inxscript_hash_inxUniquescript_hash(66)表名称：cluster_job_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别job_db_inxbigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 accounttinytext255 YNULL admin_commenttext65535 YNULL array_task_strtext65535 YNULL array_max_tasksint(10) unsigned 100N0 array_task_pendingint(10) unsigned 100N0 constraintstext65535 Y'' containertext65535 YNULL cpus_reqint(10) unsigned 100N derived_ecint(10) unsigned 100N0 derived_estext65535 YNULL env_hash_inxbigint(20) unsigned 200N0 exit_codeint(10) unsigned 100N0 extratext65535 YNULL flagsint(10) unsigned 100N0 failed_nodetinytext255 YNULL job_nametinytext255 N id_assocint(10) unsigned 100N id_array_jobint(10) unsigned 100N0 id_array_taskint(10) unsigned 100N4294967294 id_blocktinytext255 YNULL id_jobint(10) unsigned 100N id_qosint(10) unsigned 100N0 id_resvint(10) unsigned 100N id_wckeyint(10) unsigned 100N id_userint(10) unsigned 100N id_groupint(10) unsigned 100N het_job_idint(10) unsigned 100N het_job_offsetint(10) unsigned 100N kill_requidint(10) unsigned 100YNULL state_reason_prevint(10) unsigned 100N licensestext65535 YNULL mcs_labeltinytext255 Y'' mem_reqbigint(20) unsigned 200N0 nodelisttext65535 YNULL nodes_allocint(10) unsigned 100N node_inxtext65535 YNULL partitiontinytext255 N priorityint(10) unsigned 100N script_hash_inxbigint(20) unsigned 200N0 stateint(10) unsigned 100N timelimitint(10) unsigned 100N0 time_submitbigint(20) unsigned 200N0 time_eligiblebigint(20) unsigned 200N0 time_startbigint(20) unsigned 200N0 time_endbigint(20) unsigned 200N0 time_suspendedbigint(20) unsigned 200N0 gres_usedtext65535 N'' wckeytinytext255 N'' work_dirtext65535 N'' std_errtext65535 N'' std_intext65535 N'' std_outtext65535 N'' submit_linelongtext4294967295 YNULL system_commenttext65535 YNULL tres_alloctext65535 N'' tres_reqtext65535 N'' 索引名范例包含字段PRIMARYPrimaryjob_db_inxid_jobUniqueid_job,time_submitold_tupleNormalid_job,id_assoc,time_submitrollupNormaltime_eligible,time_endrollup2Normaltime_end,time_eligiblenodes_allocNormalnodes_allocwckeyNormalid_wckeyqosNormalid_qosassociationNormalid_assocarray_jobNormalid_array_jobhet_jobNormalhet_job_idreservNormalid_resvsacct_defNormalid_user,time_start,time_endsacct_def2Normalid_user,time_end,time_eligibleenv_hash_inxNormalenv_hash_inxscript_hash_inxNormalscript_hash_inxarchive_purgeNormaltime_end表名称：cluster_last_ran_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别hourly_rollupbigint(20) unsigned 200N0 daily_rollupbigint(20) unsigned 200N0 monthly_rollupbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryhourly_rollup,daily_rollup,monthly_rollup表名称：cluster_resv_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别id_resvint(10) unsigned 100N0 deletedtinyint(4) 30N0 assoclisttext65535 N'' flagsbigint(20) unsigned 200N0 nodelisttext65535 N'' node_inxtext65535 N'' resv_nametext65535 N time_startbigint(20) unsigned 200N0 time_endbigint(20) unsigned 200N0 trestext65535 N'' unused_walldouble unsigned 22 N0 commenttext65535 YNULL 索引名范例包含字段PRIMARYPrimaryid_resv,time_startarchive_purgeNormaltime_end表名称：cluster_step_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别job_db_inxbigint(20) unsigned 200N deletedtinyint(4) 30N0 exit_codeint(11) 100N0 id_stepint(11) 100N step_het_compint(10) unsigned 100N4294967294 kill_requidint(10) unsigned 100YNULL nodelisttext65535 N nodes_allocint(10) unsigned 100N node_inxtext65535 YNULL statesmallint(5) unsigned 50N step_nametext65535 N task_cntint(10) unsigned 100N task_distint(11) 100N0 time_startbigint(20) unsigned 200N0 time_endbigint(20) unsigned 200N0 time_suspendedbigint(20) unsigned 200N0 user_secbigint(20) unsigned 200N0 user_usecint(10) unsigned 100N0 sys_secbigint(20) unsigned 200N0 sys_usecint(10) unsigned 100N0 act_cpufreqdouble unsigned 22 N0 consumed_energybigint(20) unsigned 200N0 containertext65535 YNULL req_cpufreq_minint(10) unsigned 100N0 req_cpufreqint(10) unsigned 100N0 req_cpufreq_govint(10) unsigned 100N0 submit_linelongtext4294967295 YNULL tres_alloctext65535 N'' tres_usage_in_avetext65535 N'' tres_usage_in_maxtext65535 N'' tres_usage_in_max_taskidtext65535 N'' tres_usage_in_max_nodeidtext65535 N'' tres_usage_in_mintext65535 N'' tres_usage_in_min_taskidtext65535 N'' tres_usage_in_min_nodeidtext65535 N'' tres_usage_in_tottext65535 N'' tres_usage_out_avetext65535 N'' tres_usage_out_maxtext65535 N'' tres_usage_out_max_taskidtext65535 N'' tres_usage_out_max_nodeidtext65535 N'' tres_usage_out_mintext65535 N'' tres_usage_out_min_taskidtext65535 N'' tres_usage_out_min_nodeidtext65535 N'' tres_usage_out_tottext65535 N'' 索引名范例包含字段PRIMARYPrimaryjob_db_inx,id_step,step_het_comparchive_purgeNormaltime_end表名称：cluster_suspend_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别job_db_inxbigint(20) unsigned 200N id_assocint(11) 100N time_startbigint(20) unsigned 200N0 time_endbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryjob_db_inx,time_startarchive_purgeNormaltime_end表名称：cluster_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30Y0 nametinytext255 N control_hosttinytext255 N'' control_portint(10) unsigned 100N0 last_portint(10) unsigned 100N0 rpc_versionsmallint(5) unsigned 50N0 classificationsmallint(5) unsigned 50Y0 dimensionssmallint(5) unsigned 50Y1 flagsint(10) unsigned 100Y0 federationtinytext255 N featurestext65535 N'' fed_idint(10) unsigned 100N0 fed_statesmallint(5) unsigned 50N 索引名范例包含字段PRIMARYPrimaryname(42)表名称：cluster_usage_day_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 id_tresint(11) 100N time_startbigint(20) unsigned 200N countbigint(20) unsigned 200N0 alloc_secsbigint(20) unsigned 200N0 down_secsbigint(20) unsigned 200N0 pdown_secsbigint(20) unsigned 200N0 idle_secsbigint(20) unsigned 200N0 plan_secsbigint(20) unsigned 200N0 over_secsbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryid_tres,time_startarchive_purgeNormalmod_time表名称：cluster_usage_hour_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 id_tresint(11) 100N time_startbigint(20) unsigned 200N countbigint(20) unsigned 200N0 alloc_secsbigint(20) unsigned 200N0 down_secsbigint(20) unsigned 200N0 pdown_secsbigint(20) unsigned 200N0 idle_secsbigint(20) unsigned 200N0 plan_secsbigint(20) unsigned 200N0 over_secsbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryid_tres,time_startarchive_purgeNormalmod_time表名称：cluster_usage_month_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 id_tresint(11) 100N time_startbigint(20) unsigned 200N countbigint(20) unsigned 200N0 alloc_secsbigint(20) unsigned 200N0 down_secsbigint(20) unsigned 200N0 pdown_secsbigint(20) unsigned 200N0 idle_secsbigint(20) unsigned 200N0 plan_secsbigint(20) unsigned 200N0 over_secsbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryid_tres,time_startarchive_purgeNormalmod_time表名称：cluster_wckey_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 is_deftinyint(4) 30N0 id_wckeyint(10) unsigned 100N wckey_nametinytext255 N'' usertinytext255 N 索引名范例包含字段PRIMARYPrimaryid_wckeyudexUniquewckey_name(42),user(42)表名称：cluster_wckey_usage_day_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 idint(10) unsigned 100N id_tresint(11) 100N1 time_startbigint(20) unsigned 200N alloc_secsbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryid,id_tres,time_startarchive_purgeNormalmod_time表名称：cluster_wckey_usage_hour_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 idint(10) unsigned 100N id_tresint(11) 100N1 time_startbigint(20) unsigned 200N alloc_secsbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryid,id_tres,time_startarchive_purgeNormalmod_time表名称：cluster_wckey_usage_month_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30N0 idint(10) unsigned 100N id_tresint(11) 100N1 time_startbigint(20) unsigned 200N alloc_secsbigint(20) unsigned 200N0 索引名范例包含字段PRIMARYPrimaryid,id_tres,time_startarchive_purgeNormalmod_time表名称：clus_res_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30Y0 clustertinytext255 N res_idint(11) 100N allowedint(10) unsigned 100Y0 索引名范例包含字段PRIMARYPrimaryres_id,cluster(42)表名称：convert_version_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别mod_timebigint(20) unsigned 200N0 versionint(11) 100N0 索引名范例包含字段PRIMARYPrimaryversion表名称：federation_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timeint(10) unsigned 100N mod_timeint(10) unsigned 100N0 deletedtinyint(4) 30Y0 nametinytext255 N flagsint(10) unsigned 100Y0 索引名范例包含字段PRIMARYPrimaryname(42)表名称：qos_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30Y0 idint(11) 100N nametinytext255 N descriptiontext65535 YNULL flagsint(10) unsigned 100Y0 grace_timeint(10) unsigned 100YNULL max_jobs_paint(11) 100YNULL max_jobs_per_userint(11) 100YNULL max_jobs_accrue_paint(11) 100YNULL max_jobs_accrue_puint(11) 100YNULL min_prio_threshint(11) 100YNULL max_submit_jobs_paint(11) 100YNULL max_submit_jobs_per_userint(11) 100YNULL max_tres_patext65535 N'' max_tres_pjtext65535 N'' max_tres_pntext65535 N'' max_tres_putext65535 N'' max_tres_mins_pjtext65535 N'' max_tres_run_mins_patext65535 N'' max_tres_run_mins_putext65535 N'' min_tres_pjtext65535 N'' max_wall_duration_per_jobint(11) 100YNULL grp_jobsint(11) 100YNULL grp_jobs_accrueint(11) 100YNULL grp_submit_jobsint(11) 100YNULL grp_trestext65535 N'' grp_tres_minstext65535 N'' grp_tres_run_minstext65535 N'' grp_wallint(11) 100YNULL preempttext65535 N'' preempt_modeint(11) 100Y0 preempt_exempt_timeint(10) unsigned 100YNULL priorityint(10) unsigned 100Y0 usage_factordouble 22 N1 usage_thresdouble 22 YNULL limit_factordouble 22 YNULL 索引名范例包含字段PRIMARYPrimaryidudexUniquename(42)表名称：res_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30Y0 idint(11) 100N nametinytext255 N descriptiontext65535 YNULL managertinytext255 N servertinytext255 N countint(10) unsigned 100Y0 typeint(10) unsigned 100Y0 flagsint(10) unsigned 100Y0 last_consumedint(10) unsigned 100Y0 索引名范例包含字段PRIMARYPrimaryidudexUniquename(42),server(42),type表名称：table_defs_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timeint(10) unsigned 100N mod_timeint(10) unsigned 100N0 table_nametext65535 N definitiontext65535 N 索引名范例包含字段PRIMARYPrimarytable_name(50)表名称：tres_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N deletedtinyint(4) 30N0 idint(11) 100N typetinytext255 N nametinytext255 N'' 索引名范例包含字段PRIMARYPrimaryidudexUniquetype(42),name(42)表名称：txn_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别idint(11) 100N timestampbigint(20) unsigned 200N0 actionsmallint(6) 50N nametext65535 N actortinytext255 N clustertinytext255 N'' infoblob65535 YNULL 索引名范例包含字段PRIMARYPrimaryidarchive_purgeNormaltimestamp,cluster(42)表名称：user_table描述:字符集:latin1数据库:slurm@rm-f8zv4ubb75e971n5g列名范例长度精度标度是否为空缺省值描述安全级别creation_timebigint(20) unsigned 200N mod_timebigint(20) unsigned 200N0 deletedtinyint(4) 30Y0 nametinytext255 N admin_levelsmallint(6) 50N1 索引名范例包含字段PRIMARYPrimaryname(42)免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]