# Generated by Django 6.0.1 on 2026-02-18 19:41

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Tags',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=31, unique=True)),
                ('desc', models.TextField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Company',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=63)),
                ('unq_entity_id', models.CharField(blank=True, max_length=63, null=True)),
                ('website', models.URLField(blank=True, max_length=127, null=True)),
                ('short_desc', models.CharField(blank=True, max_length=63, null=True)),
                ('long_desc', models.TextField(blank=True, null=True)),
                ('gmap_link', models.CharField(blank=True, max_length=253, null=True)),
                ('address_complete', models.CharField(blank=True, max_length=127, null=True)),
                ('address_numbers', models.CharField(blank=True, max_length=63, null=True)),
                ('address_type', models.CharField(blank=True, max_length=31, null=True)),
                ('city', models.CharField(blank=True, max_length=127, null=True)),
                ('state', models.CharField(blank=True, max_length=127, null=True)),
                ('zip_code', models.CharField(blank=True, max_length=15, null=True)),
                ('tags', models.ManyToManyField(blank=True, to='contracts.tags')),
            ],
            options={
                'verbose_name_plural': 'Companies',
                'ordering': ['name'],
                'unique_together': {('name', 'website')},
            },
        ),
        migrations.CreateModel(
            name='Contract',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=31, unique=True)),
                ('notice_id', models.CharField(blank=True, max_length=31, null=True)),
                ('related_notice_id', models.CharField(blank=True, max_length=31, null=True)),
                ('opp_type', models.CharField(blank=True, max_length=63, null=True)),
                ('pub_date', models.DateField(blank=True, null=True)),
                ('us_dept', models.CharField(blank=True, max_length=31, null=True)),
                ('us_dept_sub_tier', models.CharField(blank=True, max_length=31, null=True)),
                ('major_dept', models.CharField(blank=True, max_length=31, null=True)),
                ('us_office', models.CharField(blank=True, max_length=31, null=True)),
                ('award_date', models.CharField(blank=True, max_length=31, null=True)),
                ('award_num', models.CharField(blank=True, max_length=31, null=True)),
                ('unq_entity_id', models.CharField(blank=True, max_length=31, null=True)),
                ('awarded_name', models.CharField(blank=True, max_length=31, null=True)),
                ('awarded_addr', models.CharField(blank=True, max_length=31, null=True)),
                ('contract_value', models.CharField(blank=True, max_length=31, null=True)),
                ('orig_set_aside', models.CharField(blank=True, max_length=127, null=True)),
                ('prod_svc_code', models.CharField(blank=True, max_length=127, null=True)),
                ('naics_code', models.CharField(blank=True, max_length=127, null=True)),
                ('contract_url', models.CharField(blank=True, max_length=127, null=True)),
                ('description', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='contracts.company')),
            ],
            options={
                'verbose_name_plural': 'Contracts',
                'ordering': ['pub_date', 'notice_id'],
                'unique_together': {('notice_id', 'unq_entity_id')},
            },
        ),
        migrations.CreateModel(
            name='Exec',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=63)),
                ('linkedin', models.URLField(blank=True, max_length=127, null=True)),
                ('short_desc', models.CharField(blank=True, max_length=63, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='contracts.company')),
                ('tags', models.ManyToManyField(blank=True, to='contracts.tags')),
            ],
            options={
                'verbose_name_plural': 'Execs',
                'ordering': ['name'],
                'unique_together': {('name', 'company')},
            },
        ),
    ]