# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#   * Rearrange models' order
#   * Make sure each model has one field with primary_key=True
#   * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behavior
#   * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
from django.db import models


class Administrator(models.Model):
    fullname = models.CharField(max_length=255, blank=True, null=True)
    username = models.CharField(max_length=255)
    email = models.CharField(max_length=255)
    phone_number = models.CharField(max_length=255)
    password = models.CharField(max_length=255)
    confirm_password = models.CharField(max_length=255, blank=True, null=True)
    second_password = models.CharField(max_length=255, blank=True, null=True)
    profile_img = models.CharField(max_length=255, blank=True, null=True)
    size = models.CharField(max_length=255, blank=True, null=True)
    type = models.CharField(max_length=255, blank=True, null=True)
    btc_wallet = models.CharField(max_length=255, blank=True, null=True)
    reset_token = models.CharField(max_length=255, blank=True, null=True)
    ip_address = models.CharField(max_length=255)
    city = models.CharField(max_length=255)
    country = models.CharField(max_length=255)
    lastlogin = models.CharField(max_length=255, blank=True, null=True)
    date_added = models.CharField(max_length=255, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'administrator'


class AuthGroup(models.Model):
    name = models.CharField(unique=True, max_length=150)

    class Meta:
        managed = False
        db_table = 'auth_group'


class AuthGroupPermissions(models.Model):
    id = models.BigAutoField(primary_key=True)
    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)
    permission = models.ForeignKey('AuthPermission', models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_group_permissions'
        unique_together = (('group', 'permission'),)


class AuthPermission(models.Model):
    name = models.CharField(max_length=255)
    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING)
    codename = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'auth_permission'
        unique_together = (('content_type', 'codename'),)


class AuthUser(models.Model):
    password = models.CharField(max_length=128)
    last_login = models.DateTimeField(blank=True, null=True)
    is_superuser = models.IntegerField()
    username = models.CharField(unique=True, max_length=150)
    first_name = models.CharField(max_length=150)
    last_name = models.CharField(max_length=150)
    email = models.CharField(max_length=254)
    is_staff = models.IntegerField()
    is_active = models.IntegerField()
    date_joined = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'auth_user'


class AuthUserGroups(models.Model):
    id = models.BigAutoField(primary_key=True)
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_user_groups'
        unique_together = (('user', 'group'),)


class AuthUserUserPermissions(models.Model):
    id = models.BigAutoField(primary_key=True)
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
    permission = models.ForeignKey(AuthPermission, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_user_user_permissions'
        unique_together = (('user', 'permission'),)


class Benificiary(models.Model):
    type = models.CharField(max_length=255, blank=True, null=True)
    added_by = models.CharField(max_length=255)
    acc_no = models.CharField(max_length=255, blank=True, null=True)
    acc_name = models.CharField(max_length=255, blank=True, null=True)
    short_name = models.CharField(max_length=255, blank=True, null=True)
    bank_name = models.CharField(max_length=255, blank=True, null=True)
    routine_number = models.CharField(max_length=255, blank=True, null=True)
    date_added = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'benificiary'


class CotCodes(models.Model):
    added_by = models.CharField(max_length=255)
    cot_code = models.CharField(max_length=255)
    used_by = models.CharField(max_length=255, blank=True, null=True)
    stat = models.CharField(max_length=255, default='For Sale')
    status = models.CharField(max_length=7, default='Active')
    date_added = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'cot_codes'


class DjangoAdminLog(models.Model):
    action_time = models.DateTimeField()
    object_id = models.TextField(blank=True, null=True)
    object_repr = models.CharField(max_length=200)
    action_flag = models.PositiveSmallIntegerField()
    change_message = models.TextField()
    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True)
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'django_admin_log'


class DjangoContentType(models.Model):
    app_label = models.CharField(max_length=100)
    model = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'django_content_type'
        unique_together = (('app_label', 'model'),)


