Crossmatch Catalogues Database Scheme

Table Classes

There are 4 classes of tables in the crossmatch_catalogues database:

Table Type	Prefix	Notes	Example
Catalogue	tcs_cat	The table is named with the scheme tcs_cat_	tcs_cat_ned_d_v10_2_0
View	tcs_view	The view is named with the scheme tcs_view_	tcs_view_galaxies_ned_d
Helper	tcs_helper	Mostly used to store relational information, notes on database tables and book-keeper info	tcs_helper_catalogue_tables_info
Legacy	legacy_tcs_	Legacy tables used in previous incarnations of the transient classifier	legacy_tcs_cat_md01_chiappetti2005

Versioning

Each catalogue is versioned by appending a version indicator to the end of the table name. There are 3 indicator types:

1. _final to show that the catalogue is now at it's final version and shall remain unchanged.
2. _stream to show that the catalogue is constantly being updated
3. _vX_X to show a version number for the catalogue, e.g. for v10.2 this would be _v10_2. We can also have data-release versions (e.g. _dr12).