# Generated by Django 4.1.5 on 2023-04-20 13:15 from django.db import migrations, models import django.db.models.deletion class Migration(migrations.Migration): initial = True dependencies = [ ('Subscriber', '0002_user_cardio_method_user_cardio_minutes'), ] operations = [ migrations.CreateModel( name='employees', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('employee_id', models.IntegerField(unique=True)), ('first_name', models.CharField(max_length=45)), ('email', models.CharField(max_length=45, unique=True)), ('password', models.CharField(blank=True, max_length=255, null=True)), ('is_technician', models.SmallIntegerField(default=0)), ('is_admin', models.SmallIntegerField(default=0)), ('br_code', models.CharField(blank=True, max_length=45, null=True)), ('reset_email_token', models.CharField(blank=True, max_length=100, null=True)), ('reset_email_expiry', models.SmallIntegerField(default=0)), ], ), migrations.CreateModel( name='dexa_results', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('dexa_result_id', models.IntegerField()), ('appt_id', models.IntegerField()), ('first_name', models.CharField(blank=True, max_length=20)), ('last_name', models.CharField(blank=True, max_length=20)), ('gender', models.CharField(blank=True, max_length=20)), ('measure_date', models.CharField(blank=True, max_length=20)), ('most_recent_measurement_date', models.CharField(blank=True, max_length=20)), ('male', models.CharField(blank=True, max_length=10)), ('age', models.IntegerField(blank=True, null=True)), ('arms_bmc', models.IntegerField(blank=True, null=True)), ('arm_left_bmc', models.IntegerField(blank=True, null=True)), ('arm_right_bmc', models.IntegerField(blank=True, null=True)), ('legs_bmc', models.IntegerField(blank=True, null=True)), ('leg_left_bmc', models.IntegerField(blank=True, null=True)), ('leg_right_bmc', models.IntegerField(blank=True, null=True)), ('ribs_bmc', models.IntegerField(blank=True, null=True)), ('trunk_bmc', models.IntegerField(blank=True, null=True)), ('trunk_left_bmc', models.IntegerField(blank=True, null=True)), ('trunk_right_bmc', models.IntegerField(blank=True, null=True)), ('head_bmc', models.IntegerField(blank=True, null=True)), ('spine_bmc', models.IntegerField(blank=True, null=True)), ('pelvis_bmc', models.IntegerField(blank=True, null=True)), ('total_bmc', models.IntegerField(blank=True, null=True)), ('total_left_bmc', models.IntegerField(blank=True, null=True)), ('total_right_bmc', models.IntegerField(blank=True, null=True)), ('arms_area', models.IntegerField(blank=True, null=True)), ('arm_left_area', models.IntegerField(blank=True, null=True)), ('arm_right_area', models.IntegerField(blank=True, null=True)), ('legs_area', models.IntegerField(blank=True, null=True)), ('leg_left_area', models.IntegerField(blank=True, null=True)), ('leg_right_area', models.IntegerField(blank=True, null=True)), ('ribs_area', models.IntegerField(blank=True, null=True)), ('trunk_area', models.IntegerField(blank=True, null=True)), ('trunk_left_area', models.IntegerField(blank=True, null=True)), ('trunk_right_area', models.IntegerField(blank=True, null=True)), ('head_area', models.IntegerField(blank=True, null=True)), ('spine_area', models.IntegerField(blank=True, null=True)), ('pelvis_area', models.IntegerField(blank=True, null=True)), ('total_area', models.IntegerField(blank=True, null=True)), ('total_left_area', models.IntegerField(blank=True, null=True)), ('total_right_area', models.IntegerField(blank=True, null=True)), ('total_lean_mass', models.IntegerField(blank=True, null=True)), ('total_fat_mass', models.IntegerField(blank=True, null=True)), ('total_bone_mass', models.IntegerField(blank=True, null=True)), ('total_tissue_mass', models.IntegerField(blank=True, null=True)), ('total_fat_free_mass', models.IntegerField(blank=True, null=True)), ('total_left_lean_mass', models.IntegerField(blank=True, null=True)), ('total_left_fat_mass', models.IntegerField(blank=True, null=True)), ('total_left_bone_mass', models.IntegerField(blank=True, null=True)), ('total_left_tissue_mass', models.IntegerField(blank=True, null=True)), ('total_left_fat_free_mass', models.IntegerField(blank=True, null=True)), ('total_right_lean_mass', models.IntegerField(blank=True, null=True)), ('total_right_fat_mass', models.IntegerField(blank=True, null=True)), ('total_right_bone_mass', models.IntegerField(blank=True, null=True)), ('total_right_tissue_mass', models.IntegerField(blank=True, null=True)), ('total_right_fat_free_mass', models.IntegerField(blank=True, null=True)), ('total_diff_lean_mass', models.IntegerField(blank=True, null=True)), ('total_diff_fat_mass', models.IntegerField(blank=True, null=True)), ('total_diff_bone_mass', models.IntegerField(blank=True, null=True)), ('total_diff_tissue_mass', models.IntegerField(blank=True, null=True)), ('total_diff_fat_free_mass', models.IntegerField(blank=True, null=True)), ('arms_lean_mass', models.IntegerField(blank=True, null=True)), ('arms_fat_mass', models.IntegerField(blank=True, null=True)), ('arms_bone_mass', models.IntegerField(blank=True, null=True)), ('arms_tissue_mass', models.IntegerField(blank=True, null=True)), ('arms_fat_free_mass', models.IntegerField(blank=True, null=True)), ('arm_left_lean_mass', models.IntegerField(blank=True, null=True)), ('arm_left_fat_mass', models.IntegerField(blank=True, null=True)), ('arm_left_bone_mass', models.IntegerField(blank=True, null=True)), ('arm_left_tissue_mass', models.IntegerField(blank=True, null=True)), ('arm_left_fat_free_mass', models.IntegerField(blank=True, null=True)), ('arm_right_lean_mass', models.IntegerField(blank=True, null=True)), ('arm_right_fat_mass', models.IntegerField(blank=True, null=True)), ('arm_right_bone_mass', models.IntegerField(blank=True, null=True)), ('arm_right_tissue_mass', models.IntegerField(blank=True, null=True)), ('arm_right_fat_free_mass', models.IntegerField(blank=True, null=True)), ('arm_diff_lean_mass', models.IntegerField(blank=True, null=True)), ('arm_diff_fat_mass', models.IntegerField(blank=True, null=True)), ('arm_diff_bone_mass', models.IntegerField(blank=True, null=True)), ('arm_diff_tissue_mass', models.IntegerField(blank=True, null=True)), ('arm_diff_fat_free_mass', models.IntegerField(blank=True, null=True)), ('legs_lean_mass', models.IntegerField(blank=True, null=True)), ('legs_fat_mass', models.IntegerField(blank=True, null=True)), ('legs_bone_mass', models.IntegerField(blank=True, null=True)), ('legs_tissue_mass', models.IntegerField(blank=True, null=True)), ('legs_fat_free_mass', models.IntegerField(blank=True, null=True)), ('leg_left_lean_mass', models.IntegerField(blank=True, null=True)), ('leg_left_fat_mass', models.IntegerField(blank=True, null=True)), ('leg_left_bone_mass', models.IntegerField(blank=True, null=True)), ('leg_left_tissue_mass', models.IntegerField(blank=True, null=True)), ('leg_left_fat_free_mass', models.IntegerField(blank=True, null=True)), ('leg_right_lean_mass', models.IntegerField(blank=True, null=True)), ('leg_right_fat_mass', models.IntegerField(blank=True, null=True)), ('leg_right_bone_mass', models.IntegerField(blank=True, null=True)), ('leg_right_tissue_mass', models.IntegerField(blank=True, null=True)), ('leg_right_fat_free_mass', models.IntegerField(blank=True, null=True)), ('legs_diff_lean_mass', models.IntegerField(blank=True, null=True)), ('legs_diff_fat_mass', models.IntegerField(blank=True, null=True)), ('legs_diff_bone_mass', models.IntegerField(blank=True, null=True)), ('legs_diff_tissue_mass', models.IntegerField(blank=True, null=True)), ('legs_diff_fat_free_mass', models.IntegerField(blank=True, null=True)), ('trunk_lean_mass', models.IntegerField(blank=True, null=True)), ('trunk_fat_mass', models.IntegerField(blank=True, null=True)), ('trunk_bone_mass', models.IntegerField(blank=True, null=True)), ('trunk_tissue_mass', models.IntegerField(blank=True, null=True)), ('trunk_fat_free_mass', models.IntegerField(blank=True, null=True)), ('trunk_left_lean_mass', models.IntegerField(blank=True, null=True)), ('trunk_left_fat_mass', models.IntegerField(blank=True, null=True)), ('trunk_left_bone_mass', models.IntegerField(blank=True, null=True)), ('trunk_left_tissue_mass', models.IntegerField(blank=True, null=True)), ('trunk_left_fat_free_mass', models.IntegerField(blank=True, null=True)), ('trunk_right_lean_mass', models.IntegerField(blank=True, null=True)), ('trunk_right_fat_mass', models.IntegerField(blank=True, null=True)), ('trunk_right_bone_mass', models.IntegerField(blank=True, null=True)), ('trunk_right_tissue_mass', models.IntegerField(blank=True, null=True)), ('trunk_right_fat_free_mass', models.IntegerField(blank=True, null=True)), ('trunk_diff_lean_mass', models.IntegerField(blank=True, null=True)), ('trunk_diff_fat_mass', models.IntegerField(blank=True, null=True)), ('trunk_diff_bone_mass', models.IntegerField(blank=True, null=True)), ('trunk_diff_tissue_mass', models.IntegerField(blank=True, null=True)), ('trunk_diff_fat_free_mass', models.IntegerField(blank=True, null=True)), ('android_lean_mass', models.IntegerField(blank=True, null=True)), ('android_fat_mass', models.IntegerField(blank=True, null=True)), ('android_bone_mass', models.IntegerField(blank=True, null=True)), ('android_tissue_mass', models.IntegerField(blank=True, null=True)), ('android_fat_free_mass', models.IntegerField(blank=True, null=True)), ('gynoid_lean_mass', models.IntegerField(blank=True, null=True)), ('gynoid_fat_mass', models.IntegerField(blank=True, null=True)), ('gynoid_bone_mass', models.IntegerField(blank=True, null=True)), ('gynoid_tissue_mass', models.IntegerField(blank=True, null=True)), ('gynoid_fat_free_mass', models.IntegerField(blank=True, null=True)), ('total_total_mass', models.IntegerField(blank=True, null=True)), ('total_left_total_mass', models.IntegerField(blank=True, null=True)), ('total_right_total_mass', models.IntegerField(blank=True, null=True)), ('total_diff_total_mass', models.IntegerField(blank=True, null=True)), ('arms_total_mass', models.IntegerField(blank=True, null=True)), ('arms_left_total_mass', models.IntegerField(blank=True, null=True)), ('arms_right_total_mass', models.IntegerField(blank=True, null=True)), ('arms_diff_total_mass', models.IntegerField(blank=True, null=True)), ('legs_total_mass', models.IntegerField(blank=True, null=True)), ('legs_left_total_mass', models.IntegerField(blank=True, null=True)), ('legs_right_total_mass', models.IntegerField(blank=True, null=True)), ('legs_diff_total_mass', models.IntegerField(blank=True, null=True)), ('trunk_total_mass', models.IntegerField(blank=True, null=True)), ('trunk_left_total_mass', models.IntegerField(blank=True, null=True)), ('trunk_right_total_mass', models.IntegerField(blank=True, null=True)), ('trunk_diff_total_mass', models.IntegerField(blank=True, null=True)), ('android_total_mass', models.IntegerField(blank=True, null=True)), ('gynoid_total_mass', models.IntegerField(blank=True, null=True)), ('weight_at_exam', models.IntegerField(blank=True, null=True)), ('weight', models.IntegerField(blank=True, null=True)), ('total_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('total_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('total_left_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('total_left_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('total_right_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('total_right_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('total_diff_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('total_diff_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('arms_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('arms_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('arm_left_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('arm_left_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('arm_right_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('arm_right_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('arms_diff_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('arms_diff_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('legs_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('legs_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('leg_left_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('leg_left_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('leg_right_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('leg_right_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('legs_diff_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('legs_diff_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('trunk_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('trunk_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('trunk_left_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('trunk_left_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('trunk_right_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('trunk_right_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('trunk_diff_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('trunk_diff_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('android_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('android_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('gynoid_region_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('gynoid_tissue_percent_fat', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('vat_mass', models.IntegerField(blank=True, null=True)), ('vat_volume', models.IntegerField(blank=True, null=True)), ('height', models.IntegerField(blank=True, null=True)), ('height_at_exam', models.IntegerField(blank=True, null=True)), ('arms_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('arm_left_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('arm_right_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('legs_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('leg_left_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('leg_right_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('ribs_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('trunk_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('trunk_left_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('trunk_right_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('head_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('spine_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('pelvis_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('total_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('total_left_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('total_right_bmd', models.DecimalField(blank=True, decimal_places=3, max_digits=6, null=True)), ('total_z_score', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('total_t_score', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)), ('bmi', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('image', models.TextField()), ('user_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='user_result', to='Subscriber.user')), ], ), migrations.CreateModel( name='appointments', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('appt_id', models.IntegerField()), ('start_time', models.IntegerField()), ('end_time', models.IntegerField()), ('has_dexa', models.SmallIntegerField(default=0)), ('has_rmr', models.SmallIntegerField(default=0)), ('has_vo2', models.SmallIntegerField(default=0)), ('br_code', models.CharField(max_length=45)), ('token', models.CharField(blank=True, max_length=80, null=True)), ('height', models.IntegerField(blank=True, null=True)), ('weight', models.IntegerField(blank=True, null=True)), ('lifestyle_choices', models.SmallIntegerField(blank=True, choices=[(1, 'SED'), (2, 'LIGHT'), (4, 'HEAVY'), (5, 'INTENSE')], null=True)), ('weight_training', models.SmallIntegerField(blank=True, null=True)), ('cardio_minutes', models.IntegerField(blank=True, null=True)), ('cardio_method', models.CharField(blank=True, max_length=45, null=True)), ('GOAL', models.SmallIntegerField(blank=True, choices=[(1, 'CUT'), (2, 'BULK'), (3, 'MAINTAIN')], null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('user_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='user_appt', to='Subscriber.user')), ], ), ]