Bat Cave: Database Details

The Job Table

+---------------+------------------+------+-----+---------------------+----------------+
| Field         | Type             | Null | Key | Default             | Extra          |
+---------------+------------------+------+-----+---------------------+----------------+
| jid           | int(10) unsigned |      | PRI | NULL                | auto_increment |
| user          | varchar(64)      | YES  | MUL | NULL                |                |
| host          | varchar(255)     | YES  | MUL | NULL                |                |
| port          | int(11)          | YES  |     | NULL                |                |
| djid          | int(11)          | YES  |     | NULL                |                |
| filename      | varchar(255)     | YES  | MUL | NULL                |                |
| title         | text             | YES  |     | NULL                |                |
| eta           | int(11)          | YES  |     | 0                   |                |
| priority      | float            |      | MUL | 0                   |                |
| state         | tinyint(2)       | YES  |     | 0                   |                |
| statetime     | timestamp        | YES  |     | CURRENT_TIMESTAMP   |                |
| spooltime     | timestamp        | YES  | MUL | 0000-00-00 00:00:00 |                |
| starttime     | timestamp        | YES  | MUL | 0000-00-00 00:00:00 |                |
| donetime      | timestamp        | YES  | MUL | 0000-00-00 00:00:00 |                |
| slottime      | timestamp        | YES  | MUL | 0000-00-00 00:00:00 |                |
| deletetime    | timestamp        | YES  | MUL | 0000-00-00 00:00:00 |                |
| numTasks      | int(11)          |      |     | 0                   |                |
| active        | int(11)          |      |     | 0                   |                |
| blocked       | int(11)          |      |     | 0                   |                |
| done          | int(11)          |      |     | 0                   |                |
| error         | int(11)          |      | MUL | 0                   |                |
| ready         | int(11)          |      |     | 0                   |                |
| other         | int(11)          | YES  |     | NULL                |                |
| jobgroup      | varchar(255)     | YES  |     | NULL                |                |
| spoolnotes    | varchar(255)     |      |     |                     |                |
| wranglernotes | blob             |      |     |                     |                |
| dispatchnotes | varchar(255)     |      |     |                     |                |
| taskmap       | blob             |      |     |                     |                |
+---------------+------------------+------+-----+---------------------+----------------+

The Task Table

+-----------+------------------+------+-----+---------------------+-------+
| Field     | Type             | Null | Key | Default             | Extra |
+-----------+------------------+------+-----+---------------------+-------+
| jid       | int(10) unsigned |      | PRI | 0                   |       |
| tid       | int(10) unsigned |      | PRI | 0                   |       |
| state     | tinyint(2)       | YES  | MUL | NULL                |       |
| title     | text             | YES  |     | NULL                |       |
| statetime | timestamp        | YES  | MUL | CURRENT_TIMESTAMP   |       |
| readytime | timestamp        | YES  | MUL | 0000-00-00 00:00:00 |       |
+-----------+------------------+------+-----+---------------------+-------+

The Slot Table

+------------+------------------+------+-----+---------------------+-------+
| Field      | Type             | Null | Key | Default             | Extra |
+------------+------------------+------+-----+---------------------+-------+
| name       | varchar(255)     |      | PRI |                     |       |
| hostname   | varchar(255)     | YES  | MUL | NULL                |       |
| schedstate | tinyint(2)       | YES  |     | 0                   |       |
| keylist    | varchar(255)     | YES  |     | NULL                |       |
| udi        | float            |      |     | 0                   |       |
| statetime  | timestamp        | YES  | MUL | CURRENT_TIMESTAMP   |       |
| starttime  | timestamp        | YES  | MUL | 0000-00-00 00:00:00 |       |
| lastmtd    | int(10) unsigned | YES  |     | NULL                |       |
| nimby      | varchar(128)     | YES  |     | NULL                |       |
| jid        | int(10) unsigned | YES  | MUL | NULL                |       |
| tid        | int(10) unsigned | YES  |     | NULL                |       |
| mtddebug   | varchar(255)     | YES  |     | NULL                |       |
| activity   | varchar(255)     | YES  |     |                     |       |
+------------+------------------+------+-----+---------------------+-------+

