Hello Guys,

Please I need an urgent help on this subject, I was trying to migrate my 
model in django to a postgres DB but I am getting 'value too long for type 
character varying(1)' error. I have tried making the max_length = 1000 but 
I am still getting the same error. 

The last thing I can remember I did was that I create another CharField 
with a list of choice. I tried removing it but still getting the same error.

Below is the code i am trying to migrate:

from django.db import models
from django.utils import timezone
import datetime
# Create your models here.
SEX = [
        ('M', 'MALE'),
        ('F', 'FEMALE')
]

TITLE_CHOICES = [
        ('MR','Mr.'),
        ('MRS','Mrs.'),
        ('MS','Ms.')
]

STATUS = [
    ('A', 'Admitted'),
    ('D', 'Discharged')
]


class PatientDetail(models.Model):
    
    """
    Model of the details of entry patient 
    """
    FirstName = models.CharField(blank = False, max_length = 1000)
    LastName = models.CharField(blank = False, max_length = 1000)
    MiddleName = models.CharField(max_length = 1000)
    Title = models.CharField(choices = TITLE_CHOICES, blank=False, max_length = 
1000)
    Address = models.CharField(blank = False, max_length = 1000)
    Email = models.EmailField(max_length = 1000)
    sex = models.CharField(blank = False, choices = SEX, max_length = 1000)
    Age = models.DateField(blank = False)
    PhoneNumber = models.CharField(blank = False, max_length = 1000)
    NextOfKin = models.CharField(blank = False, max_length = 1000)
    NextofKin_Address = models.CharField(blank = False, max_length = 1000)
    NextofKIn_PhoneNumber = models.DecimalField(blank = False, max_digits=13, 
decimal_places=0)
    DateOfReg = models.DateTimeField(auto_now=True)
    NurseInDuty = models.CharField(blank=False, max_length = 1000)
    Status = models.CharField(choices = STATUS, blank = False, max_length = 
1000)
    
    
    class Meta:
        db_table = 'Patient Detail'

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/64780f11-2e95-45dd-a36c-5621a17f8a3cn%40googlegroups.com.

Reply via email to