| 表名称:acct_coord_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | Y | 0 | |||
| acct | tinytext | 255 | N | |||||
| user | tinytext | 255 | N | |||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | acct(42),user(42) | ||||||
| user | Normal | user(42) | ||||||
| 表名称:acct_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | Y | 0 | |||
| flags | int(10) unsigned | 10 | 0 | Y | 0 | |||
| name | tinytext | 255 | N | |||||
| description | text | 65535 | N | |||||
| organization | text | 65535 | N | |||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | name(42) | ||||||
| 表名称:cluster_assoc_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| comment | text | 65535 | Y | NULL | ||||
| flags | int(10) unsigned | 10 | 0 | N | 0 | |||
| is_def | tinyint(4) | 3 | 0 | N | 0 | |||
| id_assoc | int(10) unsigned | 10 | 0 | N | ||||
| user | tinytext | 255 | N | '' | ||||
| acct | tinytext | 255 | N | |||||
| partition | tinytext | 255 | N | '' | ||||
| parent_acct | tinytext | 255 | N | '' | ||||
| id_parent | int(10) unsigned | 10 | 0 | N | ||||
| lineage | text | 65535 | Y | NULL | ||||
| lft | int(11) | 10 | 0 | N | 0 | |||
| rgt | int(11) | 10 | 0 | N | 0 | |||
| shares | int(11) | 10 | 0 | N | 1 | |||
| max_jobs | int(11) | 10 | 0 | Y | NULL | |||
| max_jobs_accrue | int(11) | 10 | 0 | Y | NULL | |||
| min_prio_thresh | int(11) | 10 | 0 | Y | NULL | |||
| max_submit_jobs | int(11) | 10 | 0 | Y | NULL | |||
| max_tres_pj | text | 65535 | N | '' | ||||
| max_tres_pn | text | 65535 | N | '' | ||||
| max_tres_mins_pj | text | 65535 | N | '' | ||||
| max_tres_run_mins | text | 65535 | N | '' | ||||
| max_wall_pj | int(11) | 10 | 0 | Y | NULL | |||
| grp_jobs | int(11) | 10 | 0 | Y | NULL | |||
| grp_jobs_accrue | int(11) | 10 | 0 | Y | NULL | |||
| grp_submit_jobs | int(11) | 10 | 0 | Y | NULL | |||
| grp_tres | text | 65535 | N | '' | ||||
| grp_tres_mins | text | 65535 | N | '' | ||||
| grp_tres_run_mins | text | 65535 | N | '' | ||||
| grp_wall | int(11) | 10 | 0 | Y | NULL | |||
| priority | int(10) unsigned | 10 | 0 | Y | NULL | |||
| def_qos_id | int(11) | 10 | 0 | Y | NULL | |||
| qos | blob | 65535 | N | '' | ||||
| delta_qos | blob | 65535 | N | '' | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id_assoc | ||||||
| udex | Unique | user(42),acct(42),partition(42) | ||||||
| lft | Normal | lft | ||||||
| account | Normal | acct(42) | ||||||
| 表名称:cluster_assoc_usage_day_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id | int(10) unsigned | 10 | 0 | N | ||||
| id_tres | int(11) | 10 | 0 | N | 1 | |||
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| alloc_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id,id_tres,time_start | ||||||
| archive_purge | Normal | mod_time | ||||||
| 表名称:cluster_assoc_usage_hour_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id | int(10) unsigned | 10 | 0 | N | ||||
| id_tres | int(11) | 10 | 0 | N | 1 | |||
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| alloc_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id,id_tres,time_start | ||||||
| archive_purge | Normal | mod_time | ||||||
| 表名称:cluster_assoc_usage_month_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id | int(10) unsigned | 10 | 0 | N | ||||
| id_tres | int(11) | 10 | 0 | N | 1 | |||
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| alloc_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id,id_tres,time_start | ||||||
| archive_purge | Normal | mod_time | ||||||
| 表名称:cluster_event_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| time_end | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| node_name | tinytext | 255 | N | '' | ||||
| extra | text | 65535 | Y | NULL | ||||
| cluster_nodes | text | 65535 | N | '' | ||||
| instance_id | text | 65535 | Y | NULL | ||||
| instance_type | text | 65535 | Y | NULL | ||||
| reason | tinytext | 255 | N | |||||
| reason_uid | int(10) unsigned | 10 | 0 | N | 4294967294 | |||
| state | int(10) unsigned | 10 | 0 | N | 0 | |||
| tres | text | 65535 | N | '' | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | node_name(42),time_start | ||||||
| rollup | Normal | time_start,time_end,state | ||||||
| archive_purge | Normal | time_end | ||||||
| 表名称:cluster_job_env_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| hash_inx | bigint(20) unsigned | 20 | 0 | N | ||||
| last_used | timestamp | N | current_timestamp() | |||||
| env_hash | text | 65535 | N | |||||
| env_vars | longtext | 4294967295 | Y | NULL | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | hash_inx | ||||||
| env_hash_inx | Unique | env_hash(66) | ||||||
| 表名称:cluster_job_script_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| hash_inx | bigint(20) unsigned | 20 | 0 | N | ||||
| last_used | timestamp | N | current_timestamp() | |||||
| script_hash | text | 65535 | N | |||||
| batch_script | longtext | 4294967295 | Y | NULL | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | hash_inx | ||||||
| script_hash_inx | Unique | script_hash(66) | ||||||
| 表名称:cluster_job_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| job_db_inx | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| account | tinytext | 255 | Y | NULL | ||||
| admin_comment | text | 65535 | Y | NULL | ||||
| array_task_str | text | 65535 | Y | NULL | ||||
| array_max_tasks | int(10) unsigned | 10 | 0 | N | 0 | |||
| array_task_pending | int(10) unsigned | 10 | 0 | N | 0 | |||
| constraints | text | 65535 | Y | '' | ||||
| container | text | 65535 | Y | NULL | ||||
| cpus_req | int(10) unsigned | 10 | 0 | N | ||||
| derived_ec | int(10) unsigned | 10 | 0 | N | 0 | |||
| derived_es | text | 65535 | Y | NULL | ||||
| env_hash_inx | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| exit_code | int(10) unsigned | 10 | 0 | N | 0 | |||
| extra | text | 65535 | Y | NULL | ||||
| flags | int(10) unsigned | 10 | 0 | N | 0 | |||
| failed_node | tinytext | 255 | Y | NULL | ||||
| job_name | tinytext | 255 | N | |||||
| id_assoc | int(10) unsigned | 10 | 0 | N | ||||
| id_array_job | int(10) unsigned | 10 | 0 | N | 0 | |||
| id_array_task | int(10) unsigned | 10 | 0 | N | 4294967294 | |||
| id_block | tinytext | 255 | Y | NULL | ||||
| id_job | int(10) unsigned | 10 | 0 | N | ||||
| id_qos | int(10) unsigned | 10 | 0 | N | 0 | |||
| id_resv | int(10) unsigned | 10 | 0 | N | ||||
| id_wckey | int(10) unsigned | 10 | 0 | N | ||||
| id_user | int(10) unsigned | 10 | 0 | N | ||||
| id_group | int(10) unsigned | 10 | 0 | N | ||||
| het_job_id | int(10) unsigned | 10 | 0 | N | ||||
| het_job_offset | int(10) unsigned | 10 | 0 | N | ||||
| kill_requid | int(10) unsigned | 10 | 0 | Y | NULL | |||
| state_reason_prev | int(10) unsigned | 10 | 0 | N | ||||
| licenses | text | 65535 | Y | NULL | ||||
| mcs_label | tinytext | 255 | Y | '' | ||||
| mem_req | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| nodelist | text | 65535 | Y | NULL | ||||
| nodes_alloc | int(10) unsigned | 10 | 0 | N | ||||
| node_inx | text | 65535 | Y | NULL | ||||
| partition | tinytext | 255 | N | |||||
| priority | int(10) unsigned | 10 | 0 | N | ||||
| script_hash_inx | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| state | int(10) unsigned | 10 | 0 | N | ||||
| timelimit | int(10) unsigned | 10 | 0 | N | 0 | |||
| time_submit | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| time_eligible | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| time_start | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| time_end | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| time_suspended | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| gres_used | text | 65535 | N | '' | ||||
| wckey | tinytext | 255 | N | '' | ||||
| work_dir | text | 65535 | N | '' | ||||
| std_err | text | 65535 | N | '' | ||||
| std_in | text | 65535 | N | '' | ||||
| std_out | text | 65535 | N | '' | ||||
| submit_line | longtext | 4294967295 | Y | NULL | ||||
| system_comment | text | 65535 | Y | NULL | ||||
| tres_alloc | text | 65535 | N | '' | ||||
| tres_req | text | 65535 | N | '' | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | job_db_inx | ||||||
| id_job | Unique | id_job,time_submit | ||||||
| old_tuple | Normal | id_job,id_assoc,time_submit | ||||||
| rollup | Normal | time_eligible,time_end | ||||||
| rollup2 | Normal | time_end,time_eligible | ||||||
| nodes_alloc | Normal | nodes_alloc | ||||||
| wckey | Normal | id_wckey | ||||||
| qos | Normal | id_qos | ||||||
| association | Normal | id_assoc | ||||||
| array_job | Normal | id_array_job | ||||||
| het_job | Normal | het_job_id | ||||||
| reserv | Normal | id_resv | ||||||
| sacct_def | Normal | id_user,time_start,time_end | ||||||
| sacct_def2 | Normal | id_user,time_end,time_eligible | ||||||
| env_hash_inx | Normal | env_hash_inx | ||||||
| script_hash_inx | Normal | script_hash_inx | ||||||
| archive_purge | Normal | time_end | ||||||
| 表名称:cluster_last_ran_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| hourly_rollup | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| daily_rollup | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| monthly_rollup | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | hourly_rollup,daily_rollup,monthly_rollup | ||||||
| 表名称:cluster_resv_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| id_resv | int(10) unsigned | 10 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| assoclist | text | 65535 | N | '' | ||||
| flags | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| nodelist | text | 65535 | N | '' | ||||
| node_inx | text | 65535 | N | '' | ||||
| resv_name | text | 65535 | N | |||||
| time_start | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| time_end | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| tres | text | 65535 | N | '' | ||||
| unused_wall | double unsigned | 22 | N | 0 | ||||
| comment | text | 65535 | Y | NULL | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id_resv,time_start | ||||||
| archive_purge | Normal | time_end | ||||||
| 表名称:cluster_step_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| job_db_inx | bigint(20) unsigned | 20 | 0 | N | ||||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| exit_code | int(11) | 10 | 0 | N | 0 | |||
| id_step | int(11) | 10 | 0 | N | ||||
| step_het_comp | int(10) unsigned | 10 | 0 | N | 4294967294 | |||
| kill_requid | int(10) unsigned | 10 | 0 | Y | NULL | |||
| nodelist | text | 65535 | N | |||||
| nodes_alloc | int(10) unsigned | 10 | 0 | N | ||||
| node_inx | text | 65535 | Y | NULL | ||||
| state | smallint(5) unsigned | 5 | 0 | N | ||||
| step_name | text | 65535 | N | |||||
| task_cnt | int(10) unsigned | 10 | 0 | N | ||||
| task_dist | int(11) | 10 | 0 | N | 0 | |||
| time_start | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| time_end | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| time_suspended | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| user_sec | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| user_usec | int(10) unsigned | 10 | 0 | N | 0 | |||
| sys_sec | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| sys_usec | int(10) unsigned | 10 | 0 | N | 0 | |||
| act_cpufreq | double unsigned | 22 | N | 0 | ||||
| consumed_energy | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| container | text | 65535 | Y | NULL | ||||
| req_cpufreq_min | int(10) unsigned | 10 | 0 | N | 0 | |||
| req_cpufreq | int(10) unsigned | 10 | 0 | N | 0 | |||
| req_cpufreq_gov | int(10) unsigned | 10 | 0 | N | 0 | |||
| submit_line | longtext | 4294967295 | Y | NULL | ||||
| tres_alloc | text | 65535 | N | '' | ||||
| tres_usage_in_ave | text | 65535 | N | '' | ||||
| tres_usage_in_max | text | 65535 | N | '' | ||||
| tres_usage_in_max_taskid | text | 65535 | N | '' | ||||
| tres_usage_in_max_nodeid | text | 65535 | N | '' | ||||
| tres_usage_in_min | text | 65535 | N | '' | ||||
| tres_usage_in_min_taskid | text | 65535 | N | '' | ||||
| tres_usage_in_min_nodeid | text | 65535 | N | '' | ||||
| tres_usage_in_tot | text | 65535 | N | '' | ||||
| tres_usage_out_ave | text | 65535 | N | '' | ||||
| tres_usage_out_max | text | 65535 | N | '' | ||||
| tres_usage_out_max_taskid | text | 65535 | N | '' | ||||
| tres_usage_out_max_nodeid | text | 65535 | N | '' | ||||
| tres_usage_out_min | text | 65535 | N | '' | ||||
| tres_usage_out_min_taskid | text | 65535 | N | '' | ||||
| tres_usage_out_min_nodeid | text | 65535 | N | '' | ||||
| tres_usage_out_tot | text | 65535 | N | '' | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | job_db_inx,id_step,step_het_comp | ||||||
| archive_purge | Normal | time_end | ||||||
| 表名称:cluster_suspend_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| job_db_inx | bigint(20) unsigned | 20 | 0 | N | ||||
| id_assoc | int(11) | 10 | 0 | N | ||||
| time_start | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| time_end | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | job_db_inx,time_start | ||||||
| archive_purge | Normal | time_end | ||||||
| 表名称:cluster_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | Y | 0 | |||
| name | tinytext | 255 | N | |||||
| control_host | tinytext | 255 | N | '' | ||||
| control_port | int(10) unsigned | 10 | 0 | N | 0 | |||
| last_port | int(10) unsigned | 10 | 0 | N | 0 | |||
| rpc_version | smallint(5) unsigned | 5 | 0 | N | 0 | |||
| classification | smallint(5) unsigned | 5 | 0 | Y | 0 | |||
| dimensions | smallint(5) unsigned | 5 | 0 | Y | 1 | |||
| flags | int(10) unsigned | 10 | 0 | Y | 0 | |||
| federation | tinytext | 255 | N | |||||
| features | text | 65535 | N | '' | ||||
| fed_id | int(10) unsigned | 10 | 0 | N | 0 | |||
| fed_state | smallint(5) unsigned | 5 | 0 | N | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | name(42) | ||||||
| 表名称:cluster_usage_day_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id_tres | int(11) | 10 | 0 | N | ||||
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| count | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| alloc_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| down_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| pdown_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| idle_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| plan_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| over_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id_tres,time_start | ||||||
| archive_purge | Normal | mod_time | ||||||
| 表名称:cluster_usage_hour_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id_tres | int(11) | 10 | 0 | N | ||||
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| count | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| alloc_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| down_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| pdown_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| idle_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| plan_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| over_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id_tres,time_start | ||||||
| archive_purge | Normal | mod_time | ||||||
| 表名称:cluster_usage_month_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id_tres | int(11) | 10 | 0 | N | ||||
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| count | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| alloc_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| down_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| pdown_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| idle_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| plan_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| over_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id_tres,time_start | ||||||
| archive_purge | Normal | mod_time | ||||||
| 表名称:cluster_wckey_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| is_def | tinyint(4) | 3 | 0 | N | 0 | |||
| id_wckey | int(10) unsigned | 10 | 0 | N | ||||
| wckey_name | tinytext | 255 | N | '' | ||||
| user | tinytext | 255 | N | |||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id_wckey | ||||||
| udex | Unique | wckey_name(42),user(42) | ||||||
| 表名称:cluster_wckey_usage_day_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id | int(10) unsigned | 10 | 0 | N | ||||
| id_tres | int(11) | 10 | 0 | N | 1 | |||
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| alloc_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id,id_tres,time_start | ||||||
| archive_purge | Normal | mod_time | ||||||
| 表名称:cluster_wckey_usage_hour_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id | int(10) unsigned | 10 | 0 | N | ||||
| id_tres | int(11) | 10 | 0 | N | 1 | |||
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| alloc_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id,id_tres,time_start | ||||||
| archive_purge | Normal | mod_time | ||||||
| 表名称:cluster_wckey_usage_month_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id | int(10) unsigned | 10 | 0 | N | ||||
| id_tres | int(11) | 10 | 0 | N | 1 | |||
| time_start | bigint(20) unsigned | 20 | 0 | N | ||||
| alloc_secs | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id,id_tres,time_start | ||||||
| archive_purge | Normal | mod_time | ||||||
| 表名称:clus_res_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | Y | 0 | |||
| cluster | tinytext | 255 | N | |||||
| res_id | int(11) | 10 | 0 | N | ||||
| allowed | int(10) unsigned | 10 | 0 | Y | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | res_id,cluster(42) | ||||||
| 表名称:convert_version_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| version | int(11) | 10 | 0 | N | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | version | ||||||
| 表名称:federation_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | int(10) unsigned | 10 | 0 | N | ||||
| mod_time | int(10) unsigned | 10 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | Y | 0 | |||
| name | tinytext | 255 | N | |||||
| flags | int(10) unsigned | 10 | 0 | Y | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | name(42) | ||||||
| 表名称:qos_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | Y | 0 | |||
| id | int(11) | 10 | 0 | N | ||||
| name | tinytext | 255 | N | |||||
| description | text | 65535 | Y | NULL | ||||
| flags | int(10) unsigned | 10 | 0 | Y | 0 | |||
| grace_time | int(10) unsigned | 10 | 0 | Y | NULL | |||
| max_jobs_pa | int(11) | 10 | 0 | Y | NULL | |||
| max_jobs_per_user | int(11) | 10 | 0 | Y | NULL | |||
| max_jobs_accrue_pa | int(11) | 10 | 0 | Y | NULL | |||
| max_jobs_accrue_pu | int(11) | 10 | 0 | Y | NULL | |||
| min_prio_thresh | int(11) | 10 | 0 | Y | NULL | |||
| max_submit_jobs_pa | int(11) | 10 | 0 | Y | NULL | |||
| max_submit_jobs_per_user | int(11) | 10 | 0 | Y | NULL | |||
| max_tres_pa | text | 65535 | N | '' | ||||
| max_tres_pj | text | 65535 | N | '' | ||||
| max_tres_pn | text | 65535 | N | '' | ||||
| max_tres_pu | text | 65535 | N | '' | ||||
| max_tres_mins_pj | text | 65535 | N | '' | ||||
| max_tres_run_mins_pa | text | 65535 | N | '' | ||||
| max_tres_run_mins_pu | text | 65535 | N | '' | ||||
| min_tres_pj | text | 65535 | N | '' | ||||
| max_wall_duration_per_job | int(11) | 10 | 0 | Y | NULL | |||
| grp_jobs | int(11) | 10 | 0 | Y | NULL | |||
| grp_jobs_accrue | int(11) | 10 | 0 | Y | NULL | |||
| grp_submit_jobs | int(11) | 10 | 0 | Y | NULL | |||
| grp_tres | text | 65535 | N | '' | ||||
| grp_tres_mins | text | 65535 | N | '' | ||||
| grp_tres_run_mins | text | 65535 | N | '' | ||||
| grp_wall | int(11) | 10 | 0 | Y | NULL | |||
| preempt | text | 65535 | N | '' | ||||
| preempt_mode | int(11) | 10 | 0 | Y | 0 | |||
| preempt_exempt_time | int(10) unsigned | 10 | 0 | Y | NULL | |||
| priority | int(10) unsigned | 10 | 0 | Y | 0 | |||
| usage_factor | double | 22 | N | 1 | ||||
| usage_thres | double | 22 | Y | NULL | ||||
| limit_factor | double | 22 | Y | NULL | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id | ||||||
| udex | Unique | name(42) | ||||||
| 表名称:res_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | Y | 0 | |||
| id | int(11) | 10 | 0 | N | ||||
| name | tinytext | 255 | N | |||||
| description | text | 65535 | Y | NULL | ||||
| manager | tinytext | 255 | N | |||||
| server | tinytext | 255 | N | |||||
| count | int(10) unsigned | 10 | 0 | Y | 0 | |||
| type | int(10) unsigned | 10 | 0 | Y | 0 | |||
| flags | int(10) unsigned | 10 | 0 | Y | 0 | |||
| last_consumed | int(10) unsigned | 10 | 0 | Y | 0 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id | ||||||
| udex | Unique | name(42),server(42),type | ||||||
| 表名称:table_defs_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | int(10) unsigned | 10 | 0 | N | ||||
| mod_time | int(10) unsigned | 10 | 0 | N | 0 | |||
| table_name | text | 65535 | N | |||||
| definition | text | 65535 | N | |||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | table_name(50) | ||||||
| 表名称:tres_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| deleted | tinyint(4) | 3 | 0 | N | 0 | |||
| id | int(11) | 10 | 0 | N | ||||
| type | tinytext | 255 | N | |||||
| name | tinytext | 255 | N | '' | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id | ||||||
| udex | Unique | type(42),name(42) | ||||||
| 表名称:txn_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| id | int(11) | 10 | 0 | N | ||||
| timestamp | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| action | smallint(6) | 5 | 0 | N | ||||
| name | text | 65535 | N | |||||
| actor | tinytext | 255 | N | |||||
| cluster | tinytext | 255 | N | '' | ||||
| info | blob | 65535 | Y | NULL | ||||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | id | ||||||
| archive_purge | Normal | timestamp,cluster(42) | ||||||
| 表名称:user_table | 描述: | |||||||
| 字符集:latin1 | ||||||||
| 数据库:slurm@rm-f8zv4ubb75e971n5g | ||||||||
| 列名 | 类型 | 长度 | 精度 | 标度 | 是否为空 | 缺省值 | 描述 | 安全级别 |
| creation_time | bigint(20) unsigned | 20 | 0 | N | ||||
| mod_time | bigint(20) unsigned | 20 | 0 | N | 0 | |||
| deleted | tinyint(4) | 3 | 0 | Y | 0 | |||
| name | tinytext | 255 | N | |||||
| admin_level | smallint(6) | 5 | 0 | N | 1 | |||
| 索引名 | 类型 | 包含字段 | ||||||
| PRIMARY | Primary | name(42) | ||||||
Slurm记账数据库数据字典
最新推荐文章于 2025-12-04 15:25:15 发布
1784

被折叠的 条评论
为什么被折叠?