class DjangoMigrations(models.Model):
    id = models.BigAutoField(primary_key=True)
    app = models.CharField(max_length=255)
    name = models.CharField(max_length=255)
    applied = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_migrations'


class DjangoSession(models.Model):
    session_key = models.CharField(primary_key=True, max_length=40)
    session_data = models.TextField()
    expire_date = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_session'


class Loan(models.Model):
    loan_id = models.CharField(max_length=255)
    firstname = models.CharField(max_length=255, blank=True, null=True)
    lastname = models.CharField(max_length=255, blank=True, null=True)
    username = models.CharField(max_length=255, blank=True, null=True)
    email = models.CharField(max_length=255)
    currency = models.CharField(max_length=255, default='$', blank=True, null=True)
    amount = models.FloatField()
    installment_amount = models.FloatField()
    installment = models.CharField(max_length=255)
    next_installment = models.CharField(max_length=255, default='...')
    total_installment = models.CharField(max_length=255)
    given = models.FloatField(default=0.00)
    payback = models.FloatField()
    plan_name = models.CharField(max_length=255)
    days = models.CharField(max_length=255)
    driver_license = models.CharField(max_length=255, blank=True, null=True)
    size = models.CharField(max_length=255, blank=True, null=True)
    type = models.CharField(max_length=255, blank=True, null=True)
    paid = models.FloatField(default=0.00)
    status = models.CharField(max_length=255, default='Requested')
    date_added = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'loan'

