Ticket 8087

Summary: Info on Slurm acct'g database
Product: Slurm Reporter: Will Dennis <wdennis>
Component: DatabaseAssignee: Director of Support <support>
Status: RESOLVED INFOGIVEN QA Contact:
Severity: 4 - Minor Issue    
Priority: ---    
Version: - Unsupported Older Versions   
Hardware: Linux   
OS: Linux   
Site: NEC Labs Slinky Site: ---
Alineos Sites: --- Atos/Eviden Sites: ---
Confidential Site: --- Coreweave sites: ---
Cray Sites: --- DS9 clusters: ---
Google sites: --- HPCnow Sites: ---
HPE Sites: --- IBM Sites: ---
NOAA SIte: --- NoveTech Sites: ---
Nvidia HWinf-CS Sites: --- OCF Sites: ---
Recursion Pharma Sites: --- SFW Sites: ---
SNIC sites: --- Tzag Elita Sites: ---
Linux Distro: Ubuntu Machine Name:
CLE Version: Version Fixed:
Target Release: --- DevPrio: ---
Emory-Cloud Sites: ---

Description Will Dennis 2019-11-11 12:02:28 MST 
I am looking to get a couple of answers on the schema of the Slurm accounting database answered; I have searched the Slurm documentation for a database schema diagram to no avail, and also found nothing in Bugzilla. I am wanting to put together a report off the accounting db, and would find a table relationship diagram helpful, and also need to understand the format of date columns in the database (I see it's an unsigned 10-char INT field, but how to convert that to an external date format?) Thanks.
Comment 1 Will Dennis 2019-11-11 12:04:32 MST 
SLURM_VERSION = 16.05.4
Comment 2 Douglas Wightman 2019-11-11 14:47:41 MST 
Unfortunately there are no diagrams of the database available to download, though they can be generated using tools like mysql workbench:

https://database.guide/how-to-reverse-engineer-a-database-in-mysql-workbench/

Slurm stores dates in unix time format:

https://en.wikipedia.org/wiki/Unix_time
Comment 3 Douglas Wightman 2019-11-13 09:34:18 MST 
Information provided. Closing ticket.