class HmsPatient(models.Model):
    id = models.IntegerField(primary_key=True)
    regdatetime = models.DateTimeField(default=datetime.datetime.now())
    name = models.CharField(max_length=576)
    dob = models.DateField(default=datetime.datetime.now())
    email = models.CharField(max_length=1152)
    mobile = models.CharField(max_length=144)
    gender = 
models.CharField(max_length=18,default="Male",choices=gender_choice)
    religion = 
models.CharField(max_length=27,default="Muslim",choices=religion_choice)
    marital_status = 
models.CharField(max_length=288,default="Unmarried",choices=marital_choice)
    guardian_name = models.CharField(max_length=576)
    guardian_relation = 
models.CharField(max_length=288,default="Father",choices=relation_choice)
    address = models.CharField(max_length=2304)
    city = models.CharField(max_length=576,default="Srinagar")
    state = models.CharField(max_length=576,default="J&K")
    country = 
models.CharField(max_length=576,default="India",choices=country_choice)
    class Meta:
        db_table = u'hms_patient'


class HmsDiagnosis(models.Model):
    id = models.IntegerField(primary_key=True)
    regid = models.ForeignKey(HmsPatient, db_column='regid')
    datetime = models.DateTimeField(default=datetime.datetime.now(), 
auto_now=True)
    provisional_diagnosis = models.CharField(max_length=500, null=True, 
blank=True)
    remark = models.CharField(max_length=500, null=True, blank=True)
    biochemistry = 
models.CharField(max_length=9,choices=yes_no_enum_choice,default="Yes")
    stool = 
models.CharField(max_length=9,choices=yes_no_enum_choice,default="Yes")
    blood = 
models.CharField(max_length=9,choices=yes_no_enum_choice,default="Yes")
    colonoscopy = 
models.CharField(max_length=9,choices=yes_no_enum_choice,default="Yes")
    gastroscopy = 
models.CharField(max_length=9,choices=yes_no_enum_choice,default="Yes")
    urine = 
models.CharField(max_length=9,choices=yes_no_enum_choice,default="Yes")
    xray = 
models.CharField(max_length=9,choices=yes_no_enum_choice,default="Yes")
    sonography = 
models.CharField(max_length=9,choices=yes_no_enum_choice,default="Yes")
    ecg = 
models.CharField(max_length=9,choices=yes_no_enum_choice,default="Yes")
    others = models.TextField()
    reconsultation_date = models.DateField(null=True, blank=True)
    class Meta:
        db_table = u'hms_diagnosis'



-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/django-users/-/diz8r-28fzkJ.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to