class Surgeon_color(models.Model):
    surgeon_mnemonic = models.CharField(max_length=12)
    color = models.CharField(max_length=12, default='#000000')
    def __str__(self):
        return self.surgeon_mnemonic

class Regstatus(models.Model):
    status = models.CharField(max_length=20, null=True, blank=True)
    color = models.CharField(max_length=20, default='#000000')
    def __str__(self):
        return self.status

class Appointment(models.Model):
    create_time = models.TimeField('create time', null=True, blank=True)
    sch_time = models.DateTimeField('appointment time', null=True, blank=True)
    in_time = models.TimeField('arrival time', null=True, blank=True)
    start_time = models.TimeField('start reg time', null=True, blank=True)
    finish_time = models.TimeField('end reg time', null=True, blank=True)
    pat_name = models.CharField(max_length=75)
    surgeon = models.ForeignKey(Surgeon_color, on_delete='SET_NULL', null=True)
    operation_id = models.CharField(max_length=60)
    registrar = models.ForeignKey(Registrar, on_delete='SET_NULL', null=True)
    status = models.ForeignKey(Regstatus, on_delete='SET_NULL', null=True)

    def __str__(self):
        return self.pat_name