text: # Generated by Django 3.1.13 on 2021-07-24 11:12
  
  from django.conf import settings
  from django.db import migrations, models
  import django.db.models.deletion
  import multiselectfield.db.fields
  
  
  class Migration(migrations.Migration):
  
      initial = True
  
      dependencies = [
          migrations.swappable_dependency(settings.AUTH_USER_MODEL),
      ]
  
      operations = [
          migrations.CreateModel(
              name='Cal_result',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('created_at', models.DateTimeField(auto_now_add=True)),
                  ('bmr', models.FloatField(blank=True)),
                  ('amr_total', models.FloatField(blank=True)),
                  ('tmr', models.FloatField(blank=True)),
                  ('cal_target', models.FloatField(blank=True)),
                  ('carb_target_mass', models.FloatField(blank=True)),
                  ('prot_target_mass', models.FloatField(blank=True)),
                  ('fat_target_mass', models.FloatField(blank=True)),
              ],
              options={
                  'abstract': False,
              },
          ),
          migrations.CreateModel(
              name='Foods',
              fields=[
                  ('product_id', models.BigIntegerField(primary_key=True, serialize=False)),
                  ('product_category', models.SmallIntegerField(blank=True, null=True)),
                  ('sub_category', models.SmallIntegerField(blank=True, null=True)),
                  ('product_name', models.TextField(blank=True, null=True)),
                  ('company', models.TextField(blank=True, null=True)),
                  ('price', models.FloatField(blank=True, null=True)),
                  ('content', models.FloatField(blank=True, null=True)),
                  ('cal', models.FloatField(blank=True, null=True)),
                  ('carb', models.FloatField(blank=True, null=True)),
                  ('prot', models.FloatField(blank=True, null=True)),
                  ('fat', models.FloatField(blank=True, null=True)),
                  ('saturated_fat', models.FloatField(blank=True, null=True)),
                  ('trans_fat', models.FloatField(blank=True, null=True)),
                  ('sugar', models.FloatField(blank=True, null=True)),
                  ('calcium', models.FloatField(blank=True, null=True)),
                  ('ferrous', models.FloatField(blank=True, null=True)),
                  ('vitamin_a', models.FloatField(blank=True, null=True)),
                  ('vitamin_c', models.FloatField(blank=True, null=True)),
                  ('vitamin_e', models.FloatField(blank=True, null=True)),
                  ('vitamin_b1', models.FloatField(blank=True, null=True)),
                  ('vitamin_b2', models.FloatField(blank=True, null=True)),
                  ('vitamin_b6', models.FloatField(blank=True, null=True)),
                  ('cholesterol', models.FloatField(blank=True, null=True)),
                  ('niacin', models.FloatField(blank=True, null=True)),
                  ('zinc', models.FloatField(blank=True, null=True)),
                  ('folate', models.FloatField(blank=True, null=True)),
                  ('sodium', models.FloatField(blank=True, null=True)),
                  ('links', models.TextField(blank=True, null=True)),
                  ('picture', models.TextField(blank=True, null=True)),
                  ('nutr_table', models.TextField(blank=True, null=True)),
              ],
              options={
                  'db_table': 'foods',
              },
          ),
          migrations.CreateModel(
              name='Menu_saved',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('created_at', models.DateTimeField(auto_now_add=True)),
                  ('menu', models.JSONField(blank=True, null=True)),
              ],
              options={
                  'abstract': False,
              },
          ),
          migrations.CreateModel(
              name='Profile',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('created_at', models.DateTimeField(auto_now_add=True)),
                  ('gender', models.CharField(choices=[('M', '남자'), ('F', '여자')], max_length=255)),
                  ('age', models.PositiveSmallIntegerField()),
                  ('height', models.FloatField()),
                  ('weight', models.FloatField()),
                  ('purpose', models.CharField(choices=[('체중증가', '체중증가'), ('체중유지', '체중유지'), ('체중감소', '체중감소')], default='체중감소', max_length=255)),
                  ('duration_aero_tr', models.FloatField(blank=True, default=0, null=True)),
                  ('duration_weight_tr', models.FloatField(blank=True, default=0, null=True)),
                  ('prot_amount_hope', models.FloatField(blank=True, null=True)),
                  ('budget', models.FloatField(choices=[(8000, '8000원 이하'), (10000, '10000원 이하'), (12000, '12000원 이하'), (20000, '상관없음')], default=8000)),
                  ('user_preference1', models.PositiveSmallIntegerField(choices=[(0, '도시락'), (1, '샐러드'), (2, '밀키트'), (3, '육가공식품'), (4, '과자형태'), (5, '음료'), (6, '견과류')], default=0)),
                  ('user_preference2', models.PositiveSmallIntegerField(choices=[(0, '도시락'), (1, '샐러드'), (2, '밀키트'), (3, '육가공식품'), (4, '과자형태'), (5, '음료'), (6, '견과류')], default=1)),
                  ('user_not_like', multiselectfield.db.fields.MultiSelectField(blank=True, choices=[(0, '도시락'), (1, '샐러드'), (2, '밀키트'), (3, '육가공식품'), (4, '과자형태'), (5, '음료'), (6, '견과류')], max_length=13, null=True)),
                  ('add_calories', models.FloatField(choices=[(0, '두비가 계산해준 만큼 먹을게요 (기본)'), (-150, '150kcal 덜 먹을래요'), (-300, '300kcal 덜 먹을래요'), (150, '150kcal 더 먹을래요'), (300, '300kcal 더 먹을래요')], default=0)),
                  ('bmr_known', models.FloatField(blank=True, null=True)),
              ],
              options={
                  'abstract': False,
              },
          ),
          migrations.CreateModel(
              name='Subscription_apply',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('created_at', models.DateTimeField(auto_now_add=True)),
                  ('phone_number', models.CharField(max_length=255)),
                  ('email', models.EmailField(max_length=200)),
                  ('meal_number', models.SmallIntegerField(choices=[(20, '20끼'), (30, '30끼'), (40, '40끼')], default=30)),
                  ('budget', models.FloatField(choices=[(8000, '8000원 이하'), (10000, '10000원 이하'), (12000, '12000원 이하'), (20000, '상관없음')], default=8000)),
                  ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='subscription_apply_user', to=settings.AUTH_USER_MODEL)),
              ],
              options={
                  'abstract': False,
              },
          ),
          migrations.CreateModel(
              name='Recc_result',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('created_at', models.DateTimeField(auto_now_add=True)),
                  ('product_name', models.CharField(blank=True, max_length=255)),
                  ('company', models.CharField(blank=True, max_length=255)),
                  ('price', models.FloatField(blank=True)),
                  ('content', models.FloatField(blank=True)),
                  ('cal', models.FloatField(blank=True)),
                  ('carb', models.FloatField(blank=True)),
                  ('prot', models.FloatField(blank=True)),
                  ('fat', models.FloatField(blank=True)),
                  ('links', models.TextField(blank=True)),
                  ('recommended_food', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='recommended_food', to='recc.foods')),
                  ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='recc_result_user', to=settings.AUTH_USER_MODEL)),
              ],
              options={
                  'abstract': False,
              },
          ),
      ]
  