[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/migrations/0002_ontologyproperties.py

+# Generated by Django 4.1 on 2023-02-20 16:52
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+    dependencies = [
+        ("chebi_models", "0001_initial"),
+    ]
+
+    operations = [
+        migrations.CreateModel(
+            name="OntologyProperties",
+            fields=[
+                ("id", models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name="ID")),
+                ("curie", models.CharField(max_length=60, unique=True)),
+                ("property_type", models.CharField(default="owl:Class", max_length=40)),
+                ("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)),
+                ("created_on", models.DateTimeField(auto_now_add=True, null=True)),
+                ("created_by", models.CharField(max_length=256, null=True)),
+                ("modified_on", models.DateTimeField(auto_now=True, null=True)),
+                ("modified_by", models.CharField(max_length=256, null=True)),
+                ("deleted_on", models.DateTimeField(auto_now=True, null=True)),
+                ("deleted_by", models.CharField(max_length=256, null=True)),
+            ],
+            options={
+                "db_table": "ontology_properties",
+            },
+        ),
+    ]