# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#   * Rearrange models' order
#   * Make sure each model has one field with primary_key=True
#   * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behavior
#   * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
from django.db import models


class Goals(models.Model):
    game_id_id = models.IntegerField(blank=True, null=True)
    minute = models.IntegerField(blank=True, null=True)
    penalty_kick = models.IntegerField(blank=True, null=True)
    player_id = models.TextField(blank=True, null=True)
    team_id = models.IntegerField(blank=True, null=True)
    year = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'goals'


class Keepergames(models.Model):
    game_id_id = models.IntegerField(blank=True, null=True)
    goals = models.IntegerField(blank=True, null=True)
    minutes = models.IntegerField(blank=True, null=True)
    player_id = models.TextField(blank=True, null=True)
    team_id = models.IntegerField(blank=True, null=True)
    year = models.TextField(blank=True, null=True)
    win = models.IntegerField(blank=True, null=True)
    draw = models.IntegerField(blank=True, null=True)
    loss = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'keepergames'


class Penaltyshootout(models.Model):
    game_id_id = models.IntegerField(blank=True, null=True)
    goal = models.IntegerField(blank=True, null=True)
    keeper_id = models.TextField(blank=True, null=True)
    keeper_team_id = models.IntegerField(blank=True, null=True)
    order = models.IntegerField(blank=True, null=True)
    player_id = models.TextField(blank=True, null=True)
    player_team_id = models.IntegerField(blank=True, null=True)
    year = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'penaltyshootout'


class Playerregister(models.Model):
    cityofbirth = models.TextField(db_column='cityOfBirth', blank=True, null=True)  # Field name made lowercase.
    countryofbirth = models.TextField(db_column='countryOfBirth', blank=True, null=True)  # Field name made lowercase.
    dayofbirth = models.IntegerField(db_column='dayOfBirth', blank=True, null=True)  # Field name made lowercase.
    firstname = models.TextField(db_column='firstName', blank=True, null=True)  # Field name made lowercase.
    height = models.IntegerField(blank=True, null=True)
    jerseynumber = models.IntegerField(db_column='jerseyNumber', blank=True, null=True)  # Field name made lowercase.
    lastname = models.TextField(db_column='lastName', blank=True, null=True)  # Field name made lowercase.
    monthofbirth = models.IntegerField(db_column='monthOfBirth', blank=True, null=True)  # Field name made lowercase.
    position = models.TextField(blank=True, null=True)
    player_id = models.CharField(primary_key=True, max_length=15)
    weight = models.IntegerField(blank=True, null=True)
    yearofbirth = models.IntegerField(db_column='yearOfBirth', blank=True, null=True)  # Field name made lowercase.
    stateofbirth = models.TextField(db_column='stateOfBirth', blank=True, null=True)  # Field name made lowercase.
    nickname = models.TextField(db_column='nickName', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'playerregister'


class Playerteamseason(models.Model):
    register_id = models.TextField(blank=True, null=True)
    team_id = models.IntegerField(blank=True, null=True)
    year = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'playerteamseason'


class Reallifeconference(models.Model):
    name = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'reallifeconference'


class Reallifekeeper(models.Model):
    name = models.TextField(blank=True, null=True)
    player_id = models.TextField(blank=True, null=True)
    team = models.TextField(blank=True, null=True)
    team_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'reallifekeeper'


class Reallifeplayer(models.Model):
    name = models.TextField(blank=True, null=True)
    player_id = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'reallifeplayer'


class Reallifeteam(models.Model):
    abbrev = models.TextField(blank=True, null=True)
    conf_id = models.IntegerField(blank=True, null=True)
    name = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'reallifeteam'


class Redcard(models.Model):
    game_id_id = models.IntegerField(blank=True, null=True)
    minute = models.IntegerField(blank=True, null=True)
    player_id = models.TextField(blank=True, null=True)
    team_id = models.IntegerField(blank=True, null=True)
    two_yellows = models.IntegerField(blank=True, null=True)
    year = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'redcard'


class Regulationpenalty(models.Model):
    game_id_id = models.IntegerField(blank=True, null=True)
    goal = models.IntegerField(blank=True, null=True)
    keeper_id = models.TextField(blank=True, null=True)
    keeper_team_id = models.IntegerField(blank=True, null=True)
    minute = models.IntegerField(blank=True, null=True)
    player_id = models.TextField(blank=True, null=True)
    player_team_id = models.IntegerField(blank=True, null=True)
    year = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'regulationpenalty'


class Replayedgame(models.Model):
    away_id = models.IntegerField(blank=True, null=True)
    away_score = models.IntegerField(blank=True, null=True)
    date = models.TextField(blank=True, null=True)
    home_id = models.IntegerField(blank=True, null=True)
    home_score = models.IntegerField(blank=True, null=True)
    year = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'replayedgame'


class Season(models.Model):
    name = models.TextField(blank=True, null=True)
    year_code = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'season'


class Teamseason(models.Model):
    abbrev = models.TextField(blank=True, null=True)
    conf_id = models.IntegerField(blank=True, null=True)
    goals = models.IntegerField(blank=True, null=True)
    goals_against = models.IntegerField(blank=True, null=True)
    losses = models.IntegerField(blank=True, null=True)
    name = models.TextField(blank=True, null=True)
    nickname = models.TextField(blank=True, null=True)
    shootout_wins = models.IntegerField(blank=True, null=True)
    stadium = models.TextField(blank=True, null=True)
    team_id = models.IntegerField(blank=True, null=True)
    wins = models.IntegerField(blank=True, null=True)
    year = models.CharField(max_length=10, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'teamseason'


class Yellowcard(models.Model):
    game_id_id = models.IntegerField(blank=True, null=True)
    minute = models.IntegerField(blank=True, null=True)
    player_id = models.TextField(blank=True, null=True)
    second_yellow = models.IntegerField(blank=True, null=True)
    team_id = models.IntegerField(blank=True, null=True)
    year = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'yellowcard'