# -*- coding: utf-8 -*-
# Generated by Django 1.11.2 on 2018-09-02 17:06
from __future__ import unicode_literals

import NA_DataLayer.MasterData.NA_Privilege_BR
import NA_DataLayer.file_storage
import NA_Models.models
from django.conf import settings
from django.db import migrations, models
import django.db.models.deletion
import django.utils.timezone
import django_mysql.models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0008_alter_user_username_max_length'),
    ]

    operations = [
        migrations.CreateModel(
            name='Employee',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('inactive', models.BooleanField(db_column='InActive', default=False)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('nik', models.CharField(db_column='NIK', max_length=50, unique=True)),
                ('employee_name', models.CharField(blank=True, db_column='Employee_Name', max_length=150, null=True)),
                ('typeapp', models.CharField(choices=[('P', 'Permanent'), ('C', 'Casual'), ('K', 'Kontrak')], db_column='TypeApp', max_length=32)),
                ('jobtype', models.CharField(blank=True, db_column='JobType', max_length=150, null=True)),
                ('gender', models.CharField(choices=[('M', 'Male'), ('F', 'Female'), ('O', 'Other')], db_column='Gender', max_length=1)),
                ('status', models.CharField(choices=[('S', 'Single'), ('M', 'Married')], db_column='Status', max_length=1)),
                ('telphp', models.CharField(blank=True, db_column='TelpHP', max_length=20, null=True, unique=True)),
                ('territory', models.CharField(blank=True, db_column='Territory', max_length=50, null=True)),
            ],
            options={
                'db_table': 'employee',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='goods',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('inactive', models.BooleanField(db_column='InActive', default=False)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('itemcode', models.CharField(db_column='ItemCode', max_length=30)),
                ('goodsname', models.CharField(db_column='GoodsName', max_length=150)),
                ('brandname', models.CharField(blank=True, db_column='BrandName', max_length=100, null=True)),
                ('priceperunit', models.DecimalField(db_column='PricePerUnit', decimal_places=4, max_digits=30)),
                ('depreciationmethod', models.CharField(db_column='DepreciationMethod', max_length=3)),
                ('unit', models.CharField(db_column='Unit', max_length=30)),
                ('economiclife', models.DecimalField(db_column='EconomicLife', decimal_places=2, max_digits=10)),
                ('placement', models.CharField(blank=True, db_column='Placement', max_length=50, null=True)),
                ('typeapp', models.CharField(choices=[('IT', 'IT'), ('GA', 'GA'), ('IT Accessories', 'IT Accessories'), ('GA Accesories', 'GA Accesories'), ('Others', 'Others')], db_column='typeapp', max_length=32, null=True)),
            ],
            options={
                'db_table': 'n_a_goods',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='LogEvent',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('nameapp', models.CharField(db_column='NameApp', max_length=30)),
                ('model', models.CharField(db_column='Model', max_length=30)),
                ('descriptions', django_mysql.models.JSONField(default=dict)),
            ],
            options={
                'db_table': 'LogEvent',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NA_GoodsReceive_detail',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('brandname', models.CharField(db_column='BrandName', max_length=100)),
                ('priceperunit', models.DecimalField(db_column='PricePerUnit', decimal_places=4, max_digits=30)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('warranty', models.DecimalField(db_column='Warranty', decimal_places=2, max_digits=6)),
                ('endofwarranty', models.DateTimeField(blank=True, db_column='EndOfWarranty', null=True)),
                ('serialnumber', models.CharField(db_column='SerialNumber', max_length=100)),
            ],
            options={
                'db_table': 'n_a_goods_receive_detail',
            },
        ),
        migrations.CreateModel(
            name='NAAccFa',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('serialnumber', models.CharField(db_column='SerialNumber', max_length=50)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('year', models.DecimalField(db_column='Year', decimal_places=2, max_digits=10)),
                ('startdate', models.DateField(db_column='StartDate')),
                ('date_depreciation', models.DateField(db_column='DateDepreciation', null=True)),
                ('depr_expense', models.DecimalField(blank=True, db_column='Depr_Expense', decimal_places=4, max_digits=30, null=True)),
                ('depr_accumulation', models.DecimalField(blank=True, db_column='Depr_Accumulation', decimal_places=4, max_digits=30, null=True)),
                ('bookvalue', models.DecimalField(blank=True, db_column='BookValue', decimal_places=4, max_digits=30, null=True)),
                ('is_parent', models.PositiveSmallIntegerField(db_column='IsParent', default=0)),
                ('lastupdated', models.DateTimeField(blank=True, db_column='LastUpdated', null=True)),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, related_name='AccFA_goods', to='NA_Models.goods')),
            ],
            options={
                'db_table': 'n_a_acc_fa',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAAppparams',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('codeapp', models.CharField(db_column='CodeApp', max_length=64)),
                ('nameapp', models.CharField(blank=True, db_column='NameApp', max_length=100, null=True)),
                ('typeapp', models.CharField(blank=True, db_column='TypeApp', max_length=64, null=True)),
                ('startdate', models.DateField(blank=True, db_column='StartDate', null=True)),
                ('enddate', models.DateField(blank=True, db_column='EndDate', null=True)),
                ('valuechar', models.CharField(blank=True, db_column='ValueChar', max_length=50, null=True)),
                ('fkidapp', models.SmallIntegerField(blank=True, db_column='FKIDApp', null=True)),
                ('fkcodeapp', models.CharField(blank=True, db_column='FKCodeApp', max_length=64, null=True)),
                ('attstrparams', models.CharField(blank=True, db_column='AttStrParams', max_length=20, null=True)),
                ('attdecparams', models.DecimalField(blank=True, db_column='AttDecParams', decimal_places=3, max_digits=10, null=True)),
                ('valuestrparams', models.CharField(blank=True, db_column='ValueStrParams', max_length=50, null=True)),
                ('valuedecparams', models.DecimalField(blank=True, db_column='ValueDecParams', decimal_places=3, max_digits=10, null=True)),
                ('inactive', models.IntegerField(db_column='InActive')),
                ('createddate', models.DateTimeField(blank=True, db_column='CreatedDate', null=True)),
                ('createdby', models.CharField(blank=True, db_column='CreatedBy', max_length=100, null=True)),
            ],
            options={
                'db_table': 'n_a_appparams',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NADisposal',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('serialnumber', models.CharField(db_column='SerialNumber', default='N/A', max_length=100)),
                ('datedisposal', models.DateField(db_column='DateDisposal')),
                ('islost', models.PositiveSmallIntegerField(db_column='IsLost', default=0)),
                ('issold', models.PositiveSmallIntegerField(blank=True, db_column='IsSold', null=True)),
                ('sellingprice', models.DecimalField(blank=True, db_column='SellingPrice', decimal_places=4, max_digits=30, null=True)),
                ('sold_to', models.CharField(blank=True, db_column='Sold_To', max_length=1, null=True)),
                ('sold_to_p_other', models.CharField(blank=True, db_column='Sold_To_P_Other', max_length=120, null=True)),
                ('bookvalue', models.DecimalField(db_column='BookValue', decimal_places=4, max_digits=10)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('fk_acc_fa', models.ForeignKey(blank=True, db_column='FK_Acc_FA', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_accfa', to='NA_Models.NAAccFa')),
                ('fk_acknowledge1', models.ForeignKey(blank=True, db_column='FK_Acknowledge1', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_emp_ack1', to='NA_Models.Employee')),
                ('fk_acknowledge2', models.ForeignKey(blank=True, db_column='FK_Acknowledge2', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_emp_ack2', to='NA_Models.Employee')),
                ('fk_approvedby', models.ForeignKey(blank=True, db_column='FK_ApprovedBy', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_emp_app', to='NA_Models.Employee')),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
            ],
            options={
                'db_table': 'n_a_disposal',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGAMaintenance',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('serialnumber', models.CharField(db_column='SerialNumber', default='N/A', max_length=100)),
                ('requestdate', models.DateField(blank=True, db_column='RequestDate', null=True)),
                ('startdate', models.DateField(db_column='StartDate')),
                ('isstillguarantee', models.BooleanField(db_column='IsStillGuarantee')),
                ('expense', models.DecimalField(db_column='Expense', decimal_places=4, max_digits=14)),
                ('maintenanceby', models.CharField(db_column='MaintenanceBy', max_length=100)),
                ('personalname', models.CharField(blank=True, db_column='PersonalName', max_length=100, null=True)),
                ('enddate', models.DateField(blank=True, db_column='EndDate', null=True)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('issucced', models.IntegerField(blank=True, db_column='IsSucced', default=True, null=True)),
                ('isfinished', models.BooleanField(db_column='IsFinished', default=True)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
            ],
            options={
                'db_table': 'n_a_ga_maintenance',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGaOutwards',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('isnew', models.BooleanField(db_column='IsNew')),
                ('daterequest', models.DateTimeField(db_column='DateRequest')),
                ('datereleased', models.DateTimeField(db_column='DateReleased')),
                ('lastinfo', models.CharField(blank=True, db_column='lastinfo', max_length=250, null=True)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
            ],
            options={
                'db_table': 'n_a_ga_outwards',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGaReceive',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('datereceived', models.DateTimeField(db_column='DateReceived', default=django.utils.timezone.now)),
                ('brand', models.CharField(db_column='Brand', max_length=100)),
                ('invoice_no', models.CharField(blank=True, db_column='Invoice_No', max_length=100, null=True)),
                ('typeapp', models.CharField(blank=True, db_column='TypeApp', max_length=64, null=True)),
                ('machine_no', models.CharField(db_column='Machine_No', max_length=50, unique=True)),
                ('chassis_no', models.CharField(db_column='Chassis_No', max_length=50)),
                ('year_made', models.DateField(db_column='Year_Made')),
                ('colour', models.CharField(max_length=20)),
                ('model', models.CharField(blank=True, db_column='Model', max_length=100, null=True)),
                ('kind', models.CharField(blank=True, db_column='Kind', max_length=30, null=True)),
                ('cylinder', models.CharField(blank=True, db_column='Cylinder', max_length=20, null=True)),
                ('fuel', models.CharField(blank=True, db_column='Fuel', max_length=20, null=True)),
                ('price', models.DecimalField(db_column='Price', decimal_places=4, max_digits=30)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=200, null=True)),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
                ('fk_p_r_by', models.ForeignKey(blank=True, db_column='FK_P_R_By', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_p_r_by_ga', to='NA_Models.Employee')),
                ('fk_receivedby', models.ForeignKey(db_column='FK_ReceivedBy', db_constraint=False, max_length=50, on_delete=django.db.models.deletion.CASCADE, related_name='fk_receivedBy_ga', to='NA_Models.Employee')),
            ],
            options={
                'db_table': 'n_a_ga_receive',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGAReturn',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('serialnumber', models.CharField(db_column='SerialNumber', default='N/A', max_length=100)),
                ('datereturn', models.DateTimeField(db_column='DateReturn')),
                ('conditions', models.CharField(db_column='Conditions', max_length=1)),
                ('iscompleted', models.PositiveSmallIntegerField(db_column='IsCompleted')),
                ('minusDesc', models.CharField(blank=True, db_column='MinusDesc', max_length=100, null=True)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('fk_fromemployee', models.ForeignKey(blank=True, db_column='FK_FromEmployee', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_ngr_fromemployee_nagareturn', to='NA_Models.Employee')),
                ('fk_ga_outwards', models.ForeignKey(blank=True, db_column='fk_ga_outwards', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGaOutwards')),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
                ('fk_usedemployee', models.ForeignKey(blank=True, db_column='FK_UsedEmployee', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_ngr_usedemployee_nagareturn', to='NA_Models.Employee')),
            ],
            options={
                'db_table': 'n_a_ga_return',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGaVnHistory',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('reg_no', models.CharField(db_column='Reg_No', max_length=50, unique=True)),
                ('expired_reg', models.DateField(db_column='Expired_Reg')),
                ('date_reg', models.DateField(blank=True, db_column='Date_Reg', null=True)),
                ('bpkb_expired', models.DateField(blank=True, db_column='BPKB_Expired', null=True)),
                ('purpose', models.CharField(blank=True, choices=[('extends', 'extends'), ('lost', 'lost'), ('other', 'other')], db_column='Purpose', max_length=30, null=True)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=200, null=True)),
                ('fk_app', models.ForeignKey(db_column='FK_App', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGaReceive')),
                ('fk_parent', models.ForeignKey(blank=True, db_column='FK_Parent', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGaVnHistory')),
            ],
            options={
                'db_table': 'n_a_ga_vn_history',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGoodsEquipment',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('name_app', models.CharField(db_column='NameApp', max_length=50)),
                ('type_app', models.IntegerField(choices=[(1, 'GA'), (0, 'IT')], db_column='TypeApp')),
            ],
            options={
                'db_table': 'n_a_equipment',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGoodsHistory',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('serialnumber', models.CharField(db_column='SerialNumber', default='N/A', max_length=100)),
                ('fk_disposal', models.ForeignKey(blank=True, db_column='FK_Disposal', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NADisposal')),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
            ],
            options={
                'db_table': 'n_a_goods_history',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGoodsLending',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('serialnumber', models.CharField(db_column='SerialNumber', default='N/A', max_length=100)),
                ('isnew', models.IntegerField(db_column='IsNew')),
                ('datelending', models.DateField(blank=True, db_column='DateLending', null=True)),
                ('datereturn', models.DateTimeField(db_column='DateReturn', null=True)),
                ('interests', models.CharField(blank=True, db_column='interests', max_length=150, null=True)),
                ('statuslent', models.CharField(blank=True, db_column='Status', max_length=10, null=True)),
                ('lastinfo', models.CharField(blank=True, db_column='lastinfo', max_length=250, null=True)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=200, null=True)),
                ('fk_currentapp', models.ForeignKey(blank=True, db_column='FK_CurrentApp', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_gl_parent', to='NA_Models.NAGoodsLending')),
                ('fk_employee', models.ForeignKey(db_column='FK_Employee', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.Employee')),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
            ],
            options={
                'db_table': 'n_a_goods_lending',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGoodsLost',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('serialnumber', models.CharField(db_column='SerialNumber', default='N/A', max_length=100)),
                ('datelost', models.DateTimeField(db_column='DateLost', default=django.utils.timezone.now)),
                ('fromgoods', models.CharField(db_column='FromGoods', max_length=10)),
                ('status', models.CharField(db_column='Status', max_length=5)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('reason', models.CharField(blank=True, db_column='Reason', max_length=250, null=True)),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
                ('fk_goods_lending', models.ForeignKey(blank=True, db_column='FK_Goods_Lending', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGoodsLending')),
            ],
            options={
                'db_table': 'n_a_goods_lost',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGoodsOutwards',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('serialnumber', models.CharField(db_column='SerialNumber', default='N/A', max_length=100)),
                ('isnew', models.BooleanField(db_column='IsNew')),
                ('daterequest', models.DateTimeField(db_column='DateRequest')),
                ('datereleased', models.DateTimeField(db_column='DateReleased')),
                ('lastinfo', models.CharField(blank=True, db_column='lastinfo', max_length=250, null=True)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('fk_employee', models.ForeignKey(db_column='FK_Employee', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.Employee')),
                ('fk_frommaintenance', models.ForeignKey(blank=True, db_column='FK_FromMaintenance', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_maintenance_nagoodsoutwards', to='NA_Models.Employee')),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
                ('fk_lending', models.ForeignKey(blank=True, db_column='FK_Lending', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_lending_nagoodsoutwards', to='NA_Models.NAGoodsLending')),
            ],
            options={
                'db_table': 'n_a_goods_outwards',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGoodsReceive',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('datereceived', models.DateTimeField(db_column='DateReceived')),
                ('totalpurchase', models.SmallIntegerField(db_column='TotalPurchase')),
                ('totalreceived', models.SmallIntegerField(db_column='TotalReceived')),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('descbysystem', models.CharField(blank=True, db_column='DescBySystem', max_length=500, null=True)),
                ('refno', models.CharField(db_column='REFNO', max_length=50)),
            ],
            options={
                'db_table': 'n_a_goods_receive',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAGoodsReceive_other',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('datereceived', models.DateTimeField(db_column='DateReceived')),
                ('totalpurchase', models.SmallIntegerField(db_column='TotalPurchase')),
                ('totalreceived', models.SmallIntegerField(db_column='TotalReceived')),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('descbysystem', models.CharField(blank=True, db_column='DescBySystem', max_length=500, null=True)),
                ('refno', models.CharField(db_column='REFNO', max_length=50)),
                ('fk_goods', models.ForeignKey(db_column='fk_goods', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
                ('fk_p_r_by', models.ForeignKey(blank=True, db_column='FK_P_R_By', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_p_r_by_other', to='NA_Models.Employee')),
                ('fk_receivedby', models.ForeignKey(db_column='FK_ReceivedBy', db_constraint=False, max_length=50, on_delete=django.db.models.deletion.CASCADE, related_name='fk_receivedBy_other', to='NA_Models.Employee')),
            ],
            options={
                'db_table': 'n_a_goods_receive_other',
            },
        ),
        migrations.CreateModel(
            name='NAGoodsReturn',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('serialnumber', models.CharField(db_column='SerialNumber', default='N/A', max_length=100)),
                ('datereturn', models.DateTimeField(db_column='DateReturn')),
                ('conditions', models.CharField(db_column='Conditions', max_length=1)),
                ('iscompleted', models.PositiveSmallIntegerField(db_column='IsCompleted')),
                ('minusDesc', models.CharField(blank=True, db_column='MinusDesc', max_length=100, null=True)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('fk_fromemployee', models.ForeignKey(blank=True, db_column='FK_FromEmployee', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_ngr_fromemployee_nagoodsreturn', to='NA_Models.Employee')),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
                ('fk_goods_lend', models.ForeignKey(blank=True, db_column='FK_Goods_Lend', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_lend_nagoodsreturn', to='NA_Models.NAGoodsLending')),
                ('fk_goods_outwards', models.ForeignKey(blank=True, db_column='FK_Goods_Outwards', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_outwards_nagoodsreturn', to='NA_Models.NAGoodsOutwards')),
                ('fk_usedemployee', models.ForeignKey(blank=True, db_column='FK_UsedEmployee', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_ngr_usedemployee_nagoodsreturn', to='NA_Models.Employee')),
            ],
            options={
                'db_table': 'n_a_goods_return',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAMaintenance',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('serialnumber', models.CharField(db_column='SerialNumber', default='N/A', max_length=100)),
                ('requestdate', models.DateField(blank=True, db_column='RequestDate', null=True)),
                ('startdate', models.DateField(db_column='StartDate')),
                ('isstillguarantee', models.TextField(db_column='IsStillGuarantee')),
                ('expense', models.DecimalField(db_column='Expense', decimal_places=4, max_digits=14)),
                ('maintenanceby', models.CharField(db_column='MaintenanceBy', max_length=100)),
                ('personalname', models.CharField(blank=True, db_column='PersonalName', max_length=100, null=True)),
                ('enddate', models.DateField(blank=True, db_column='EndDate', null=True)),
                ('typeapp', models.CharField(db_column='TypeApp', max_length=32)),
                ('issucced', models.IntegerField(blank=True, db_column='IsSucced', null=True)),
                ('isfinished', models.BooleanField(db_column='IsFinished', default=False)),
                ('descriptions', models.CharField(blank=True, db_column='Descriptions', max_length=250, null=True)),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
            ],
            options={
                'db_table': 'n_a_maintenance',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NAPrivilege_Form',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('form_id', models.CharField(db_column='Form_id', max_length=20)),
                ('form_name', models.CharField(db_column='Form_name', max_length=30)),
                ('form_name_ori', models.CharField(choices=[('employee', 'employee'), ('n_a_supplier', 'n_a_supplier'), ('goods', 'goods'), ('n_a_goods_receive', 'n_a_goods_receive'), ('n_a_privilege', 'n_a_privilege'), ('n_a_acc_fa', 'n_a_acc_fa')], db_column='Form_name_ori', max_length=50)),
            ],
            options={
                'db_table': 'N_A_Privilege_form',
            },
        ),
        migrations.CreateModel(
            name='NAStock',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('t_goods_spare', models.PositiveSmallIntegerField(db_column='T_Goods_Spare', null=True)),
                ('totalqty', models.IntegerField(db_column='TotalQty', null=True)),
                ('tisused', models.IntegerField(db_column='TIsUsed', null=True)),
                ('tisnew', models.PositiveSmallIntegerField(db_column='TIsNew', null=True)),
                ('tisrenew', models.PositiveSmallIntegerField(db_column='TIsRenew', null=True)),
                ('tisbroken', models.IntegerField(db_column='TIsBroken', null=True)),
                ('tgoods_return', models.SmallIntegerField(blank=True, db_column='TGoods_Return', null=True)),
                ('tgoods_received', models.IntegerField(blank=True, db_column='TGoods_Received', null=True)),
                ('tmaintenance', models.SmallIntegerField(blank=True, db_column='TMaintenance', null=True)),
                ('tdisposal', models.IntegerField(db_column='TDisposal', null=True)),
                ('tislost', models.IntegerField(db_column='TIsLost', null=True)),
                ('fk_goods', models.ForeignKey(db_column='FK_Goods', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods')),
            ],
            options={
                'db_table': 'n_a_stock',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NASupplier',
            fields=[
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('inactive', models.BooleanField(db_column='InActive', default=False)),
                ('suppliercode', models.CharField(db_column='SupplierCode', max_length=30, primary_key=True, serialize=False, unique=True)),
                ('suppliername', models.CharField(blank=True, db_column='SupplierName', max_length=100, null=True)),
                ('address', models.CharField(blank=True, db_column='Address', max_length=150, null=True)),
                ('telp', models.CharField(blank=True, db_column='Telp', max_length=20, null=True, unique=True)),
                ('hp', models.CharField(blank=True, db_column='HP', max_length=20, null=True, unique=True)),
                ('contactperson', models.CharField(blank=True, db_column='ContactPerson', max_length=100, null=True)),
            ],
            options={
                'db_table': 'n_a_supplier',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='NASysPrivilege',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createddate', models.DateTimeField(db_column='CreatedDate', default=django.utils.timezone.now)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('permission', models.CharField(choices=[('Allow View', 'Allow View'), ('Allow Add', 'Allow Add'), ('Allow Edit', 'Allow Edit'), ('Allow Delete', 'Allow Delete')], db_column='Permission', max_length=50)),
                ('inactive', models.IntegerField(blank=True, db_column='InActive', default=0, null=True)),
                ('fk_p_form', models.ForeignKey(db_column='FK_PForm', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAPrivilege_Form')),
            ],
            options={
                'db_table': 'N_A_Sys_Privilege',
            },
        ),
        migrations.CreateModel(
            name='NAPrivilege',
            fields=[
                ('idapp', models.AutoField(db_column='IDApp', primary_key=True, serialize=False)),
                ('createdby', models.CharField(db_column='CreatedBy', max_length=100)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('modifiedby', models.CharField(blank=True, db_column='ModifiedBy', max_length=100, null=True)),
                ('first_name', models.CharField(max_length=20)),
                ('last_name', models.CharField(max_length=20)),
                ('username', models.CharField(db_column='UserName', max_length=250, unique=True)),
                ('email', models.EmailField(blank=True, db_column='Email', max_length=254, unique=True)),
                ('divisi', models.CharField(choices=[('IT', 'IT'), ('GA', 'GA')], db_column='Divisi', max_length=5)),
                ('password', models.CharField(db_column='Password', max_length=128)),
                ('picture', models.ImageField(blank=True, db_column='Picture', default='default.png', null=True, storage=NA_DataLayer.file_storage.NAFileStorage(), upload_to=NA_Models.models.upload_to_each_dir)),
                ('last_login', models.DateTimeField(db_column='Last_login', null=True)),
                ('last_form', models.CharField(db_column='Last_form', max_length=50, null=True)),
                ('computer_name', models.CharField(db_column='Computer_Name', max_length=50)),
                ('ip_address', models.CharField(db_column='IP_Address', max_length=20)),
                ('role', models.IntegerField(choices=[(3, 'Guest'), (2, 'User'), (1, 'Super User')], db_column='Role', default=3, null=True)),
                ('is_superuser', models.BooleanField(db_column='Is_SuperUser', default=False)),
                ('is_staff', models.BooleanField(db_column='Is_Staff', default=False)),
                ('is_active', models.BooleanField(db_column='Is_Active', default=True)),
                ('date_joined', models.DateTimeField(blank=True, db_column='Date_Joined', null=True)),
                ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
                ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
            ],
            options={
                'db_table': 'N_A_Privilege',
                'managed': True,
            },
            managers=[
                ('objects', NA_DataLayer.MasterData.NA_Privilege_BR.NA_BR_Privilege()),
            ],
        ),
        migrations.AddField(
            model_name='nasysprivilege',
            name='user_id',
            field=models.ForeignKey(db_column='User_id', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='nagoodsreceive_other',
            name='fk_supplier',
            field=models.ForeignKey(db_column='FK_Supplier', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NASupplier'),
        ),
        migrations.AddField(
            model_name='nagoodsreceive',
            name='fk_supplier',
            field=models.ForeignKey(db_column='FK_Supplier', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NASupplier'),
        ),
        migrations.AddField(
            model_name='nagoodsreceive',
            name='idapp_fk_goods',
            field=models.ForeignKey(db_column='fk_goods', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods'),
        ),
        migrations.AddField(
            model_name='nagoodsreceive',
            name='idapp_fk_p_r_by',
            field=models.ForeignKey(blank=True, db_column='FK_P_R_By', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_p_r_by', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodsreceive',
            name='idapp_fk_receivedby',
            field=models.ForeignKey(db_column='FK_ReceivedBy', db_constraint=False, max_length=50, on_delete=django.db.models.deletion.CASCADE, related_name='fk_receivedBy', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodsoutwards',
            name='fk_receive',
            field=models.ForeignKey(db_column='FK_Receive', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_receive_nagoodsoutwards', to='NA_Models.NAGoodsReceive'),
        ),
        migrations.AddField(
            model_name='nagoodsoutwards',
            name='fk_responsibleperson',
            field=models.ForeignKey(blank=True, db_column='FK_ResponsiblePerson', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_resp_person_nagoodsoutwards', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodsoutwards',
            name='fk_return',
            field=models.ForeignKey(db_column='FK_Return', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_return_nagoodsoutwards', to='NA_Models.NAGoodsReturn'),
        ),
        migrations.AddField(
            model_name='nagoodsoutwards',
            name='fk_sender',
            field=models.ForeignKey(blank=True, db_column='FK_Sender', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_sender_nagoodsoutwards', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodsoutwards',
            name='fk_stock',
            field=models.ForeignKey(blank=True, db_column='FK_Stock', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_stock_nagoodsoutwards', to='NA_Models.NAStock'),
        ),
        migrations.AddField(
            model_name='nagoodsoutwards',
            name='fk_usedemployee',
            field=models.ForeignKey(db_column='FK_UsedEmployee', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_used_employee_nagoodsoutwards', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodslost',
            name='fk_goods_outwards',
            field=models.ForeignKey(blank=True, db_column='FK_Goods_Outwards', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGoodsOutwards'),
        ),
        migrations.AddField(
            model_name='nagoodslost',
            name='fk_lostby',
            field=models.ForeignKey(blank=True, db_column='FK_LostBy', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='lost_by', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodslost',
            name='fk_maintenance',
            field=models.ForeignKey(blank=True, db_column='FK_Maintenance', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAMaintenance'),
        ),
        migrations.AddField(
            model_name='nagoodslost',
            name='fk_responsibleperson',
            field=models.ForeignKey(blank=True, db_column='FK_ResponsiblePerson', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='resp_person_goods_lost', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodslost',
            name='fk_usedby',
            field=models.ForeignKey(blank=True, db_column='FK_UsedBy', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='used_by', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodslending',
            name='fk_maintenance',
            field=models.ForeignKey(blank=True, db_column='FK_Maintenance', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_gl_maintenance', to='NA_Models.NAMaintenance'),
        ),
        migrations.AddField(
            model_name='nagoodslending',
            name='fk_receive',
            field=models.ForeignKey(blank=True, db_column='FK_Receive', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_gl_goods_receive', to='NA_Models.NAGoodsReceive'),
        ),
        migrations.AddField(
            model_name='nagoodslending',
            name='fk_responsibleperson',
            field=models.ForeignKey(blank=True, db_column='FK_ResponsiblePerson', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_gl_employee_resp_person', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodslending',
            name='fk_return',
            field=models.ForeignKey(blank=True, db_column='FK_RETURN', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_gl_goods_return', to='NA_Models.NAGoodsReturn'),
        ),
        migrations.AddField(
            model_name='nagoodslending',
            name='fk_sender',
            field=models.ForeignKey(blank=True, db_column='FK_Sender', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_gl_employee_sender', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagoodslending',
            name='fk_stock',
            field=models.ForeignKey(db_column='FK_Stock', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, related_name='fk_gl_stock', to='NA_Models.NAStock'),
        ),
        migrations.AddField(
            model_name='nagoodshistory',
            name='fk_lending',
            field=models.ForeignKey(blank=True, db_column='FK_Lending', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGoodsLending'),
        ),
        migrations.AddField(
            model_name='nagoodshistory',
            name='fk_lost',
            field=models.ForeignKey(blank=True, db_column='FK_Lost', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGoodsLost'),
        ),
        migrations.AddField(
            model_name='nagoodshistory',
            name='fk_maintenance',
            field=models.ForeignKey(blank=True, db_column='FK_Maintenance', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAMaintenance'),
        ),
        migrations.AddField(
            model_name='nagoodshistory',
            name='fk_outwards',
            field=models.ForeignKey(blank=True, db_column='FK_Outwards', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGoodsOutwards'),
        ),
        migrations.AddField(
            model_name='nagoodshistory',
            name='fk_return',
            field=models.ForeignKey(blank=True, db_column='FK_Return', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGoodsReturn'),
        ),
        migrations.AddField(
            model_name='nagareceive',
            name='fk_supplier',
            field=models.ForeignKey(db_column='FK_Supplier', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NASupplier'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='add_equipment',
            field=models.ManyToManyField(db_column='AddEquipment', db_constraint=False, related_name='ga_add_equipment', to='NA_Models.NAGoodsEquipment'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='equipment',
            field=models.ManyToManyField(db_column='Equipment', db_constraint=False, related_name='ga_equipment', to='NA_Models.NAGoodsEquipment'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_app',
            field=models.ForeignKey(db_column='fk_app', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGaVnHistory'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_employee',
            field=models.ForeignKey(db_column='FK_Employee', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_frommaintenance',
            field=models.ForeignKey(blank=True, db_column='FK_FromMaintenance', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_maintenance_nagaoutwards', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_goods',
            field=models.ForeignKey(db_column='FK_Goods', db_constraint=False, max_length=30, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.goods'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_receive',
            field=models.ForeignKey(db_column='FK_Receive', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGaReceive'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_responsibleperson',
            field=models.ForeignKey(blank=True, db_column='FK_ResponsiblePerson', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_resp_person_nagaoutwards', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_return',
            field=models.ForeignKey(db_column='FK_Return', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_return_nagaoutwards', to='NA_Models.NAGoodsReturn'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_sender',
            field=models.ForeignKey(blank=True, db_column='FK_Sender', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_sender_nagaoutwards', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_stock',
            field=models.ForeignKey(blank=True, db_column='FK_Stock', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_stock_nagaoutwards', to='NA_Models.NAStock'),
        ),
        migrations.AddField(
            model_name='nagaoutwards',
            name='fk_usedemployee',
            field=models.ForeignKey(db_column='FK_UsedEmployee', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='rel_used_employee_nagaoutwards', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nadisposal',
            name='fk_lending',
            field=models.ForeignKey(blank=True, db_column='FK_Lending', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_lending', to='NA_Models.NAGoodsLending'),
        ),
        migrations.AddField(
            model_name='nadisposal',
            name='fk_lost',
            field=models.ForeignKey(blank=True, db_column='FK_Lost', null=True, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGoodsLost'),
        ),
        migrations.AddField(
            model_name='nadisposal',
            name='fk_maintenance',
            field=models.ForeignKey(blank=True, db_column='FK_Maintenance', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_maintenance', to='NA_Models.NAMaintenance'),
        ),
        migrations.AddField(
            model_name='nadisposal',
            name='fk_outwards',
            field=models.ForeignKey(blank=True, db_column='FK_Outwards', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_outwards', to='NA_Models.NAGoodsOutwards'),
        ),
        migrations.AddField(
            model_name='nadisposal',
            name='fk_proposedby',
            field=models.ForeignKey(blank=True, db_column='FK_ProposedBy', db_constraint=False, max_length=50, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_emp_proposed', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nadisposal',
            name='fk_return',
            field=models.ForeignKey(blank=True, db_column='FK_Return', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_return', to='NA_Models.NAGoodsReturn'),
        ),
        migrations.AddField(
            model_name='nadisposal',
            name='fk_sold_to_employee',
            field=models.ForeignKey(blank=True, db_column='FK_Sold_To_Employee', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_emp_Sold', to='NA_Models.Employee'),
        ),
        migrations.AddField(
            model_name='nadisposal',
            name='fk_stock',
            field=models.ForeignKey(blank=True, db_column='FK_Stock', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_stock', to='NA_Models.NAStock'),
        ),
        migrations.AddField(
            model_name='nadisposal',
            name='fk_usedemployee',
            field=models.ForeignKey(blank=True, db_column='FK_UsedEmployee', db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='fk_disposal_emp_used', to='NA_Models.Employee'),
        ),
        migrations.AlterUniqueTogether(
            name='naappparams',
            unique_together=set([('idapp', 'codeapp')]),
        ),
        migrations.AddField(
            model_name='na_goodsreceive_detail',
            name='fk_app',
            field=models.ForeignKey(db_column='FK_App', db_constraint=False, on_delete=django.db.models.deletion.CASCADE, to='NA_Models.NAGoodsReceive'),
        ),
        migrations.AlterUniqueTogether(
            name='nasysprivilege',
            unique_together=set([('fk_p_form', 'permission', 'user_id')]),
        ),
    ]

