TGCSpareList

TGC Database

Place



tgc_database_place

Information of the database

  • The database, "tgc_sparemodule_db", is on dbod-atlastgc.cern.ch
  • The database contains 6 tables, "ps_board", "HPT_board", "SSW", "cable", "fan", and "other_module".

Description of table, "ps_board", "HPT_board", "SSW", and "cable".

Field Type Null Key Default Extra
id int(11) YES MUL NULL  
name varchar(20) YES   NULL  
model_number varchar(200) YES   NULL  
serial_number varchar(200) YES   NULL  
barcode_number varchar(200) YES   NULL  
place enum('locker_1','locker_2','locker_3','locker_4','locker_5','locker_6','locker_7','locker_8','locker_9','locker_10') YES   NULL  
memo varchar(2000) YES   NULL  
confirmation_date date YES   NULL  

Description of table, "fan".

Field Type Null Key Default Extra
id int(11) YES MUL NULL  
name varchar(20) YES   NULL  
model_number varchar(200) YES   NULL  
serial_number varchar(200) YES   NULL  
memo varchar(200) YES   NULL  
confirmation_date date YES   NULL  

Description of table, "other_module".

Field Type Null Key Default Extra
id int(11) YES MUL NULL  
name varchar(20) YES   NULL  
model_number varchar(200) YES   NULL  
serial_number varchar(200) YES   NULL  
barcode_number varchar(200) YES   NULL  
place varchar(200) YES   NULL  
memo varchar(2000) YES   NULL  
confirmation_date date YES   NULL  

How to access the database

  1. login to lxplus
  2. $ mysql -h dbod-atlastgc.cern.ch -P 5515 -u sparemod_user -p (password: sparemodule_user)
  3. mysql> SHOW DATABASES;
    • Please check whether database "tgc_sparemod_db" exists.
  4. mysql> USE tgc_sparemod_db
  5. mysql> SHOW TABLES;
  6. mysql> SELECT * FROM ps_board; (to see contents of ps_board)

How to edit the database

  1. login to lxplus
  2. $ mysql -h dbod-atlastgc.cern.ch -P 5515 -u sparemod_admin -p (password: sparemodule)
  3. mysql> SHOW DATABASES;
    • Please check whether database "tgc_sparemod_db" exists.
  4. mysql> USE tgc_sparemod_db
  5. mysql> SHOW TABLES;
  6. For example, UPDATE SSW SET memo = "/N" WHERE id = 31;

spare list (spreadsheets)

Spare list

CERN Technical Database

CERN Database

-- ShogoKido - 2017-06-09

Topic attachments
I Attachment History Action Size Date Who Comment
PNGpng tgc_database_place.png r1 manage 89.2 K 2017-08-22 - 13:44 ShogoKido  
Edit | Attach | Watch | Print version | History: r6 < r5 < r4 < r3 < r2 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r6 - 2017-08-22 - ShogoKido
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Sandbox All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback