# Generated by Django 2.2.12 on 2021-11-23 19:35 from django.db import migrations, models import django.db.models.deletion import otree.db.idmap import otree.db.models class Migration(migrations.Migration): initial = True dependencies = [ ('otree', '0001_initial'), ] operations = [ migrations.CreateModel( name='DecodeStrings', fields=[ ('id', otree.db.models.IntegerField(null=True, primary_key=True, serialize=False)), ('letters', otree.db.models.StringField(max_length=50, null=True)), ('numbers', otree.db.models.StringField(max_length=50, null=True)), ], ), migrations.CreateModel( name='Gamble', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('gamble_id', otree.db.models.IntegerField(null=True)), ('gamble_choice', otree.db.models.StringField(max_length=10000, null=True)), ('outcome_id', otree.db.models.IntegerField(null=True)), ('outcome_raw', otree.db.models.IntegerField(null=True)), ], ), migrations.CreateModel( name='Group', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('id_in_subsession', otree.db.models.PositiveIntegerField(db_index=True, null=True)), ('round_number', otree.db.models.PositiveIntegerField(db_index=True, null=True)), ('session', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='project_selection_group', to='otree.Session')), ], options={ 'db_table': 'project_selection_group', }, bases=(models.Model, otree.db.idmap.GroupIDMapMixin), ), migrations.CreateModel( name='Project', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('project_id', otree.db.models.IntegerField(null=True)), ('outcome_id', otree.db.models.IntegerField(null=True)), ('outcome_raw', otree.db.models.IntegerField(null=True)), ('outcome_ri', otree.db.models.IntegerField(null=True)), ('outcome_roi', otree.db.models.IntegerField(null=True)), ('outcome_bonus', otree.db.models.IntegerField(null=True)), ], ), migrations.CreateModel( name='Subsession', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('round_number', otree.db.models.PositiveIntegerField(db_index=True, null=True)), ('session', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='project_selection_subsession', to='otree.Session')), ], options={ 'db_table': 'project_selection_subsession', }, bases=(models.Model, otree.db.idmap.SubsessionIDMapMixin), ), migrations.CreateModel( name='Player', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('id_in_group', otree.db.models.PositiveIntegerField(db_index=True, null=True)), ('_payoff', otree.db.models.CurrencyField(default=0, null=True)), ('round_number', otree.db.models.PositiveIntegerField(db_index=True, null=True)), ('_role', otree.db.models.StringField(max_length=10000, null=True)), ('condition', otree.db.models.IntegerField(null=True)), ('informed_consent', otree.db.models.StringField(choices=[('Yes', 'Yes'), ('No', 'No')], max_length=10000, null=True, verbose_name='')), ('kc1', otree.db.models.StringField(choices=[('a', 'a. 2'), ('b', 'b. 4'), ('c', 'c. 5')], max_length=10000, null=True, verbose_name='')), ('kc2', otree.db.models.StringField(choices=[('True', 'True'), ('False', 'False')], max_length=10000, null=True, verbose_name='')), ('kc3', otree.db.models.StringField(choices=[('a', 'a. $0.00-$0.20'), ('b', 'b. $0.00-$0.80'), ('c', 'c. $0.00-$1.20'), ('d', 'd. $0.00-$2.00')], max_length=10000, null=True, verbose_name='')), ('kc4_RI', otree.db.models.StringField(choices=[('a', 'a. Residual income'), ('b', 'b. Net cash flows'), ('c', 'c. Return on investment')], max_length=10000, null=True, verbose_name='')), ('kc4_ROI', otree.db.models.StringField(choices=[('a', 'a. Return on investment'), ('b', 'b. Net cash flows'), ('c', 'c. Residual income')], max_length=10000, null=True, verbose_name='')), ('kc4_NI', otree.db.models.StringField(choices=[('a', 'a. Net income'), ('b', 'b. Net cash flows'), ('c', 'c. Return on investment')], max_length=10000, null=True, verbose_name='')), ('kc5_RI', otree.db.models.StringField(choices=[('a', 'a. Income generated by project - $700'), ('b', 'b. Income generated by project – (Required rate of return × Investment in project)'), ('c', 'c. Income generated by project × 10%')], max_length=10000, null=True, verbose_name='')), ('kc5_ROI', otree.db.models.StringField(choices=[('a', 'a. Income generated by project × $700'), ('b', 'b. (Income generated by project / Investment in project) × 100(%)'), ('c', 'c. Income generated by project × 10%')], max_length=10000, null=True, verbose_name='')), ('kc6', otree.db.models.StringField(choices=[('a', 'a. $0.40'), ('b', 'b. $0.60'), ('c', 'c. $0.80'), ('d', 'd. $1.00')], max_length=10000, null=True, verbose_name='')), ('kc7', otree.db.models.StringField(choices=[('a', 'a. $0.20'), ('b', 'b. $0.40'), ('c', 'c. $0.60'), ('d', 'd. $0.80')], max_length=10000, null=True, verbose_name='')), ('num_attempted_1', otree.db.models.IntegerField(null=True)), ('num_decoded_1', otree.db.models.IntegerField(null=True)), ('num_attempted_2', otree.db.models.IntegerField(null=True)), ('num_decoded_2', otree.db.models.IntegerField(null=True)), ('num_attempted_3', otree.db.models.IntegerField(null=True)), ('num_decoded_3', otree.db.models.IntegerField(null=True)), ('num_attempted_4', otree.db.models.IntegerField(null=True)), ('num_decoded_4', otree.db.models.IntegerField(null=True)), ('num_attempted_5', otree.db.models.IntegerField(null=True)), ('num_decoded_5', otree.db.models.IntegerField(null=True)), ('work_time_1', otree.db.models.StringField(max_length=10000, null=True)), ('work_time_2', otree.db.models.StringField(max_length=10000, null=True)), ('work_time_3', otree.db.models.StringField(max_length=10000, null=True)), ('work_time_4', otree.db.models.StringField(max_length=10000, null=True)), ('work_time_5', otree.db.models.StringField(max_length=10000, null=True)), ('p1v2', otree.db.models.IntegerField(null=True)), ('p3v4', otree.db.models.IntegerField(null=True)), ('p1v5', otree.db.models.IntegerField(null=True)), ('p2v3', otree.db.models.IntegerField(null=True)), ('p3v5', otree.db.models.IntegerField(null=True)), ('p1v2a', otree.db.models.IntegerField(null=True)), ('p3v4a', otree.db.models.IntegerField(null=True)), ('p1v5a', otree.db.models.IntegerField(null=True)), ('p2v3a', otree.db.models.IntegerField(null=True)), ('p3v5a', otree.db.models.IntegerField(null=True)), ('p1v2_time', otree.db.models.StringField(max_length=10000, null=True)), ('p3v4_time', otree.db.models.StringField(max_length=10000, null=True)), ('p1v5_time', otree.db.models.StringField(max_length=10000, null=True)), ('p2v3_time', otree.db.models.StringField(max_length=10000, null=True)), ('p3v5_time', otree.db.models.StringField(max_length=10000, null=True)), ('implemented_project_1', otree.db.models.IntegerField(null=True)), ('implemented_project_2', otree.db.models.IntegerField(null=True)), ('implemented_project_3', otree.db.models.IntegerField(null=True)), ('implemented_project_4', otree.db.models.IntegerField(null=True)), ('implemented_project_5', otree.db.models.IntegerField(null=True)), ('impl_project_outcome_1', otree.db.models.IntegerField(null=True)), ('impl_project_outcome_2', otree.db.models.IntegerField(null=True)), ('impl_project_outcome_3', otree.db.models.IntegerField(null=True)), ('impl_project_outcome_4', otree.db.models.IntegerField(null=True)), ('impl_project_outcome_5', otree.db.models.IntegerField(null=True)), ('raw_outcome_1', otree.db.models.IntegerField(null=True)), ('raw_outcome_2', otree.db.models.IntegerField(null=True)), ('raw_outcome_3', otree.db.models.IntegerField(null=True)), ('raw_outcome_4', otree.db.models.IntegerField(null=True)), ('raw_outcome_5', otree.db.models.IntegerField(null=True)), ('pm_outcome_1', otree.db.models.IntegerField(null=True)), ('pm_outcome_2', otree.db.models.IntegerField(null=True)), ('pm_outcome_3', otree.db.models.IntegerField(null=True)), ('pm_outcome_4', otree.db.models.IntegerField(null=True)), ('pm_outcome_5', otree.db.models.IntegerField(null=True)), ('bonus_outcome_1', otree.db.models.StringField(max_length=10000, null=True)), ('bonus_outcome_2', otree.db.models.StringField(max_length=10000, null=True)), ('bonus_outcome_3', otree.db.models.StringField(max_length=10000, null=True)), ('bonus_outcome_4', otree.db.models.StringField(max_length=10000, null=True)), ('bonus_outcome_5', otree.db.models.StringField(max_length=10000, null=True)), ('total_bonus', otree.db.models.StringField(max_length=10000, null=True)), ('total_comp', otree.db.models.StringField(max_length=10000, null=True)), ('pair_order', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble1', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble2', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble3', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble4', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble5', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble6', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble7', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble8', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble9', otree.db.models.StringField(max_length=10000, null=True)), ('peq_gamble10', otree.db.models.StringField(max_length=10000, null=True)), ('paid_gamble', otree.db.models.IntegerField(null=True)), ('paid_gamble_choice', otree.db.models.StringField(max_length=10000, null=True)), ('paid_gamble_outcome', otree.db.models.IntegerField(null=True)), ('bonus_outcome_peq', otree.db.models.StringField(max_length=10000, null=True)), ('peq_decoding_difficulty', otree.db.models.StringField(choices=[('0', '0 = Not at all.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Extremely difficult.')], max_length=10000, null=True, verbose_name='')), ('peq_choice_enjoyment', otree.db.models.StringField(choices=[('0', '0 = Not at all.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = A great deal.')], max_length=10000, null=True, verbose_name='')), ('peq_choice_difficulty', otree.db.models.StringField(choices=[('0', '0 = Not at all - there was always a clear "best" choice for me.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Somewhat difficult - some pairs had a clear "best" choice.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Extremely difficult - there was never a clear "best" choice for me.')], max_length=10000, null=True, verbose_name='')), ('peq_threshold_salience', otree.db.models.StringField(choices=[('-5', '-5 = Strongly disagree.'), ('-4', '-4'), ('-3', '-3'), ('-2', '-2'), ('-1', '-1'), ('0', '0 = Neither agree nor disagree.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('peq_importance_max_payoff', otree.db.models.StringField(choices=[('0', '0 = Not at all important.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Somewhat important.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Very important.')], max_length=10000, null=True, verbose_name='')), ('peq_importance_max_odds', otree.db.models.StringField(choices=[('0', '0 = Not at all important.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Somewhat important.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Very important.')], max_length=10000, null=True, verbose_name='')), ('peq_importance_min_payoff', otree.db.models.StringField(choices=[('0', '0 = Not at all important.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Somewhat important.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Very important.')], max_length=10000, null=True, verbose_name='')), ('peq_importance_min_odds', otree.db.models.StringField(choices=[('0', '0 = Not at all important.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Somewhat important.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Very important.')], max_length=10000, null=True, verbose_name='')), ('peq_importance_likely_payoff', otree.db.models.StringField(choices=[('0', '0 = Not at all important.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Somewhat important.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Very important.')], max_length=10000, null=True, verbose_name='')), ('peq_importance_bonus_proportion', otree.db.models.StringField(choices=[('0', '0 = Not at all important.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Somewhat important.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Very important.')], max_length=10000, null=True, verbose_name='')), ('peq_expected_bonus', otree.db.models.FloatField(null=True, verbose_name='')), ('peq_open_ended', otree.db.models.LongStringField(null=True, verbose_name='')), ('peq_turk_income', otree.db.models.StringField(choices=[('0', '0 = My work on MTurk is for fun or interest only - I don`t rely on it for income.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = My work on MTurk supplements my household`s primary income.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = My work on MTurk generates a significant portion of my household`s total income.')], max_length=10000, null=True, verbose_name='')), ('peq_risk_attitude', otree.db.models.StringField(choices=[('0', '0 = I`m not at all willing to take risks.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = I`m somewhat willing to take risks.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = I`m very willing to take risks.')], max_length=10000, null=True, verbose_name='')), ('peq_affect_excited', otree.db.models.StringField(choices=[('0', '0 = Not at all.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Moderately.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Extremely.')], max_length=10000, null=True, verbose_name='')), ('peq_affect_upset', otree.db.models.StringField(choices=[('0', '0 = Not at all.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Moderately.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Extremely.')], max_length=10000, null=True, verbose_name='')), ('peq_affect_proud', otree.db.models.StringField(choices=[('0', '0 = Not at all.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Moderately.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Extremely.')], max_length=10000, null=True, verbose_name='')), ('peq_affect_irritable', otree.db.models.StringField(choices=[('0', '0 = Not at all.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Moderately.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Extremely.')], max_length=10000, null=True, verbose_name='')), ('peq_affect_inspired', otree.db.models.StringField(choices=[('0', '0 = Not at all.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Moderately.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Extremely.')], max_length=10000, null=True, verbose_name='')), ('peq_affect_nervous', otree.db.models.StringField(choices=[('0', '0 = Not at all.'), ('1', '1'), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5 = Moderately.'), ('6', '6'), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10 = Extremely.')], max_length=10000, null=True, verbose_name='')), ('peq_gender', otree.db.models.StringField(choices=[('1', 'Male'), ('2', 'Female')], max_length=10000, null=True, verbose_name='')), ('peq_age_range', otree.db.models.StringField(choices=[('1', '18-24'), ('2', '25-34'), ('3', '35-44'), ('4', '45-54'), ('5', '55-64'), ('6', '65 and older')], max_length=10000, null=True, verbose_name='')), ('peq_work_experience', otree.db.models.IntegerField(null=True, verbose_name='')), ('peq_education', otree.db.models.StringField(choices=[('1', 'Less than high school'), ('2', 'High school graduate'), ('3', 'Some college'), ('4', '2 year degree'), ('5', '4 year degree'), ('6', 'Graduate degree')], max_length=10000, null=True, verbose_name='')), ('peq_accounting', otree.db.models.StringField(choices=[('0', '0'), ('1', '1 or 2'), ('3', '3 or more')], max_length=10000, null=True, verbose_name='')), ('worker_id', otree.db.models.StringField(default='e', max_length=10000, null=True)), ('mturk_dupe', otree.db.models.IntegerField(null=True)), ('group', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='project_selection.Group')), ('participant', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='project_selection_player', to='otree.Participant')), ('session', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='project_selection_player', to='otree.Session')), ('subsession', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='project_selection.Subsession')), ], options={ 'db_table': 'project_selection_player', }, bases=(models.Model, otree.db.idmap.PlayerIDMapMixin), ), migrations.AddField( model_name='group', name='subsession', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='project_selection.Subsession'), ), ]