🗃️ context records, finds: new fields in database

Context record:
- excavator

Find:
- discovery method

2 files changed, 41 insertions, 1 deletions

diff --git a/archaeological_context_records/migrations/0120_excavator.py b/archaeological_context_records/migrations/0120_excavator.py
new file mode 100644
index 000000000..e5a88cd6f
--- /dev/null
+++ b/archaeological_context_records/migrations/0120_excavator.py
@@ -0,0 +1,35 @@
+# Generated by Django 2.2.24 on 2024-09-20 11:05
+
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('ishtar_common', '0249_town_notice'),
+        ('archaeological_context_records', '0119_default_typos'),
+    ]
+
+    operations = [
+        migrations.AddField(
+            model_name='contextrecord',
+            name='excavator',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='context_record_excavation', to='ishtar_common.Person', verbose_name='Excavator'),
+        ),
+        migrations.AddField(
+            model_name='historicalcontextrecord',
+            name='excavator',
+            field=models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='ishtar_common.Person', verbose_name='Excavator'),
+        ),
+        migrations.AlterField(
+            model_name='contextrecord',
+            name='surface',
+            field=models.FloatField(blank=True, null=True, verbose_name='Surface (m²)'),
+        ),
+        migrations.AlterField(
+            model_name='historicalcontextrecord',
+            name='surface',
+            field=models.FloatField(blank=True, null=True, verbose_name='Surface (m²)'),
+        ),
+    ]
diff --git a/archaeological_context_records/models.py b/archaeological_context_records/models.py
index a10c78552..c1a03e79e 100644
--- a/archaeological_context_records/models.py
+++ b/archaeological_context_records/models.py
@@ -42,6 +42,7 @@ from ishtar_common.utils import (
 
 from ishtar_common.models import (
     Document,
+    Person,
     GeneralType,
     BaseHistorizedItem,
     OwnPerms,
@@ -847,6 +848,10 @@ class ContextRecord(
     label = models.CharField(_("ID"), max_length=200)
     description = models.TextField(_("Description"), blank=True, default="")
     comment = models.TextField(_("General comment"), blank=True, default="")
+    excavator = models.ForeignKey(
+        Person, verbose_name=_("Excavator"), on_delete=models.SET_NULL,
+        blank=True, null=True, related_name="context_record_excavation"
+    )
     opening_date = models.DateField(_("Opening date"), blank=True, null=True)
     closing_date = models.DateField(_("Closing date"), blank=True, null=True)
     length = models.FloatField(_("Length (m)"), blank=True, null=True)
@@ -859,7 +864,7 @@ class ContextRecord(
     depth_of_appearance = models.FloatField(
         _("Depth of appearance (m)"), blank=True, null=True
     )
-    surface = models.FloatField(_("Surface (m2)"), blank=True, null=True)
+    surface = models.FloatField(_("Surface (m²)"), blank=True, null=True)
     location = models.TextField(
         _("Location"),
         blank=True,