search

sdss / sdssdb

Central SDSS product for database management
https://sdssdb.readthedocs.io/en/latest/
BSD 3-Clause "New" or "Revised" License
7 stars 2 forks source link

Add database metadata for catalogdb schema tables #263

Open havok2063 opened 3 months ago

havok2063 commented 3 months ago

Add database metadata info for the tables in catalogdb. The metadata should go here, https://github.com/sdss/sdssdb/tree/main/schema/sdss5db/metadata and follow the syntax in https://github.com/sdss/sdssdb/blob/main/schema/sdss5db/metadata/vizdb.json.

I need metadata for at least catalogdb.sdss_id_to_catalog but it'd be nice to also have the metadata defined for all of the parent catalog tables.

albireox commented 3 months ago

There is a decent amount of column information with human-readable descriptions here

https://github.com/sdss/minidb_docs

It would need some parsing, and it doesn't cover all the catalogdb tables.