summaryrefslogtreecommitdiffstats
path: root/engagements/migrations/0001_initial.py
diff options
context:
space:
mode:
Diffstat (limited to 'engagements/migrations/0001_initial.py')
-rw-r--r--engagements/migrations/0001_initial.py134
1 files changed, 134 insertions, 0 deletions
diff --git a/engagements/migrations/0001_initial.py b/engagements/migrations/0001_initial.py
new file mode 100644
index 0000000..2516517
--- /dev/null
+++ b/engagements/migrations/0001_initial.py
@@ -0,0 +1,134 @@
+# Generated by Django 4.0.8 on 2022-11-02 09:00
+
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+ initial = True
+
+ dependencies = [
+ ]
+
+ operations = [
+ migrations.CreateModel(
+ name='Engagement',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('date_created', models.DateTimeField(auto_now_add=True)),
+ ('last_modified', models.DateTimeField(auto_now=True)),
+ ('proposed_start_date', models.DateField()),
+ ('proposed_end_date', models.DateField(blank=True, null=True)),
+ ],
+ options={
+ 'ordering': ('proposed_start_date',),
+ },
+ ),
+ migrations.CreateModel(
+ name='EngagementType',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('date_created', models.DateTimeField(auto_now_add=True)),
+ ('last_modified', models.DateTimeField(auto_now=True)),
+ ('name', models.CharField(max_length=56)),
+ ('description', models.TextField(blank=True, null=True)),
+ ],
+ options={
+ 'verbose_name_plural': 'Engagement Types',
+ },
+ ),
+ migrations.CreateModel(
+ name='Organisation',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('date_created', models.DateTimeField(auto_now_add=True)),
+ ('last_modified', models.DateTimeField(auto_now=True)),
+ ('name', models.CharField(max_length=128)),
+ ('slug', models.SlugField(blank=True, max_length=128)),
+ ('is_regulated_entity', models.BooleanField(default=False)),
+ ],
+ options={
+ 'verbose_name_plural': 'Organisations',
+ },
+ ),
+ migrations.CreateModel(
+ name='RegulatedEntityType',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('date_created', models.DateTimeField(auto_now_add=True)),
+ ('last_modified', models.DateTimeField(auto_now=True)),
+ ('name', models.CharField(max_length=128)),
+ ],
+ options={
+ 'verbose_name_plural': 'Regulated Entity Types',
+ },
+ ),
+ migrations.CreateModel(
+ name='RegulatoryRole',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('date_created', models.DateTimeField(auto_now_add=True)),
+ ('last_modified', models.DateTimeField(auto_now=True)),
+ ('name', models.CharField(max_length=64)),
+ ('description', models.TextField(max_length=1024)),
+ ],
+ options={
+ 'verbose_name_plural': 'Regulatory Roles',
+ },
+ ),
+ migrations.CreateModel(
+ name='Person',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('date_created', models.DateTimeField(auto_now_add=True)),
+ ('last_modified', models.DateTimeField(auto_now=True)),
+ ('first_name', models.CharField(max_length=64)),
+ ('last_name', models.CharField(max_length=64)),
+ ('email', models.EmailField(blank=True, max_length=254, null=True)),
+ ('mobile', models.CharField(blank=True, max_length=64, null=True)),
+ ('organisation', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='engagements.organisation')),
+ ('regulatory_role', models.ManyToManyField(to='engagements.regulatoryrole')),
+ ],
+ options={
+ 'verbose_name_plural': 'People',
+ },
+ ),
+ migrations.AddField(
+ model_name='organisation',
+ name='ap',
+ field=models.ManyToManyField(blank=True, related_name='accountable_person', to='engagements.person', verbose_name='Accountable Person'),
+ ),
+ migrations.AddField(
+ model_name='organisation',
+ name='entitytype',
+ field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='engagements.regulatedentitytype'),
+ ),
+ migrations.AddField(
+ model_name='organisation',
+ name='ih',
+ field=models.ManyToManyField(blank=True, related_name='information_holder', to='engagements.person', verbose_name='Information Holder'),
+ ),
+ migrations.AddField(
+ model_name='organisation',
+ name='rp',
+ field=models.ManyToManyField(blank=True, related_name='responsible_person', to='engagements.person', verbose_name='Responsible Person'),
+ ),
+ migrations.CreateModel(
+ name='EngagementEffort',
+ fields=[
+ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('date_created', models.DateTimeField(auto_now_add=True)),
+ ('last_modified', models.DateTimeField(auto_now=True)),
+ ('is_planned', models.BooleanField(blank=True, default=True, null=True, verbose_name='Planned')),
+ ('effort_type', models.CharField(choices=[('TRAVEL', 'Travel'), ('PLANNING', 'Planning'), ('REGULATION', 'Regulation (On-site or Remote)'), ('DISCUSSION', 'Discussion'), ('REPORT', 'Reporting')], max_length=32, verbose_name='Effort Type')),
+ ('proposed_start_date', models.DateTimeField()),
+ ('proposed_end_date', models.DateTimeField()),
+ ('engagement', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='effort', to='engagements.engagement')),
+ ],
+ options={
+ 'verbose_name_plural': 'Engagement Effort',
+ 'ordering': ('proposed_start_date',),
+ },
+ ),
+ ]