The Machine Table

+--------------+------------------+------+-----+---------------------+----------------+
| Field        | Type             | Null | Key | Default             | Extra          |
+--------------+------------------+------+-----+---------------------+----------------+
| machineid    | int(10) unsigned |      | PRI | NULL                | auto_increment |
| hostname     | varchar(255)     |      | UNI |                     |                |
| software     | varchar(128)     |      | MUL |                     |                |
| hardware     | varchar(128)     |      | MUL |                     |                |
| alfversion   | varchar(64)      |      |     |                     |                |
| alfstate     | tinyint(2)       | YES  |     | 0                   |                |
| statetime    | timestamp        | YES  | MUL | CURRENT_TIMESTAMP   |                |
| boottime     | timestamp        | YES  |     | 0000-00-00 00:00:00 |                |
| alfstarttime | timestamp        | YES  |     | 0000-00-00 00:00:00 |                |
| numslots     | tinyint(4)       |      |     | 0                   |                |
| slotsinuse   | tinyint(4)       |      |     | 0                   |                |
| numcpus      | tinyint(4)       |      |     | 0                   |                |
| benchmark    | float            |      |     | 0                   |                |
| loadavg      | float            |      | MUL | 0                   |                |
| availmemory  | bigint(20)       |      |     | 0                   |                |
| availdisk    | bigint(20)       |      |     | 0                   |                |
| notes        | blob             | YES  |     | NULL                |                |
+--------------+------------------+------+-----+---------------------+----------------+

The Maitred Table

+-----------+------------------+------+-----+---------------------+----------------+
| Field     | Type             | Null | Key | Default             | Extra          |
+-----------+------------------+------+-----+---------------------+----------------+
| mtdid     | int(10) unsigned |      | PRI | NULL                | auto_increment |
| host      | varchar(255)     |      | MUL |                     |                |
| port      | int(11)          |      |     | 0                   |                |
| grade     | int(5)           | YES  |     | 0                   |                |
| mversion  | varchar(255)     | YES  |     | NULL                |                |
| statetime | timestamp        | YES  | MUL | CURRENT_TIMESTAMP   |                |
| starttime | timestamp        | YES  | MUL | 0000-00-00 00:00:00 |                |
| exittime  | timestamp        | YES  |     | 0000-00-00 00:00:00 |                |
| state     | tinyint(2)       | YES  | MUL | NULL                |                |
| dcount    | int(6)           | YES  |     | 0                   |                |
+-----------+------------------+------+-----+---------------------+----------------+

The Dispatcher Table

+--------------+--------------+------+-----+---------------------+-------+
| Field        | Type         | Null | Key | Default             | Extra |
+--------------+--------------+------+-----+---------------------+-------+
| user         | varchar(64)  |      | PRI |                     |       |
| host         | varchar(255) |      | PRI |                     |       |
| sessionid    | varchar(32)  |      | MUL |                     |       |
| port         | int(11)      | YES  |     | NULL                |       |
| maitred_host | varchar(255) | YES  |     | NULL                |       |
| dversion     | varchar(255) | YES  |     | NULL                |       |
| statetime    | timestamp    | YES  | MUL | CURRENT_TIMESTAMP   |       |
| starttime    | timestamp    | YES  | MUL | 0000-00-00 00:00:00 |       |
| exittime     | timestamp    | YES  | MUL | 0000-00-00 00:00:00 |       |
| state        | tinyint(2)   |      | MUL | 0                   |       |
+--------------+--------------+------+-----+---------------------+-------+

The MetricDef Table

+-------------+----------------------------+------+-----+----------+----------------+
| Field       | Type                       | Null | Key | Default  | Extra          |
+-------------+----------------------------+------+-----+----------+----------------+
| metricid    | int(10) unsigned           |      | PRI | NULL     | auto_increment |
| mname       | varchar(64)                |      | UNI |          |                |
| mdescript   | mediumtext                 |      |     |          |                |
| mdefinition | mediumtext                 |      |     |          |                |
| minterval   | int(10)                    |      |     | 0        |                |
| mtype       | enum('mnumeric','mstring') |      |     | mnumeric |                |
+-------------+----------------------------+------+-----+----------+----------------+

