# Generated by Django 5.2.1 on 2025-05-12 05:20 import django.db.models.deletion import simple_history.models from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ('account', '0091_alter_attendancemember_member'), ] operations = [ migrations.CreateModel( name='HistoricalAdjutant', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(default='', max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical adjutant', 'verbose_name_plural': 'historical adjutants', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalApartment', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical apartment', 'verbose_name_plural': 'historical apartments', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalApplyLeave', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('days', models.IntegerField(blank=True, null=True)), ('status', models.CharField(choices=[('pending', 'Pending'), ('approved', 'Approved'), ('rejected', 'Rejected')], default='pending', max_length=10)), ('csm_status', models.CharField(choices=[('pending', 'Pending'), ('approved', 'Approved'), ('rejected', 'Rejected')], default='pending', max_length=10)), ('company_commander_status', models.CharField(choices=[('pending', 'Pending'), ('approved', 'Approved'), ('rejected', 'Rejected')], default='pending', max_length=10)), ('apply_by', models.CharField(blank=True, max_length=50, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('leave_type', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.leavetype')), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical apply leave', 'verbose_name_plural': 'historical apply leaves', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAttendanceMember', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('ops_depl', models.BooleanField(blank=True, default=False, null=True)), ('status', models.BooleanField(blank=True, default=False, null=True)), ('reason', models.TextField(blank=True, null=True)), ('date', models.DateField(blank=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('attendance', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.companytakeattendance')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical attendance member', 'verbose_name_plural': 'historical attendance members', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAttendanceSummary', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('date', models.DateField()), ('toe_offr_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_mwo_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_smo_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_wo_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_sgt_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_cpl_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_lcpl_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_snk_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_clk_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_tailor_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_e_br_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_ck_mm_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_carp_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_rco_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_nc_e_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_nc_u_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_att_auth', models.IntegerField(blank=True, default=0, null=True)), ('toe_total_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_offr_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_mwo_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_smo_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_wo_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_sgt_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_cpl_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_lcpl_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_snk_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_clk_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_tailor_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_e_br_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_ck_mm_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_carp_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_rco_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_nc_e_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_nc_u_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_att_auth', models.IntegerField(blank=True, default=0, null=True)), ('ere_total_auth', models.IntegerField(blank=True, default=0, null=True)), ('offr_auth', models.IntegerField(blank=True, default=0, null=True)), ('mwo_auth', models.IntegerField(blank=True, default=0, null=True)), ('smo_auth', models.IntegerField(blank=True, default=0, null=True)), ('wo_auth', models.IntegerField(blank=True, default=0, null=True)), ('sgt_auth', models.IntegerField(blank=True, default=0, null=True)), ('cpl_auth', models.IntegerField(blank=True, default=0, null=True)), ('lcpl_auth', models.IntegerField(blank=True, default=0, null=True)), ('snk_auth', models.IntegerField(blank=True, default=0, null=True)), ('clk_auth', models.IntegerField(blank=True, default=0, null=True)), ('tailor_auth', models.IntegerField(blank=True, default=0, null=True)), ('e_br_auth', models.IntegerField(blank=True, default=0, null=True)), ('ck_mm_auth', models.IntegerField(blank=True, default=0, null=True)), ('carp_auth', models.IntegerField(blank=True, default=0, null=True)), ('rco_auth', models.IntegerField(blank=True, default=0, null=True)), ('nc_e_auth', models.IntegerField(blank=True, default=0, null=True)), ('nc_u_auth', models.IntegerField(blank=True, default=0, null=True)), ('att_auth', models.IntegerField(blank=True, default=0, null=True)), ('total_auth', models.IntegerField(blank=True, default=0, null=True)), ('offr_posted', models.IntegerField(blank=True, default=0, null=True)), ('mwo_posted', models.IntegerField(blank=True, default=0, null=True)), ('smo_posted', models.IntegerField(blank=True, default=0, null=True)), ('wo_posted', models.IntegerField(blank=True, default=0, null=True)), ('sgt_posted', models.IntegerField(blank=True, default=0, null=True)), ('cpl_posted', models.IntegerField(blank=True, default=0, null=True)), ('lcpl_posted', models.IntegerField(blank=True, default=0, null=True)), ('snk_posted', models.IntegerField(blank=True, default=0, null=True)), ('clk_posted', models.IntegerField(blank=True, default=0, null=True)), ('tailor_posted', models.IntegerField(blank=True, default=0, null=True)), ('e_br_posted', models.IntegerField(blank=True, default=0, null=True)), ('ck_mm_posted', models.IntegerField(blank=True, default=0, null=True)), ('carp_posted', models.IntegerField(blank=True, default=0, null=True)), ('rco_posted', models.IntegerField(blank=True, default=0, null=True)), ('nc_e_posted', models.IntegerField(blank=True, default=0, null=True)), ('nc_u_posted', models.IntegerField(blank=True, default=0, null=True)), ('att_posted', models.IntegerField(blank=True, default=0, null=True)), ('total_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_offr_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_mwo_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_smo_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_wo_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_sgt_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_cpl_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_lcpl_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_snk_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_clk_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_tailor_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_e_br_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_ck_mm_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_carp_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_rco_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_nc_e_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_nc_u_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_att_posted', models.IntegerField(blank=True, default=0, null=True)), ('raw_total_posted', models.IntegerField(blank=True, default=0, null=True)), ('offr_def', models.IntegerField(blank=True, default=0, null=True)), ('mwo_def', models.IntegerField(blank=True, default=0, null=True)), ('smo_def', models.IntegerField(blank=True, default=0, null=True)), ('wo_def', models.IntegerField(blank=True, default=0, null=True)), ('sgt_def', models.IntegerField(blank=True, default=0, null=True)), ('cpl_def', models.IntegerField(blank=True, default=0, null=True)), ('lcpl_def', models.IntegerField(blank=True, default=0, null=True)), ('snk_def', models.IntegerField(blank=True, default=0, null=True)), ('clk_def', models.IntegerField(blank=True, default=0, null=True)), ('tailor_def', models.IntegerField(blank=True, default=0, null=True)), ('e_br_def', models.IntegerField(blank=True, default=0, null=True)), ('ck_mm_def', models.IntegerField(blank=True, default=0, null=True)), ('carp_def', models.IntegerField(blank=True, default=0, null=True)), ('rco_def', models.IntegerField(blank=True, default=0, null=True)), ('nc_e_def', models.IntegerField(blank=True, default=0, null=True)), ('nc_u_def', models.IntegerField(blank=True, default=0, null=True)), ('att_def', models.IntegerField(blank=True, default=0, null=True)), ('total_def', models.IntegerField(blank=True, default=0, null=True)), ('offr_held', models.IntegerField(blank=True, default=0, null=True)), ('mwo_held', models.IntegerField(blank=True, default=0, null=True)), ('smo_held', models.IntegerField(blank=True, default=0, null=True)), ('wo_held', models.IntegerField(blank=True, default=0, null=True)), ('sgt_held', models.IntegerField(blank=True, default=0, null=True)), ('cpl_held', models.IntegerField(blank=True, default=0, null=True)), ('lcpl_held', models.IntegerField(blank=True, default=0, null=True)), ('snk_held', models.IntegerField(blank=True, default=0, null=True)), ('clk_held', models.IntegerField(blank=True, default=0, null=True)), ('tailor_held', models.IntegerField(blank=True, default=0, null=True)), ('e_br_held', models.IntegerField(blank=True, default=0, null=True)), ('ck_mm_held', models.IntegerField(blank=True, default=0, null=True)), ('carp_held', models.IntegerField(blank=True, default=0, null=True)), ('rco_held', models.IntegerField(blank=True, default=0, null=True)), ('nc_e_held', models.IntegerField(blank=True, default=0, null=True)), ('nc_u_held', models.IntegerField(blank=True, default=0, null=True)), ('att_held', models.IntegerField(blank=True, default=0, null=True)), ('total_held', models.IntegerField(blank=True, default=0, null=True)), ('offr_absent', models.IntegerField(blank=True, default=0, null=True)), ('mwo_absent', models.IntegerField(blank=True, default=0, null=True)), ('smo_absent', models.IntegerField(blank=True, default=0, null=True)), ('wo_absent', models.IntegerField(blank=True, default=0, null=True)), ('sgt_absent', models.IntegerField(blank=True, default=0, null=True)), ('cpl_absent', models.IntegerField(blank=True, default=0, null=True)), ('lcpl_absent', models.IntegerField(blank=True, default=0, null=True)), ('snk_absent', models.IntegerField(blank=True, default=0, null=True)), ('clk_absent', models.IntegerField(blank=True, default=0, null=True)), ('tailor_absent', models.IntegerField(blank=True, default=0, null=True)), ('e_br_absent', models.IntegerField(blank=True, default=0, null=True)), ('ck_mm_absent', models.IntegerField(blank=True, default=0, null=True)), ('carp_absent', models.IntegerField(blank=True, default=0, null=True)), ('rco_absent', models.IntegerField(blank=True, default=0, null=True)), ('nc_e_absent', models.IntegerField(blank=True, default=0, null=True)), ('nc_u_absent', models.IntegerField(blank=True, default=0, null=True)), ('att_absent', models.IntegerField(blank=True, default=0, null=True)), ('total_absent', models.IntegerField(blank=True, default=0, null=True)), ('offr_present', models.IntegerField(blank=True, default=0, null=True)), ('mwo_present', models.IntegerField(blank=True, default=0, null=True)), ('smo_present', models.IntegerField(blank=True, default=0, null=True)), ('wo_present', models.IntegerField(blank=True, default=0, null=True)), ('sgt_present', models.IntegerField(blank=True, default=0, null=True)), ('cpl_present', models.IntegerField(blank=True, default=0, null=True)), ('lcpl_present', models.IntegerField(blank=True, default=0, null=True)), ('snk_present', models.IntegerField(blank=True, default=0, null=True)), ('clk_present', models.IntegerField(blank=True, default=0, null=True)), ('tailor_present', models.IntegerField(blank=True, default=0, null=True)), ('e_br_present', models.IntegerField(blank=True, default=0, null=True)), ('ck_mm_present', models.IntegerField(blank=True, default=0, null=True)), ('carp_present', models.IntegerField(blank=True, default=0, null=True)), ('rco_present', models.IntegerField(blank=True, default=0, null=True)), ('nc_e_present', models.IntegerField(blank=True, default=0, null=True)), ('nc_u_present', models.IntegerField(blank=True, default=0, null=True)), ('att_present', models.IntegerField(blank=True, default=0, null=True)), ('total_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_offr_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_mwo_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_smo_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_wo_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_sgt_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_cpl_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_lcpl_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_snk_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_clk_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_tailor_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_e_br_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_ck_mm_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_carp_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_rco_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_nc_e_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_nc_u_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_att_present', models.IntegerField(blank=True, default=0, null=True)), ('ops_depl_total_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_offr_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_mwo_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_smo_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_wo_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_sgt_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_cpl_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_lcpl_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_snk_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_clk_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_tailor_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_e_br_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_ck_mm_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_carp_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_rco_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_nc_e_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_nc_u_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_att_present', models.IntegerField(blank=True, default=0, null=True)), ('rear_total_present', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_offr', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_mwo', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_smo', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_wo', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_sgt', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_cpl', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_snk', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_clk', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_tailor', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_e_br', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_carp', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_rco', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_att', models.IntegerField(blank=True, default=0, null=True)), ('p_leave_total', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_offr', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_mwo', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_smo', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_wo', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_sgt', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_cpl', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_snk', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_clk', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_tailor', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_e_br', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_carp', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_rco', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_att', models.IntegerField(blank=True, default=0, null=True)), ('c_leave_total', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_offr', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_mwo', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_smo', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_wo', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_sgt', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_cpl', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_snk', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_clk', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_tailor', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_e_br', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_carp', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_rco', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_att', models.IntegerField(blank=True, default=0, null=True)), ('r_leave_total', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_offr', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_mwo', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_smo', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_wo', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_sgt', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_cpl', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_snk', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_clk', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_tailor', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_e_br', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_carp', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_rco', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_att', models.IntegerField(blank=True, default=0, null=True)), ('m_leave_total', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_offr', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_mwo', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_smo', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_wo', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_sgt', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_cpl', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_snk', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_clk', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_tailor', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_e_br', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_carp', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_rco', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_att', models.IntegerField(blank=True, default=0, null=True)), ('j_leave_total', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_offr', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_mwo', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_smo', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_wo', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_sgt', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_cpl', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_snk', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_clk', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_tailor', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_e_br', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_carp', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_rco', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_att', models.IntegerField(blank=True, default=0, null=True)), ('w_leave_total', models.IntegerField(blank=True, default=0, null=True)), ('osl_offr', models.IntegerField(blank=True, default=0, null=True)), ('osl_mwo', models.IntegerField(blank=True, default=0, null=True)), ('osl_smo', models.IntegerField(blank=True, default=0, null=True)), ('osl_wo', models.IntegerField(blank=True, default=0, null=True)), ('osl_sgt', models.IntegerField(blank=True, default=0, null=True)), ('osl_cpl', models.IntegerField(blank=True, default=0, null=True)), ('osl_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('osl_snk', models.IntegerField(blank=True, default=0, null=True)), ('osl_clk', models.IntegerField(blank=True, default=0, null=True)), ('osl_tailor', models.IntegerField(blank=True, default=0, null=True)), ('osl_e_br', models.IntegerField(blank=True, default=0, null=True)), ('osl_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('osl_carp', models.IntegerField(blank=True, default=0, null=True)), ('osl_rco', models.IntegerField(blank=True, default=0, null=True)), ('osl_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('osl_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('osl_att', models.IntegerField(blank=True, default=0, null=True)), ('osl_total', models.IntegerField(blank=True, default=0, null=True)), ('awol_offr', models.IntegerField(blank=True, default=0, null=True)), ('awol_mwo', models.IntegerField(blank=True, default=0, null=True)), ('awol_smo', models.IntegerField(blank=True, default=0, null=True)), ('awol_wo', models.IntegerField(blank=True, default=0, null=True)), ('awol_sgt', models.IntegerField(blank=True, default=0, null=True)), ('awol_cpl', models.IntegerField(blank=True, default=0, null=True)), ('awol_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('awol_snk', models.IntegerField(blank=True, default=0, null=True)), ('awol_clk', models.IntegerField(blank=True, default=0, null=True)), ('awol_tailor', models.IntegerField(blank=True, default=0, null=True)), ('awol_e_br', models.IntegerField(blank=True, default=0, null=True)), ('awol_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('awol_carp', models.IntegerField(blank=True, default=0, null=True)), ('awol_rco', models.IntegerField(blank=True, default=0, null=True)), ('awol_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('awol_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('awol_att', models.IntegerField(blank=True, default=0, null=True)), ('awol_total', models.IntegerField(blank=True, default=0, null=True)), ('course_offr', models.IntegerField(blank=True, default=0, null=True)), ('course_mwo', models.IntegerField(blank=True, default=0, null=True)), ('course_smo', models.IntegerField(blank=True, default=0, null=True)), ('course_wo', models.IntegerField(blank=True, default=0, null=True)), ('course_sgt', models.IntegerField(blank=True, default=0, null=True)), ('course_cpl', models.IntegerField(blank=True, default=0, null=True)), ('course_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('course_snk', models.IntegerField(blank=True, default=0, null=True)), ('course_clk', models.IntegerField(blank=True, default=0, null=True)), ('course_tailor', models.IntegerField(blank=True, default=0, null=True)), ('course_e_br', models.IntegerField(blank=True, default=0, null=True)), ('course_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('course_carp', models.IntegerField(blank=True, default=0, null=True)), ('course_rco', models.IntegerField(blank=True, default=0, null=True)), ('course_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('course_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('course_att', models.IntegerField(blank=True, default=0, null=True)), ('course_total', models.IntegerField(blank=True, default=0, null=True)), ('trg_offr', models.IntegerField(blank=True, default=0, null=True)), ('trg_mwo', models.IntegerField(blank=True, default=0, null=True)), ('trg_smo', models.IntegerField(blank=True, default=0, null=True)), ('trg_wo', models.IntegerField(blank=True, default=0, null=True)), ('trg_sgt', models.IntegerField(blank=True, default=0, null=True)), ('trg_cpl', models.IntegerField(blank=True, default=0, null=True)), ('trg_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('trg_snk', models.IntegerField(blank=True, default=0, null=True)), ('trg_clk', models.IntegerField(blank=True, default=0, null=True)), ('trg_tailor', models.IntegerField(blank=True, default=0, null=True)), ('trg_e_br', models.IntegerField(blank=True, default=0, null=True)), ('trg_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('trg_carp', models.IntegerField(blank=True, default=0, null=True)), ('trg_rco', models.IntegerField(blank=True, default=0, null=True)), ('trg_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('trg_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('trg_att', models.IntegerField(blank=True, default=0, null=True)), ('trg_total', models.IntegerField(blank=True, default=0, null=True)), ('cdr_offr', models.IntegerField(blank=True, default=0, null=True)), ('cdr_mwo', models.IntegerField(blank=True, default=0, null=True)), ('cdr_smo', models.IntegerField(blank=True, default=0, null=True)), ('cdr_wo', models.IntegerField(blank=True, default=0, null=True)), ('cdr_sgt', models.IntegerField(blank=True, default=0, null=True)), ('cdr_cpl', models.IntegerField(blank=True, default=0, null=True)), ('cdr_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('cdr_snk', models.IntegerField(blank=True, default=0, null=True)), ('cdr_clk', models.IntegerField(blank=True, default=0, null=True)), ('cdr_tailor', models.IntegerField(blank=True, default=0, null=True)), ('cdr_e_br', models.IntegerField(blank=True, default=0, null=True)), ('cdr_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('cdr_carp', models.IntegerField(blank=True, default=0, null=True)), ('cdr_rco', models.IntegerField(blank=True, default=0, null=True)), ('cdr_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('cdr_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('cdr_att', models.IntegerField(blank=True, default=0, null=True)), ('cdr_total', models.IntegerField(blank=True, default=0, null=True)), ('cmh_offr', models.IntegerField(blank=True, default=0, null=True)), ('cmh_mwo', models.IntegerField(blank=True, default=0, null=True)), ('cmh_smo', models.IntegerField(blank=True, default=0, null=True)), ('cmh_wo', models.IntegerField(blank=True, default=0, null=True)), ('cmh_sgt', models.IntegerField(blank=True, default=0, null=True)), ('cmh_cpl', models.IntegerField(blank=True, default=0, null=True)), ('cmh_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('cmh_snk', models.IntegerField(blank=True, default=0, null=True)), ('cmh_clk', models.IntegerField(blank=True, default=0, null=True)), ('cmh_tailor', models.IntegerField(blank=True, default=0, null=True)), ('cmh_e_br', models.IntegerField(blank=True, default=0, null=True)), ('cmh_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('cmh_carp', models.IntegerField(blank=True, default=0, null=True)), ('cmh_rco', models.IntegerField(blank=True, default=0, null=True)), ('cmh_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('cmh_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('cmh_att', models.IntegerField(blank=True, default=0, null=True)), ('cmh_total', models.IntegerField(blank=True, default=0, null=True)), ('stmk_offr', models.IntegerField(blank=True, default=0, null=True)), ('stmk_mwo', models.IntegerField(blank=True, default=0, null=True)), ('stmk_smo', models.IntegerField(blank=True, default=0, null=True)), ('stmk_wo', models.IntegerField(blank=True, default=0, null=True)), ('stmk_sgt', models.IntegerField(blank=True, default=0, null=True)), ('stmk_cpl', models.IntegerField(blank=True, default=0, null=True)), ('stmk_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('stmk_snk', models.IntegerField(blank=True, default=0, null=True)), ('stmk_clk', models.IntegerField(blank=True, default=0, null=True)), ('stmk_tailor', models.IntegerField(blank=True, default=0, null=True)), ('stmk_e_br', models.IntegerField(blank=True, default=0, null=True)), ('stmk_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('stmk_carp', models.IntegerField(blank=True, default=0, null=True)), ('stmk_rco', models.IntegerField(blank=True, default=0, null=True)), ('stmk_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('stmk_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('stmk_att', models.IntegerField(blank=True, default=0, null=True)), ('stmk_total', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_offr', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_mwo', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_smo', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_wo', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_sgt', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_cpl', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_snk', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_clk', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_tailor', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_e_br', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_carp', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_rco', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_att', models.IntegerField(blank=True, default=0, null=True)), ('line_sick_total', models.IntegerField(blank=True, default=0, null=True)), ('misc_offr', models.IntegerField(blank=True, default=0, null=True)), ('misc_mwo', models.IntegerField(blank=True, default=0, null=True)), ('misc_smo', models.IntegerField(blank=True, default=0, null=True)), ('misc_wo', models.IntegerField(blank=True, default=0, null=True)), ('misc_sgt', models.IntegerField(blank=True, default=0, null=True)), ('misc_cpl', models.IntegerField(blank=True, default=0, null=True)), ('misc_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('misc_snk', models.IntegerField(blank=True, default=0, null=True)), ('misc_clk', models.IntegerField(blank=True, default=0, null=True)), ('misc_tailor', models.IntegerField(blank=True, default=0, null=True)), ('misc_e_br', models.IntegerField(blank=True, default=0, null=True)), ('misc_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('misc_carp', models.IntegerField(blank=True, default=0, null=True)), ('misc_rco', models.IntegerField(blank=True, default=0, null=True)), ('misc_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('misc_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('misc_att', models.IntegerField(blank=True, default=0, null=True)), ('misc_total', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_offr', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_mwo', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_smo', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_wo', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_sgt', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_cpl', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_snk', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_clk', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_tailor', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_e_br', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_carp', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_rco', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_att', models.IntegerField(blank=True, default=0, null=True)), ('total_leave_total', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_offr', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_mwo', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_smo', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_wo', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_sgt', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_cpl', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_snk', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_clk', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_tailor', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_e_br', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_carp', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_rco', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_att', models.IntegerField(blank=True, default=0, null=True)), ('ration_out_total', models.IntegerField(blank=True, default=0, null=True)), ('ere_offr', models.IntegerField(blank=True, default=0, null=True)), ('ere_mwo', models.IntegerField(blank=True, default=0, null=True)), ('ere_smo', models.IntegerField(blank=True, default=0, null=True)), ('ere_wo', models.IntegerField(blank=True, default=0, null=True)), ('ere_sgt', models.IntegerField(blank=True, default=0, null=True)), ('ere_cpl', models.IntegerField(blank=True, default=0, null=True)), ('ere_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('ere_snk', models.IntegerField(blank=True, default=0, null=True)), ('ere_clk', models.IntegerField(blank=True, default=0, null=True)), ('ere_tailor', models.IntegerField(blank=True, default=0, null=True)), ('ere_e_br', models.IntegerField(blank=True, default=0, null=True)), ('ere_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('ere_carp', models.IntegerField(blank=True, default=0, null=True)), ('ere_rco', models.IntegerField(blank=True, default=0, null=True)), ('ere_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('ere_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('ere_att', models.IntegerField(blank=True, default=0, null=True)), ('ere_total', models.IntegerField(blank=True, default=0, null=True)), ('att_offr', models.IntegerField(blank=True, default=0, null=True)), ('att_mwo', models.IntegerField(blank=True, default=0, null=True)), ('att_smo', models.IntegerField(blank=True, default=0, null=True)), ('att_wo', models.IntegerField(blank=True, default=0, null=True)), ('att_sgt', models.IntegerField(blank=True, default=0, null=True)), ('att_cpl', models.IntegerField(blank=True, default=0, null=True)), ('att_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('att_snk', models.IntegerField(blank=True, default=0, null=True)), ('att_clk', models.IntegerField(blank=True, default=0, null=True)), ('att_tailor', models.IntegerField(blank=True, default=0, null=True)), ('att_e_br', models.IntegerField(blank=True, default=0, null=True)), ('att_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('att_carp', models.IntegerField(blank=True, default=0, null=True)), ('att_rco', models.IntegerField(blank=True, default=0, null=True)), ('att_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('att_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('att_att', models.IntegerField(blank=True, default=0, null=True)), ('att_total', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_offr', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_mwo', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_smo', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_wo', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_sgt', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_cpl', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_snk', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_clk', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_tailor', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_e_br', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_carp', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_rco', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_att', models.IntegerField(blank=True, default=0, null=True)), ('t_duty_total', models.IntegerField(blank=True, default=0, null=True)), ('msn_offr', models.IntegerField(blank=True, default=0, null=True)), ('msn_mwo', models.IntegerField(blank=True, default=0, null=True)), ('msn_smo', models.IntegerField(blank=True, default=0, null=True)), ('msn_wo', models.IntegerField(blank=True, default=0, null=True)), ('msn_sgt', models.IntegerField(blank=True, default=0, null=True)), ('msn_cpl', models.IntegerField(blank=True, default=0, null=True)), ('msn_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('msn_snk', models.IntegerField(blank=True, default=0, null=True)), ('msn_clk', models.IntegerField(blank=True, default=0, null=True)), ('msn_tailor', models.IntegerField(blank=True, default=0, null=True)), ('msn_e_br', models.IntegerField(blank=True, default=0, null=True)), ('msn_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('msn_carp', models.IntegerField(blank=True, default=0, null=True)), ('msn_rco', models.IntegerField(blank=True, default=0, null=True)), ('msn_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('msn_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('msn_att', models.IntegerField(blank=True, default=0, null=True)), ('msn_total', models.IntegerField(blank=True, default=0, null=True)), ('okp_offr', models.IntegerField(blank=True, default=0, null=True)), ('okp_mwo', models.IntegerField(blank=True, default=0, null=True)), ('okp_smo', models.IntegerField(blank=True, default=0, null=True)), ('okp_wo', models.IntegerField(blank=True, default=0, null=True)), ('okp_sgt', models.IntegerField(blank=True, default=0, null=True)), ('okp_cpl', models.IntegerField(blank=True, default=0, null=True)), ('okp_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('okp_snk', models.IntegerField(blank=True, default=0, null=True)), ('okp_clk', models.IntegerField(blank=True, default=0, null=True)), ('okp_tailor', models.IntegerField(blank=True, default=0, null=True)), ('okp_e_br', models.IntegerField(blank=True, default=0, null=True)), ('okp_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('okp_carp', models.IntegerField(blank=True, default=0, null=True)), ('okp_rco', models.IntegerField(blank=True, default=0, null=True)), ('okp_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('okp_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('okp_att', models.IntegerField(blank=True, default=0, null=True)), ('okp_total', models.IntegerField(blank=True, default=0, null=True)), ('demov_offr', models.IntegerField(blank=True, default=0, null=True)), ('demov_mwo', models.IntegerField(blank=True, default=0, null=True)), ('demov_smo', models.IntegerField(blank=True, default=0, null=True)), ('demov_wo', models.IntegerField(blank=True, default=0, null=True)), ('demov_sgt', models.IntegerField(blank=True, default=0, null=True)), ('demov_cpl', models.IntegerField(blank=True, default=0, null=True)), ('demov_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('demov_snk', models.IntegerField(blank=True, default=0, null=True)), ('demov_clk', models.IntegerField(blank=True, default=0, null=True)), ('demov_tailor', models.IntegerField(blank=True, default=0, null=True)), ('demov_e_br', models.IntegerField(blank=True, default=0, null=True)), ('demov_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('demov_carp', models.IntegerField(blank=True, default=0, null=True)), ('demov_rco', models.IntegerField(blank=True, default=0, null=True)), ('demov_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('demov_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('demov_att', models.IntegerField(blank=True, default=0, null=True)), ('demov_total', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_offr', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_mwo', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_smo', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_wo', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_sgt', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_cpl', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_snk', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_clk', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_tailor', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_e_br', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_carp', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_rco', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_att', models.IntegerField(blank=True, default=0, null=True)), ('out_of_unit_emp_total', models.IntegerField(blank=True, default=0, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('attendance_summary_cart', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.attendancesummarycart')), ('company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical attendance summary', 'verbose_name_plural': 'historical attendance summarys', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalAttendanceSummaryCart', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('date', models.DateField()), ('battalion_approved', models.BooleanField(blank=True, null=True)), ('adjutant_approved', models.BooleanField(blank=True, null=True)), ('dq_approved', models.BooleanField(blank=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('battalion', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.battalion')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical attendance summary cart', 'verbose_name_plural': 'historical attendance summary carts', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalBasicInformation', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('blood', models.CharField(blank=True, choices=[('a+', 'A+'), ('a-', 'A-'), ('b+', 'B+'), ('b-', 'B-'), ('o+', 'O+'), ('o-', 'O-'), ('ab+', 'AB+'), ('ab-', 'AB-')], max_length=50, null=True)), ('email', models.EmailField(blank=True, max_length=254, null=True)), ('nid', models.CharField(blank=True, max_length=150, null=True)), ('birth', models.CharField(blank=True, max_length=150, null=True)), ('passport', models.CharField(blank=True, max_length=150, null=True)), ('bank', models.CharField(blank=True, max_length=150, null=True)), ('religion', models.CharField(blank=True, max_length=150, null=True)), ('height', models.CharField(blank=True, max_length=150, null=True)), ('age', models.IntegerField(blank=True, null=True)), ('gender', models.CharField(blank=True, choices=[('male', 'Male'), ('female', 'Female')], max_length=50, null=True)), ('marital_status', models.CharField(blank=True, choices=[('single', 'Single'), ('married', 'Married'), ('unmarried', 'Unmarried'), ('divorced', 'Divorced'), ('widowed', 'Widowed'), ('separated', 'Separated')], max_length=150, null=True)), ('em_name', models.CharField(blank=True, max_length=55, null=True)), ('em_mobile_no', models.CharField(blank=True, max_length=55, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('district', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.district')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ('upazila', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.upazila')), ], options={ 'verbose_name': 'historical basic information', 'verbose_name_plural': 'historical basic informations', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalBattalion', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('sn', models.IntegerField(blank=True, default=0, null=True)), ('name', models.CharField(default='', max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical battalion', 'verbose_name_plural': 'historical battalions', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalBM', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(default='', max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical bm', 'verbose_name_plural': 'historical bms', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCO', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(default='', max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical co', 'verbose_name_plural': 'historical cos', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCommandant', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(default='', max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical commandant', 'verbose_name_plural': 'historical commandants', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCompany', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(default='', max_length=150)), ('offr', models.IntegerField(blank=True, default=0, null=True)), ('mwo', models.IntegerField(blank=True, default=0, null=True)), ('smo', models.IntegerField(blank=True, default=0, null=True)), ('wo', models.IntegerField(blank=True, default=0, null=True)), ('sgt', models.IntegerField(blank=True, default=0, null=True)), ('cpl', models.IntegerField(blank=True, default=0, null=True)), ('lcpl', models.IntegerField(blank=True, default=0, null=True)), ('snk', models.IntegerField(blank=True, default=0, null=True)), ('clk', models.IntegerField(blank=True, default=0, null=True)), ('tailor', models.IntegerField(blank=True, default=0, null=True)), ('e_br', models.IntegerField(blank=True, default=0, null=True)), ('ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('carp', models.IntegerField(blank=True, default=0, null=True)), ('rco', models.IntegerField(blank=True, default=0, null=True)), ('nc_e', models.IntegerField(blank=True, default=0, null=True)), ('nc_u', models.IntegerField(blank=True, default=0, null=True)), ('att', models.IntegerField(blank=True, default=0, null=True)), ('ere_offr', models.IntegerField(blank=True, default=0, null=True)), ('ere_mwo', models.IntegerField(blank=True, default=0, null=True)), ('ere_smo', models.IntegerField(blank=True, default=0, null=True)), ('ere_wo', models.IntegerField(blank=True, default=0, null=True)), ('ere_sgt', models.IntegerField(blank=True, default=0, null=True)), ('ere_cpl', models.IntegerField(blank=True, default=0, null=True)), ('ere_lcpl', models.IntegerField(blank=True, default=0, null=True)), ('ere_snk', models.IntegerField(blank=True, default=0, null=True)), ('ere_clk', models.IntegerField(blank=True, default=0, null=True)), ('ere_tailor', models.IntegerField(blank=True, default=0, null=True)), ('ere_e_br', models.IntegerField(blank=True, default=0, null=True)), ('ere_ck_mm', models.IntegerField(blank=True, default=0, null=True)), ('ere_carp', models.IntegerField(blank=True, default=0, null=True)), ('ere_rco', models.IntegerField(blank=True, default=0, null=True)), ('ere_nc_e', models.IntegerField(blank=True, default=0, null=True)), ('ere_nc_u', models.IntegerField(blank=True, default=0, null=True)), ('ere_att', models.IntegerField(blank=True, default=0, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('battalion', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.battalion')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical company', 'verbose_name_plural': 'historical companys', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCompanyCommander', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(default='', max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical company commander', 'verbose_name_plural': 'historical company commanders', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCompanyTakeAttendance', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('attendance_date', models.DateField()), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical company take attendance', 'verbose_name_plural': 'historical company take attendances', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCore', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical core', 'verbose_name_plural': 'historical cores', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCourse_Cdr_Trg', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('days', models.IntegerField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('leave_type', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.leavetype')), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical course_ cdr_ trg', 'verbose_name_plural': 'historical course_ cdr_ trgs', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalCSM', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(default='', max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical csm', 'verbose_name_plural': 'historical csms', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalDistrict', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical district', 'verbose_name_plural': 'historical districts', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalDQ', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(default='', max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical dq', 'verbose_name_plural': 'historical dqs', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalEducationInformation', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('name', models.CharField(blank=True, default='', max_length=150, null=True)), ('institution', models.CharField(blank=True, default='', max_length=150, null=True)), ('board', models.CharField(blank=True, max_length=150, null=True)), ('roll', models.CharField(blank=True, max_length=150, null=True)), ('reg', models.CharField(blank=True, max_length=150, null=True)), ('year', models.CharField(blank=True, max_length=150, null=True)), ('gpa', models.CharField(blank=True, max_length=150, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical education information', 'verbose_name_plural': 'historical education informations', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalEreTypeTwo', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('start_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('end_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('status', models.BooleanField(blank=True, default=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('from_company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ('to_company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ], options={ 'verbose_name': 'historical ere type two', 'verbose_name_plural': 'historical ere type twos', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalFamilyInformation', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('name', models.CharField(blank=True, default='', max_length=150, null=True)), ('relationship', models.CharField(blank=True, choices=[('wife', 'Wife'), ('children', 'Children')], max_length=50, null=True)), ('age', models.IntegerField(blank=True, null=True)), ('nid', models.CharField(blank=True, max_length=150, null=True)), ('gender', models.CharField(blank=True, choices=[('male', 'Male'), ('female', 'Female')], max_length=50, null=True)), ('mobile_no', models.CharField(blank=True, max_length=50, null=True)), ('picture', models.TextField(blank=True, default='family/default.png', max_length=100, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical family information', 'verbose_name_plural': 'historical family informations', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalLeave', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('date', models.DateField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('days', models.IntegerField(blank=True, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('apply_by', models.CharField(blank=True, max_length=50, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('attendance_member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.attendancemember')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('leave_type', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.leavetype')), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical leave', 'verbose_name_plural': 'historical leaves', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalLeaveType', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('showName', models.CharField(blank=True, default='', max_length=150, null=True)), ('days', models.CharField(blank=True, max_length=3, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical leave type', 'verbose_name_plural': 'historical leave types', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalMainLeave', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('days', models.IntegerField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('leave_type', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.leavetype')), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical main leave', 'verbose_name_plural': 'historical main leaves', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalMember', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('army_no', models.CharField(db_index=True, max_length=50)), ('mobile_no', models.CharField(max_length=50)), ('name', models.CharField(max_length=150)), ('other', models.CharField(blank=True, default='', max_length=250, null=True)), ('active', models.BooleanField(blank=True, default=True, null=True)), ('picture', models.TextField(blank=True, default='members/default.png', max_length=100, null=True)), ('ops_depl', models.BooleanField(blank=True, default=False, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('apartment', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.apartment')), ('company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member_type', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.membertype')), ('p_company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ('rank', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.rank')), ('t_company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ('unit', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.unit')), ('user', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical member', 'verbose_name_plural': 'historical members', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalMemberType', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('showName', models.CharField(blank=True, default='', max_length=150, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical member type', 'verbose_name_plural': 'historical member types', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalMovementOrder', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('movement_type', models.CharField(blank=True, max_length=50, null=True)), ('show_movement_type', models.CharField(blank=True, max_length=50, null=True)), ('unit', models.CharField(blank=True, max_length=50, null=True)), ('reason', models.TextField(blank=True, null=True)), ('status', models.CharField(blank=True, choices=[('in', 'In'), ('out', 'Out')], max_length=10, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('days', models.IntegerField(blank=True, null=True)), ('user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical movement order', 'verbose_name_plural': 'historical movement orders', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalOpsDepl', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('start_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('end_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('status', models.BooleanField(blank=True, default=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical ops depl', 'verbose_name_plural': 'historical ops depls', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalOtherReason', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('start_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('end_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('status', models.BooleanField(blank=True, default=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('leave_type', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.leavetype')), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical other reason', 'verbose_name_plural': 'historical other reasons', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalOutOfUnitEmp', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('type_name', models.CharField(blank=True, choices=[('ere', 'ERE'), ('att', 'ATT'), ('t_duty', 'T Duty'), ('msn', 'MSN'), ('okp', 'OKP'), ('demov', 'DEMOV')], max_length=50, null=True)), ('unit', models.CharField(blank=True, max_length=50, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('start_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('end_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('status', models.BooleanField(blank=True, default=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical out of unit emp', 'verbose_name_plural': 'historical out of unit emps', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalPunishment', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('days', models.IntegerField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ('punishment_type', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.punishmenttype')), ], options={ 'verbose_name': 'historical punishment', 'verbose_name_plural': 'historical punishments', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalPunishmentType', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical punishment type', 'verbose_name_plural': 'historical punishment types', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalRank', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('memberType', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.membertype')), ], options={ 'verbose_name': 'historical rank', 'verbose_name_plural': 'historical ranks', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalServiceInformation', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('med_cat', models.CharField(blank=True, choices=[('a', 'A'), ('b', 'B'), ('c', 'C')], max_length=50, null=True)), ('un_msn', models.CharField(blank=True, choices=[('yes', 'Yes'), ('no', 'No')], max_length=50, null=True)), ('retirement', models.DateField(blank=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('core', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.core')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ('trade', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.trade')), ], options={ 'verbose_name': 'historical service information', 'verbose_name_plural': 'historical service informations', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalSpecialQuality', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical special quality', 'verbose_name_plural': 'historical special qualitys', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalSpecialQualityInformation', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('description', models.TextField(blank=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ('special_quality', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.specialquality')), ], options={ 'verbose_name': 'historical special quality information', 'verbose_name_plural': 'historical special quality informations', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalTrade', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical trade', 'verbose_name_plural': 'historical trades', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalTransCoy', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('date', models.DateField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ('new_company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ('old_company', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.company')), ], options={ 'verbose_name': 'historical trans coy', 'verbose_name_plural': 'historical trans coys', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalUnauthAbsent', fields=[ ('id', models.BigIntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('start_date', models.DateField(blank=True, null=True)), ('end_date', models.DateField(blank=True, null=True)), ('reason', models.TextField(blank=True, null=True)), ('start_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('end_user_info', models.CharField(blank=True, default='', max_length=255, null=True)), ('status', models.BooleanField(blank=True, default=True, null=True)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('leave_type', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.leavetype')), ('member', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.member')), ], options={ 'verbose_name': 'historical unauth absent', 'verbose_name_plural': 'historical unauth absents', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalUnit', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical unit', 'verbose_name_plural': 'historical units', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='HistoricalUpazila', fields=[ ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('updated_at', models.DateTimeField(blank=True, editable=False, null=True)), ('id', models.IntegerField(blank=True, db_index=True)), ('name', models.CharField(max_length=150)), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField(db_index=True)), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('district', models.ForeignKey(blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.district')), ('history_user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'historical upazila', 'verbose_name_plural': 'historical upazilas', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': ('history_date', 'history_id'), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), ]