BWEC component database

All information about the EMC components will be stored in a mysql database on bwec-fileserver

The database can be accessed for entering, editing and visualising data through phpmyadim on the server (accessible from the emp.him network):

http://bwec-database/phpmyadmin/

username: himuser

password: the usual agmaas password

Documentation about the web interface can be found here:

https://docs.phpmyadmin.net/en/latest/index.html

And about mysql in general here:

https://dev.mysql.com/doc/refman/8.0/en/

An sql tutorial is here:

https://www.w3schools.com/sql/


Database structure

The foreseen structure for the database as presented at the 2019 Production Readiness Review meeting is the following.