db: phenotypes: Add phenotype table mapping

1 files changed, 17 insertions, 0 deletions

diff --git a/gn3/db/phenotypes.py b/gn3/db/phenotypes.py
index 11d67db..645c0af 100644
--- a/gn3/db/phenotypes.py
+++ b/gn3/db/phenotypes.py
@@ -23,6 +23,23 @@ class Phenotype:
     authorized_users: Optional[str] = None
 
 
+# Mapping from the Phenotype dataclass to the actual column names in the
+# database
+phenotype_column_mapping = {
+    "id_": "id",
+    "pre_pub_description": "Pre_publication_description",
+    "post_pub_description": "Post_publication_description",
+    "original_description": "Original_description",
+    "units": "Units",
+    "pre_pub_abbrevition": "Pre_publication_abbreviation",
+    "post_pub_abbreviation": "Post_publication_abbreviation",
+    "lab_code": "Lab_code",
+    "submitter": "Submitter",
+    "owner": "Owner",
+    "authorized_users": "Authorized_Users",
+}
+
+
 @dataclass(frozen=True)
 class PublishXRef:
     """Data Type that represents the table PublishXRef"""