...
- MCCQA IRMISDB schema: Production for all gui’s and applications. Contains data populated nightly by perl crawler scripts from production IOC configuration files. Data validation is done following each load.
- MCCO IRMISDB schema: contains production data, currently for 3 tables only: bsa_root_names, devices_and_attributes, curr_pvs. MCCQA data is copied to MCCO once it has been validated. So MCCO is as close as possible to pristine data at all times.
- SLACDEV contains the 3 schemas which are used for developing, testing and staging new features before release to production on MCCQA (see accounts below)
- IRMISDB – sandbox for all kinds of development, data sifting, etc. Not refreshed from prod, or not very often.
- IRMISDB_TEST – testing for application implementation. Refreshed from prod at the start of a development project.
- IRMISDB_STAGE – staging for testing completed applications against recently-refreshed production data.
- SLACPROD IRMISDB schema: this is obsolete, but will be kept around for awhile (6 months?) as a starting point in case the DB migration goes awry somehow.
...