Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database schema reorganization #4

Open
caparker opened this issue Oct 31, 2022 · 1 comment
Open

Database schema reorganization #4

caparker opened this issue Oct 31, 2022 · 1 comment
Labels
enhancement New feature or request

Comments

@caparker
Copy link
Collaborator

I propose a slight reorganization to the structure of the files in this project to facilitate more meta data about the database tables and views.

Right now we have

openaqdb
-- tables
-- -- countries.sql

Where the table definitions are organized by table name, one table per file. And

openaqdb
-- idempodent
-- -- views.sql 

Where all views are in one file

I propose a more verbose structure that would allow for README.md files that would contain schema details as well as information as to why the table/view exists.

For example

openaqdb (to not change too much)
-- tables
-- -- countries
-- -- -- README.md
-- -- -- countries.sql

Or something like that. We could also split up all the views and functions as well and have readme files for all of those.

@caparker caparker added the enhancement New feature or request label Oct 31, 2022
@russbiggs
Copy link
Member

I like this structure with individual readmes per view

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants