PLM_demo/IT_service/migrations/0001_initial.py

# Generated by Django 4.0.5 on 2023-02-23 04:29

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('Info', '0009_rename_modular_modularenablement_modular_and_more'),
    ]

    operations = [
        migrations.CreateModel(
            name='Case',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('status', models.TextField(default='submit')),
                ('urgency_level', models.IntegerField()),
                ('create_datetime', models.DateTimeField(auto_now_add=True)),
                ('due_datetime', models.DateTimeField()),
                ('last_update_datetime', models.DateTimeField(auto_now=True)),
                ('comment', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Info.company')),
                ('owner', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='owner_of_case', to='Info.user')),
                ('submitter', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='submitter_of_case', to='Info.user')),
            ],
        ),
        migrations.CreateModel(
            name='Setting',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('default_urgency_level', models.IntegerField(default=3)),
                ('company', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='Info.company')),
                ('default_escalation', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='escalation_contact', to='Info.user')),
                ('default_owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='default_engineer', to='Info.user')),
            ],
        ),
        migrations.CreateModel(
            name='CaseAttachment',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('storage_type', models.TextField(default='local')),
                ('url', models.TextField()),
                ('display_name', models.TextField()),
                ('create_datetime', models.DateTimeField(auto_now_add=True)),
                ('last_update_datetime', models.DateTimeField(auto_now=True)),
                ('company', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='Info.company')),
                ('creator', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Info.user')),
                ('part', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='IT_service.case')),
            ],
        ),
    ]