1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
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',),
},
),
]
|
