# Create your models here.
from django.db import models
from django.db import models
from organisations.models import *

class CustomerSearch(models.Model):
    id = models.BigIntegerField(primary_key=True)
    customer_type_id =  models.BigIntegerField()
    customer_type_name = models.CharField(max_length=155)
    organisation_id  = models.BigIntegerField()
    has_members      = models.BooleanField(default=False)
    is_deleted       = models.BooleanField(default=False)
    customer_type_date_added = models.DateTimeField()
    customer_id   = models.BigIntegerField()
    name          = models.CharField(max_length=155)
    member_number = models.CharField(max_length=155)
    old_member_number = models.CharField(max_length=155)
    status      = models.CharField(max_length=155)
    telephone   = models.CharField(max_length=155)
    gender      = models.CharField(max_length=155)
    gender_label = models.CharField(max_length=155)
    branch_id   = models.BigIntegerField()
    branch_name = models.CharField(max_length=155)
    branch_short_name = models.CharField(max_length=155)
    organisation_id   = models.BigIntegerField()
    organisation_name = models.CharField(max_length=155)
    villagename       = models.CharField(max_length=155)
    districtname       = models.CharField(max_length=155)
    subcountyname          = models.CharField(max_length=155)
    regionname        = models.CharField(max_length=155)
    physical_address  = models.CharField(max_length=155)
    date_added = models.DateTimeField()
    card_id = models.CharField(max_length=555)
    is_biometric = models.BooleanField(default=False)
    dob = models.DateTimeField()
    nin = models.CharField(max_length=555)

    class Meta:
        managed = False
        db_table = "public\".\"customer_search_view"


class SavingsAccountSearch(models.Model):
    id = models.BigIntegerField(primary_key=True)
    account_no = models.CharField(max_length=155)
    open_date = models.DateTimeField()
    dormancy_date = models.DateTimeField()
    customer_type_id =  models.BigIntegerField()
    customer_type_name = models.CharField(max_length=155)
    organisation_id  = models.BigIntegerField()
    has_members      = models.BooleanField()
    deleted          = models.BooleanField()
    is_active        = models.BooleanField()
    opened_by_id     = models.BigIntegerField()
    opened_by_name   = models.CharField(max_length=155)
    product_id       = models.BigIntegerField()
    product_name     = models.CharField(max_length=155)
    currency_name    = models.CharField(max_length=155)
    currency_symbol  = models.CharField(max_length=155)
    currency_code    = models.CharField(max_length=155)
    customer_id      = models.BigIntegerField()
    customer_name    = models.CharField(max_length=155)
    customer_member_number = models.CharField(max_length=155)
    customer_old_member_number = models.CharField(max_length=155)
    status      = models.CharField(max_length=155)
    telephone   = models.CharField(max_length=155)
    gender      = models.CharField(max_length=155)
    branch_id   = models.BigIntegerField()
    branch_name = models.CharField(max_length=155)
    branch_short_name = models.CharField(max_length=155)
    organisation_id   = models.BigIntegerField()
    organisation_name = models.CharField(max_length=155)
    villagename       = models.CharField(max_length=155)
    regionname        = models.CharField(max_length=155)
    physical_address  = models.CharField(max_length=155)
    last_updated = models.DateTimeField()
    
    class Meta:
        managed = False
        db_table = "public\".\"savings_account_search_view"