search

Big-Life-Lab / PHES-ODM

The Public Health Environmental Surveillance Open Data Model (PHES-ODM, or ODM). A data model, dictionary and support tools for environmental surveillance.
Creative Commons Attribution Share Alike 4.0 International
54 stars 18 forks source link

Added variable short formal names, removed french, added max/min length #183

Closed mathew-thomson closed 3 years ago

mathew-thomson commented 3 years ago

Added short formal names that include the short formal table names using the format "tableShortFormalName_variableShortFormalName" - perhaps considered a uniqueID?

variableShortFormalName varies from two to four characters. I don't think it's fully necessary for there to be a set character number, but if I'm mistaken I can revise. The general structure is to use the first two letters for sing word variable names, or up to four first letters from multi-word variable names. Rules were sometimes slightly bent to avoid duplication.

Removed the french language information in preparation for multi-language functionality.

Added columns for max and min value length, taken from validation/validate.csv in the validation branch. This validation file can likely be deleted now. I will go through and populate max and min values for length now by hand.

DougManuel commented 3 years ago

This PR addresses issue https://github.com/Big-Life-Lab/ODM/issues/181.

mathew-thomson commented 3 years ago

Updated the short formal name columns to uid and finished populating the max and min value fields - will work on putting up a breakdown of the naming methodology asap.