class Team(models.Model):
id_team = models.IntegerField(default = 0,blank= True, primary_key=True)
name = models.CharField(max_length = 256)
code = models.CharField(max_length = 10)
nation = models.ForeignKey(Nation,related_name='nation', on_delete=models.CASCADE)
continent = models.CharField(max_length = 10)
category = models.CharField(max_length = 256)
def __str__(self):
return self.name
class Nation(models.Model):
id_nation = models.IntegerField(default = 0,blank= True,primary_key=True)
name = models.CharField(max_length = 256)
code_name = models.CharField(max_length = 256)
def __str__(self):
return self.name
#-----------------------------------------------------#
class Rider(models.Model):
id_raider = models.IntegerField(default = 0,blank= True, primary_key=True)
first_name = models.CharField(max_length = 256,blank= True)
last_name = models.CharField(max_length = 256,blank= True)
display_name = models.CharField(max_length = 256,blank= True)
birth = models.DateTimeField(default=timezone.now)
place_of_birth = models.CharField(max_length = 256,blank= True)
age = models.IntegerField(default = 0,blank= True)
nationality = models.ForeignKey(Nation,related_name='nation', on_delete=models.CASCADE)
height = models.FloatField(default = 0.0 ,blank= True)
weight = models.FloatField(default = 0.0 ,blank= True)
team = models.ForeignKey(Team,related_name='team', on_delete=models.CASCADE)
cost = models.IntegerField(default = 0,blank= True)
stage = models.ForeignKey(Stage,related_name='stage', on_delete=models.CASCADE)
def __str__(self):
return self.display_name
class Stage(models.Model):
id_stage = models.IntegerField(default = 0,blank= True, primary_key=True)
date = models.DateTimeField(default=timezone.now)
tipo = models.CharField(max_length = 256,blank= True)
start = models.CharField(max_length = 256,blank= True)
end = models.CharField(max_length = 256,blank= True)
km = models.CharField(max_length = 256,blank= True)
profile = models.CharField(max_length = 256,blank= True)
hc = models.IntegerField(default = 0,blank= True)
UNOc = models.IntegerField(default = 0,blank= True)
def __str__(self):
return self.date
class Risultato(models.Model):
id_raider = models.ForeignKey(Raider,related_name='raider', on_delete=models.CASCADE)
id_stage = models.ForeignKey(Stage,related_name='team', on_delete=models.CASCADE)
type_ris = models.CharField(max_length = 256,blank= True)
rank = models.IntegerField(default = 0,blank= True)
punti = models.IntegerField(default = 0,blank= True)
def __str__(self):
return self.id_raider,self.id_stage,self.rank