# 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='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='csr_rpi_group', to='otree.Session')), ], options={ 'db_table': 'csr_rpi_group', }, bases=(models.Model, otree.db.idmap.GroupIDMapMixin), ), migrations.CreateModel( name='Rank', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('period_number', otree.db.models.IntegerField(null=True)), ('type', otree.db.models.IntegerField(null=True)), ('group_id', otree.db.models.IntegerField(null=True)), ('player_id', otree.db.models.IntegerField(null=True)), ('value', otree.db.models.FloatField(null=True)), ('rank', otree.db.models.IntegerField(null=True)), ('player_label', otree.db.models.StringField(max_length=10000, 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='csr_rpi_subsession', to='otree.Session')), ], options={ 'db_table': 'csr_rpi_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)), ('participant_number', otree.db.models.IntegerField(default=0, null=True)), ('total_compensation', otree.db.models.StringField(default='Not Finished', max_length=10000, null=True)), ('player_label', otree.db.models.StringField(max_length=10000, null=True)), ('condition', otree.db.models.IntegerField(null=True)), ('pay_period', 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=[('True', 'True'), ('False', 'False')], max_length=10000, null=True, verbose_name='')), ('kc2', otree.db.models.StringField(choices=[('a', 'a. 2'), ('b', 'b. 3'), ('c', 'c. 4'), ('d', 'd. 5')], max_length=10000, null=True, verbose_name='')), ('kc3', otree.db.models.StringField(choices=[('True', 'True'), ('False', 'False')], max_length=10000, null=True, verbose_name='')), ('kc4', otree.db.models.StringField(choices=[('True', 'True'), ('False', 'False')], max_length=10000, null=True, verbose_name='')), ('kc5', otree.db.models.StringField(choices=[('a', 'a. $0'), ('b', 'b. $3'), ('c', 'c. $6'), ('d', 'd. $9')], max_length=10000, null=True, verbose_name='')), ('kc6', otree.db.models.StringField(choices=[('a', 'a. $0'), ('b', 'b. $3'), ('c', 'c. $6'), ('d', 'd. $9')], max_length=10000, null=True, verbose_name='')), ('kc7', otree.db.models.StringField(choices=[('a', 'a. Higher probability of success.'), ('b', 'b. Lower probability of success.')], max_length=10000, null=True, verbose_name='')), ('kc8', otree.db.models.StringField(choices=[('a', 'a. Higher probability of success.'), ('b', 'b. Lower probability of success.')], max_length=10000, null=True, verbose_name='')), ('kc9', otree.db.models.StringField(choices=[('True', 'True'), ('False', 'False')], max_length=10000, null=True, verbose_name='')), ('kc10a', otree.db.models.StringField(choices=[('True', 'True'), ('False', 'False')], max_length=10000, null=True, verbose_name='')), ('kc10b', otree.db.models.StringField(choices=[('True', 'True'), ('False', 'False')], max_length=10000, null=True, verbose_name='')), ('kc10c', otree.db.models.StringField(choices=[('True', 'True'), ('False', 'False')], max_length=10000, null=True, verbose_name='')), ('kc10d', otree.db.models.StringField(choices=[('True', 'True'), ('False', 'False')], max_length=10000, null=True, verbose_name='')), ('practice_decision_time', otree.db.models.StringField(max_length=10000, null=True)), ('practice_dollars_kept', otree.db.models.FloatField(null=True, verbose_name='')), ('practice_dollars_invested', otree.db.models.FloatField(null=True, verbose_name='')), ('practice_local_weight', otree.db.models.IntegerField(null=True, verbose_name='')), ('practice_state_weight', otree.db.models.IntegerField(null=True, verbose_name='')), ('practice_national_weight', otree.db.models.IntegerField(null=True, verbose_name='')), ('practice_impact_score', otree.db.models.FloatField(null=True)), ('practice_potential_return', otree.db.models.FloatField(null=True)), ('practice_local_payoff', otree.db.models.IntegerField(null=True)), ('practice_state_payoff', otree.db.models.IntegerField(null=True)), ('practice_national_payoff', otree.db.models.IntegerField(null=True)), ('practice_dollar_rank', otree.db.models.IntegerField(null=True)), ('practice_impact_rank', otree.db.models.IntegerField(null=True)), ('practice_return_rank', otree.db.models.IntegerField(null=True)), ('charity_selection', otree.db.models.StringField(max_length=10000, null=True)), ('running_dollars_invested', otree.db.models.FloatField(null=True)), ('running_impact_score', otree.db.models.FloatField(null=True)), ('running_potential_return', otree.db.models.FloatField(null=True)), ('p1_decision_time', otree.db.models.StringField(max_length=10000, null=True)), ('p1_dollars_kept', otree.db.models.FloatField(null=True)), ('p1_dollars_invested', otree.db.models.FloatField(null=True)), ('p1_local_weight', otree.db.models.IntegerField(null=True)), ('p1_state_weight', otree.db.models.IntegerField(null=True)), ('p1_national_weight', otree.db.models.IntegerField(null=True)), ('p1_dollar_rank', otree.db.models.IntegerField(null=True)), ('p1_impact_rank', otree.db.models.IntegerField(null=True)), ('p1_return_rank', otree.db.models.IntegerField(null=True)), ('p2_decision_time', otree.db.models.StringField(max_length=10000, null=True)), ('p2_dollars_kept', otree.db.models.FloatField(null=True)), ('p2_dollars_invested', otree.db.models.FloatField(null=True)), ('p2_local_weight', otree.db.models.IntegerField(null=True)), ('p2_state_weight', otree.db.models.IntegerField(null=True)), ('p2_national_weight', otree.db.models.IntegerField(null=True)), ('p2_dollar_rank', otree.db.models.IntegerField(null=True)), ('p2_impact_rank', otree.db.models.IntegerField(null=True)), ('p2_return_rank', otree.db.models.IntegerField(null=True)), ('p3_decision_time', otree.db.models.StringField(max_length=10000, null=True)), ('p3_dollars_kept', otree.db.models.FloatField(null=True)), ('p3_dollars_invested', otree.db.models.FloatField(null=True)), ('p3_local_weight', otree.db.models.IntegerField(null=True)), ('p3_state_weight', otree.db.models.IntegerField(null=True)), ('p3_national_weight', otree.db.models.IntegerField(null=True)), ('p3_dollar_rank', otree.db.models.IntegerField(null=True)), ('p3_impact_rank', otree.db.models.IntegerField(null=True)), ('p3_return_rank', otree.db.models.IntegerField(null=True)), ('p4_decision_time', otree.db.models.StringField(max_length=10000, null=True)), ('p4_dollars_kept', otree.db.models.FloatField(null=True)), ('p4_dollars_invested', otree.db.models.FloatField(null=True)), ('p4_local_weight', otree.db.models.IntegerField(null=True)), ('p4_state_weight', otree.db.models.IntegerField(null=True)), ('p4_national_weight', otree.db.models.IntegerField(null=True)), ('p4_dollar_rank', otree.db.models.IntegerField(null=True)), ('p4_impact_rank', otree.db.models.IntegerField(null=True)), ('p4_return_rank', otree.db.models.IntegerField(null=True)), ('state_project_payoff', otree.db.models.IntegerField(null=True)), ('national_project_payoff', otree.db.models.IntegerField(null=True)), ('charity_payment', otree.db.models.FloatField(null=True)), ('feeling_performance', otree.db.models.StringField(choices=[('1', '1 = Very ashamed.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither ashamed nor proud.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Very proud.')], max_length=10000, null=True, verbose_name='')), ('ranking_salience', otree.db.models.StringField(choices=[('1', '1 = Never.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Sometimes.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Very often.')], max_length=10000, null=True, verbose_name='')), ('ranking_concern', otree.db.models.StringField(choices=[('1', '1 = Not at all nervous or concerned.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Somewhat nervous or concerned.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Very nervous or concerned.')], max_length=10000, null=True, verbose_name='')), ('ranking_interference', otree.db.models.StringField(choices=[('1', '1 = Not at all.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Somewhat.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Very much.')], max_length=10000, null=True, verbose_name='')), ('high_investment_desire', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('high_impact_desire', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('high_return_desire', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('look_good_concern', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('investment_comfort', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('impact_comfort', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('charitability_image', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('risk_attitude', otree.db.models.StringField(choices=[('1', "1 = I'm not at all willing to take risks."), ('2', '2'), ('3', '3'), ('4', '4'), ('5', '5'), ('6', "6 = I'm somewhat willing to take risks."), ('7', '7'), ('8', '8'), ('9', '9'), ('10', '10'), ('11', "11 = I'm very willing to take risks.")], max_length=10000, null=True, verbose_name='')), ('importance_prob_success', otree.db.models.StringField(choices=[('1', '1 = Not at all important.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Somewhat important.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Very important.')], max_length=10000, null=True, verbose_name='')), ('charity_inv_preference', otree.db.models.StringField(choices=[('1', '1 = Charity would strongly prefer projects with lower impact and higher probability of success.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Charity would have no preference.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Charity would strongly prefer projects with higher impact and lower probability of success.')], max_length=10000, null=True, verbose_name='')), ('csr_importance', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('general_charity_importance', otree.db.models.StringField(choices=[('1', '1 = Not at all important.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Somewhat important.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Very important.')], max_length=10000, null=True, verbose_name='')), ('charity_identification', otree.db.models.StringField(choices=[('1', '1 = Not at all.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Somewhat.'), ('5', '5 '), ('6', '6 '), ('7', '7 = A great deal.')], max_length=10000, null=True, verbose_name='')), ('relative_importance_investment', otree.db.models.StringField(choices=[('1', '1 = Greater social impact is more important.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Both are equally important.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Investing more $ is more important.')], max_length=10000, null=True, verbose_name='')), ('project_failure_guilt', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('non_maximizing_guilt', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('investment_decision_difficulty', otree.db.models.StringField(choices=[('1', '1 = Not at all difficult.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Somewhat difficult.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Very difficult.')], max_length=10000, null=True, verbose_name='')), ('impact_decision_difficulty', otree.db.models.StringField(choices=[('1', '1 = Not at all difficult.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Somewhat difficult.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Very difficult.')], max_length=10000, null=True, verbose_name='')), ('ranking_processing_difficulty', otree.db.models.StringField(choices=[('1', '1 = Not at all difficult.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Somewhat difficult.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Very difficult.')], max_length=10000, null=True, verbose_name='')), ('inc_return_factors', otree.db.models.StringField(choices=[('a', 'a. Increasing the cumulative average social impact score.'), ('b', 'b. Increasing the cumulative dollar amount of investments.'), ('c', 'c. No difference.')], max_length=10000, null=True, verbose_name='')), ('inc_return_extent', otree.db.models.StringField(choices=[('a', 'a. Somewhat easier.'), ('b', 'b. Moderately easier.'), ('c', 'c. Significantly easier.')], max_length=10000, null=True, verbose_name='')), ('company_attachment', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('peer_attachment', otree.db.models.StringField(choices=[('1', '1 = Strongly disagree.'), ('2', '2 '), ('3', '3 '), ('4', '4 = Neither agree nor disagree.'), ('5', '5 '), ('6', '6 '), ('7', '7 = Strongly agree.')], max_length=10000, null=True, verbose_name='')), ('investment_strategy', otree.db.models.LongStringField(null=True, verbose_name='')), ('strategy_change', otree.db.models.LongStringField(null=True, verbose_name='')), ('gender', otree.db.models.StringField(choices=[('a', 'a. Male'), ('b', 'b. Female'), ('c', 'c. Prefer not to say')], max_length=10000, null=True, verbose_name='')), ('age', otree.db.models.IntegerField(null=True, verbose_name='')), ('major', otree.db.models.StringField(choices=[('a', 'a. Accounting'), ('b', 'b. Economics'), ('c', 'c. Financial Management'), ('d', 'd. Management'), ('e', 'e. Marketing'), ('f', 'f. Other')], 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='csr_rpi.Group')), ('participant', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='csr_rpi_player', to='otree.Participant')), ('session', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='csr_rpi_player', to='otree.Session')), ('subsession', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='csr_rpi.Subsession')), ], options={ 'db_table': 'csr_rpi_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='csr_rpi.Subsession'), ), ]