The Limits Table

+---------+------------------+------+-----+---------+-------+
| Field   | Type             | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| user    | varchar(64)      |      | MUL |         |       |
| host    | varchar(255)     |      | MUL |         |       |
| mtdid   | int(10)          | YES  | MUL | NULL    |       |
| limitid | int(10) unsigned |      | MUL | 0       |       |
| lcount  | int(10) unsigned |      |     | 0       |       |
+---------+------------------+------+-----+---------+-------+

The LimitDef Table

+-----------+---------------------------------+------+-----+------------+----------------+
| Field     | Type                            | Null | Key | Default    | Extra          |
+-----------+---------------------------------+------+-----+------------+----------------+
| limitid   | int(10) unsigned                |      | PRI | NULL       | auto_increment |
| lname     | varchar(128)                    |      | UNI |            |                |
| maxlocal  | int(10)                         |      |     | -1         |                |
| maxglobal | int(10)                         |      |     | -1         |                |
| ltype     | enum('lpermanent','ltemporary') |      |     | ltemporary |                |
+-----------+---------------------------------+------+-----+------------+----------------+

The Metrics Table

+-----------+------------------+------+-----+-------------------+-------+
| Field     | Type             | Null | Key | Default           | Extra |
+-----------+------------------+------+-----+-------------------+-------+
| metricid  | int(10) unsigned |      | MUL | 0                 |       |
| machineid | int(10) unsigned |      | MUL | 0                 |       |
| mtime     | timestamp        | YES  | MUL | CURRENT_TIMESTAMP |       |
| mnumeric  | float            |      |     | 0                 |       |
| mstring   | mediumtext       |      |     |                   |       |
+-----------+------------------+------+-----+-------------------+-------+

The StateName Table

+----------+---------------------+------+-----+---------+-------+
| Field    | Type                | Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| statid   | tinyint(2) unsigned |      | PRI | 255     |       |
| stattext | varchar(12)         |      |     |         |       |
+----------+---------------------+------+-----+---------+-------+

The Cmd Table

+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| cmdid       | int(10) unsigned |      | PRI | NULL    | auto_increment |
| jid         | int(10) unsigned |      | MUL | 0       |                |
| tid         | int(10) unsigned |      | MUL | 0       |                |
| commandline | text             | YES  |     | NULL    |                |
| keylist     | text             | YES  |     | NULL    |                |
| taglist     | text             | YES  |     | NULL    |                |
| slots       | text             | YES  |     | NULL    |                |
| starttime   | timestamp        | YES  | MUL | NULL    |                |
| endtime     | timestamp        | YES  | MUL | NULL    |                |
| status      | int(10)          | YES  |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+

The Templates Table

+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| templateID      | int(11)      |      | PRI | NULL    | auto_increment |
| templateName    | varchar(64)  |      | UNI |         |                |
| templateCode    | mediumtext   |      |     |         |                |
| templateControl | varchar(255) |      |     |         |                |
+-----------------+--------------+------+-----+---------+----------------+

The Queries Table

+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| queryid          | int(10) unsigned |      | PRI | NULL    | auto_increment |
| query            | varchar(255)     |      | UNI |         |                |
| ldescript        | mediumtext       | YES  |     | NULL    |                |
| phpscript        | varchar(255)     |      |     |         |                |
| sql              | mediumtext       |      |     |         |                |
| whereclause      | mediumtext       |      |     |         |                |
| groupby          | varchar(255)     |      |     |         |                |
| orderby          | varchar(255)     | YES  |     | NULL    |                |
| header_template  | varchar(255)     |      |     |         |                |
| row_template     | varchar(255)     |      |     |         |                |
| footer_template  | varchar(255)     |      |     |         |                |
| control_template | varchar(255)     |      |     |         |                |
| visibility       | varchar(255)     |      |     | navbar  |                |
| rank             | int(10)          |      |     | 0       |                |
+------------------+------------------+------+-----+---------+----------------+