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
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
|
# Generated by Django 2.2.12 on 2020-08-27 09:40
import django.contrib.auth
from django.db import migrations, models
import django.db.models.deletion
import django_extensions.db.fields
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='AddressType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('descriptor', models.CharField(max_length=50)),
],
),
migrations.CreateModel(
name='Mode',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('descriptor', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Organisation',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255)),
('slug', django_extensions.db.fields.AutoSlugField(blank=True, editable=False, populate_from=['name'])),
('oes', models.BooleanField(default=True)),
('designation_type', models.IntegerField(choices=[(1, 'Automatic'), (2, 'Reserve Power'), (3, 'NA')], default=1)),
('registered_company_name', models.CharField(blank=True, max_length=255)),
('registered_company_number', models.CharField(blank=True, max_length=100)),
('date_updated', models.DateField(auto_now=True)),
('comments', models.TextField(blank=True, max_length=500, null=True)),
('active', models.BooleanField(default=True)),
],
),
migrations.CreateModel(
name='Person',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('primary_nis_contact', models.BooleanField(default=False, verbose_name='Primary NIS contact')),
('voluntary_point_of_contact', models.BooleanField(default=False)),
('has_egress', models.BooleanField(default=False, verbose_name='Has Egress')),
('title', models.IntegerField(choices=[(1, 'Mr'), (2, 'Mrs'), (3, 'Miss'), (4, 'Ms'), (5, 'Dr.'), (6, 'Professor'), (7, 'The Rt Hon.'), (8, 'Lord'), (9, 'Lady')], default=1)),
('job_title', models.CharField(max_length=100)),
('first_name', models.CharField(max_length=50)),
('last_name', models.CharField(max_length=50)),
('email', models.EmailField(max_length=254)),
('secondary_email', models.EmailField(blank=True, max_length=254)),
('mobile', models.CharField(blank=True, max_length=20)),
('landline', models.CharField(blank=True, max_length=20)),
('date_updated', models.DateField(auto_now=True)),
('clearance', models.IntegerField(choices=[(1, 'NA'), (2, 'BPSS'), (3, 'CTC'), (4, 'SC'), (5, 'DV'), (6, 'Other')], default=1)),
('clearance_sponsor', models.CharField(blank=True, max_length=100)),
('clearance_start_date', models.DateField(blank=True, null=True)),
('clearance_last_checked', models.DateField(blank=True, null=True)),
('clearance_expiry', models.DateField(blank=True, null=True)),
('active', models.BooleanField(default=True)),
('date_ended', models.DateField(blank=True, null=True)),
('comments', models.TextField(blank=True, max_length=1000)),
('organisation', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='organisations.Organisation')),
('predecessor', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='previous_person', to='organisations.Person')),
],
options={
'verbose_name_plural': 'People',
},
),
migrations.CreateModel(
name='Role',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Submode',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('descriptor', models.CharField(max_length=100)),
('mode', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='organisations.Mode')),
],
),
migrations.CreateModel(
name='Stakeholder',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('person', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='organisations.Person')),
],
),
migrations.AddField(
model_name='person',
name='role',
field=models.ManyToManyField(to='organisations.Role'),
),
migrations.AddField(
model_name='organisation',
name='submode',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='organisations.Submode'),
),
migrations.CreateModel(
name='IncidentReport',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('person_involved', models.CharField(blank=True, max_length=100, verbose_name='Name of person reporting/detecting incident')),
('role', models.CharField(blank=True, help_text='Role of person reporting/detecting incident', max_length=100)),
('phone_number', models.CharField(max_length=30)),
('email', models.EmailField(max_length=254)),
('internal_incident_number', models.CharField(blank=True, max_length=30)),
('date_time_incident_detected', models.DateTimeField(verbose_name='Date/Time incident detected')),
('date_time_incident_reported', models.DateTimeField(auto_now=True, verbose_name='Date/Time incident reported')),
('incident_type', models.CharField(choices=[('Cyber', 'Cyber'), ('Non-Cyber', 'Non-Cyber'), ('Both', 'Both'), ('Power Outage', 'Power Outage')], help_text='This can be appoximate', max_length=20)),
('incident_status', models.CharField(choices=[('Detected', 'Detected'), ('Suspected', 'Suspected'), ('Resolved', 'Resolved')], max_length=20)),
('incident_stage', models.CharField(choices=[('Ongoing', 'Ongoing'), ('Ended', 'Ended'), ('Ongoing but managed', 'Ongoing but managed')], max_length=20)),
('summary', models.TextField(help_text='Please provide a summary of your understanding of the incident, including any impact to services and/or users.')),
('mitigations', models.TextField(help_text='What investigations and/or mitigations have you or a third party performed or plan to perform?', verbose_name='Investigations or mitigations')),
('others_informed', models.TextField(help_text='Who else has been informed about this incident?(CSIRT, NCSC, NCA, etc)', verbose_name='Others parties informed')),
('next_steps', models.TextField(help_text='What are your planned next steps?', verbose_name='Planned next steps')),
('dft_handle_status', models.CharField(choices=[('QUEUED', 'QUEUED'), ('REVIEWING', 'REVIEWING'), ('WAITING', 'WAITING'), ('COMPLETED', 'COMPLETED')], default='QUEUED', max_length=20)),
('organisation', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='organisations.Organisation')),
('reporting_person', models.ForeignKey(on_delete=models.SET(django.contrib.auth.get_user_model), to='organisations.Person', verbose_name='Person reporting the incident')),
],
),
migrations.CreateModel(
name='Address',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('line1', models.CharField(max_length=255)),
('line2', models.CharField(blank=True, max_length=255)),
('line3', models.CharField(blank=True, max_length=255)),
('city', models.CharField(max_length=100)),
('county', models.CharField(blank=True, max_length=100)),
('postcode', models.CharField(max_length=10)),
('country', models.CharField(max_length=100)),
('other_details', models.CharField(blank=True, max_length=255)),
('organisation', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='addresses', to='organisations.Organisation')),
('type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='organisations.AddressType', verbose_name='Address Type')),
],
options={
'verbose_name_plural': 'Addresses',
},
),
]
|
