[carlosm] new table ontology_properties created

Resolves #11 (closed)

Describe the change in few words here

• This change has security impacts (if so, add them to the description)
• Bug fix (non-breaking change which fixes an issue)
• New feature (non-breaking change which adds functionality)
• Breaking change (fix or feature that would cause existing functionality to not work as expected)
• This change requires a documentation update

Checklist:

• I have performed a self-review of my own code
• I have commented my code, particularly in hard-to-understand areas
• I have made corresponding changes to the documentation (README, Confluence etc.)
• My changes generate no new warnings in the build
• I have added tests that prove my fix is effective or that my feature works
• My code does not decrease pylint score

Dependencies

• This Merge Request is dependent on any other Merge Request or configuration or some ticket; please mention here
• Includes migration
• Installs new requirement

Post Review

• Squash and merge feature_branch to staging
• Delete branch after merge

Additional Description

This PR includes a new table called ontology_properties to store all the information related to the ontology predicates (subject -> predicate -> object). This information is used to build the chebi.owl file and all its variants. Perhaps, later on we can replace the table relation_type by this one.

chebi_models/models/compound.py

@@ -218,3 +218,20 @@ class Wurcs(BaseModel):
 
     class Meta:
         db_table = "wurcs"
+
+class OntologyProperties(BaseModel):
+    curie = models.CharField(max_length=60, unique=True)
+    property_type = models.CharField(max_length=40, default='owl:Class')
+    characteristic = models.CharField(max_length=30, null=True)
+    label = models.CharField(max_length=60, null=True)
+    sub_property = models.CharField(max_length=60, null=True)
+    inverse_of = models.CharField(max_length=40, null=True)
+    comment = models.TextField(null=True)
+    xref = models.CharField(max_length=60, null=True)
+    namespace = models.CharField(max_length=40, null=True)
+    object_property = models.CharField(max_length=60, null=True)
+    is_cyclic = models.BooleanField(null=True)
+    is_transitive = models.BooleanField(null=True)
+
+    class Meta:
+        db_table = 'ontology_properties'
\ No newline at end of file