===== accounting =====

  * hard core-h limits
  * different QOS depending on project status
  * show create table for vsc3_accounting


----

==== job stats daily ====

  * derived from slurmdb
  * special treatment of reservations

<code>
  Column   |            Type             | 
-----------+-----------------------------+
 project   | text                        | 
 username  | text                        | 
 day       | timestamp without time zone | 
 usage     | numeric                     | 
 partition | text                        | 
 qos       | text                        | 
 licenses  | text                        | 
</code>

----

==== hardware availability ====

  * updated daily with sinfo/django
  * qos or partition

<code>
    Column     |  Type   |
---------------+---------+
 id            | integer |
 date          | date    |
 cpus          | integer | 
 entitytype_id | integer | 

</code>

----

==== cluster utilization ====

  * updateted daily with stats from sreport
  * license or gres

<code>
    Column     |  Type   |
---------------+---------+
 id            | integer |
 date          | date    |
 trescount     | bigint  |
 allocated     | bigint  |
 down          | bigint  |
 idle          | bigint  |
 overcommited  | bigint  |
 planneddown   | bigint  |
 reserved      | bigint  |
 reported      | bigint  |
 entitytype_id | integer |
</code>