class Facilitator(models.Model): Fid = models.AutoField(primary_key=True) name = models.CharField(max_length=100, null=True, blank=True) DOB = models.DateField(blank=True, null=True) phone = models.CharField(max_length=13, blank=False) country = models.TextField(blank=True, null=True) state = models.TextField(blank=True, null=True) PAddress = models.TextField(blank=True, null=True) TAddress = models.TextField(blank=True, null=True) profile = models.ImageField(upload_to='Mentor_profiles/', default='default.png', null=True, blank=True) Bio = models.TextField(blank=True, null=True) country = models.CharField(max_length=100, blank=True, null=True) state = models.CharField(max_length=100, blank=True, null=True) zipcode = models.CharField(max_length=7, blank=True, null=True) user = models.OneToOneField(Applicants, on_delete=models.CASCADE, null=True, related_name='facilitator') class Meta: verbose_name = 'Approved Facilitator' verbose_name_plural = 'Approved Facilitators' def __str__(self): return self.name
class Experience(models.Model): REXP=(('', 'Relative Experience'), ('A', '3-6 yrs'), ('B', '6-10 yrs'), ('C', '10+ yrs'),) TEXP=(('', 'Total Experience'), ('A', '3-6 yrs'), ('B', '6-10 yrs'), ('C', '10+ yrs'),) Eid=models.AutoField(primary_key=True) Linkedin_Url= models.URLField(max_length=250,blank=True,null=True) Website_Url= models.URLField(max_length=250,blank=True,null=True) Youtube_Url= models.URLField(max_length=250,blank=True,null=True) RExperience=models.CharField(max_length=1,choices=REXP) TExperience=models.CharField(max_length=1,choices=TEXP) facilitator= models.OneToOneField(Applicants, on_delete=models.CASCADE,null=True)
class FacilitatorQueries(models.Model): STATUS=(('Resolved','Resolved'),('Doubt','Doubt')) Qid=models.AutoField(primary_key=True) query=models.TextField(blank=True,null=True) status=models.CharField(max_length=10,choices=STATUS,default="Doubt") user= models.OneToOneField(Applicants, on_delete=models.CASCADE,null=True) def __str__(self): return self.status
class Applicants(models.Model): Aid=models.AutoField(primary_key=True) name=models.CharField(max_length=100,null=True,blank=True) phone=models.CharField(max_length=13,null=True, blank=True) portfolio = models.FileField(upload_to ='uploads/',null=True, blank=True) intrest=models.CharField(max_length=250) user = models.OneToOneField(CustomUser, on_delete=models.CASCADE, null=True, related_name="user") status = models.CharField(max_length=50, null=True, blank=True) added = models.DateTimeField(auto_now_add=True,blank=True,null=True) updated = models.DateTimeField(auto_now=True,blank=True,null=True) def __str__(self): # __unicode__ for Python 2 return self.user.email class Meta: verbose_name='Registered Applicant' verbose_name_plural='Registered Applicants' def __str__(self): # __unicode__ for Python 2 return self.user.email