| GLOBALSEQNO |
Nick West
This table is not a standard DBI compliant one; there is no corresponding GLOBALSEQNOVLD table. This table is used to allocate global SEQNOs. SEQNOs must be global so that they won't conflict regardless of where they are created. Any database that contains a GLOBALSEQNO table is considered to be an authorising database and each such database is assigned a unique range within which to issue SEQNOs. We have authorising databases at FNAL and Soudan.
The table is by the DatabaseInterface package when writing new data.
The data in a GLOBALSEQNO is never exported and all modifications to it should go via the DatabaseInterface package. As a precaution that package confirms that a global SEQNO issued by that table is higher than any existing SEQNO in the assigned band.
Table not updated automatically or info not available.
The concept of Authorising Databases and Global Sequence Numbers is described in the Database Interface chapter of the User Manual
| Field | Type | Description |
|---|---|---|
| TABLENAME | char(64) | The name of the table for which SEQNOs are to be assigned. The special name * is used to prime new entries |
| LASTUSEDSEQNO | int(11) | The highest SEQNO allocated so far. |
| Detector | Responsible | Frequency | Method | |
|---|---|---|---|---|
| caldet | data | Every table updater | When any table is updated | via DBI (DbiWriter) |
| MC | Every table updater | When any table is updated | via DBI (DbiWriter) | |
| neardet | data | Every table updater | When any table is updated | via DBI (DbiWriter) |
| MC | Every table updater | When any table is updated | via DBI (DbiWriter) | |
| fardet | data | Every table updater | When any table is updated | via DBI (DbiWriter) |
| MC | Every table updater | When any table is updated | via DBI (DbiWriter) | |