Data documentation
All data included into the databases has be documented!
Naming of data
Database Name
The name of the database is *oedb*
Database Schema
The structure of the database is realised via the naming of the schema!
- always lower case; no points; no spaces; no dates -> use underscores; ...
# name starts with type of schema (*orig* for original data; *calc* for calculations; ???)
Database Table
- always lower case; no points; no spaces; no dates -> use underscores; ...
# name starts with the source (e.g. _zensus_)
# main value (e.g. _population_)
# if separated by [attribute] (e.g. _by_gender_)
# with resolution [tupel] (e.g. _per_mun_)
-> *_zensus_population_by_gender_per_mun_*
- All abreviations have to be documentated (in the Glossary or Wiki)!