Columns in "Crate"
| Field | Type | Null | Key | Default | Extra |
|---|
| Obj_id | int(11) | NO | PRI | | auto_increment |
| FileId | int(11) | YES | | | |
| OID | varchar(255) | YES | | | |
| Name | text | YES | | | |
| Type | text | YES | | | |
| Location | text | YES | | | |
| Description | text | YES | | | |
| HelpLink | text | YES | | | |
| InstallationRef | text | YES | | | |
| State | varchar(10) | YES | | | |
| NumberOfSlots | int(10) unsigned | YES | | | |
| Position | int(10) unsigned | YES | | | |
| LogicalId | int(10) unsigned | YES | | | |
| NumberOfModules | int(10) unsigned | YES | | | |
| NumberOfEvents | int(10) unsigned | YES | | | |
| Modules | text | YES | | | |
| BelongsTo | text | YES | | | |
| MROC | text | YES | | | |
| MCC | text | YES | | | |
| MTI | text | YES | | | |
| PPCModule | text | YES | | | |
| ETC | text | YES | | | |
| EFO | text | YES | | | |
| TFEE | text | YES | | | |
| TMON | text | YES | | | |
| TROC | text | YES | | | |
| TCLK | text | YES | | | |
| MUONROMO | text | YES | | | |
| MUONROC | text | YES | | | |
| FCTL | text | YES | | | |
| Trg_SAF | text | YES | | | |
| Trg_GTL | text | YES | | | |
| Trg_TDC | text | YES | | | |
| Trg_TROC | text | YES | | | |
| Trg_LTKC | text | YES | | | |
| Trg_STKC | text | YES | | | |
| Trg_TKF | text | YES | | | |
| Trg_TKFGeneral | text | YES | | | |
| Trg_EACC | text | YES | | | |
| Trg_EACC_Debug | text | YES | | | |
| Trg_TCBA | text | YES | | | |
| Trg_TOFT | text | YES | | | |
| Trg_CLKF | text | YES | | | |
| Trg_FCTL | text | YES | | | |
| Trg_TFCF | text | YES | | | |
| Trg_MUTL | text | YES | | | |
| Trg_MUDT | text | YES | | | |
| EMCMonitor | text | NO | | | |
| Trg_BASG | text | NO | | | |
Know more about the database in Database dictionary!