# -*- coding: utf-8 -*-
# Generated by Django 1.11 on 2017-06-02 15:59
from __future__ import unicode_literals

from django.db import migrations


def load_assessments(apps, schema_editor):
    db = schema_editor.connection.alias

    Assessment = apps.get_model("multidb_account", "Assessment")
    AssessmentFormat = apps.get_model("multidb_account", "AssessmentFormat")
    AssessmentRelationshipType = apps.get_model("multidb_account", "AssessmentRelationshipType")

    AssessmentSubCategory = apps.get_model("multidb_account", "AssessmentSubCategory")
    AssessmentTopCategory = apps.get_model("multidb_account", "AssessmentTopCategory")

    Sport = apps.get_model("multidb_account", "Sport")

    soccer_sport = Sport.objects.using(db).get(name='soccer')
    basketball_sport = Sport.objects.using(db).get(name='basketball')
    baseball_sport = Sport.objects.using(db).get(name='baseball')
    hockey_sport = Sport.objects.using(db).get(name='hockey')
    rugby_sport = Sport.objects.using(db).get(name='rugby')
    tennis_sport = Sport.objects.using(db).get(name='tennis')
    field_hockey_sport = Sport.objects.using(db).get(name='field hockey')
    volleyball_sport = Sport.objects.using(db).get(name='volleyball')

    self = AssessmentRelationshipType.objects.using(db).create(description='Self assessment type', type='self')
    coach_athlete = AssessmentRelationshipType.objects.using(db).create(description='Coach-Athlete assessment type',
                                                                        type='coach_athlete')
    athlete_coach = AssessmentRelationshipType.objects.using(db).create(description='Athlete-Coach assessment type',
                                                                        type='athlete_coach')

    format_1to4 = AssessmentFormat.objects.using(db).create(description='Format accepts: 1 to 4', unit='stars',
                                                            validation_regex="^([1-4]{1})(\.[0]{1,6})?$")
    format_cm = AssessmentFormat.objects.using(db).create(description='Format accepted: 1.000000 to 999999999.999999',
                                                          unit='cm', validation_regex="^[0-9]{1,9}(\.[0-9]{1,6})?$")
    format_sec = AssessmentFormat.objects.using(db).create(description='Format accepted: 1.000000 to 999999999.999999',
                                                           unit='sec', validation_regex="^[0-9]{1,9}(\.[0-9]{1,6})?$")
    format_kg = AssessmentFormat.objects.using(db).create(description='Format accepted: 1.000000 to 999999999.999999',
                                                          unit='kg', validation_regex="^[0-9]{1,9}(\.[0-9]{1,6})?$")
    format_degrees = AssessmentFormat.objects.using(db).create(
        description='Format accepted: 1.000000 to 999999999.999999', unit='degrees',
        validation_regex="^[0-9]{1,9}(\.[0-9]{1,6})?$")
    format_percents = AssessmentFormat.objects.using(db).create(
        description='Format accepted: 1.000000 to 999999999.999999', unit='%',
        validation_regex="^[0-9]{1,9}(\.[0-9]{1,6})?$")
    format_int = AssessmentFormat.objects.using(db).create(description='Format accepted: 1 to 999999999',
                                                           unit='integer',
                                                           validation_regex="^([0-9]{1,9})(\.[0]{1,6})?$")
    format_l_min = AssessmentFormat.objects.using(db).create(
        description='Format accepted: 1.000000 to 999999999.999999', unit='L/min',
        validation_regex="^[0-9]{1,9}(\.[0-9]{1,6})?$")
    format_numb = AssessmentFormat.objects.using(db).create(description='Format accepted: 1.000000 to 999999999.999999',
                                                            unit='number',
                                                            validation_regex="^[0-9]{1,9}(\.[0-9]{1,6})?$")
    format_watts = AssessmentFormat.objects.using(db).create(
        description='Format accepted: 1.000000 to 999999999.999999', unit='watts',
        validation_regex="^[0-9]{1,9}(\.[0-9]{1,6})?$")
    format_competent = AssessmentFormat.objects.using(db).create(description='Format accepted: 0 OR 1',
                                                                 unit='competent/not-competent',
                                                                 validation_regex="^([0-1]{1})(\.[0]{1,6})?$")

    # ================== general =================================
    psr199 = AssessmentTopCategory.objects.using(db).create(id=10000, name='General-Physical',
                                                            description='General-Physical')
    psr200 = AssessmentTopCategory.objects.using(db).create(id=10001, name='General-Leadership',
                                                            description='General-Leadership')
    psr201 = AssessmentSubCategory.objects.using(db).create(name='Fundamental Movement Skills',
                                                            description='Fundamental Movement Skills',
                                                            parent_top_category=psr199)
    psr202 = Assessment.objects.using(db).create(name='Throwing', description='Throwing', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr202.relationship_types.add(self, coach_athlete)
    psr203 = Assessment.objects.using(db).create(name='Balance', description='Balance', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr203.relationship_types.add(self, coach_athlete)
    psr204 = Assessment.objects.using(db).create(name='Catching', description='Catching', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr204.relationship_types.add(self, coach_athlete)
    psr205 = Assessment.objects.using(db).create(name='Dodging', description='Dodging', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr205.relationship_types.add(self, coach_athlete)
    psr206 = Assessment.objects.using(db).create(name='Falling', description='Falling', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr206.relationship_types.add(self, coach_athlete)
    psr207 = Assessment.objects.using(db).create(name='Galloping', description='Galloping', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr207.relationship_types.add(self, coach_athlete)
    psr208 = Assessment.objects.using(db).create(name='Hopping', description='Hopping', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr208.relationship_types.add(self, coach_athlete)
    psr209 = Assessment.objects.using(db).create(name='Jumping', description='Jumping', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr209.relationship_types.add(self, coach_athlete)
    psr210 = Assessment.objects.using(db).create(name='Kicking', description='Kicking', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr210.relationship_types.add(self, coach_athlete)
    psr211 = Assessment.objects.using(db).create(name='Object Manipulation - Hands',
                                                 description='Object Manipulation - Hands', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr211.relationship_types.add(self, coach_athlete)
    psr212 = Assessment.objects.using(db).create(name='Object Manipulation - Feet',
                                                 description='Object Manipulation - Feet', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr212.relationship_types.add(self, coach_athlete)
    psr213 = Assessment.objects.using(db).create(name='Rolling', description='Rolling', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr213.relationship_types.add(self, coach_athlete)
    psr214 = Assessment.objects.using(db).create(name='Running', description='Running', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr214.relationship_types.add(self, coach_athlete)
    psr215 = Assessment.objects.using(db).create(name='Starting and Stopping', description='Starting and Stopping',
                                                 parent_sub_category=psr201, format=format_1to4)
    psr215.relationship_types.add(self, coach_athlete)
    psr216 = Assessment.objects.using(db).create(name='Skipping', description='Skipping', parent_sub_category=psr201,
                                                 format=format_1to4)
    psr216.relationship_types.add(self, coach_athlete)
    psr217 = Assessment.objects.using(db).create(name='Two Hand Striking', description='Two Hand Striking',
                                                 parent_sub_category=psr201, format=format_1to4)
    psr217.relationship_types.add(self, coach_athlete)
    psr218 = AssessmentSubCategory.objects.using(db).create(name='Physical Skills', description='Physical Skills',
                                                            parent_top_category=psr199)
    psr219 = AssessmentSubCategory.objects.using(db).create(name='Speed', description='Speed',
                                                            parent_sub_category=psr218)
    psr220 = Assessment.objects.using(db).create(name='20 m', description='20 m', parent_sub_category=psr219,
                                                 format=format_sec)
    psr220.relationship_types.add(self, coach_athlete)
    psr221 = Assessment.objects.using(db).create(name='40 m', description='40 m', parent_sub_category=psr219,
                                                 format=format_sec)
    psr221.relationship_types.add(self, coach_athlete)
    psr222 = Assessment.objects.using(db).create(name='60 m', description='60 m', parent_sub_category=psr219,
                                                 format=format_sec)
    psr222.relationship_types.add(self, coach_athlete)
    psr223 = AssessmentSubCategory.objects.using(db).create(name='Strength (15+)', description='Strength (15+)',
                                                            parent_sub_category=psr218)
    psr224 = Assessment.objects.using(db).create(name='Max Bench Press', description='Max Bench Press',
                                                 parent_sub_category=psr223, format=format_kg)
    psr224.relationship_types.add(self, coach_athlete)
    psr225 = Assessment.objects.using(db).create(name='Squats', description='Squats', parent_sub_category=psr223,
                                                 format=format_kg)
    psr225.relationship_types.add(self, coach_athlete)
    psr226 = Assessment.objects.using(db).create(name='Power Clean', description='Power Clean',
                                                 parent_sub_category=psr223, format=format_kg)
    psr226.relationship_types.add(self, coach_athlete)
    psr227 = AssessmentSubCategory.objects.using(db).create(name='Power', description='Power',
                                                            parent_sub_category=psr218)
    psr228 = Assessment.objects.using(db).create(name='Standing Broad Jump', description='Standing Broad Jump',
                                                 parent_sub_category=psr227, format=format_cm)
    psr228.relationship_types.add(self, coach_athlete)
    psr229 = Assessment.objects.using(db).create(name='Vertical Jump', description='Vertical Jump',
                                                 parent_sub_category=psr227, format=format_cm)
    psr229.relationship_types.add(self, coach_athlete)
    psr230 = Assessment.objects.using(db).create(name='Power Cleans', description='Power Cleans',
                                                 parent_sub_category=psr227, format=format_kg)
    psr230.relationship_types.add(self, coach_athlete)
    psr231 = AssessmentSubCategory.objects.using(db).create(name='Cardio Endurance', description='Cardio Endurance',
                                                            parent_sub_category=psr218)
    psr232 = Assessment.objects.using(db).create(name='Beep Test Level', description='Beep Test Level',
                                                 parent_sub_category=psr231, format=format_int)
    psr232.relationship_types.add(self, coach_athlete)
    psr233 = Assessment.objects.using(db).create(name='V02 Max Test', description='V02 Max Test',
                                                 parent_sub_category=psr231, format=format_l_min)
    psr233.relationship_types.add(self, coach_athlete)
    psr234 = Assessment.objects.using(db).create(name='Yoyo Test level', description='Yoyo Test level',
                                                 parent_sub_category=psr231, format=format_int)
    psr234.relationship_types.add(self, coach_athlete)
    psr235 = AssessmentSubCategory.objects.using(db).create(name='Muscular Endurance', description='Muscular Endurance',
                                                            parent_sub_category=psr218)
    psr236 = Assessment.objects.using(db).create(name='Max Number of Pushups', description='Max Number of Pushups',
                                                 parent_sub_category=psr235, format=format_int)
    psr236.relationship_types.add(self, coach_athlete)
    psr237 = Assessment.objects.using(db).create(name='Max Number of Pullups', description='Max Number of Pullups',
                                                 parent_sub_category=psr235, format=format_int)
    psr237.relationship_types.add(self, coach_athlete)
    psr238 = Assessment.objects.using(db).create(name='Max Number of Dips', description='Max Number of Dips',
                                                 parent_sub_category=psr235, format=format_int)
    psr238.relationship_types.add(self, coach_athlete)
    psr239 = AssessmentSubCategory.objects.using(db).create(name='Flexibility', description='Flexibility',
                                                            parent_sub_category=psr218)
    psr240 = Assessment.objects.using(db).create(name='Sit & Reach', description='Sit & Reach',
                                                 parent_sub_category=psr239, format=format_cm)
    psr240.relationship_types.add(self, coach_athlete)
    psr241 = Assessment.objects.using(db).create(name='Straight leg raise', description='Straight leg raise',
                                                 parent_sub_category=psr239, format=format_degrees)
    psr241.relationship_types.add(self, coach_athlete)
    psr242 = Assessment.objects.using(db).create(name='Thomas test', description='Thomas test',
                                                 parent_sub_category=psr239, format=format_competent)
    psr242.relationship_types.add(self, coach_athlete)
    psr243 = AssessmentSubCategory.objects.using(db).create(name='Balance', description='Balance',
                                                            parent_sub_category=psr218)
    psr244 = Assessment.objects.using(db).create(name='Stork Stand', description='Stork Stand',
                                                 parent_sub_category=psr243, format=format_sec)
    psr244.relationship_types.add(self, coach_athlete)
    psr245 = Assessment.objects.using(db).create(name='Flamingo Balance (touches)',
                                                 description='Flamingo Balance (touches)', parent_sub_category=psr243,
                                                 format=format_int)
    psr245.relationship_types.add(self, coach_athlete)
    psr246 = Assessment.objects.using(db).create(name='Y-Balance', description='Y-Balance', parent_sub_category=psr243,
                                                 format=format_cm)
    psr246.relationship_types.add(self, coach_athlete)
    psr247 = AssessmentSubCategory.objects.using(db).create(name='Agility', description='Agility',
                                                            parent_sub_category=psr218)
    psr248 = Assessment.objects.using(db).create(name='Speed Ladder', description='Speed Ladder',
                                                 parent_sub_category=psr247, format=format_sec)
    psr248.relationship_types.add(self, coach_athlete)
    psr249 = Assessment.objects.using(db).create(name='Shuttle Test', description='Shuttle Test',
                                                 parent_sub_category=psr247, format=format_sec)
    psr249.relationship_types.add(self, coach_athlete)
    psr250 = Assessment.objects.using(db).create(name='T-Test', description='T-Test', parent_sub_category=psr247,
                                                 format=format_sec)
    psr250.relationship_types.add(self, coach_athlete)
    psr251 = AssessmentSubCategory.objects.using(db).create(name='Body Comp', description='Body Comp',
                                                            parent_sub_category=psr218)
    psr252 = Assessment.objects.using(db).create(name='% Body Fat', description='% Body Fat',
                                                 parent_sub_category=psr251, format=format_percents)
    psr252.relationship_types.add(self, coach_athlete)
    psr253 = Assessment.objects.using(db).create(name='Height', description='Height', parent_sub_category=psr251,
                                                 format=format_cm)
    psr253.relationship_types.add(self, coach_athlete)
    psr254 = Assessment.objects.using(db).create(name='Weight', description='Weight', parent_sub_category=psr251,
                                                 format=format_kg)
    psr254.relationship_types.add(self, coach_athlete)
    psr255 = AssessmentSubCategory.objects.using(db).create(name='Functional Movement Screen',
                                                            description='Functional Movement Screen',
                                                            parent_sub_category=psr218)
    psr256 = Assessment.objects.using(db).create(name='Deep Squat', description='Deep Squat',
                                                 parent_sub_category=psr255, format=format_1to4)
    psr256.relationship_types.add(self, coach_athlete)
    psr257 = Assessment.objects.using(db).create(name='Hurdle Step', description='Hurdle Step',
                                                 parent_sub_category=psr255, format=format_1to4)
    psr257.relationship_types.add(self, coach_athlete)
    psr258 = Assessment.objects.using(db).create(name='Inline Lunge', description='Inline Lunge',
                                                 parent_sub_category=psr255, format=format_1to4)
    psr258.relationship_types.add(self, coach_athlete)
    psr259 = Assessment.objects.using(db).create(name='Shoulder Mobility', description='Shoulder Mobility',
                                                 parent_sub_category=psr255, format=format_1to4)
    psr259.relationship_types.add(self, coach_athlete)
    psr260 = Assessment.objects.using(db).create(name='Active Straight Leg Raise',
                                                 description='Active Straight Leg Raise', parent_sub_category=psr255,
                                                 format=format_1to4)
    psr260.relationship_types.add(self, coach_athlete)
    psr261 = Assessment.objects.using(db).create(name='Trunk Stability', description='Trunk Stability',
                                                 parent_sub_category=psr255, format=format_1to4)
    psr261.relationship_types.add(self, coach_athlete)
    psr262 = Assessment.objects.using(db).create(name='Rotary Stability', description='Rotary Stability',
                                                 parent_sub_category=psr255, format=format_1to4)
    psr262.relationship_types.add(self, coach_athlete)
    psr263 = AssessmentSubCategory.objects.using(db).create(name='Social / Mental feedback',
                                                            description='Social / Mental feedback',
                                                            parent_top_category=psr200)
    psr264 = AssessmentSubCategory.objects.using(db).create(name='Social / Emotional', description='Social / Emotional',
                                                            parent_sub_category=psr263)
    psr265 = Assessment.objects.using(db).create(name='Developing Self Esteem', description='Developing Self Esteem',
                                                 parent_sub_category=psr264, format=format_1to4)
    psr265.relationship_types.add(self, athlete_coach, coach_athlete)
    psr266 = Assessment.objects.using(db).create(name='Having Fun Playing', description='Having Fun Playing',
                                                 parent_sub_category=psr264, format=format_1to4)
    psr266.relationship_types.add(self, athlete_coach, coach_athlete)
    psr267 = Assessment.objects.using(db).create(name='Conflict Resolution', description='Conflict Resolution',
                                                 parent_sub_category=psr264, format=format_1to4)
    psr267.relationship_types.add(self, athlete_coach, coach_athlete)
    psr268 = Assessment.objects.using(db).create(name='Doing What Is Right', description='Doing What Is Right',
                                                 parent_sub_category=psr264, format=format_1to4)
    psr268.relationship_types.add(self, athlete_coach, coach_athlete)
    psr269 = Assessment.objects.using(db).create(name='Linking Action to Consequences',
                                                 description='Linking Action to Consequences',
                                                 parent_sub_category=psr264, format=format_1to4)
    psr269.relationship_types.add(self, athlete_coach, coach_athlete)
    psr270 = Assessment.objects.using(db).create(name='Relationships with Team Mates',
                                                 description='Relationships with Team Mates',
                                                 parent_sub_category=psr264, format=format_1to4)
    psr270.relationship_types.add(self, athlete_coach, coach_athlete)
    psr271 = Assessment.objects.using(db).create(name='Understanding Social Media',
                                                 description='Understanding Social Media', parent_sub_category=psr264,
                                                 format=format_1to4)
    psr271.relationship_types.add(self, athlete_coach, coach_athlete)
    psr272 = Assessment.objects.using(db).create(name='Understanding Sickness / Fatigue',
                                                 description='Understanding Sickness / Fatigue',
                                                 parent_sub_category=psr264, format=format_1to4)
    psr272.relationship_types.add(self, athlete_coach, coach_athlete)
    psr273 = Assessment.objects.using(db).create(name='Understanding Performance Nutrition',
                                                 description='Understanding Performance Nutrition',
                                                 parent_sub_category=psr264, format=format_1to4)
    psr273.relationship_types.add(self, athlete_coach, coach_athlete)
    psr274 = AssessmentSubCategory.objects.using(db).create(name='Mental / Psychological',
                                                            description='Mental / Psychological',
                                                            parent_sub_category=psr263)
    psr275 = Assessment.objects.using(db).create(name='Positive Attitude', description='Positive Attitude',
                                                 parent_sub_category=psr274, format=format_1to4)
    psr275.relationship_types.add(self, athlete_coach, coach_athlete)
    psr276 = Assessment.objects.using(db).create(name='Dealing with Setbacks', description='Dealing with Setbacks',
                                                 parent_sub_category=psr274, format=format_1to4)
    psr276.relationship_types.add(self, athlete_coach, coach_athlete)
    psr277 = Assessment.objects.using(db).create(name='Self Motivated', description='Self Motivated',
                                                 parent_sub_category=psr274, format=format_1to4)
    psr277.relationship_types.add(self, athlete_coach, coach_athlete)
    psr278 = Assessment.objects.using(db).create(name='Goal Setting', description='Goal Setting',
                                                 parent_sub_category=psr274, format=format_1to4)
    psr278.relationship_types.add(self, athlete_coach, coach_athlete)
    psr279 = Assessment.objects.using(db).create(name='Positive Self Talk', description='Positive Self Talk',
                                                 parent_sub_category=psr274, format=format_1to4)
    psr279.relationship_types.add(self, athlete_coach, coach_athlete)
    psr280 = Assessment.objects.using(db).create(name='Focus', description='Focus', parent_sub_category=psr274,
                                                 format=format_1to4)
    psr280.relationship_types.add(self, athlete_coach, coach_athlete)
    psr281 = Assessment.objects.using(db).create(name='Leadership', description='Leadership',
                                                 parent_sub_category=psr274, format=format_1to4)
    psr281.relationship_types.add(self, athlete_coach, coach_athlete)
    psr282 = Assessment.objects.using(db).create(name='Work Ethic', description='Work Ethic',
                                                 parent_sub_category=psr274, format=format_1to4)
    psr282.relationship_types.add(self, athlete_coach, coach_athlete)
    psr283 = Assessment.objects.using(db).create(name='Decision Making / Game Sense',
                                                 description='Decision Making / Game Sense', parent_sub_category=psr274,
                                                 format=format_1to4)
    psr283.relationship_types.add(self, athlete_coach, coach_athlete)
    psr284 = AssessmentSubCategory.objects.using(db).create(name='Pacific Sport', description='Pacific Sport',
                                                            parent_top_category=psr199)
    psr285 = AssessmentSubCategory.objects.using(db).create(name='Field Tests', description='Field Tests',
                                                            parent_sub_category=psr284)
    psr286 = Assessment.objects.using(db).create(name='Height', description='Height', parent_sub_category=psr285,
                                                 format=format_cm)
    psr286.relationship_types.add(self, coach_athlete)
    psr287 = Assessment.objects.using(db).create(name='Weight', description='Weight', parent_sub_category=psr285,
                                                 format=format_kg)
    psr287.relationship_types.add(self, coach_athlete)
    psr288 = Assessment.objects.using(db).create(name='Sit & Reach', description='Sit & Reach',
                                                 parent_sub_category=psr285, format=format_cm)
    psr288.relationship_types.add(self, coach_athlete)
    psr289 = Assessment.objects.using(db).create(name='Vertical Jump (counter movement & non-counter movement)',
                                                 description='Vertical Jump (counter movement & non-counter movement)',
                                                 parent_sub_category=psr285, format=format_cm)
    psr289.relationship_types.add(self, coach_athlete)
    psr290 = Assessment.objects.using(db).create(name='T-Test', description='T-Test', parent_sub_category=psr285,
                                                 format=format_sec)
    psr290.relationship_types.add(self, coach_athlete)
    psr291 = Assessment.objects.using(db).create(name='20 m', description='20 m', parent_sub_category=psr285,
                                                 format=format_sec)
    psr291.relationship_types.add(self, coach_athlete)
    psr292 = Assessment.objects.using(db).create(name='Paced Push Ups', description='Paced Push Ups',
                                                 parent_sub_category=psr285, format=format_int)
    psr292.relationship_types.add(self, coach_athlete)
    psr293 = Assessment.objects.using(db).create(name='Prone Bridge (3 min max)',
                                                 description='Prone Bridge (3 min max)', parent_sub_category=psr285,
                                                 format=format_sec)
    psr293.relationship_types.add(self, coach_athlete)
    psr294 = Assessment.objects.using(db).create(name='Beep Test (Leger version)',
                                                 description='Beep Test (Leger version)', parent_sub_category=psr285,
                                                 format=format_int)
    psr294.relationship_types.add(self, coach_athlete)
    psr295 = AssessmentSubCategory.objects.using(db).create(name='Sport Specific Tests',
                                                            description='Sport Specific Tests',
                                                            parent_sub_category=psr284)
    psr296 = Assessment.objects.using(db).create(name='Wingspan (Swimming / Basketball)',
                                                 description='Wingspan (Swimming / Basketball)',
                                                 parent_sub_category=psr295, format=format_cm)
    psr296.relationship_types.add(self, coach_athlete)
    psr297 = Assessment.objects.using(db).create(name='Penta Jumps (double leg / single leg - Alpine)',
                                                 description='Penta Jumps (double leg / single leg - Alpine)',
                                                 parent_sub_category=psr295, format=format_cm)
    psr297.relationship_types.add(self, coach_athlete)
    psr298 = Assessment.objects.using(db).create(name='Box Test (30 sec / 60 sec / 90 sec – Alpine)',
                                                 description='Box Test (30 sec / 60 sec / 90 sec – Alpine)',
                                                 parent_sub_category=psr295, format=format_int)
    psr298.relationship_types.add(self, coach_athlete)
    psr299 = Assessment.objects.using(db).create(name='Broad Jump (Rugby)', description='Broad Jump (Rugby)',
                                                 parent_sub_category=psr295, format=format_cm)
    psr299.relationship_types.add(self, coach_athlete)
    psr300 = Assessment.objects.using(db).create(name='300 yard Shuttle (Rugby)',
                                                 description='300 yard Shuttle (Rugby)', parent_sub_category=psr295,
                                                 format=format_sec)
    psr300.relationship_types.add(self, coach_athlete)
    psr301 = Assessment.objects.using(db).create(name='10 m', description='10 m', parent_sub_category=psr295,
                                                 format=format_sec)
    psr301.relationship_types.add(self, coach_athlete)
    psr302 = Assessment.objects.using(db).create(name='40 m sprint (with 10 m / 30 m split)',
                                                 description='40 m sprint (with 10 m / 30 m split)',
                                                 parent_sub_category=psr295, format=format_sec)
    psr302.relationship_types.add(self, coach_athlete)
    psr303 = Assessment.objects.using(db).create(name='Arrowhead (Soccer)', description='Arrowhead (Soccer)',
                                                 parent_sub_category=psr295, format=format_sec)
    psr303.relationship_types.add(self, coach_athlete)
    psr304 = AssessmentSubCategory.objects.using(db).create(name='Sport School / IGNITE Tests',
                                                            description='Sport School / IGNITE Tests',
                                                            parent_sub_category=psr284)
    psr305 = Assessment.objects.using(db).create(name='Overhead Squat', description='Overhead Squat',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr305.relationship_types.add(self, coach_athlete)
    psr306 = Assessment.objects.using(db).create(name='Lunge Knee / Hip', description='Lunge Knee / Hip',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr306.relationship_types.add(self, coach_athlete)
    psr307 = Assessment.objects.using(db).create(name='Lunge Balance / Control', description='Lunge Balance / Control',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr307.relationship_types.add(self, coach_athlete)
    psr308 = Assessment.objects.using(db).create(name='Single Leg Drop Left Control',
                                                 description='Single Leg Drop Left Control', parent_sub_category=psr304,
                                                 format=format_1to4)
    psr308.relationship_types.add(self, coach_athlete)
    psr309 = Assessment.objects.using(db).create(name='Single Leg Drop Left Landing',
                                                 description='Single Leg Drop Left Landing', parent_sub_category=psr304,
                                                 format=format_1to4)
    psr309.relationship_types.add(self, coach_athlete)
    psr310 = Assessment.objects.using(db).create(name='Single Leg Drop Left Alignment',
                                                 description='Single Leg Drop Left Alignment',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr310.relationship_types.add(self, coach_athlete)
    psr311 = Assessment.objects.using(db).create(name='Single Leg Drop Right Control',
                                                 description='Single Leg Drop Right Control',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr311.relationship_types.add(self, coach_athlete)
    psr312 = Assessment.objects.using(db).create(name='Single Leg Drop Right Landing',
                                                 description='Single Leg Drop Right Landing',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr312.relationship_types.add(self, coach_athlete)
    psr313 = Assessment.objects.using(db).create(name='Single Leg Drop Right Alignment',
                                                 description='Single Leg Drop Right Alignment',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr313.relationship_types.add(self, coach_athlete)
    psr314 = Assessment.objects.using(db).create(name='Inverted Row Alignment', description='Inverted Row Alignment',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr314.relationship_types.add(self, coach_athlete)
    psr315 = Assessment.objects.using(db).create(name='Inverted Row Chest', description='Inverted Row Chest',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr315.relationship_types.add(self, coach_athlete)
    psr316 = Assessment.objects.using(db).create(name='Inverted Row Scapulae', description='Inverted Row Scapulae',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr316.relationship_types.add(self, coach_athlete)
    psr317 = Assessment.objects.using(db).create(name='Pushup Alignment', description='Pushup Alignment',
                                                 parent_sub_category=psr304, format=format_1to4)
    psr317.relationship_types.add(self, coach_athlete)
    psr318 = Assessment.objects.using(db).create(name='Pushup Chest', description='Pushup Chest',
                                                 parent_sub_category=psr304, format=format_int)
    psr318.relationship_types.add(self, coach_athlete)
    psr319 = Assessment.objects.using(db).create(name='Pushup Scapulae', description='Pushup Scapulae',
                                                 parent_sub_category=psr304, format=format_int)
    psr319.relationship_types.add(self, coach_athlete)
    psr320 = Assessment.objects.using(db).create(name='10 m sprint', description='10 m sprint',
                                                 parent_sub_category=psr304, format=format_sec)
    psr320.relationship_types.add(self, coach_athlete)
    psr321 = Assessment.objects.using(db).create(name='30 m sprint', description='30 m sprint',
                                                 parent_sub_category=psr304, format=format_sec)
    psr321.relationship_types.add(self, coach_athlete)
    psr322 = Assessment.objects.using(db).create(name='2 Foot Broad Jump', description='2 Foot Broad Jump',
                                                 parent_sub_category=psr304, format=format_cm)
    psr322.relationship_types.add(self, coach_athlete)
    psr323 = Assessment.objects.using(db).create(name='Left Foot Broad Jump', description='Left Foot Broad Jump',
                                                 parent_sub_category=psr304, format=format_cm)
    psr323.relationship_types.add(self, coach_athlete)
    psr324 = Assessment.objects.using(db).create(name='Right Foot Broad Jump', description='Right Foot Broad Jump',
                                                 parent_sub_category=psr304, format=format_cm)
    psr324.relationship_types.add(self, coach_athlete)
    psr325 = Assessment.objects.using(db).create(name='Standing Reach', description='Standing Reach',
                                                 parent_sub_category=psr304, format=format_cm)
    psr325.relationship_types.add(self, coach_athlete)
    psr326 = Assessment.objects.using(db).create(name='Vertical Jump', description='Vertical Jump',
                                                 parent_sub_category=psr304, format=format_cm)
    psr326.relationship_types.add(self, coach_athlete)
    psr327 = Assessment.objects.using(db).create(name='Med Ball Throw', description='Med Ball Throw',
                                                 parent_sub_category=psr304, format=format_cm)
    psr327.relationship_types.add(self, coach_athlete)
    psr328 = Assessment.objects.using(db).create(name='Sit & Reach', description='Sit & Reach',
                                                 parent_sub_category=psr304, format=format_cm)
    psr328.relationship_types.add(self, coach_athlete)
    psr329 = Assessment.objects.using(db).create(name='Beep Test', description='Beep Test', parent_sub_category=psr304,
                                                 format=format_int)
    psr329.relationship_types.add(self, coach_athlete)
    psr330 = AssessmentSubCategory.objects.using(db).create(name='Fit Body Bootcamp', description='Fit Body Bootcamp',
                                                            parent_top_category=psr199)
    psr331 = AssessmentSubCategory.objects.using(db).create(name='Body Comp', description='Body Comp',
                                                            parent_sub_category=psr330)
    psr332 = Assessment.objects.using(db).create(name='% Body Fat', description='% Body Fat',
                                                 parent_sub_category=psr331, format=format_percents)
    psr332.relationship_types.add(self, coach_athlete)
    psr333 = Assessment.objects.using(db).create(name='Weight', description='Weight', parent_sub_category=psr331,
                                                 format=format_kg)
    psr333.relationship_types.add(self, coach_athlete)
    psr334 = Assessment.objects.using(db).create(name='Chest', description='Chest', parent_sub_category=psr331,
                                                 format=format_cm)
    psr334.relationship_types.add(self, coach_athlete)
    psr335 = Assessment.objects.using(db).create(name='Waist', description='Waist', parent_sub_category=psr331,
                                                 format=format_cm)
    psr335.relationship_types.add(self, coach_athlete)
    psr336 = Assessment.objects.using(db).create(name='Hips', description='Hips', parent_sub_category=psr331,
                                                 format=format_cm)
    psr336.relationship_types.add(self, coach_athlete)
    psr337 = AssessmentSubCategory.objects.using(db).create(name='Strength', description='Strength',
                                                            parent_sub_category=psr330)
    psr338 = Assessment.objects.using(db).create(name='Monthly AMRAP 5mins', description='Monthly AMRAP 5mins',
                                                 parent_sub_category=psr337, format=format_int)
    psr338.relationship_types.add(self, coach_athlete)
    psr339 = Assessment.objects.using(db).create(name='10 Squats', description='10 Squats', parent_sub_category=psr337,
                                                 format=format_kg)
    psr339.relationship_types.add(self, coach_athlete)
    psr340 = Assessment.objects.using(db).create(name='10 Pushups', description='10 Pushups',
                                                 parent_sub_category=psr337, format=format_kg)
    psr340.relationship_types.add(self, coach_athlete)
    psr341 = Assessment.objects.using(db).create(name='10 Crunches', description='10 Crunches',
                                                 parent_sub_category=psr337, format=format_kg)
    psr341.relationship_types.add(self, coach_athlete)
    psr342 = Assessment.objects.using(db).create(name='10 Burpees', description='10 Burpees',
                                                 parent_sub_category=psr337, format=format_kg)
    psr342.relationship_types.add(self, coach_athlete)
    psr343 = AssessmentSubCategory.objects.using(db).create(name='Innovative Fitness', description='Innovative Fitness',
                                                            parent_top_category=psr199)
    psr344 = AssessmentSubCategory.objects.using(db).create(name='Body Comp', description='Body Comp',
                                                            parent_sub_category=psr343)
    psr345 = Assessment.objects.using(db).create(name='Weight', description='Weight', parent_sub_category=psr344,
                                                 format=format_kg)
    psr345.relationship_types.add(self, coach_athlete)
    psr346 = Assessment.objects.using(db).create(name='Height', description='Height', parent_sub_category=psr344,
                                                 format=format_cm)
    psr346.relationship_types.add(self, coach_athlete)
    psr347 = Assessment.objects.using(db).create(name='Waist Girth', description='Waist Girth',
                                                 parent_sub_category=psr344, format=format_cm)
    psr347.relationship_types.add(self, coach_athlete)
    psr348 = Assessment.objects.using(db).create(name='Hip Girth', description='Hip Girth', parent_sub_category=psr344,
                                                 format=format_cm)
    psr348.relationship_types.add(self, coach_athlete)
    psr349 = Assessment.objects.using(db).create(name='Bicep Circumference', description='Bicep Circumference',
                                                 parent_sub_category=psr344, format=format_cm)
    psr349.relationship_types.add(self, coach_athlete)
    psr350 = Assessment.objects.using(db).create(name='Mid Thigh Circumference', description='Mid Thigh Circumference',
                                                 parent_sub_category=psr344, format=format_cm)
    psr350.relationship_types.add(self, coach_athlete)
    psr351 = Assessment.objects.using(db).create(name='Waist to Hip Ratio', description='Waist to Hip Ratio',
                                                 parent_sub_category=psr344, format=format_cm)
    psr351.relationship_types.add(self, coach_athlete)
    psr352 = AssessmentSubCategory.objects.using(db).create(name='Bioimpedance Scale Values',
                                                            description='Bioimpedance Scale Values',
                                                            parent_sub_category=psr343)
    psr353 = Assessment.objects.using(db).create(name='% Body Fat', description='% Body Fat',
                                                 parent_sub_category=psr352, format=format_percents)
    psr353.relationship_types.add(self, coach_athlete)
    psr354 = Assessment.objects.using(db).create(name='Body Fat Mass', description='Body Fat Mass',
                                                 parent_sub_category=psr352, format=format_kg)
    psr354.relationship_types.add(self, coach_athlete)
    psr355 = Assessment.objects.using(db).create(name='Lean Body', description='Lean Body', parent_sub_category=psr352,
                                                 format=format_kg)
    psr355.relationship_types.add(self, coach_athlete)
    psr356 = Assessment.objects.using(db).create(name='Basal Metabolic Rate', description='Basal Metabolic Rate',
                                                 parent_sub_category=psr352, format=format_numb)
    psr356.relationship_types.add(self, coach_athlete)
    psr357 = Assessment.objects.using(db).create(name='Metabolic Age', description='Metabolic Age',
                                                 parent_sub_category=psr352, format=format_numb)
    psr357.relationship_types.add(self, coach_athlete)
    psr358 = AssessmentSubCategory.objects.using(db).create(name='Functional Movement Screen',
                                                            description='Functional Movement Screen',
                                                            parent_sub_category=psr343)
    psr359 = Assessment.objects.using(db).create(name='Deep Squat', description='Deep Squat',
                                                 parent_sub_category=psr358, format=format_1to4)
    psr359.relationship_types.add(self, coach_athlete)
    psr360 = Assessment.objects.using(db).create(name='Hurdle Step', description='Hurdle Step',
                                                 parent_sub_category=psr358, format=format_1to4)
    psr360.relationship_types.add(self, coach_athlete)
    psr361 = Assessment.objects.using(db).create(name='Inline Lunge', description='Inline Lunge',
                                                 parent_sub_category=psr358, format=format_1to4)
    psr361.relationship_types.add(self, coach_athlete)
    psr362 = Assessment.objects.using(db).create(name='Shoulder Mobility', description='Shoulder Mobility',
                                                 parent_sub_category=psr358, format=format_1to4)
    psr362.relationship_types.add(self, coach_athlete)
    psr363 = Assessment.objects.using(db).create(name='Active Straight Leg Raise',
                                                 description='Active Straight Leg Raise', parent_sub_category=psr358,
                                                 format=format_1to4)
    psr363.relationship_types.add(self, coach_athlete)
    psr364 = Assessment.objects.using(db).create(name='Trunk Stability Pushup', description='Trunk Stability Pushup',
                                                 parent_sub_category=psr358, format=format_1to4)
    psr364.relationship_types.add(self, coach_athlete)
    psr365 = Assessment.objects.using(db).create(name='Rotary Stability', description='Rotary Stability',
                                                 parent_sub_category=psr358, format=format_1to4)
    psr365.relationship_types.add(self, coach_athlete)
    psr366 = AssessmentSubCategory.objects.using(db).create(name='Co-Ordination and Agility',
                                                            description='Co-Ordination and Agility',
                                                            parent_sub_category=psr343)
    psr367 = Assessment.objects.using(db).create(name='7 Rung Lateral Ladder Drill',
                                                 description='7 Rung Lateral Ladder Drill', parent_sub_category=psr366,
                                                 format=format_sec)
    psr367.relationship_types.add(self, coach_athlete)
    psr368 = Assessment.objects.using(db).create(name='1 Minute Skipping', description='1 Minute Skipping',
                                                 parent_sub_category=psr366, format=format_numb)
    psr368.relationship_types.add(self, coach_athlete)
    psr369 = AssessmentSubCategory.objects.using(db).create(name='Trunk Stability', description='Trunk Stability',
                                                            parent_sub_category=psr343)
    psr370 = Assessment.objects.using(db).create(name='Timed Front Plank', description='Timed Front Plank',
                                                 parent_sub_category=psr369, format=format_sec)
    psr370.relationship_types.add(self, coach_athlete)
    psr371 = Assessment.objects.using(db).create(name='Straight Leg Drop', description='Straight Leg Drop',
                                                 parent_sub_category=psr369, format=format_degrees)
    psr371.relationship_types.add(self, coach_athlete)
    psr372 = AssessmentSubCategory.objects.using(db).create(name='Muscle Strength / Endurance',
                                                            description='Muscle Strength / Endurance',
                                                            parent_sub_category=psr343)
    psr373 = Assessment.objects.using(db).create(name='Max Number Pushups', description='Max Number Pushups',
                                                 parent_sub_category=psr372, format=format_int)
    psr373.relationship_types.add(self, coach_athlete)
    psr374 = Assessment.objects.using(db).create(name='Max Number Body Weight Squats',
                                                 description='Max Number Body Weight Squats',
                                                 parent_sub_category=psr372, format=format_int)
    psr374.relationship_types.add(self, coach_athlete)
    psr375 = Assessment.objects.using(db).create(name='Max Number Pullup', description='Max Number Pullup',
                                                 parent_sub_category=psr372, format=format_int)
    psr375.relationship_types.add(self, coach_athlete)
    psr376 = AssessmentSubCategory.objects.using(db).create(name='CardioVascular endurance',
                                                            description='CardioVascular endurance',
                                                            parent_sub_category=psr343)
    psr377 = Assessment.objects.using(db).create(name='Bike - 5km Time trial - Men: Lvl 12 / Woman: Lvl 10',
                                                 description='Bike - 5km Time trial - Men: Lvl 12 / Woman: Lvl 10',
                                                 parent_sub_category=psr376, format=format_sec)
    psr377.relationship_types.add(self, coach_athlete)
    psr378 = Assessment.objects.using(db).create(name='Treadmill - 2.4km @ 1%', description='Treadmill - 2.4km @ 1%',
                                                 parent_sub_category=psr376, format=format_sec)
    psr378.relationship_types.add(self, coach_athlete)
    psr379 = Assessment.objects.using(db).create(name='Rowing Erg: 2km @ lvl 6', description='Rowing Erg: 2km @ lvl 6',
                                                 parent_sub_category=psr376, format=format_sec)
    psr379.relationship_types.add(self, coach_athlete)
    psr380 = Assessment.objects.using(db).create(name='20 minute Functional Threshold Power',
                                                 description='20 minute Functional Threshold Power',
                                                 parent_sub_category=psr376, format=format_watts)
    psr380.relationship_types.add(self, coach_athlete)
    psr381 = AssessmentSubCategory.objects.using(db).create(name='Club Advanced Profile',
                                                            description='Club Advanced Profile',
                                                            parent_sub_category=psr343)
    psr382 = Assessment.objects.using(db).create(name='7 Rung Lateral Ladder Drill - toes in and out',
                                                 description='7 Rung Lateral Ladder Drill - toes in and out',
                                                 parent_sub_category=psr381, format=format_sec)
    psr382.relationship_types.add(self, coach_athlete)
    psr383 = Assessment.objects.using(db).create(name='2 Minute Skipping', description='2 Minute Skipping',
                                                 parent_sub_category=psr381, format=format_numb)
    psr383.relationship_types.add(self, coach_athlete)
    psr384 = AssessmentSubCategory.objects.using(db).create(name='Power', description='Power',
                                                            parent_sub_category=psr343)
    psr385 = Assessment.objects.using(db).create(name='Vertical Jump', description='Vertical Jump',
                                                 parent_sub_category=psr384, format=format_cm)
    psr385.relationship_types.add(self, coach_athlete)
    psr386 = AssessmentSubCategory.objects.using(db).create(name='Muscle strength: 10 rep max',
                                                            description='Muscle strength: 10 rep max',
                                                            parent_sub_category=psr343)
    psr387 = Assessment.objects.using(db).create(name='Bench Press', description='Bench Press',
                                                 parent_sub_category=psr386, format=format_kg)
    psr387.relationship_types.add(self, coach_athlete)
    psr388 = Assessment.objects.using(db).create(name='Barbell Back Squat', description='Barbell Back Squat',
                                                 parent_sub_category=psr386, format=format_kg)
    psr388.relationship_types.add(self, coach_athlete)
    psr389 = Assessment.objects.using(db).create(name='Pull ups', description='Pull ups', parent_sub_category=psr386,
                                                 format=format_kg)
    psr389.relationship_types.add(self, coach_athlete)

    # ================== Sports related =================================
    psr400 = AssessmentTopCategory.objects.using(db).create(id=baseball_sport.id, name='Baseball',
                                                            description='Baseball', sport=baseball_sport)
    psr401 = AssessmentSubCategory.objects.using(db).create(name='Baseball: Train to Train',
                                                            description='Baseball: Train to Train',
                                                            parent_top_category=psr400)
    psr402 = AssessmentSubCategory.objects.using(db).create(name='Throwing', description='Throwing',
                                                            parent_sub_category=psr401)
    psr403 = Assessment.objects.using(db).create(name='Proper throwing mechanics',
                                                 description='Proper throwing mechanics', parent_sub_category=psr402,
                                                 format=format_1to4)
    psr403.relationship_types.add(self, coach_athlete)
    psr404 = Assessment.objects.using(db).create(name='Speed', description='Speed', parent_sub_category=psr402,
                                                 format=format_1to4)
    psr404.relationship_types.add(self, coach_athlete)
    psr405 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr402,
                                                 format=format_1to4)
    psr405.relationship_types.add(self, coach_athlete)
    psr406 = AssessmentSubCategory.objects.using(db).create(name='Pitching', description='Pitching',
                                                            parent_sub_category=psr401)
    psr407 = Assessment.objects.using(db).create(name='Speed', description='Speed', parent_sub_category=psr406,
                                                 format=format_1to4)
    psr407.relationship_types.add(self, coach_athlete)
    psr408 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr406,
                                                 format=format_1to4)
    psr408.relationship_types.add(self, coach_athlete)
    psr409 = Assessment.objects.using(db).create(name='Variety', description='Variety', parent_sub_category=psr406,
                                                 format=format_1to4)
    psr409.relationship_types.add(self, coach_athlete)
    psr410 = AssessmentSubCategory.objects.using(db).create(name='Catching', description='Catching',
                                                            parent_sub_category=psr401)
    psr411 = Assessment.objects.using(db).create(name='Proper catching mechanics',
                                                 description='Proper catching mechanics', parent_sub_category=psr410,
                                                 format=format_1to4)
    psr411.relationship_types.add(self, coach_athlete)
    psr412 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr410,
                                                 format=format_1to4)
    psr412.relationship_types.add(self, coach_athlete)
    psr413 = Assessment.objects.using(db).create(name='In motion / dynamic', description='In motion / dynamic',
                                                 parent_sub_category=psr410, format=format_1to4)
    psr413.relationship_types.add(self, coach_athlete)
    psr414 = AssessmentSubCategory.objects.using(db).create(name='Hitting', description='Hitting',
                                                            parent_sub_category=psr401)
    psr415 = Assessment.objects.using(db).create(name='Proper hitting mechanics',
                                                 description='Proper hitting mechanics', parent_sub_category=psr414,
                                                 format=format_1to4)
    psr415.relationship_types.add(self, coach_athlete)
    psr416 = Assessment.objects.using(db).create(name='Power', description='Power', parent_sub_category=psr414,
                                                 format=format_1to4)
    psr416.relationship_types.add(self, coach_athlete)
    psr417 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr414,
                                                 format=format_1to4)
    psr417.relationship_types.add(self, coach_athlete)
    psr418 = AssessmentSubCategory.objects.using(db).create(name='Bunting', description='Bunting',
                                                            parent_sub_category=psr401)
    psr419 = Assessment.objects.using(db).create(name='Proper bunting mechanics',
                                                 description='Proper bunting mechanics', parent_sub_category=psr418,
                                                 format=format_1to4)
    psr419.relationship_types.add(self, coach_athlete)
    psr420 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr418,
                                                 format=format_1to4)
    psr420.relationship_types.add(self, coach_athlete)
    psr421 = Assessment.objects.using(db).create(name='Consistency', description='Consistency',
                                                 parent_sub_category=psr418, format=format_1to4)
    psr421.relationship_types.add(self, coach_athlete)
    psr422 = AssessmentSubCategory.objects.using(db).create(name='Fielding', description='Fielding',
                                                            parent_sub_category=psr401)
    psr423 = Assessment.objects.using(db).create(name='Transition from Defense to Offense',
                                                 description='Transition from Defense to Offense',
                                                 parent_sub_category=psr422, format=format_1to4)
    psr423.relationship_types.add(self, coach_athlete)
    psr424 = Assessment.objects.using(db).create(name='Accuracy & Consistency', description='Accuracy & Consistency',
                                                 parent_sub_category=psr422, format=format_1to4)
    psr424.relationship_types.add(self, coach_athlete)
    psr425 = Assessment.objects.using(db).create(name='Positioning', description='Positioning',
                                                 parent_sub_category=psr422, format=format_1to4)
    psr425.relationship_types.add(self, coach_athlete)
    psr426 = AssessmentSubCategory.objects.using(db).create(name='Running', description='Running',
                                                            parent_sub_category=psr401)
    psr427 = Assessment.objects.using(db).create(name='Speed', description='Speed', parent_sub_category=psr426,
                                                 format=format_1to4)
    psr427.relationship_types.add(self, coach_athlete)
    psr428 = Assessment.objects.using(db).create(name='On Bases / Decision Making',
                                                 description='On Bases / Decision Making', parent_sub_category=psr426,
                                                 format=format_1to4)
    psr428.relationship_types.add(self, coach_athlete)
    psr429 = Assessment.objects.using(db).create(name='In Field of Play / Decision Making',
                                                 description='In Field of Play / Decision Making',
                                                 parent_sub_category=psr426, format=format_1to4)
    psr429.relationship_types.add(self, coach_athlete)
    psr430 = AssessmentSubCategory.objects.using(db).create(name='Position and Movement',
                                                            description='Position and Movement',
                                                            parent_sub_category=psr401)
    psr431 = Assessment.objects.using(db).create(name='Situation Based Positioning',
                                                 description='Situation Based Positioning', parent_sub_category=psr430,
                                                 format=format_1to4)
    psr431.relationship_types.add(self, coach_athlete)
    psr432 = Assessment.objects.using(db).create(name='Movement Based on Offensive Play',
                                                 description='Movement Based on Offensive Play',
                                                 parent_sub_category=psr430, format=format_1to4)
    psr432.relationship_types.add(self, coach_athlete)
    psr433 = Assessment.objects.using(db).create(name='Movement Based on Defensive Need',
                                                 description='Movement Based on Defensive Need',
                                                 parent_sub_category=psr430, format=format_1to4)
    psr433.relationship_types.add(self, coach_athlete)
    psr434 = AssessmentTopCategory.objects.using(db).create(id=basketball_sport.id, name='Basketball',
                                                            description='Basketball', sport=basketball_sport)
    psr435 = AssessmentSubCategory.objects.using(db).create(name='Basketball: Train to Train',
                                                            description='Basketball: Train to Train',
                                                            parent_top_category=psr434)
    psr436 = AssessmentSubCategory.objects.using(db).create(name='Speed', description='Speed',
                                                            parent_sub_category=psr435)
    psr437 = Assessment.objects.using(db).create(name='Without ball', description='Without ball',
                                                 parent_sub_category=psr436, format=format_1to4)
    psr437.relationship_types.add(self, coach_athlete)
    psr438 = Assessment.objects.using(db).create(name='With ball', description='With ball', parent_sub_category=psr436,
                                                 format=format_1to4)
    psr438.relationship_types.add(self, coach_athlete)
    psr439 = Assessment.objects.using(db).create(name='Quickness & Agility', description='Quickness & Agility',
                                                 parent_sub_category=psr436, format=format_1to4)
    psr439.relationship_types.add(self, coach_athlete)
    psr440 = AssessmentSubCategory.objects.using(db).create(name='Dribbling', description='Dribbling',
                                                            parent_sub_category=psr435)
    psr441 = Assessment.objects.using(db).create(name='Ball control', description='Ball control',
                                                 parent_sub_category=psr440, format=format_1to4)
    psr441.relationship_types.add(self, coach_athlete)
    psr442 = Assessment.objects.using(db).create(name='In traffic', description='In traffic',
                                                 parent_sub_category=psr440, format=format_1to4)
    psr442.relationship_types.add(self, coach_athlete)
    psr443 = Assessment.objects.using(db).create(name='Ambidextrous', description='Ambidextrous',
                                                 parent_sub_category=psr440, format=format_1to4)
    psr443.relationship_types.add(self, coach_athlete)
    psr444 = AssessmentSubCategory.objects.using(db).create(name='Passing', description='Passing',
                                                            parent_sub_category=psr435)
    psr445 = Assessment.objects.using(db).create(name='Proper passing mechanics',
                                                 description='Proper passing mechanics', parent_sub_category=psr444,
                                                 format=format_1to4)
    psr445.relationship_types.add(self, coach_athlete)
    psr446 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr444,
                                                 format=format_1to4)
    psr446.relationship_types.add(self, coach_athlete)
    psr447 = Assessment.objects.using(db).create(name='Creativity / Appropriateness in play',
                                                 description='Creativity / Appropriateness in play',
                                                 parent_sub_category=psr444, format=format_1to4)
    psr447.relationship_types.add(self, coach_athlete)
    psr448 = AssessmentSubCategory.objects.using(db).create(name='Shooting', description='Shooting',
                                                            parent_sub_category=psr435)
    psr449 = Assessment.objects.using(db).create(name='Proper Shooting Mechanics',
                                                 description='Proper Shooting Mechanics', parent_sub_category=psr448,
                                                 format=format_1to4)
    psr449.relationship_types.add(self, coach_athlete)
    psr450 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr448,
                                                 format=format_1to4)
    psr450.relationship_types.add(self, coach_athlete)
    psr451 = Assessment.objects.using(db).create(name='Range', description='Range', parent_sub_category=psr448,
                                                 format=format_1to4)
    psr451.relationship_types.add(self, coach_athlete)
    psr452 = AssessmentSubCategory.objects.using(db).create(name='1v1 Offense', description='1v1 Offense',
                                                            parent_sub_category=psr435)
    psr453 = Assessment.objects.using(db).create(name='Creativity / Deception with Moves',
                                                 description='Creativity / Deception with Moves',
                                                 parent_sub_category=psr452, format=format_1to4)
    psr453.relationship_types.add(self, coach_athlete)
    psr454 = Assessment.objects.using(db).create(name='Determination / Thread with Speed',
                                                 description='Determination / Thread with Speed',
                                                 parent_sub_category=psr452, format=format_1to4)
    psr454.relationship_types.add(self, coach_athlete)
    psr455 = Assessment.objects.using(db).create(name='Change of Pace / Direction',
                                                 description='Change of Pace / Direction', parent_sub_category=psr452,
                                                 format=format_1to4)
    psr455.relationship_types.add(self, coach_athlete)
    psr456 = AssessmentSubCategory.objects.using(db).create(name='1v1 Defense', description='1v1 Defense',
                                                            parent_sub_category=psr435)
    psr457 = Assessment.objects.using(db).create(name='Positioning in Defensive End',
                                                 description='Positioning in Defensive End', parent_sub_category=psr456,
                                                 format=format_1to4)
    psr457.relationship_types.add(self, coach_athlete)
    psr458 = Assessment.objects.using(db).create(name='Body Control in Defensive End',
                                                 description='Body Control in Defensive End',
                                                 parent_sub_category=psr456, format=format_1to4)
    psr458.relationship_types.add(self, coach_athlete)
    psr459 = Assessment.objects.using(db).create(name='Transition to Offense', description='Transition to Offense',
                                                 parent_sub_category=psr456, format=format_1to4)
    psr459.relationship_types.add(self, coach_athlete)
    psr460 = AssessmentSubCategory.objects.using(db).create(name='Positioning and movement',
                                                            description='Positioning and movement',
                                                            parent_sub_category=psr435)
    psr461 = Assessment.objects.using(db).create(name='During Offensive Sets', description='During Offensive Sets',
                                                 parent_sub_category=psr460, format=format_1to4)
    psr461.relationship_types.add(self, coach_athlete)
    psr462 = Assessment.objects.using(db).create(name='During Defensive Sets', description='During Defensive Sets',
                                                 parent_sub_category=psr460, format=format_1to4)
    psr462.relationship_types.add(self, coach_athlete)
    psr463 = Assessment.objects.using(db).create(name='In Transition', description='In Transition',
                                                 parent_sub_category=psr460, format=format_1to4)
    psr463.relationship_types.add(self, coach_athlete)
    psr464 = AssessmentTopCategory.objects.using(db).create(id=hockey_sport.id, name='Hockey', description='Hockey',
                                                            sport=hockey_sport)
    psr465 = AssessmentSubCategory.objects.using(db).create(name='Hockey: Train to Train',
                                                            description='Hockey: Train to Train',
                                                            parent_top_category=psr464)
    psr466 = AssessmentSubCategory.objects.using(db).create(name='Skating', description='Skating',
                                                            parent_sub_category=psr465)
    psr467 = Assessment.objects.using(db).create(name='Speed & Acceleration', description='Speed & Acceleration',
                                                 parent_sub_category=psr466, format=format_1to4)
    psr467.relationship_types.add(self, coach_athlete)
    psr468 = Assessment.objects.using(db).create(name='Change of Pace & Direction',
                                                 description='Change of Pace & Direction', parent_sub_category=psr466,
                                                 format=format_1to4)
    psr468.relationship_types.add(self, coach_athlete)
    psr469 = Assessment.objects.using(db).create(name='Control / Mobility / Agility',
                                                 description='Control / Mobility / Agility', parent_sub_category=psr466,
                                                 format=format_1to4)
    psr469.relationship_types.add(self, coach_athlete)
    psr470 = AssessmentSubCategory.objects.using(db).create(name='Passing', description='Passing',
                                                            parent_sub_category=psr465)
    psr471 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr470,
                                                 format=format_1to4)
    psr471.relationship_types.add(self, coach_athlete)
    psr472 = Assessment.objects.using(db).create(name='Velocity', description='Velocity', parent_sub_category=psr470,
                                                 format=format_1to4)
    psr472.relationship_types.add(self, coach_athlete)
    psr473 = Assessment.objects.using(db).create(name='Creativity', description='Creativity',
                                                 parent_sub_category=psr470, format=format_1to4)
    psr473.relationship_types.add(self, coach_athlete)
    psr474 = AssessmentSubCategory.objects.using(db).create(name='Recieving', description='Recieving',
                                                            parent_sub_category=psr465)
    psr475 = Assessment.objects.using(db).create(name='Forehand', description='Forehand', parent_sub_category=psr474,
                                                 format=format_1to4)
    psr475.relationship_types.add(self, coach_athlete)
    psr476 = Assessment.objects.using(db).create(name='Backhand', description='Backhand', parent_sub_category=psr474,
                                                 format=format_1to4)
    psr476.relationship_types.add(self, coach_athlete)
    psr477 = Assessment.objects.using(db).create(name='Target & Timing', description='Target & Timing',
                                                 parent_sub_category=psr474, format=format_1to4)
    psr477.relationship_types.add(self, coach_athlete)
    psr478 = AssessmentSubCategory.objects.using(db).create(name='Puck handling', description='Puck handling',
                                                            parent_sub_category=psr465)
    psr479 = Assessment.objects.using(db).create(name='Head Up', description='Head Up', parent_sub_category=psr478,
                                                 format=format_1to4)
    psr479.relationship_types.add(self, coach_athlete)
    psr480 = Assessment.objects.using(db).create(name='Good Hands', description='Good Hands',
                                                 parent_sub_category=psr478, format=format_1to4)
    psr480.relationship_types.add(self, coach_athlete)
    psr481 = Assessment.objects.using(db).create(name='Quickness & Deception', description='Quickness & Deception',
                                                 parent_sub_category=psr478, format=format_1to4)
    psr481.relationship_types.add(self, coach_athlete)
    psr482 = AssessmentSubCategory.objects.using(db).create(name='Shooting', description='Shooting',
                                                            parent_sub_category=psr465)
    psr483 = Assessment.objects.using(db).create(name='Power', description='Power', parent_sub_category=psr482,
                                                 format=format_1to4)
    psr483.relationship_types.add(self, coach_athlete)
    psr484 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr482,
                                                 format=format_1to4)
    psr484.relationship_types.add(self, coach_athlete)
    psr485 = Assessment.objects.using(db).create(name='Quick Release', description='Quick Release',
                                                 parent_sub_category=psr482, format=format_1to4)
    psr485.relationship_types.add(self, coach_athlete)
    psr486 = Assessment.objects.using(db).create(name='Static & Dynamic', description='Static & Dynamic',
                                                 parent_sub_category=psr482, format=format_1to4)
    psr486.relationship_types.add(self, coach_athlete)
    psr487 = AssessmentSubCategory.objects.using(db).create(name='Checking', description='Checking',
                                                            parent_sub_category=psr465)
    psr488 = Assessment.objects.using(db).create(name='Strength & Power', description='Strength & Power',
                                                 parent_sub_category=psr487, format=format_1to4)
    psr488.relationship_types.add(self, coach_athlete)
    psr489 = Assessment.objects.using(db).create(name='Body Position & Control', description='Body Position & Control',
                                                 parent_sub_category=psr487, format=format_1to4)
    psr489.relationship_types.add(self, coach_athlete)
    psr490 = Assessment.objects.using(db).create(name='Win / Lose 1v1 Battles', description='Win / Lose 1v1 Battles',
                                                 parent_sub_category=psr487, format=format_1to4)
    psr490.relationship_types.add(self, coach_athlete)
    psr491 = AssessmentSubCategory.objects.using(db).create(name='1v1 Offense', description='1v1 Offense',
                                                            parent_sub_category=psr465)
    psr492 = Assessment.objects.using(db).create(name='Creativity / Deception with Moves',
                                                 description='Creativity / Deception with Moves',
                                                 parent_sub_category=psr491, format=format_1to4)
    psr492.relationship_types.add(self, coach_athlete)
    psr493 = Assessment.objects.using(db).create(name='Determination / Thread with Speed',
                                                 description='Determination / Thread with Speed',
                                                 parent_sub_category=psr491, format=format_1to4)
    psr493.relationship_types.add(self, coach_athlete)
    psr494 = Assessment.objects.using(db).create(name='Change of Pace / Direction',
                                                 description='Change of Pace / Direction', parent_sub_category=psr491,
                                                 format=format_1to4)
    psr494.relationship_types.add(self, coach_athlete)
    psr495 = AssessmentSubCategory.objects.using(db).create(name='1v1 Defense', description='1v1 Defense',
                                                            parent_sub_category=psr465)
    psr496 = Assessment.objects.using(db).create(name='Positioning / Gap Control / Defensive End',
                                                 description='Positioning / Gap Control / Defensive End',
                                                 parent_sub_category=psr495, format=format_1to4)
    psr496.relationship_types.add(self, coach_athlete)
    psr497 = Assessment.objects.using(db).create(name='1v1 Battles (Small Area / Front of Net)',
                                                 description='1v1 Battles (Small Area / Front of Net)',
                                                 parent_sub_category=psr495, format=format_1to4)
    psr497.relationship_types.add(self, coach_athlete)
    psr498 = Assessment.objects.using(db).create(name='Play @ Offensive Side', description='Play @ Offensive Side',
                                                 parent_sub_category=psr495, format=format_1to4)
    psr498.relationship_types.add(self, coach_athlete)
    psr499 = AssessmentSubCategory.objects.using(db).create(name='Hockey Goaltender: Train to Train',
                                                            description='Hockey Goaltender: Train to Train',
                                                            parent_top_category=psr464)
    psr500 = AssessmentSubCategory.objects.using(db).create(name='Stance', description='Stance',
                                                            parent_sub_category=psr499)
    psr501 = Assessment.objects.using(db).create(
        name='Utilizes proper bend in knees and hips with shoulders front of hips',
        description='Utilizes proper bend in knees and hips with shoulders front of hips', parent_sub_category=psr500,
        format=format_1to4)
    psr501.relationship_types.add(self, coach_athlete)
    psr502 = Assessment.objects.using(db).create(
        name='Maintains stablitiy in hands keeping them front of body for full mobility',
        description='Maintains stablitiy in hands keeping them front of body for full mobility',
        parent_sub_category=psr500, format=format_1to4)
    psr502.relationship_types.add(self, coach_athlete)
    psr503 = Assessment.objects.using(db).create(name='Proper head Angle for trajectory of puck',
                                                 description='Proper head Angle for trajectory of puck',
                                                 parent_sub_category=psr500, format=format_1to4)
    psr503.relationship_types.add(self, coach_athlete)
    psr504 = AssessmentSubCategory.objects.using(db).create(name='Low Shots', description='Low Shots',
                                                            parent_sub_category=psr499)
    psr505 = Assessment.objects.using(db).create(name='Butterfly technique (compact / square)',
                                                 description='Butterfly technique (compact / square)',
                                                 parent_sub_category=psr504, format=format_1to4)
    psr505.relationship_types.add(self, coach_athlete)
    psr506 = Assessment.objects.using(db).create(name='Rebound control: off stick and pads',
                                                 description='Rebound control: off stick and pads',
                                                 parent_sub_category=psr504, format=format_1to4)
    psr506.relationship_types.add(self, coach_athlete)
    psr507 = Assessment.objects.using(db).create(name='Ability to butterfly at Appropriate time',
                                                 description='Ability to butterfly at Appropriate time',
                                                 parent_sub_category=psr504, format=format_1to4)
    psr507.relationship_types.add(self, coach_athlete)
    psr508 = AssessmentSubCategory.objects.using(db).create(name='High Shots', description='High Shots',
                                                            parent_sub_category=psr499)
    psr509 = Assessment.objects.using(db).create(name='Rebound control: blocker',
                                                 description='Rebound control: blocker', parent_sub_category=psr508,
                                                 format=format_1to4)
    psr509.relationship_types.add(self, coach_athlete)
    psr510 = Assessment.objects.using(db).create(name='Rebound control: catcher',
                                                 description='Rebound control: catcher', parent_sub_category=psr508,
                                                 format=format_1to4)
    psr510.relationship_types.add(self, coach_athlete)
    psr511 = Assessment.objects.using(db).create(name='Rebound control: chest', description='Rebound control: chest',
                                                 parent_sub_category=psr508, format=format_1to4)
    psr511.relationship_types.add(self, coach_athlete)
    psr512 = AssessmentSubCategory.objects.using(db).create(name='Use of Stick', description='Use of Stick',
                                                            parent_sub_category=psr499)
    psr513 = Assessment.objects.using(db).create(name='Passing / clearing', description='Passing / clearing',
                                                 parent_sub_category=psr512, format=format_1to4)
    psr513.relationship_types.add(self, coach_athlete)
    psr514 = Assessment.objects.using(db).create(name='Puck playing Ability', description='Puck playing Ability',
                                                 parent_sub_category=psr512, format=format_1to4)
    psr514.relationship_types.add(self, coach_athlete)
    psr515 = AssessmentSubCategory.objects.using(db).create(name='Positioning & Angles',
                                                            description='Positioning & Angles',
                                                            parent_sub_category=psr499)
    psr516 = Assessment.objects.using(db).create(name='Knows position at all times',
                                                 description='Knows position at all times', parent_sub_category=psr515,
                                                 format=format_1to4)
    psr516.relationship_types.add(self, coach_athlete)
    psr517 = Assessment.objects.using(db).create(name='Assumes neutral position at top edge of crease',
                                                 description='Assumes neutral position at top edge of crease',
                                                 parent_sub_category=psr515, format=format_1to4)
    psr517.relationship_types.add(self, coach_athlete)
    psr518 = Assessment.objects.using(db).create(name='Positions self properly prior to shot',
                                                 description='Positions self properly prior to shot',
                                                 parent_sub_category=psr515, format=format_1to4)
    psr518.relationship_types.add(self, coach_athlete)
    psr519 = Assessment.objects.using(db).create(name='Lines up properly on puck',
                                                 description='Lines up properly on puck', parent_sub_category=psr515,
                                                 format=format_1to4)
    psr519.relationship_types.add(self, coach_athlete)
    psr520 = AssessmentSubCategory.objects.using(db).create(name='Deflections & Screen Shots',
                                                            description='Deflections & Screen Shots',
                                                            parent_sub_category=psr499)
    psr521 = Assessment.objects.using(db).create(name='Ability to locate potential shooters',
                                                 description='Ability to locate potential shooters',
                                                 parent_sub_category=psr520, format=format_1to4)
    psr521.relationship_types.add(self, coach_athlete)
    psr522 = Assessment.objects.using(db).create(name='Position with respect to potential deflectors',
                                                 description='Position with respect to potential deflectors',
                                                 parent_sub_category=psr520, format=format_1to4)
    psr522.relationship_types.add(self, coach_athlete)
    psr523 = Assessment.objects.using(db).create(name='Works hard to find puck', description='Works hard to find puck',
                                                 parent_sub_category=psr520, format=format_1to4)
    psr523.relationship_types.add(self, coach_athlete)
    psr524 = AssessmentSubCategory.objects.using(db).create(name='Play at Posts', description='Play at Posts',
                                                            parent_sub_category=psr499)
    psr525 = Assessment.objects.using(db).create(name='Position self properly (play behind net / corner)',
                                                 description='Position self properly (play behind net / corner)',
                                                 parent_sub_category=psr524, format=format_1to4)
    psr525.relationship_types.add(self, coach_athlete)
    psr526 = Assessment.objects.using(db).create(name='Utilizes learned techniques for tight angle plays',
                                                 description='Utilizes learned techniques for tight angle plays',
                                                 parent_sub_category=psr524, format=format_1to4)
    psr526.relationship_types.add(self, coach_athlete)
    psr527 = Assessment.objects.using(db).create(name='Lateral mobility-post to post movement',
                                                 description='Lateral mobility-post to post movement',
                                                 parent_sub_category=psr524, format=format_1to4)
    psr527.relationship_types.add(self, coach_athlete)
    psr528 = AssessmentSubCategory.objects.using(db).create(name='Concentration', description='Concentration',
                                                            parent_sub_category=psr499)
    psr529 = Assessment.objects.using(db).create(name='Alert at all times', description='Alert at all times',
                                                 parent_sub_category=psr528, format=format_1to4)
    psr529.relationship_types.add(self, coach_athlete)
    psr530 = Assessment.objects.using(db).create(name='Follows puck at all times',
                                                 description='Follows puck at all times', parent_sub_category=psr528,
                                                 format=format_1to4)
    psr530.relationship_types.add(self, coach_athlete)
    psr531 = Assessment.objects.using(db).create(name='Maintains conc. despite bad plays/early goals',
                                                 description='Maintains conc. despite bad plays/early goals',
                                                 parent_sub_category=psr528, format=format_1to4)
    psr531.relationship_types.add(self, coach_athlete)
    psr532 = AssessmentSubCategory.objects.using(db).create(name='Confidence', description='Confidence',
                                                            parent_sub_category=psr499)
    psr533 = Assessment.objects.using(db).create(name='Displays an ‘in charge’ attitude',
                                                 description='Displays an ‘in charge’ attitude',
                                                 parent_sub_category=psr532, format=format_1to4)
    psr533.relationship_types.add(self, coach_athlete)
    psr534 = Assessment.objects.using(db).create(name='Understanding and implimentation of positive self-talk',
                                                 description='Understanding and implimentation of positive self-talk',
                                                 parent_sub_category=psr532, format=format_1to4)
    psr534.relationship_types.add(self, coach_athlete)
    psr535 = Assessment.objects.using(db).create(name='Positive mental attitude at all times',
                                                 description='Positive mental attitude at all times',
                                                 parent_sub_category=psr532, format=format_1to4)
    psr535.relationship_types.add(self, coach_athlete)
    psr536 = AssessmentSubCategory.objects.using(db).create(name='Communication', description='Communication',
                                                            parent_sub_category=psr499)
    psr537 = Assessment.objects.using(db).create(name='Communicates with teammates on and off the ice',
                                                 description='Communicates with teammates on and off the ice',
                                                 parent_sub_category=psr536, format=format_1to4)
    psr537.relationship_types.add(self, coach_athlete)
    psr538 = Assessment.objects.using(db).create(
        name='Uses standardized glossary of play commands - Move it/Man on/etc.',
        description='Uses standardized glossary of play commands - Move it/Man on/etc.', parent_sub_category=psr536,
        format=format_1to4)
    psr538.relationship_types.add(self, coach_athlete)
    psr539 = AssessmentSubCategory.objects.using(db).create(name='Hand-eye Coordination',
                                                            description='Hand-eye Coordination',
                                                            parent_sub_category=psr499)
    psr540 = Assessment.objects.using(db).create(name='Has ability to perform static hand-eye drills',
                                                 description='Has ability to perform static hand-eye drills',
                                                 parent_sub_category=psr539, format=format_1to4)
    psr540.relationship_types.add(self, coach_athlete)
    psr541 = Assessment.objects.using(db).create(name='Dynamic hand-eye drills', description='Dynamic hand-eye drills',
                                                 parent_sub_category=psr539, format=format_1to4)
    psr541.relationship_types.add(self, coach_athlete)
    psr542 = Assessment.objects.using(db).create(name='Maintains proper athletic stance when training',
                                                 description='Maintains proper athletic stance when training',
                                                 parent_sub_category=psr539, format=format_1to4)
    psr542.relationship_types.add(self, coach_athlete)
    psr543 = AssessmentSubCategory.objects.using(db).create(name='Static Vision Skills',
                                                            description='Static Vision Skills',
                                                            parent_sub_category=psr499)
    psr544 = Assessment.objects.using(db).create(name='Quiet Eye - Keeps eyes on puck before shot release',
                                                 description='Quiet Eye - Keeps eyes on puck before shot release',
                                                 parent_sub_category=psr543, format=format_1to4)
    psr544.relationship_types.add(self, coach_athlete)
    psr545 = Assessment.objects.using(db).create(name='Maintains proper head positioning for optimal gaze data intake',
                                                 description='Maintains proper head positioning for optimal gaze data intake',
                                                 parent_sub_category=psr543, format=format_1to4)
    psr545.relationship_types.add(self, coach_athlete)
    psr546 = Assessment.objects.using(db).create(
        name='Contract Sensitivity - Ability to track puck through like-coloured screens (black/black / white/white)',
        description='Contract Sensitivity - Ability to track puck through like-coloured screens (black/black / white/white)',
        parent_sub_category=psr543, format=format_1to4)
    psr546.relationship_types.add(self, coach_athlete)
    psr547 = AssessmentSubCategory.objects.using(db).create(name='Dynamic Vision Skills',
                                                            description='Dynamic Vision Skills',
                                                            parent_sub_category=psr499)
    psr548 = Assessment.objects.using(db).create(
        name='Vergence Systems - Convergence/Divergence eye working together to focus near/far',
        description='Vergence Systems - Convergence/Divergence eye working together to focus near/far',
        parent_sub_category=psr547, format=format_1to4)
    psr548.relationship_types.add(self, coach_athlete)
    psr549 = Assessment.objects.using(db).create(name='Smooth Pursuit - continuous focus on moving target',
                                                 description='Smooth Pursuit - continuous focus on moving target',
                                                 parent_sub_category=psr547, format=format_1to4)
    psr549.relationship_types.add(self, coach_athlete)
    psr550 = Assessment.objects.using(db).create(name='Saccades - Rapid eye movements between two points',
                                                 description='Saccades - Rapid eye movements between two points',
                                                 parent_sub_category=psr547, format=format_1to4)
    psr550.relationship_types.add(self, coach_athlete)
    psr551 = AssessmentSubCategory.objects.using(db).create(name='Balance', description='Balance',
                                                            parent_sub_category=psr499)
    psr552 = Assessment.objects.using(db).create(name='Retains ready position after blocking shots',
                                                 description='Retains ready position after blocking shots',
                                                 parent_sub_category=psr551, format=format_1to4)
    psr552.relationship_types.add(self, coach_athlete)
    psr553 = Assessment.objects.using(db).create(name='Holds ready position in movement',
                                                 description='Holds ready position in movement',
                                                 parent_sub_category=psr551, format=format_1to4)
    psr553.relationship_types.add(self, coach_athlete)
    psr554 = Assessment.objects.using(db).create(name='Recovery (retains position after scrambling)',
                                                 description='Recovery (retains position after scrambling)',
                                                 parent_sub_category=psr551, format=format_1to4)
    psr554.relationship_types.add(self, coach_athlete)
    psr555 = AssessmentSubCategory.objects.using(db).create(name='Mobility', description='Mobility',
                                                            parent_sub_category=psr499)
    psr556 = Assessment.objects.using(db).create(name='Skating ability', description='Skating ability',
                                                 parent_sub_category=psr555, format=format_1to4)
    psr556.relationship_types.add(self, coach_athlete)
    psr557 = Assessment.objects.using(db).create(name='Reacts well to puck movement in zone',
                                                 description='Reacts well to puck movement in zone',
                                                 parent_sub_category=psr555, format=format_1to4)
    psr557.relationship_types.add(self, coach_athlete)
    psr558 = Assessment.objects.using(db).create(name='Ability to recover from knees / side',
                                                 description='Ability to recover from knees / side',
                                                 parent_sub_category=psr555, format=format_1to4)
    psr558.relationship_types.add(self, coach_athlete)
    psr559 = AssessmentSubCategory.objects.using(db).create(name='Quickness', description='Quickness',
                                                            parent_sub_category=psr499)
    psr560 = Assessment.objects.using(db).create(name='Reacts well to quick untelegraphed shots',
                                                 description='Reacts well to quick untelegraphed shots',
                                                 parent_sub_category=psr559, format=format_1to4)
    psr560.relationship_types.add(self, coach_athlete)
    psr561 = Assessment.objects.using(db).create(name='Effective in close', description='Effective in close',
                                                 parent_sub_category=psr559, format=format_1to4)
    psr561.relationship_types.add(self, coach_athlete)
    psr562 = Assessment.objects.using(db).create(name='Relaxed movements and reaction time',
                                                 description='Relaxed movements and reaction time',
                                                 parent_sub_category=psr559, format=format_1to4)
    psr562.relationship_types.add(self, coach_athlete)
    psr563 = AssessmentTopCategory.objects.using(db).create(id=soccer_sport.id, name='Soccer', description='Soccer',
                                                            sport=soccer_sport)
    psr564 = AssessmentSubCategory.objects.using(db).create(name='Soccer: Train to Train (Ages 12-16)',
                                                            description='Soccer: Train to Train (Ages 12-16)',
                                                            parent_top_category=psr563)
    psr565 = AssessmentSubCategory.objects.using(db).create(name='Speed', description='Speed',
                                                            parent_sub_category=psr564)
    psr566 = Assessment.objects.using(db).create(name='Without Ball', description='Without Ball',
                                                 parent_sub_category=psr565, format=format_1to4)
    psr566.relationship_types.add(self, coach_athlete)
    psr567 = Assessment.objects.using(db).create(name='With Ball', description='With Ball', parent_sub_category=psr565,
                                                 format=format_1to4)
    psr567.relationship_types.add(self, coach_athlete)
    psr568 = Assessment.objects.using(db).create(name='Quickness & Agility', description='Quickness & Agility',
                                                 parent_sub_category=psr565, format=format_1to4)
    psr568.relationship_types.add(self, coach_athlete)
    psr569 = AssessmentSubCategory.objects.using(db).create(name='Passing', description='Passing',
                                                            parent_sub_category=psr564)
    psr570 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr569,
                                                 format=format_1to4)
    psr570.relationship_types.add(self, coach_athlete)
    psr571 = Assessment.objects.using(db).create(name='Velocity', description='Velocity', parent_sub_category=psr569,
                                                 format=format_1to4)
    psr571.relationship_types.add(self, coach_athlete)
    psr572 = Assessment.objects.using(db).create(name='Foot Control', description='Foot Control',
                                                 parent_sub_category=psr569, format=format_1to4)
    psr572.relationship_types.add(self, coach_athlete)
    psr573 = Assessment.objects.using(db).create(name='Creativity', description='Creativity',
                                                 parent_sub_category=psr569, format=format_1to4)
    psr573.relationship_types.add(self, coach_athlete)
    psr574 = AssessmentSubCategory.objects.using(db).create(name='Recieving', description='Recieving',
                                                            parent_sub_category=psr564)
    psr575 = Assessment.objects.using(db).create(name='1 Touch', description='1 Touch', parent_sub_category=psr574,
                                                 format=format_1to4)
    psr575.relationship_types.add(self, coach_athlete)
    psr576 = Assessment.objects.using(db).create(name='Foot Control', description='Foot Control',
                                                 parent_sub_category=psr574, format=format_1to4)
    psr576.relationship_types.add(self, coach_athlete)
    psr577 = Assessment.objects.using(db).create(name='Ambidextrous', description='Ambidextrous',
                                                 parent_sub_category=psr574, format=format_1to4)
    psr577.relationship_types.add(self, coach_athlete)
    psr578 = AssessmentSubCategory.objects.using(db).create(name='Ball Control', description='Ball Control',
                                                            parent_sub_category=psr564)
    psr579 = Assessment.objects.using(db).create(name='Head / Chest / Thigh to Feet',
                                                 description='Head / Chest / Thigh to Feet', parent_sub_category=psr578,
                                                 format=format_1to4)
    psr579.relationship_types.add(self, coach_athlete)
    psr580 = Assessment.objects.using(db).create(name='In Space', description='In Space', parent_sub_category=psr578,
                                                 format=format_1to4)
    psr580.relationship_types.add(self, coach_athlete)
    psr581 = Assessment.objects.using(db).create(name='In Traffic', description='In Traffic',
                                                 parent_sub_category=psr578, format=format_1to4)
    psr581.relationship_types.add(self, coach_athlete)
    psr582 = AssessmentSubCategory.objects.using(db).create(name='Striking', description='Striking',
                                                            parent_sub_category=psr564)
    psr583 = Assessment.objects.using(db).create(name='Ambidextrous', description='Ambidextrous',
                                                 parent_sub_category=psr582, format=format_1to4)
    psr583.relationship_types.add(self, coach_athlete)
    psr584 = Assessment.objects.using(db).create(name='Accuracy', description='Accuracy', parent_sub_category=psr582,
                                                 format=format_1to4)
    psr584.relationship_types.add(self, coach_athlete)
    psr585 = Assessment.objects.using(db).create(name='Power', description='Power', parent_sub_category=psr582,
                                                 format=format_1to4)
    psr585.relationship_types.add(self, coach_athlete)
    psr586 = AssessmentSubCategory.objects.using(db).create(name='Checking', description='Checking',
                                                            parent_sub_category=psr564)
    psr587 = Assessment.objects.using(db).create(name='Technique', description='Technique', parent_sub_category=psr586,
                                                 format=format_1to4)
    psr587.relationship_types.add(self, coach_athlete)
    psr588 = Assessment.objects.using(db).create(name='Placement', description='Placement', parent_sub_category=psr586,
                                                 format=format_1to4)
    psr588.relationship_types.add(self, coach_athlete)
    psr589 = Assessment.objects.using(db).create(name='Through Checks', description='Through Checks',
                                                 parent_sub_category=psr586, format=format_1to4)
    psr589.relationship_types.add(self, coach_athlete)
    psr590 = AssessmentSubCategory.objects.using(db).create(name='1v1 Offense', description='1v1 Offense',
                                                            parent_sub_category=psr564)
    psr591 = Assessment.objects.using(db).create(name='Creativity / Deception with Moves',
                                                 description='Creativity / Deception with Moves',
                                                 parent_sub_category=psr590, format=format_1to4)
    psr591.relationship_types.add(self, coach_athlete)
    psr592 = Assessment.objects.using(db).create(name='Determination / Thread with Speed',
                                                 description='Determination / Thread with Speed',
                                                 parent_sub_category=psr590, format=format_1to4)
    psr592.relationship_types.add(self, coach_athlete)
    psr593 = Assessment.objects.using(db).create(name='Change of Pace / Direction',
                                                 description='Change of Pace / Direction', parent_sub_category=psr590,
                                                 format=format_1to4)
    psr593.relationship_types.add(self, coach_athlete)
    psr594 = AssessmentSubCategory.objects.using(db).create(name='1v1 Defense', description='1v1 Defense',
                                                            parent_sub_category=psr564)
    psr595 = Assessment.objects.using(db).create(name='Positioning @ Defensive End',
                                                 description='Positioning @ Defensive End', parent_sub_category=psr594,
                                                 format=format_1to4)
    psr595.relationship_types.add(self, coach_athlete)
    psr596 = Assessment.objects.using(db).create(name='Win 1v1 Battles', description='Win 1v1 Battles',
                                                 parent_sub_category=psr594, format=format_1to4)
    psr596.relationship_types.add(self, coach_athlete)
    psr597 = Assessment.objects.using(db).create(name='Transition to Offense', description='Transition to Offense',
                                                 parent_sub_category=psr594, format=format_1to4)
    psr597.relationship_types.add(self, coach_athlete)
    psr598 = AssessmentSubCategory.objects.using(db).create(name='Soccer: Learn to Train (Ages 9-12)',
                                                            description='Soccer: Learn to Train (Ages 9-12)',
                                                            parent_top_category=psr563)
    psr599 = AssessmentSubCategory.objects.using(db).create(name='With the Ball', description='With the Ball',
                                                            parent_sub_category=psr598)
    psr600 = Assessment.objects.using(db).create(name='Ball Manipulation', description='Ball Manipulation',
                                                 parent_sub_category=psr599, format=format_1to4)
    psr600.relationship_types.add(self, coach_athlete)
    psr601 = Assessment.objects.using(db).create(name='Turning', description='Turning', parent_sub_category=psr599,
                                                 format=format_1to4)
    psr601.relationship_types.add(self, coach_athlete)
    psr602 = Assessment.objects.using(db).create(name='Running with the ball', description='Running with the ball',
                                                 parent_sub_category=psr599, format=format_1to4)
    psr602.relationship_types.add(self, coach_athlete)
    psr603 = Assessment.objects.using(db).create(name='Dribbling Moves', description='Dribbling Moves',
                                                 parent_sub_category=psr599, format=format_1to4)
    psr603.relationship_types.add(self, coach_athlete)
    psr604 = Assessment.objects.using(db).create(name='Dragging Moves', description='Dragging Moves',
                                                 parent_sub_category=psr599, format=format_1to4)
    psr604.relationship_types.add(self, coach_athlete)
    psr605 = Assessment.objects.using(db).create(name='Shielding', description='Shielding', parent_sub_category=psr599,
                                                 format=format_1to4)
    psr605.relationship_types.add(self, coach_athlete)
    psr606 = Assessment.objects.using(db).create(name='Passing', description='Passing', parent_sub_category=psr599,
                                                 format=format_1to4)
    psr606.relationship_types.add(self, coach_athlete)
    psr607 = Assessment.objects.using(db).create(name='Control', description='Control', parent_sub_category=psr599,
                                                 format=format_1to4)
    psr607.relationship_types.add(self, coach_athlete)
    psr608 = Assessment.objects.using(db).create(name='Finishing', description='Finishing', parent_sub_category=psr599,
                                                 format=format_1to4)
    psr608.relationship_types.add(self, coach_athlete)
    psr609 = AssessmentSubCategory.objects.using(db).create(name='Without the Ball', description='Without the Ball',
                                                            parent_sub_category=psr598)
    psr610 = Assessment.objects.using(db).create(name='Jocking', description='Jocking', parent_sub_category=psr609,
                                                 format=format_1to4)
    psr610.relationship_types.add(self, coach_athlete)
    psr611 = Assessment.objects.using(db).create(name='Challenging', description='Challenging',
                                                 parent_sub_category=psr609, format=format_1to4)
    psr611.relationship_types.add(self, coach_athlete)
    psr612 = AssessmentSubCategory.objects.using(db).create(name='Goalkeeping', description='Goalkeeping',
                                                            parent_sub_category=psr598)
    psr613 = Assessment.objects.using(db).create(name='Body Position', description='Body Position',
                                                 parent_sub_category=psr612, format=format_1to4)
    psr613.relationship_types.add(self, coach_athlete)
    psr614 = Assessment.objects.using(db).create(name='Footwork', description='Footwork', parent_sub_category=psr612,
                                                 format=format_1to4)
    psr614.relationship_types.add(self, coach_athlete)
    psr615 = Assessment.objects.using(db).create(name='Catching', description='Catching', parent_sub_category=psr612,
                                                 format=format_1to4)
    psr615.relationship_types.add(self, coach_athlete)
    psr616 = Assessment.objects.using(db).create(name='Throwing', description='Throwing', parent_sub_category=psr612,
                                                 format=format_1to4)
    psr616.relationship_types.add(self, coach_athlete)
    psr617 = Assessment.objects.using(db).create(name='Diving', description='Diving', parent_sub_category=psr612,
                                                 format=format_1to4)
    psr617.relationship_types.add(self, coach_athlete)
    psr618 = AssessmentSubCategory.objects.using(db).create(name='Soccer: FUNdamentals (Ages 6-9)',
                                                            description='Soccer: FUNdamentals (Ages 6-9)',
                                                            parent_top_category=psr563)
    psr619 = AssessmentSubCategory.objects.using(db).create(name='With the Ball', description='With the Ball',
                                                            parent_sub_category=psr618)
    psr620 = Assessment.objects.using(db).create(name='Ball Manipulation', description='Ball Manipulation',
                                                 parent_sub_category=psr619, format=format_1to4)
    psr620.relationship_types.add(self, coach_athlete)
    psr621 = Assessment.objects.using(db).create(name='Turning', description='Turning', parent_sub_category=psr619,
                                                 format=format_1to4)
    psr621.relationship_types.add(self, coach_athlete)
    psr622 = Assessment.objects.using(db).create(name='Running with the ball', description='Running with the ball',
                                                 parent_sub_category=psr619, format=format_1to4)
    psr622.relationship_types.add(self, coach_athlete)
    psr623 = Assessment.objects.using(db).create(name='Dribbling Moves', description='Dribbling Moves',
                                                 parent_sub_category=psr619, format=format_1to4)
    psr623.relationship_types.add(self, coach_athlete)
    psr624 = Assessment.objects.using(db).create(name='Passing', description='Passing', parent_sub_category=psr619,
                                                 format=format_1to4)
    psr624.relationship_types.add(self, coach_athlete)
    psr625 = Assessment.objects.using(db).create(name='Control', description='Control', parent_sub_category=psr619,
                                                 format=format_1to4)
    psr625.relationship_types.add(self, coach_athlete)
    psr626 = Assessment.objects.using(db).create(name='Finishing', description='Finishing', parent_sub_category=psr619,
                                                 format=format_1to4)
    psr626.relationship_types.add(self, coach_athlete)
    psr627 = AssessmentSubCategory.objects.using(db).create(name='Without the Ball', description='Without the Ball',
                                                            parent_sub_category=psr618)
    psr628 = Assessment.objects.using(db).create(name='Challenging', description='Challenging',
                                                 parent_sub_category=psr627, format=format_1to4)
    psr628.relationship_types.add(self, coach_athlete)
    psr629 = AssessmentSubCategory.objects.using(db).create(name='Goalkeeping', description='Goalkeeping',
                                                            parent_sub_category=psr618)
    psr630 = Assessment.objects.using(db).create(name='Catching', description='Catching', parent_sub_category=psr629,
                                                 format=format_1to4)
    psr630.relationship_types.add(self, coach_athlete)
    psr631 = Assessment.objects.using(db).create(name='Throwing', description='Throwing', parent_sub_category=psr629,
                                                 format=format_1to4)
    psr631.relationship_types.add(self, coach_athlete)
    psr632 = AssessmentSubCategory.objects.using(db).create(name='Soccer: Active Start (Ages 0-6)',
                                                            description='Soccer: Active Start (Ages 0-6)',
                                                            parent_top_category=psr563)
    psr633 = AssessmentSubCategory.objects.using(db).create(name='With the Ball', description='With the Ball',
                                                            parent_sub_category=psr632)
    psr634 = Assessment.objects.using(db).create(name='Ball Manipulation', description='Ball Manipulation',
                                                 parent_sub_category=psr633, format=format_1to4)
    psr634.relationship_types.add(self, coach_athlete)
    psr635 = Assessment.objects.using(db).create(name='Running with the ball', description='Running with the ball',
                                                 parent_sub_category=psr633, format=format_1to4)
    psr635.relationship_types.add(self, coach_athlete)
    psr636 = Assessment.objects.using(db).create(name='Finishing', description='Finishing', parent_sub_category=psr633,
                                                 format=format_1to4)
    psr636.relationship_types.add(self, coach_athlete)
    psr637 = AssessmentSubCategory.objects.using(db).create(name='Without the Ball', description='Without the Ball',
                                                            parent_sub_category=psr632)
    psr638 = Assessment.objects.using(db).create(name='Challenging', description='Challenging',
                                                 parent_sub_category=psr637, format=format_1to4)
    psr638.relationship_types.add(self, coach_athlete)
    psr639 = AssessmentSubCategory.objects.using(db).create(name='Goalkeeping', description='Goalkeeping',
                                                            parent_sub_category=psr632)
    psr640 = Assessment.objects.using(db).create(name='Catching', description='Catching', parent_sub_category=psr639,
                                                 format=format_1to4)
    psr640.relationship_types.add(self, coach_athlete)
    psr641 = Assessment.objects.using(db).create(name='Throwing', description='Throwing', parent_sub_category=psr639,
                                                 format=format_1to4)
    psr641.relationship_types.add(self, coach_athlete)
    psr642 = AssessmentTopCategory.objects.using(db).create(id=rugby_sport.id, name='Rugby', description='Rugby',
                                                            sport=rugby_sport)
    psr643 = AssessmentSubCategory.objects.using(db).create(name='Rugby BC: Train to Train',
                                                            description='Rugby BC: Train to Train',
                                                            parent_top_category=psr642)
    psr644 = Assessment.objects.using(db).create(name='40m Sprint', description='40m Sprint',
                                                 parent_sub_category=psr643, format=format_sec)
    psr644.relationship_types.add(self, coach_athlete)
    psr645 = Assessment.objects.using(db).create(name='30m Sprint', description='30m Sprint',
                                                 parent_sub_category=psr643, format=format_sec)
    psr645.relationship_types.add(self, coach_athlete)
    psr646 = Assessment.objects.using(db).create(name='10m Sprint', description='10m Sprint',
                                                 parent_sub_category=psr643, format=format_sec)
    psr646.relationship_types.add(self, coach_athlete)
    psr647 = Assessment.objects.using(db).create(name='30-40m Sprint', description='30-40m Sprint',
                                                 parent_sub_category=psr643, format=format_sec)
    psr647.relationship_types.add(self, coach_athlete)
    psr648 = Assessment.objects.using(db).create(name='Standing broad jump', description='Standing broad jump',
                                                 parent_sub_category=psr643, format=format_cm)
    psr648.relationship_types.add(self, coach_athlete)
    psr649 = Assessment.objects.using(db).create(name='Triple broad jump', description='Triple broad jump',
                                                 parent_sub_category=psr643, format=format_cm)
    psr649.relationship_types.add(self, coach_athlete)
    psr650 = Assessment.objects.using(db).create(name='300 Yard Shuttle', description='300 Yard Shuttle',
                                                 parent_sub_category=psr643, format=format_sec)
    psr650.relationship_types.add(self, coach_athlete)
    psr651 = Assessment.objects.using(db).create(name='FMS (1-2-3 for 7 different tests = combined score out of 21)',
                                                 description='FMS (1-2-3 for 7 different tests = combined score out of 21)',
                                                 parent_sub_category=psr643, format=format_numb)
    psr651.relationship_types.add(self, coach_athlete)
    psr652 = Assessment.objects.using(db).create(
        name='ACSM overhead squat (competent/not-competent for 9 different points)',
        description='ACSM overhead squat (competent/not-competent for 9 different points)', parent_sub_category=psr643,
        format=format_competent)
    psr652.relationship_types.add(self, coach_athlete)
    psr653 = Assessment.objects.using(db).create(name='Yo-Yo Test L1 (level reached)',
                                                 description='Yo-Yo Test L1 (level reached)',
                                                 parent_sub_category=psr643, format=format_int)
    psr653.relationship_types.add(self, coach_athlete)
    psr654 = Assessment.objects.using(db).create(name='1600m time (sec)', description='1600m time (sec)',
                                                 parent_sub_category=psr643, format=format_sec)
    psr654.relationship_types.add(self, coach_athlete)
    psr655 = AssessmentSubCategory.objects.using(db).create(name='Rugby Canada: Train to Train',
                                                            description='Rugby Canada: Train to Train',
                                                            parent_top_category=psr642)
    psr656 = Assessment.objects.using(db).create(name='20m Sprint', description='20m Sprint',
                                                 parent_sub_category=psr655, format=format_sec)
    psr656.relationship_types.add(self, coach_athlete)
    psr657 = Assessment.objects.using(db).create(name='Box Squat 3RM', description='Box Squat 3RM',
                                                 parent_sub_category=psr655, format=format_kg)
    psr657.relationship_types.add(self, coach_athlete)
    psr658 = Assessment.objects.using(db).create(name='Bench Press 3RM', description='Bench Press 3RM',
                                                 parent_sub_category=psr655, format=format_kg)
    psr658.relationship_types.add(self, coach_athlete)
    psr659 = Assessment.objects.using(db).create(name='Barbell Row 3RM', description='Barbell Row 3RM',
                                                 parent_sub_category=psr655, format=format_kg)
    psr659.relationship_types.add(self, coach_athlete)
    psr660 = Assessment.objects.using(db).create(name='Close-Grip Chin-Up 3RM', description='Close-Grip Chin-Up 3RM',
                                                 parent_sub_category=psr655, format=format_kg)
    psr660.relationship_types.add(self, coach_athlete)
    psr661 = Assessment.objects.using(db).create(name='Power Clean 1RM', description='Power Clean 1RM',
                                                 parent_sub_category=psr655, format=format_kg)
    psr661.relationship_types.add(self, coach_athlete)
    psr662 = Assessment.objects.using(db).create(name='Power Snatch 1RM', description='Power Snatch 1RM',
                                                 parent_sub_category=psr655, format=format_kg)
    psr662.relationship_types.add(self, coach_athlete)
    psr663 = Assessment.objects.using(db).create(name='Front Squat 1RM', description='Front Squat 1RM',
                                                 parent_sub_category=psr655, format=format_kg)
    psr663.relationship_types.add(self, coach_athlete)
    psr664 = Assessment.objects.using(db).create(name='Neutral-Grip Chin-Up 1RM',
                                                 description='Neutral-Grip Chin-Up 1RM', parent_sub_category=psr655,
                                                 format=format_kg)
    psr664.relationship_types.add(self, coach_athlete)
    psr665 = Assessment.objects.using(db).create(name='1-Foot Jump height', description='1-Foot Jump height',
                                                 parent_sub_category=psr655, format=format_kg)
    psr665.relationship_types.add(self, coach_athlete)
    psr666 = Assessment.objects.using(db).create(name='Overhead Barbell Press 1RM',
                                                 description='Overhead Barbell Press 1RM', parent_sub_category=psr655,
                                                 format=format_kg)
    psr666.relationship_types.add(self, coach_athlete)
    psr667 = AssessmentTopCategory.objects.using(db).create(id=tennis_sport.id, name='Tennis', description='Tennis',
                                                            sport=tennis_sport)
    psr668 = AssessmentSubCategory.objects.using(db).create(name='Tennis: Train to Train',
                                                            description='Tennis: Train to Train',
                                                            parent_top_category=psr667)
    psr669 = AssessmentSubCategory.objects.using(db).create(name='Both back - Rallying',
                                                            description='Both back - Rallying',
                                                            parent_sub_category=psr668)
    psr670 = Assessment.objects.using(db).create(name='500 Ball Time', description='500 Ball Time',
                                                 parent_sub_category=psr669, format=format_sec)
    psr670.relationship_types.add(self, coach_athlete)
    psr671 = Assessment.objects.using(db).create(name='4 Minute Drill Score', description='4 Minute Drill Score',
                                                 parent_sub_category=psr669, format=format_int)
    psr671.relationship_types.add(self, coach_athlete)
    psr672 = Assessment.objects.using(db).create(name='1 Minute Drill Score', description='1 Minute Drill Score',
                                                 parent_sub_category=psr669, format=format_int)
    psr672.relationship_types.add(self, coach_athlete)
    psr673 = Assessment.objects.using(db).create(name='10 Ball Time', description='10 Ball Time',
                                                 parent_sub_category=psr669, format=format_sec)
    psr673.relationship_types.add(self, coach_athlete)
    psr674 = Assessment.objects.using(db).create(name='3 ball Drill Score', description='3 ball Drill Score',
                                                 parent_sub_category=psr669, format=format_int)
    psr674.relationship_types.add(self, coach_athlete)
    psr675 = Assessment.objects.using(db).create(name='Monthly Serves Hit', description='Monthly Serves Hit',
                                                 parent_sub_category=psr669, format=format_int)
    psr675.relationship_types.add(self, coach_athlete)
    psr676 = Assessment.objects.using(db).create(name='Longest Spanish Drill at Quality',
                                                 description='Longest Spanish Drill at Quality',
                                                 parent_sub_category=psr669, format=format_int)
    psr676.relationship_types.add(self, coach_athlete)
    psr677 = AssessmentSubCategory.objects.using(db).create(name='Both back - Attacking',
                                                            description='Both back - Attacking',
                                                            parent_sub_category=psr668)
    psr678 = Assessment.objects.using(db).create(name='50 and 5 Score', description='50 and 5 Score',
                                                 parent_sub_category=psr677, format=format_int)
    psr678.relationship_types.add(self, coach_athlete)
    psr679 = AssessmentSubCategory.objects.using(db).create(name='Both back - Defending',
                                                            description='Both back - Defending',
                                                            parent_sub_category=psr668)
    psr680 = Assessment.objects.using(db).create(name='Most balls in a row back to coach volleying',
                                                 description='Most balls in a row back to coach volleying',
                                                 parent_sub_category=psr679, format=format_int)
    psr680.relationship_types.add(self, coach_athlete)
    psr681 = AssessmentSubCategory.objects.using(db).create(name='Serving', description='Serving',
                                                            parent_sub_category=psr668)
    psr682 = Assessment.objects.using(db).create(name='First serve percentage', description='First serve percentage',
                                                 parent_sub_category=psr681, format=format_percents)
    psr682.relationship_types.add(self, coach_athlete)
    psr683 = Assessment.objects.using(db).create(name='Second serve percentage', description='Second serve percentage',
                                                 parent_sub_category=psr681, format=format_percents)
    psr683.relationship_types.add(self, coach_athlete)
    psr684 = Assessment.objects.using(db).create(name='Time before 2 double faults',
                                                 description='Time before 2 double faults', parent_sub_category=psr681,
                                                 format=format_sec)
    psr684.relationship_types.add(self, coach_athlete)
    psr685 = Assessment.objects.using(db).create(name='Specific serve percentage',
                                                 description='Specific serve percentage', parent_sub_category=psr681,
                                                 format=format_percents)
    psr685.relationship_types.add(self, coach_athlete)
    psr686 = AssessmentSubCategory.objects.using(db).create(name='Returning', description='Returning',
                                                            parent_sub_category=psr668)
    psr687 = Assessment.objects.using(db).create(name='Specific first serve return percentage',
                                                 description='Specific first serve return percentage',
                                                 parent_sub_category=psr686, format=format_percents)
    psr687.relationship_types.add(self, coach_athlete)
    psr688 = Assessment.objects.using(db).create(name='Second serve return percentage',
                                                 description='Second serve return percentage',
                                                 parent_sub_category=psr686, format=format_percents)
    psr688.relationship_types.add(self, coach_athlete)
    psr689 = AssessmentSubCategory.objects.using(db).create(name='Approaching', description='Approaching',
                                                            parent_sub_category=psr668)
    psr690 = Assessment.objects.using(db).create(name='50 and 5 drive volleys', description='50 and 5 drive volleys',
                                                 parent_sub_category=psr689, format=format_int)
    psr690.relationship_types.add(self, coach_athlete)
    psr691 = Assessment.objects.using(db).create(name='Longest smash/volley rally',
                                                 description='Longest smash/volley rally', parent_sub_category=psr689,
                                                 format=format_int)
    psr691.relationship_types.add(self, coach_athlete)
    psr692 = Assessment.objects.using(db).create(name='Longest approach volley/groundstroke rally',
                                                 description='Longest approach volley/groundstroke rally',
                                                 parent_sub_category=psr689, format=format_int)
    psr692.relationship_types.add(self, coach_athlete)
    psr693 = AssessmentSubCategory.objects.using(db).create(name='Match stats', description='Match stats',
                                                            parent_sub_category=psr668)
    psr694 = Assessment.objects.using(db).create(name='Aggressive margin score (# / positive or negative)',
                                                 description='Aggressive margin score (# / positive or negative)',
                                                 parent_sub_category=psr693, format=format_numb)
    psr694.relationship_types.add(self, coach_athlete)
    psr695 = Assessment.objects.using(db).create(name='Hold percentage', description='Hold percentage',
                                                 parent_sub_category=psr693, format=format_percents)
    psr695.relationship_types.add(self, coach_athlete)
    psr696 = Assessment.objects.using(db).create(name='Break percentage', description='Break percentage',
                                                 parent_sub_category=psr693, format=format_percents)
    psr696.relationship_types.add(self, coach_athlete)
    psr697 = AssessmentTopCategory.objects.using(db).create(id=field_hockey_sport.id, name='Field Hockey',
                                                            description='Field Hockey', sport=field_hockey_sport)
    psr698 = AssessmentSubCategory.objects.using(db).create(name='Field Hockey: Train to Train',
                                                            description='Field Hockey: Train to Train',
                                                            parent_top_category=psr697)
    psr699 = AssessmentSubCategory.objects.using(db).create(name='Aerobic Capacity', description='Aerobic Capacity',
                                                            parent_sub_category=psr698)
    psr700 = Assessment.objects.using(db).create(name='YoYo Interval Test level',
                                                 description='YoYo Interval Test level', parent_sub_category=psr699,
                                                 format=format_int)
    psr700.relationship_types.add(self, coach_athlete)
    psr701 = AssessmentSubCategory.objects.using(db).create(name='Speed', description='Speed',
                                                            parent_sub_category=psr698)
    psr702 = Assessment.objects.using(db).create(name='Speed (30-40m Split Time)',
                                                 description='Speed (30-40m Split Time)', parent_sub_category=psr701,
                                                 format=format_sec)
    psr702.relationship_types.add(self, coach_athlete)
    psr703 = AssessmentSubCategory.objects.using(db).create(name='Acceleration', description='Acceleration',
                                                            parent_sub_category=psr698)
    psr704 = Assessment.objects.using(db).create(name='Acceleration (5m / 10m / 40m)',
                                                 description='Acceleration (5m / 10m / 40m)',
                                                 parent_sub_category=psr703, format=format_sec)
    psr704.relationship_types.add(self, coach_athlete)
    psr705 = AssessmentSubCategory.objects.using(db).create(name='Agility', description='Agility',
                                                            parent_sub_category=psr698)
    psr706 = Assessment.objects.using(db).create(name='5-0-5 Agility', description='5-0-5 Agility',
                                                 parent_sub_category=psr705, format=format_sec)
    psr706.relationship_types.add(self, coach_athlete)
    psr707 = AssessmentSubCategory.objects.using(db).create(name='Strength', description='Strength',
                                                            parent_sub_category=psr698)
    psr708 = Assessment.objects.using(db).create(name='Bench Press', description='Bench Press',
                                                 parent_sub_category=psr707, format=format_kg)
    psr708.relationship_types.add(self, coach_athlete)
    psr709 = Assessment.objects.using(db).create(name='Back Squat', description='Back Squat',
                                                 parent_sub_category=psr707, format=format_kg)
    psr709.relationship_types.add(self, coach_athlete)
    psr710 = Assessment.objects.using(db).create(name='Bench Pull', description='Bench Pull',
                                                 parent_sub_category=psr707, format=format_kg)
    psr710.relationship_types.add(self, coach_athlete)
    psr711 = Assessment.objects.using(db).create(name='Power Clean', description='Power Clean',
                                                 parent_sub_category=psr707, format=format_kg)
    psr711.relationship_types.add(self, coach_athlete)
    psr712 = AssessmentSubCategory.objects.using(db).create(name='Power', description='Power',
                                                            parent_sub_category=psr698)
    psr713 = Assessment.objects.using(db).create(name='Vertical Jump', description='Vertical Jump',
                                                 parent_sub_category=psr712, format=format_cm)
    psr713.relationship_types.add(self, coach_athlete)
    psr714 = AssessmentTopCategory.objects.using(db).create(id=volleyball_sport.id, name='Volleyball',
                                                            description='Volleyball', sport=volleyball_sport)
    psr715 = AssessmentSubCategory.objects.using(db).create(name='Volleyball: Train to Train',
                                                            description='Volleyball: Train to Train',
                                                            parent_top_category=psr714)
    psr716 = AssessmentSubCategory.objects.using(db).create(name='Serving', description='Serving',
                                                            parent_sub_category=psr715)
    psr717 = Assessment.objects.using(db).create(name='Underhand', description='Underhand', parent_sub_category=psr716,
                                                 format=format_1to4)
    psr717.relationship_types.add(self, coach_athlete)
    psr718 = Assessment.objects.using(db).create(name='Standing Float', description='Standing Float',
                                                 parent_sub_category=psr716, format=format_1to4)
    psr718.relationship_types.add(self, coach_athlete)
    psr719 = Assessment.objects.using(db).create(name='Spike Serve', description='Spike Serve',
                                                 parent_sub_category=psr716, format=format_1to4)
    psr719.relationship_types.add(self, coach_athlete)
    psr720 = AssessmentSubCategory.objects.using(db).create(name='Passing', description='Passing',
                                                            parent_sub_category=psr715)
    psr721 = Assessment.objects.using(db).create(name='On Target', description='On Target', parent_sub_category=psr720,
                                                 format=format_1to4)
    psr721.relationship_types.add(self, coach_athlete)
    psr722 = Assessment.objects.using(db).create(name='Trajectory', description='Trajectory',
                                                 parent_sub_category=psr720, format=format_1to4)
    psr722.relationship_types.add(self, coach_athlete)
    psr723 = Assessment.objects.using(db).create(name='Emergency / Recovery', description='Emergency / Recovery',
                                                 parent_sub_category=psr720, format=format_1to4)
    psr723.relationship_types.add(self, coach_athlete)
    psr724 = AssessmentSubCategory.objects.using(db).create(name='Setting', description='Setting',
                                                            parent_sub_category=psr715)
    psr725 = Assessment.objects.using(db).create(name='Passing from Front Court',
                                                 description='Passing from Front Court', parent_sub_category=psr724,
                                                 format=format_1to4)
    psr725.relationship_types.add(self, coach_athlete)
    psr726 = Assessment.objects.using(db).create(name='Passing from BackCourt', description='Passing from BackCourt',
                                                 parent_sub_category=psr724, format=format_1to4)
    psr726.relationship_types.add(self, coach_athlete)
    psr727 = Assessment.objects.using(db).create(name='Double Axe Handle', description='Double Axe Handle',
                                                 parent_sub_category=psr724, format=format_1to4)
    psr727.relationship_types.add(self, coach_athlete)
    psr728 = AssessmentSubCategory.objects.using(db).create(name='Setter', description='Setter',
                                                            parent_sub_category=psr715)
    psr729 = Assessment.objects.using(db).create(name='Release from Reception', description='Release from Reception',
                                                 parent_sub_category=psr728, format=format_1to4)
    psr729.relationship_types.add(self, coach_athlete)
    psr730 = Assessment.objects.using(db).create(name='Calling the Shot', description='Calling the Shot',
                                                 parent_sub_category=psr728, format=format_1to4)
    psr730.relationship_types.add(self, coach_athlete)
    psr731 = Assessment.objects.using(db).create(name='Attack Second Contact', description='Attack Second Contact',
                                                 parent_sub_category=psr728, format=format_1to4)
    psr731.relationship_types.add(self, coach_athlete)
    psr732 = AssessmentSubCategory.objects.using(db).create(name='Attacking', description='Attacking',
                                                            parent_sub_category=psr715)
    psr733 = Assessment.objects.using(db).create(name='Approach / Striking Action / Landing',
                                                 description='Approach / Striking Action / Landing',
                                                 parent_sub_category=psr732, format=format_1to4)
    psr733.relationship_types.add(self, coach_athlete)
    psr734 = Assessment.objects.using(db).create(name='Attack Directions: Cross / Line / Cutty',
                                                 description='Attack Directions: Cross / Line / Cutty',
                                                 parent_sub_category=psr732, format=format_1to4)
    psr734.relationship_types.add(self, coach_athlete)
    psr735 = Assessment.objects.using(db).create(name='Coverage: On Defense', description='Coverage: On Defense',
                                                 parent_sub_category=psr732, format=format_1to4)
    psr735.relationship_types.add(self, coach_athlete)
    psr736 = AssessmentSubCategory.objects.using(db).create(name='Blocking', description='Blocking',
                                                            parent_sub_category=psr715)
    psr737 = Assessment.objects.using(db).create(name='Ready Position / Movement & Blocking Action',
                                                 description='Ready Position / Movement & Blocking Action',
                                                 parent_sub_category=psr736, format=format_1to4)
    psr737.relationship_types.add(self, coach_athlete)
    psr738 = Assessment.objects.using(db).create(name='Line / Cross & Ball', description='Line / Cross & Ball',
                                                 parent_sub_category=psr736, format=format_1to4)
    psr738.relationship_types.add(self, coach_athlete)
    psr739 = Assessment.objects.using(db).create(name='Set a Blocked Ball', description='Set a Blocked Ball',
                                                 parent_sub_category=psr736, format=format_1to4)
    psr739.relationship_types.add(self, coach_athlete)
    psr740 = AssessmentSubCategory.objects.using(db).create(name='Defense', description='Defense',
                                                            parent_sub_category=psr715)
    psr741 = Assessment.objects.using(db).create(name='Attitude / Ready Position / Movement & Digging Action',
                                                 description='Attitude / Ready Position / Movement & Digging Action',
                                                 parent_sub_category=psr740, format=format_1to4)
    psr741.relationship_types.add(self, coach_athlete)
    psr742 = Assessment.objects.using(db).create(name='Dive / Roll', description='Dive / Roll',
                                                 parent_sub_category=psr740, format=format_1to4)
    psr742.relationship_types.add(self, coach_athlete)
    psr743 = Assessment.objects.using(db).create(name='Direct Set to Offense', description='Direct Set to Offense',
                                                 parent_sub_category=psr740, format=format_1to4)
    psr743.relationship_types.add(self, coach_athlete)


def reverse_func(apps, schema_editor):
    del apps, schema_editor


class Migration(migrations.Migration):
    dependencies = [
        ('multidb_account', '0001_initial'),
        ('multidb_account', '0002_load_sports'),
    ]

    operations = [
        migrations.RunPython(load_assessments, reverse_func),
    ]
