# Generated by Django 4.2.15 on 2025-12-23 10:14

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='tm_material_request_table',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('company_id', models.IntegerField(null=True)),
                ('po_date', models.DateField(null=True)),
                ('po_no', models.CharField(max_length=10)),
                ('time', models.TimeField(null=True)),
                ('num_series', models.CharField(max_length=10)),
                ('current_fy', models.IntegerField(null=True)),
                ('branch_id', models.IntegerField(null=True)),
                ('supply_branch_id', models.IntegerField(null=True)),
                ('total_quantity', models.IntegerField(null=True)),
                ('total_amount', models.FloatField(null=True)),
                ('sub_total', models.FloatField(null=True)),
                ('roundoff', models.FloatField(null=True)),
                ('po_status', models.CharField(max_length=10)),
                ('remarks', models.CharField(max_length=150)),
                ('is_active', models.IntegerField(default=1, null=True)),
                ('status', models.IntegerField(default=1, null=True)),
                ('created_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
                ('created_by', models.IntegerField(null=True)),
                ('updated_by', models.IntegerField(null=True)),
                ('employee_id', models.IntegerField(null=True)),
            ],
            options={
                'db_table': 'tm_material_po',
            },
        ),
        migrations.CreateModel(
            name='tx_material_request_table',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('company_id', models.IntegerField(null=True)),
                ('current_fy', models.IntegerField(null=True)),
                ('tm_po_id', models.IntegerField(null=True)),
                ('branch_id', models.IntegerField(null=True)),
                ('supply_branch_id', models.IntegerField(null=True)),
                ('item_id', models.IntegerField(null=True)),
                ('ean', models.CharField(max_length=50, null=True)),
                ('brand_id', models.IntegerField(default=0, null=True)),
                ('model_id', models.IntegerField(default=0, null=True)),
                ('variant_id', models.CharField(max_length=10, null=True)),
                ('color_id', models.IntegerField(default=0, null=True)),
                ('quantity', models.IntegerField(null=True)),
                ('rate', models.FloatField(null=True)),
                ('amount', models.FloatField(null=True)),
                ('remarks', models.CharField(max_length=150)),
                ('is_active', models.IntegerField(default=1, null=True)),
                ('status', models.IntegerField(default=1, null=True)),
                ('created_on', models.DateTimeField(null=True)),
                ('updated_on', models.DateTimeField(null=True)),
                ('created_by', models.IntegerField(null=True)),
                ('updated_by', models.IntegerField(null=True)),
            ],
            options={
                'db_table': 'tx_material_po',
            },
        ),
    ]