# Generated by Django 5.2.6 on 2025-09-30 03:22 import django.core.validators import django.db.models.deletion from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='Aerodrome', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('icao', models.CharField(max_length=4, unique=True)), ('iata', models.CharField(blank=True, max_length=3, null=True, unique=True)), ('name', models.CharField(max_length=100)), ('city', models.CharField(max_length=100)), ('country', models.CharField(max_length=3)), ('latitude', models.FloatField()), ('longitude', models.FloatField()), ], ), migrations.CreateModel( name='AircraftBase', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=20)), ('manufacturer', models.CharField(max_length=50)), ('range_nm', models.IntegerField()), ('capacity', models.IntegerField()), ('cruise_speed_kt', models.IntegerField()), ], ), migrations.CreateModel( name='Carrier', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('icao', models.CharField(max_length=3, unique=True)), ('iata', models.CharField(max_length=2, unique=True)), ('name', models.CharField(max_length=100, unique=True)), ('country', models.CharField(max_length=3)), ], ), migrations.CreateModel( name='Equipment', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('registration', models.CharField(max_length=10, unique=True)), ('model', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='aircraft', to='simulator.aircraftbase')), ('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='fleet', to='simulator.carrier')), ], ), migrations.CreateModel( name='Flight', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('flight_number', models.PositiveIntegerField(validators=[django.core.validators.MinValueValidator(1), django.core.validators.MaxValueValidator(9999)])), ('departure_time', models.DateTimeField()), ('carrier', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='flights', to='simulator.carrier')), ('destination', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='arrivals', to='simulator.aerodrome')), ('equipment', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='flights', to='simulator.equipment')), ('origin', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='departures', to='simulator.aerodrome')), ], options={ 'constraints': [models.UniqueConstraint(fields=('carrier', 'flight_number'), name='unique_flight_per_carrier')], }, ), ]