Description
Goal | Users would be able to look up an LDP1 or Metadb table in a list to get a basic description of what the table contains and where it comes from. |
Ideas | - Maybe include a list of fields but not descriptions of those fields? Or should it also have field descriptions?
- Also from Tod, after another SIG discussion: This morning in the Reporting SIG we talked briefly about ways to document the derived tables. I'd mentioned maybe there's a way to create the documentation in the SQL and then generate something legible and easy to reference. In looking for pre-existing solutions, a couple searches that I found useful were "how to document tables in sql comments" and "sphinx sql documentation". This at least seems to be a problem that others have wrestled with, so we may be able to lean on or draw inspiration from prior work.
- (Also look for notes in SIG meetings from August/September)
- Also, how the tables connect to other tables? maybe a small ER diagram with foreign key relationships?
|
Difference between extracted and derived tables.
Extracted tables | Tables that LDP1/Metadb creates. |
Derived tables | Tables created by the community and located in the folio-analytics repository. |
Meeting notes
Google Drive: FOLIO\Reporting_SIG\Documentation Subteam\Project Build a directory of extracted and derived tables
https://drive.google.com/drive/folders/1N829RPhjqr_zN2i9g_XBYH9dBR6lOU1M
Meetings do not take place regularly. Appointments are made ad hoc.
Repository
https://github.com/stdombek/folio_reporting_project_extracted_derived_tables
Members
| Mainz University |
| Leipzig University |