class ReferredUsers(models.Model):
    firstname = models.CharField(max_length=255, blank=True, null=True)
    lastname = models.CharField(max_length=255, blank=True, null=True)
    username = models.CharField(max_length=255, blank=True, null=True)
    email = models.CharField(max_length=255, blank=True, null=True)
    referred_by = models.CharField(max_length=255)
    status = models.CharField(max_length=255, default='Pending')
    date_added = models.CharField(max_length=255, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'referred_users'

class Siteconfig(models.Model):
    sitename = models.CharField(max_length=225, blank=True, null=True)
    sitemail = models.CharField(max_length=225, blank=True, null=True)
    sitemail2 = models.CharField(max_length=255, blank=True, null=True)
    siteaddress = models.CharField(max_length=225, blank=True, null=True)
    sitenumber = models.CharField(max_length=225, blank=True, null=True)
    sitelink = models.CharField(max_length=225, blank=True, null=True)
    sitelink2 = models.CharField(max_length=255, blank=True, null=True)
    site_admin_reg_link = models.CharField(max_length=3)
    btc_wallet = models.CharField(max_length=225, blank=True, null=True)
    eth_wallet = models.CharField(max_length=255, blank=True, null=True)
    tron_wallet = models.CharField(max_length=255, blank=True, null=True)
    ltc_wallet = models.CharField(max_length=225, blank=True, null=True)
    usdt_wallet = models.CharField(max_length=255, blank=True, null=True)
    paypal_email = models.CharField(max_length=225, blank=True, null=True)
    zelle_email = models.CharField(max_length=225, blank=True, null=True)
    cashap_tag = models.CharField(max_length=225, blank=True, null=True)
    minimum_transfer = models.CharField(max_length=225)
    maximum_transfer = models.CharField(max_length=255)
    date_registered = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'siteconfig'


class TaxCodes(models.Model):
    added_by = models.CharField(max_length=255)
    tax_code = models.CharField(max_length=255)
    used_by = models.CharField(max_length=255, blank=True, null=True)
    stat = models.CharField(max_length=255, default='For Sale')
    status = models.CharField(max_length=255, default='Active')
    date_added = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'tax_codes'


class TotalVisitors(models.Model):
    visitors = models.TextField()

    class Meta:
        managed = False
        db_table = 'total_visitors'


class Transfers(models.Model):
    email = models.CharField(max_length=255, blank=True, null=True)
    receiver_fullname = models.CharField(max_length=255, blank=True, null=True)
    acc_no = models.CharField(max_length=255, blank=True, null=True)
    acc_type = models.CharField(max_length=255, blank=True, null=True)
    receiver_bank_name = models.CharField(max_length=255, blank=True, null=True)
    receiver_bank_address = models.CharField(max_length=255, blank=True, null=True)
    receiver_bank_country = models.CharField(max_length=255, blank=True, null=True)
    iban = models.CharField(max_length=255, blank=True, null=True)
    currency = models.CharField(max_length=255, default='$', blank=True, null=True)
    amount = models.FloatField(default=0.00)
    prev_bal = models.FloatField(default=0.00)
    new_bal = models.FloatField(default=0.00)
    description = models.CharField(max_length=255, blank=True, null=True)
    recipient = models.CharField(max_length=255, blank=True, null=True)
    transfer_type = models.CharField(max_length=255, blank=True, null=True)
    sender_acc_no = models.CharField(max_length=255, blank=True, null=True)
    receipt = models.CharField(max_length=255, blank=True, null=True)
    trxid = models.CharField(max_length=255, blank=True, null=True)
    stat = models.CharField(max_length=255, blank=True, null=True)
    status = models.CharField(max_length=10, default='Pending')
    date_added = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'transfers'


class Users(models.Model):
    firstname = models.CharField(max_length=255)
    lastname = models.CharField(max_length=255)
    username = models.CharField(max_length=255)
    email = models.CharField(unique=True, max_length=255)
    country = models.CharField(max_length=255)
    phone_number = models.CharField(max_length=255)
    pin = models.CharField(max_length=255, blank=True, null=True)
    city = models.CharField(max_length=255)
    zip_code = models.CharField(max_length=255)
    address = models.CharField(max_length=255)
    ip = models.CharField(max_length=255, blank=True, null=True)
    browser = models.CharField(max_length=255, blank=True, null=True)
    password = models.CharField(max_length=255)
    confirm_password = models.CharField(max_length=255)
    plain_password = models.CharField(max_length=255)
    plain_pin = models.CharField(max_length=255)
    acc_no = models.CharField(unique=True, max_length=255)
    currency = models.CharField(max_length=255, blank=True, null=True)
    balance = models.FloatField(default=0.00)
    deposits = models.CharField(max_length=255, default=0.00)
    transactions = models.CharField(max_length=255, default=0)
    loan = models.CharField(max_length=255, default=0)
    max_transfer_limit = models.CharField(max_length=255, default=1000000)
    reset_token = models.CharField(max_length=255, blank=True, null=True)
    pin_reset_token = models.CharField(max_length=255, blank=True, null=True)
    referrals = models.CharField(max_length=255, default=0)
    referred_by = models.CharField(max_length=255, blank=True, null=True)
    referrals_earning = models.FloatField(default=0.00)
    ref_code = models.CharField(max_length=255)
    referral_url = models.CharField(max_length=255, blank=True, null=True)
    profile_img = models.CharField(max_length=255, blank=True, null=True)
    type = models.CharField(max_length=255, blank=True, null=True)
    size = models.CharField(max_length=255, blank=True, null=True)
    otp = models.CharField(max_length=255, blank=True, null=True)
    cot_code = models.CharField(max_length=3, default='off')
    tax_code = models.CharField(max_length=3, default='off')
    billing_status = models.CharField(max_length=3, default='off')
    billing_title = models.CharField(max_length=255, blank=True, null=True)
    billing_message = models.CharField(max_length=255, blank=True, null=True)
    status = models.CharField(max_length=9, default='Pending')
    lastlogin = models.CharField(max_length=255, blank=True, null=True)
    date_added = models.CharField(max_length=255, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'users'


class Visitors(models.Model):
    ip = models.CharField(max_length=255, blank=True, null=True)
    browser = models.CharField(max_length=255, blank=True, null=True)
    location = models.CharField(max_length=255, blank=True, null=True)
    date_added = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'visitors'