# 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
#   * 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.
#
# Also note: You'll have to insert the output of 'django-admin sqlcustom [app_label]'
# into your database.
from __future__ import unicode_literals

from django.db import models


class FileModels(models.Model):
    file_model_no = models.AutoField(db_column='File_MODEL_NO', primary_key=True)  # Field name made lowercase.
    file_model_name = models.CharField(db_column='File_MODEL_NAME', max_length=255)  # Field name made lowercase.
    file_model_path = models.CharField(db_column='File_MODEL_PATH', max_length=255)  # Field name made lowercase.
    file_model_chinese_name = models.CharField(db_column='File_MODEL_CHINESE_NAME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    file_model_text = models.TextField(db_column='File_MODEL_TEXT')  # Field name made lowercase.
    file_model_cols = models.IntegerField(db_column='File_MODEL_COLS')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'File_models'


class SupplierBiddingPhoto(models.Model):
    supplier_bidding_no = models.CharField(db_column='Supplier_bidding_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    supplier_bidding_photo = models.CharField(db_column='Supplier_bidding_PHOTO', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'Supplier_bidding_photo'


class AccessControl(models.Model):
    usr_no = models.IntegerField(db_column='USR_NO')  # Field name made lowercase.
    func_no = models.IntegerField(db_column='FUNC_NO')  # Field name made lowercase.
    opera_auth = models.IntegerField(db_column='OPERA_AUTH')  # Field name made lowercase.
    access_remark = models.CharField(db_column='ACCESS_REMARK', max_length=255, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'access_control'
        unique_together = (('USR_NO', 'FUNC_NO'),)


class AgentBidding(models.Model):
    agntbd_product_name = models.CharField(db_column='AgntBd_PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    agntbd_product_model = models.CharField(db_column='AgntBd_PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    agntbd_product_measurement = models.CharField(db_column='AgntBd_PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    agntbd_quantity = models.IntegerField(db_column='AgntBd_QUANTITY')  # Field name made lowercase.
    agntbd_unit_price = models.DecimalField(db_column='AgntBd_UNIT_PRICE', max_digits=10, decimal_places=0)  # Field name made lowercase.
    agntbd_amount = models.DecimalField(db_column='AgntBd_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase.
    agntbd_bidding_time = models.DateField(db_column='AgntBd_BIDDING_TIME')  # Field name made lowercase.
    agntbd_price_validity = models.IntegerField(db_column='AgntBd_PRICE_VALIDITY')  # Field name made lowercase.
    agntbd_remarks = models.TextField(db_column='AgntBd_REMARKS', blank=True, null=True)  # Field name made lowercase.
    agntbd_product_photo = models.CharField(db_column='AgntBd_PRODUCT_PHOTO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    agntbd_product_description = models.CharField(db_column='AgntBd_PRODUCT_DESCRIPTION', max_length=255, blank=True, null=True)  # Field name made lowercase.
    agntbd_status = models.IntegerField(db_column='AgntBd_STATUS')  # Field name made lowercase.
    agntbd_no = models.CharField(db_column='AgntBd_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    product_no = models.CharField(db_column='PRODUCT_NO', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'agent_bidding'


class AskingBiddingMapping(models.Model):
    purask_asking_no = models.CharField(db_column='PurAsk_ ASKING_NO', primary_key=True, max_length=255)  # Field name made lowercase. Field renamed to remove unsuitable characters.
    supbd_bidding_no = models.TextField(db_column='SupBd_BIDDING_NO', blank=True, null=True)  # Field name made lowercase.
    abmap_remarks = models.TextField(db_column='ABMap_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'asking_bidding_mapping'


class AskingSupply(models.Model):
    asking_supply_no = models.IntegerField(db_column='ASKING_SUPPLY_NO', primary_key=True)  # Field name made lowercase.
    agnt_asking_no = models.CharField(db_column='Agnt_Asking_NO', max_length=255)  # Field name made lowercase.
    agntbd_no = models.CharField(db_column='AgntBd_NO', max_length=255)  # Field name made lowercase.
    agntas_remarks = models.TextField(db_column='AgntAS_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'asking_supply'


class Assign(models.Model):
    assign_no = models.AutoField(db_column='Assign_No', primary_key=True)  # Field name made lowercase.
    assign_usr_from = models.CharField(db_column='Assign_Usr_From', max_length=255)  # Field name made lowercase.
    assign_usr_to = models.CharField(db_column='Assign_Usr_To', max_length=255)  # Field name made lowercase.
    assign_title = models.CharField(db_column='Assign_Title', max_length=255)  # Field name made lowercase.
    assign_content = models.TextField(db_column='Assign_Content')  # Field name made lowercase.
    assign_time = models.DateTimeField(db_column='Assign_Time')  # Field name made lowercase.
    assign_status = models.IntegerField(db_column='Assign_Status')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'assign'


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

    class Meta:
        managed = False
        db_table = 'auth_group'


class AuthGroupPermissions(models.Model):
    group = models.ForeignKey(AuthGroup)
    permission = models.ForeignKey('AuthPermission')

    class Meta:
        managed = False
        db_table = 'auth_group_permissions'
        unique_together = (('group_id', 'permission_id'),)


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

    class Meta:
        managed = False
        db_table = 'auth_permission'
        unique_together = (('content_type_id', '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=30)
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)
    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):
    user = models.ForeignKey(AuthUser)
    group = models.ForeignKey(AuthGroup)

    class Meta:
        managed = False
        db_table = 'auth_user_groups'
        unique_together = (('user_id', 'group_id'),)


class AuthUserUserPermissions(models.Model):
    user = models.ForeignKey(AuthUser)
    permission = models.ForeignKey(AuthPermission)

    class Meta:
        managed = False
        db_table = 'auth_user_user_permissions'
        unique_together = (('user_id', 'permission_id'),)


class BaonAskingSupply(models.Model):
    asking_supply_no = models.AutoField(db_column='ASKING_SUPPLY _NO', primary_key=True)  # Field name made lowercase. Field renamed to remove unsuitable characters.
    bnagnt_asking_no = models.CharField(db_column='BnAgnt_Asking_NO', max_length=255)  # Field name made lowercase.
    bnagntbd_no = models.CharField(db_column='BnAgntBd_NO', max_length=255)  # Field name made lowercase.
    bnagntas_remarks = models.TextField(db_column='BnAgntAS_REMARKS')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'baon_asking_supply'


class BoanAgentBidding(models.Model):
    bnagntbd_product_name = models.CharField(db_column='BnAgntBd_PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    bnagntbd_product_model = models.CharField(db_column='BnAgntBd_PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    bnagntbd_product_measurement = models.CharField(db_column='BnAgntBd_PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    bnagntbd_quantity = models.IntegerField(db_column='BnAgntBd_QUANTITY')  # Field name made lowercase.
    bnagntbd_unit_price = models.DecimalField(db_column='BnAgntBd_UNIT_PRICE', max_digits=10, decimal_places=0)  # Field name made lowercase.
    bnagntbd_amount = models.DecimalField(db_column='BnAgntBd_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase.
    bnagntbd_bidding_time = models.CharField(db_column='BnAgntBd_BIDDING_TIME', max_length=255)  # Field name made lowercase.
    bnagntbd_price_validity = models.IntegerField(db_column='BnAgntBd_PRICE_VALIDITY')  # Field name made lowercase.
    bnagntbd_remarks = models.TextField(db_column='BnAgntBd_REMARKS', blank=True, null=True)  # Field name made lowercase.
    bnagntbd_product_photo = models.CharField(db_column='BnAgntBd_PRODUCT_PHOTO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    bnagntbd_product_description = models.CharField(db_column='BnAgntBd_PRODUCT_DESCRIPTION', max_length=255, blank=True, null=True)  # Field name made lowercase.
    bnagntbd_status = models.IntegerField(db_column='BnAgntBd_STATUS')  # Field name made lowercase.
    bnagntbd_no = models.CharField(db_column='BnAgntBd_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    product_no = models.CharField(db_column='PRODUCT_NO', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'boan_agent_bidding'


class BulletinBoard(models.Model):
    board_no = models.AutoField(primary_key=True)
    board_content = models.TextField()
    board_state = models.IntegerField()
    usr_no = models.CharField(max_length=255)
    board_time = models.DateField()
    board_name = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'bulletin_board'


class CashDisbursement(models.Model):
    cashdisb_no = models.CharField(db_column='CashDisb_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    usr_no = models.CharField(db_column='USR_NO', max_length=255)  # Field name made lowercase.
    cashdisb_time = models.DateTimeField(db_column='CashDisb_Time')  # Field name made lowercase.
    cashdisb_begin_time = models.DateTimeField(db_column='CashDisb_Begin_Time', blank=True, null=True)  # Field name made lowercase.
    cashdisb_end_time = models.DateTimeField(db_column='CashDisb_End_Time', blank=True, null=True)  # Field name made lowercase.
    cashdisb_reason = models.CharField(db_column='CashDisb_Reason', max_length=255, blank=True, null=True)  # Field name made lowercase.
    cashdisb_address = models.CharField(db_column='CashDisb_Address', max_length=255, blank=True, null=True)  # Field name made lowercase.
    cashdisb_transport = models.CharField(db_column='CashDisb_Transport', max_length=255)  # Field name made lowercase.
    cashdisb_transport_money = models.FloatField(db_column='CashDisb_Transport_money', blank=True, null=True)  # Field name made lowercase.
    cashdisb_food_money = models.FloatField(db_column='CashDisb_Food_money', blank=True, null=True)  # Field name made lowercase.
    cashdisb_su_money = models.FloatField(db_column='CashDisb_Su_money', blank=True, null=True)  # Field name made lowercase.
    cashdisb_zhuqin_money = models.FloatField(db_column='CashDisb_ZhuQin_money', blank=True, null=True)  # Field name made lowercase.
    cashdisb_za_use = models.CharField(db_column='CashDisb_Za_Use', max_length=255, blank=True, null=True)  # Field name made lowercase.
    cashdisb_za_money = models.FloatField(db_column='CashDisb_Za_money', blank=True, null=True)  # Field name made lowercase.
    cashdisb_subtotal = models.FloatField(db_column='CashDisb_Subtotal', blank=True, null=True)  # Field name made lowercase.
    cashdisb_total = models.FloatField(db_column='CashDisb_Total', blank=True, null=True)  # Field name made lowercase.
    cashdisb_total_cn = models.CharField(db_column='CashDisb_Total_Cn', max_length=255, blank=True, null=True)  # Field name made lowercase.
    cashdisb_agent = models.CharField(db_column='CashDisb_Agent', max_length=255, blank=True, null=True)  # Field name made lowercase.
    cashdisb_check = models.CharField(db_column='CashDisb_Check', max_length=255, blank=True, null=True)  # Field name made lowercase.
    cashdisb_manager = models.CharField(db_column='CashDisb_Manager', max_length=255, blank=True, null=True)  # Field name made lowercase.
    cashdisb_use_way = models.TextField(db_column='CashDisb_Use_Way', blank=True, null=True)  # Field name made lowercase.
    cashdisb_kind = models.IntegerField(db_column='CashDisb_Kind')  # Field name made lowercase.
    cashdisb_remarks = models.TextField(db_column='CashDisb_REMARKS', blank=True, null=True)  # Field name made lowercase.
    cashdisb_status = models.IntegerField(db_column='CashDisb_STATUS')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'cash_disbursement'


class CashDisbursementLimit(models.Model):
    cash_limit_no = models.AutoField(db_column='Cash_limit_No', primary_key=True)  # Field name made lowercase.
    cash_company_no = models.CharField(db_column='Cash_company_no', max_length=255)  # Field name made lowercase.
    cash_limit_money = models.DecimalField(db_column='Cash_limit_money', max_digits=15, decimal_places=2)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'cash_disbursement_limit'


class CashdisbPhoto(models.Model):
    cashdisb_no = models.CharField(db_column='CashDisb_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    cashdisb_photo = models.CharField(db_column='CashDisb_PHOTO', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'cashdisb_photo'


class CeleryTaskmeta(models.Model):
    task_id = models.CharField(unique=True, max_length=255)
    status = models.CharField(max_length=50)
    result = models.TextField(blank=True, null=True)
    date_done = models.DateTimeField()
    traceback = models.TextField(blank=True, null=True)
    hidden = models.IntegerField()
    meta = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'celery_taskmeta'


class CeleryTasksetmeta(models.Model):
    taskset_id = models.CharField(unique=True, max_length=255)
    result = models.TextField()
    date_done = models.DateTimeField()
    hidden = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'celery_tasksetmeta'


class CnEnMapping(models.Model):
    cnenmap_cnname = models.CharField(db_column='CnEnMap_CNNAME', max_length=50)  # Field name made lowercase.
    cnenmap_database = models.CharField(db_column='CnEnMap_DATABASE', max_length=50)  # Field name made lowercase.
    cnenmap_table_name = models.CharField(db_column='CnEnMap_TABLE_NAME', max_length=50)  # Field name made lowercase.
    cnenmap_enname = models.CharField(db_column='CnEnMap_ENNAME', max_length=50)  # Field name made lowercase.
    cnenmap_no = models.AutoField(db_column='CnEnMap_NO', primary_key=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'cn_en_mapping'


class ContractModels(models.Model):
    models_no = models.AutoField(db_column='MODELS_NO', primary_key=True)  # Field name made lowercase.
    models_name = models.CharField(db_column='MODELS_NAME', max_length=255)  # Field name made lowercase.
    models_len = models.IntegerField(db_column='MODELS_LEN')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'contract_models'


class ContractPhoto(models.Model):
    contract_no = models.CharField(db_column='Contract_No', primary_key=True, max_length=255)  # Field name made lowercase.
    contract_photo = models.CharField(db_column='Contract_Photo', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'contract_photo'


class Customer(models.Model):
    cstm_no = models.CharField(db_column='Cstm_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    cstm_name = models.CharField(db_column='Cstm_NAME', max_length=255)  # Field name made lowercase.
    cstm_class = models.CharField(db_column='Cstm_CLASS', max_length=50, blank=True, null=True)  # Field name made lowercase.
    cstm_contacts = models.CharField(db_column='Cstm_CONTACTS', max_length=50)  # Field name made lowercase.
    cstm_address = models.CharField(db_column='Cstm_ADDRESS', max_length=50)  # Field name made lowercase.
    cstm_phone_no = models.CharField(db_column='Cstm_PHONE_NO', max_length=50)  # Field name made lowercase.
    cstm_responsible_man = models.CharField(db_column='Cstm_RESPONSIBLE_MAN', max_length=50)  # Field name made lowercase.
    cstm_mobile_no = models.CharField(db_column='Cstm_MOBILE_NO', max_length=50)  # Field name made lowercase.
    cstm_email = models.CharField(db_column='Cstm_EMAIL', max_length=255, blank=True, null=True)  # Field name made lowercase.
    cstm_bank_account = models.CharField(db_column='Cstm_bank_account', max_length=255)  # Field name made lowercase.
    cstm_remarks = models.TextField(db_column='Cstm_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'customer'


class CustomerAskingLog(models.Model):
    custasklg_log_no = models.AutoField(db_column='CustAskLg_LOG_NO', primary_key=True)  # Field name made lowercase.
    custasklg_asking_no = models.CharField(db_column='CustAskLg_ASKING_NO', max_length=255)  # Field name made lowercase.
    custasklg_user_no = models.CharField(db_column='CustAskLg_USER_NO', max_length=255)  # Field name made lowercase.
    custasklg_time = models.DateTimeField(db_column='CustAskLg_TIME')  # Field name made lowercase.
    custasklg_remarks = models.TextField(db_column='CustAskLg_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'customer_asking_log'


class CustomerInspection(models.Model):
    cstmchck_checking_no = models.IntegerField(db_column='CstmChck_CHECKING_NO', primary_key=True)  # Field name made lowercase.
    cstmchck_contract_no = models.CharField(db_column='CstmChck_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    cstmchck_purchase_quantity = models.IntegerField(db_column='CstmChck_PURCHASE_QUANTITY')  # Field name made lowercase.
    cstmchck_inspection_quantity = models.IntegerField(db_column='CstmChck_INSPECTION_QUANTITY')  # Field name made lowercase.
    cstmchck_qualified_quantity = models.IntegerField(db_column='CstmChck_QUALIFIED_QUANTITY')  # Field name made lowercase.
    cstmchck_amount = models.IntegerField(db_column='CstmChck_AMOUNT')  # Field name made lowercase.
    cstmchck_supplier = models.CharField(db_column='CstmChck_SUPPLIER', max_length=255)  # Field name made lowercase.
    cstmchck_storage_warehouse = models.CharField(db_column='CstmChck_STORAGE_WAREHOUSE', max_length=255)  # Field name made lowercase.
    cstmchck_responsible_man = models.CharField(db_column='CstmChck_RESPONSIBLE_MAN', max_length=255)  # Field name made lowercase.
    cstmchck_payable_amount = models.DecimalField(db_column='CstmChck_PAYABLE_AMOUNT', max_digits=11, decimal_places=0)  # Field name made lowercase.
    cstmchck_checking_time = models.DateField(db_column='CstmChck_CHECKING_TIME')  # Field name made lowercase.
    cstmchck_broker = models.CharField(db_column='CstmChck_BROKER', max_length=255)  # Field name made lowercase.
    cstmchck_status = models.IntegerField(db_column='CstmChck_STATUS')  # Field name made lowercase.
    cstmchck_remarks = models.TextField(db_column='CstmChck_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'customer_inspection'


class CustomerUserMapping(models.Model):
    custusrmap_customer_no = models.IntegerField(db_column='CustUsrMap_CUSTOMER_NO')  # Field name made lowercase.
    custusrmap_user_no = models.IntegerField(db_column='CustUsrMap_USER_NO')  # Field name made lowercase.
    custusrmap_remarks = models.TextField(db_column='CustUsrMap_REMARKS', blank=True, null=True)  # Field name made lowercase.
    custusrmap_id = models.IntegerField(db_column='CustUsrMap_ID', primary_key=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'customer_user_mapping'


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.SmallIntegerField()
    change_message = models.TextField()
    content_type = models.ForeignKey('DjangoContentType', blank=True, null=True)
    user = models.ForeignKey(AuthUser)

    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):
    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 DjceleryCrontabschedule(models.Model):
    minute = models.CharField(max_length=64)
    hour = models.CharField(max_length=64)
    day_of_week = models.CharField(max_length=64)
    day_of_month = models.CharField(max_length=64)
    month_of_year = models.CharField(max_length=64)

    class Meta:
        managed = False
        db_table = 'djcelery_crontabschedule'


class DjceleryIntervalschedule(models.Model):
    every = models.IntegerField()
    period = models.CharField(max_length=24)

    class Meta:
        managed = False
        db_table = 'djcelery_intervalschedule'


class DjceleryPeriodictask(models.Model):
    name = models.CharField(unique=True, max_length=200)
    task = models.CharField(max_length=200)
    args = models.TextField()
    kwargs = models.TextField()
    queue = models.CharField(max_length=200, blank=True, null=True)
    exchange = models.CharField(max_length=200, blank=True, null=True)
    routing_key = models.CharField(max_length=200, blank=True, null=True)
    expires = models.DateTimeField(blank=True, null=True)
    enabled = models.IntegerField()
    last_run_at = models.DateTimeField(blank=True, null=True)
    total_run_count = models.IntegerField()
    date_changed = models.DateTimeField()
    description = models.TextField()
    crontab = models.ForeignKey(DjceleryCrontabschedule, blank=True, null=True)
    interval = models.ForeignKey(DjceleryIntervalschedule, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'djcelery_periodictask'


class DjceleryPeriodictasks(models.Model):
    ident = models.SmallIntegerField(primary_key=True)
    last_update = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'djcelery_periodictasks'


class DjceleryTaskstate(models.Model):
    state = models.CharField(max_length=64)
    task_id = models.CharField(unique=True, max_length=36)
    name = models.CharField(max_length=200, blank=True, null=True)
    tstamp = models.DateTimeField()
    args = models.TextField(blank=True, null=True)
    kwargs = models.TextField(blank=True, null=True)
    eta = models.DateTimeField(blank=True, null=True)
    expires = models.DateTimeField(blank=True, null=True)
    result = models.TextField(blank=True, null=True)
    traceback = models.TextField(blank=True, null=True)
    runtime = models.FloatField(blank=True, null=True)
    retries = models.IntegerField()
    hidden = models.IntegerField()
    worker = models.ForeignKey('DjceleryWorkerstate', blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'djcelery_taskstate'


class DjceleryWorkerstate(models.Model):
    hostname = models.CharField(unique=True, max_length=255)
    last_heartbeat = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'djcelery_workerstate'


class DjkombuMessage(models.Model):
    visible = models.IntegerField()
    sent_at = models.DateTimeField(blank=True, null=True)
    payload = models.TextField()
    queue = models.ForeignKey('DjkombuQueue')

    class Meta:
        managed = False
        db_table = 'djkombu_message'


class DjkombuQueue(models.Model):
    name = models.CharField(unique=True, max_length=200)

    class Meta:
        managed = False
        db_table = 'djkombu_queue'


class DocumentTop(models.Model):
    document_top_no = models.CharField(db_column='DOCUMENT_TOP_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    usr_no = models.CharField(db_column='USR_NO', max_length=255)  # Field name made lowercase.
    document_top_time = models.DateTimeField(db_column='DOCUMENT_TOP_TIME')  # Field name made lowercase.
    document_top_size = models.FloatField(db_column='DOCUMENT_TOP_SIZE', blank=True, null=True)  # Field name made lowercase.
    document_top_name = models.CharField(db_column='DOCUMENT_TOP_NAME', max_length=255)  # Field name made lowercase.
    document_top_download = models.IntegerField(db_column='DOCUMENT_TOP_DOWNLOAD')  # Field name made lowercase.
    document_top_path = models.CharField(db_column='Document_TOP_PATH', max_length=255)  # Field name made lowercase.
    document_top_chinese_name = models.CharField(db_column='Document_TOP_CHINESE_NAME', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'document_top'


class Files(models.Model):
    num = models.CharField(db_column='Num', max_length=255, blank=True, null=True)  # Field name made lowercase.
    filepath = models.CharField(max_length=255, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'files'


class FunctionModule(models.Model):
    func_no = models.IntegerField(db_column='FUNC_NO', primary_key=True)  # Field name made lowercase.
    func_name = models.CharField(db_column='FUNC_NAME', max_length=50)  # Field name made lowercase.
    func_remark = models.CharField(db_column='FUNC_REMARK', max_length=255, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'function_module'


class HuanengAsking(models.Model):
    hnask_asking_no = models.CharField(db_column='HNAsk_ASKING_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    hnask_product_name = models.CharField(db_column='HNAsk_PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    hnask_product_model = models.CharField(db_column='HNAsk_PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    hnask_product_measurement = models.CharField(db_column='HNAsk_PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    hnask_quantity = models.IntegerField(db_column='HNAsk_QUANTITY')  # Field name made lowercase.
    hnask_bidding_endtime = models.DateTimeField(db_column='HNAsk_BIDDING_ENDTIME')  # Field name made lowercase.
    hnask_duedate = models.DateTimeField(db_column='HNAsk_DUEDATE')  # Field name made lowercase.
    hnask_maker = models.CharField(db_column='HNAsk_MAKER', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_remarks = models.TextField(db_column='HNAsk_REMARKS', blank=True, null=True)  # Field name made lowercase.
    hnask_class = models.CharField(db_column='HNAsk_CLASS', max_length=255)  # Field name made lowercase.
    hnask_asking_value = models.CharField(db_column='HNAsk_ASKING_VALUE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_asking_value1 = models.CharField(db_column='HNAsk_ASKING_VALUE1', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_shipping_address = models.CharField(db_column='HNAsk_SHIPPING_ADDRESS', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_caution_bidder = models.CharField(db_column='HNAsk_CAUTION_BIDDER', max_length=255, blank=True, null=True)  # Field name made lowercase.
    asking_no = models.CharField(db_column='ASKING_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_promise_date = models.CharField(db_column='HNAsk_PROMISE_DATE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_num = models.IntegerField(db_column='HNAsk_BIDDING_NUM', blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_price_start = models.DecimalField(db_column='HNAsk_BIDDING_PRICE_START', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_price_target = models.DecimalField(db_column='HNAsk_BIDDING_PRICE_TARGET', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_price = models.DecimalField(db_column='HNAsk_BIDDING_PRICE', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_currency = models.CharField(db_column='HNAsk_BIDDING_CURRENCY', max_length=50, blank=True, null=True)  # Field name made lowercase.
    hnask_model = models.CharField(db_column='HNAsk_MODEL', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_maker = models.CharField(db_column='HNAsk_BIDDING_MAKER', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_maker_product = models.CharField(db_column='HNAsk_BIDDING_MAKER_PRODUCT', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_caution_inquirer = models.CharField(db_column='HNAsk_CAUTION_INQUIRER', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_attachment = models.TextField(db_column='HNAsk_ATTACHMENT', blank=True, null=True)  # Field name made lowercase.
    hnask_attachment_url = models.CharField(db_column='HNAsk_ATTACHMENT_URL', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_asking_currency = models.CharField(db_column='HNAsk_ASKING_CURRENCY', max_length=50, blank=True, null=True)  # Field name made lowercase.
    hnask_asking_precision = models.CharField(db_column='HNAsk_ASKING_PRECISION', max_length=50, blank=True, null=True)  # Field name made lowercase.
    hnask_attribute = models.CharField(db_column='HNAsk_ATTRIBUTE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_response = models.CharField(db_column='HNAsk_BIDDING_RESPONSE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_attribute_type = models.CharField(db_column='HNAsk_ATTRIBUTE_TYPE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_value = models.CharField(db_column='HNAsk_BIDDING_VALUE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_attribute1 = models.CharField(db_column='HNAsk_ATTRIBUTE1', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_response1 = models.CharField(db_column='HNAsk_BIDDING_RESPONSE1', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_attribute_type1 = models.CharField(db_column='HNAsk_ATTRIBUTE_TYPE1', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_value1 = models.CharField(db_column='HNAsk_BIDDING_VALUE1', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_attribute2 = models.CharField(db_column='HNAsk_ATTRIBUTE2', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_response2 = models.CharField(db_column='HNAsk_BIDDING_RESPONSE2', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_attribute_type2 = models.CharField(db_column='HNAsk_ATTRIBUTE_TYPE2', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_ask_value2 = models.CharField(db_column='HNAsk_ASK_VALUE2', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bid_value2 = models.CharField(db_column='HNAsk_BID_VALUE2', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_attribute3 = models.CharField(db_column='HNAsk_ATTRIBUTE3', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_response3 = models.CharField(db_column='HNAsk_BIDDING_RESPONSE3', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_attribute_type3 = models.CharField(db_column='HNAsk_ATTRIBUTE_TYPE3', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_asking_value3 = models.CharField(db_column='HNAsk_ASKING_VALUE3', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_bidding_value3 = models.CharField(db_column='HNAsk_BIDDING_VALUE3', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnask_lineno = models.CharField(db_column='HNAsk_LINENO', max_length=50, blank=True, null=True)  # Field name made lowercase.
    hnask_status = models.IntegerField(db_column='HNAsk_STATUS', blank=True, null=True)  # Field name made lowercase.
    hnask_customer_no = models.CharField(db_column='HNAsk_CUSTOMER_NO', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'huaneng_asking'


class HuanengSalesBidding(models.Model):
    hnslsbd_bidding_no = models.CharField(db_column='HNSlsBd_BIDDING_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    hnslsbd_product_name = models.CharField(db_column='HNSlsBd_PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    hnslsbd_product_model = models.CharField(db_column='HNSlsBd_PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    hnslsbd_product_measurement = models.CharField(db_column='HNSlsBd_PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    hnslsbd_quantity = models.IntegerField(db_column='HNSlsBd_QUANTITY')  # Field name made lowercase.
    hnslsbd_pur_asking_price = models.DecimalField(db_column='HNSlsBd_PUR_ASKING_PRICE', max_digits=10, decimal_places=2)  # Field name made lowercase.
    hnslsbd_bids = models.DecimalField(db_column='HNSlsBd_BIDS', max_digits=10, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    hnslsbd_tax_unit_price = models.DecimalField(db_column='HNSlsBd_TAX_UNIT_PRICE', max_digits=10, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    hnslsbd_tax_rate = models.DecimalField(db_column='HNSlsBd_TAX_RATE', max_digits=10, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    hnslsbd_unit_price = models.DecimalField(db_column='HNSlsBd_UNIT_PRICE', max_digits=10, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    hnslsbd_tax_amount = models.DecimalField(db_column='HNSlsBd_TAX_AMOUNT', max_digits=10, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    hnslsbd_amount = models.DecimalField(db_column='HNSlsBd_AMOUNT', max_digits=10, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    hnslsbd_supplier = models.CharField(db_column='HNSlsBd_SUPPLIER', max_length=255)  # Field name made lowercase.
    hnslsbd_remarks = models.TextField(db_column='HNSlsBd_REMARKS', blank=True, null=True)  # Field name made lowercase.
    hnslsbd_status = models.IntegerField(db_column='HNSlsBd_STATUS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'huaneng_sales_bidding'


class Notice(models.Model):
    notice_no = models.CharField(db_column='Notice_No', primary_key=True, max_length=255)  # Field name made lowercase.
    notice_title = models.CharField(db_column='Notice_TITLE', max_length=255)  # Field name made lowercase.
    notice_content = models.CharField(db_column='Notice_Content', max_length=255)  # Field name made lowercase.
    notice_create_time = models.DateTimeField(db_column='Notice_Create_Time')  # Field name made lowercase.
    notice_status = models.IntegerField(db_column='Notice_Status')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'notice'


class OperationType(models.Model):
    opera_no = models.IntegerField(db_column='OPERA_NO', primary_key=True)  # Field name made lowercase.
    opera_name = models.CharField(db_column='OPERA_NAME', max_length=50)  # Field name made lowercase.
    opera_remark = models.CharField(db_column='OPERA_REMARK', max_length=255, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'operation_type'


class OpportunityManagement(models.Model):
    oppmanag_no = models.CharField(db_column='OppManag_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    usr_no = models.CharField(db_column='USR_NO', max_length=255)  # Field name made lowercase.
    oppmanag_address = models.CharField(db_column='OppManag_ADDRESS', max_length=255)  # Field name made lowercase.
    oppmanag_depiction = models.CharField(db_column='OppManag_DEPICTION', max_length=255)  # Field name made lowercase.
    oppmanag_time = models.DateTimeField(db_column='OppManag_TIME')  # Field name made lowercase.
    oppmanag_advise = models.CharField(db_column='OppManag_ADVISE', max_length=255)  # Field name made lowercase.
    oppmanag_remarks = models.CharField(db_column='OppManag_REMARKS', max_length=255, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'opportunity_management'


class OpportunityPhoto(models.Model):
    opportunity_no = models.CharField(db_column='Opportunity_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    opportunity_photo = models.CharField(db_column='Opportunity_PHOTO', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'opportunity_photo'


class PayVoucher(models.Model):
    pay_voucher_no = models.CharField(db_column='PAY_VOUCHER_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purcontin_contract_no = models.CharField(db_column='PurContIn_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    payer_no = models.CharField(db_column='PAYER_NO', max_length=255)  # Field name made lowercase.
    receiver_no = models.CharField(db_column='RECEIVER_NO', max_length=255)  # Field name made lowercase.
    money = models.DecimalField(db_column='MONEY', max_digits=15, decimal_places=2)  # Field name made lowercase.
    pay_time = models.DateField(db_column='PAY_TIME')  # Field name made lowercase.
    pay_voucher_broker = models.CharField(db_column='PAY_VOUCHER_BROKER', max_length=255)  # Field name made lowercase.
    pay_sup_account = models.CharField(db_column='PAY_SUP_ACCOUNT', max_length=255)  # Field name made lowercase.
    pay_usr_account = models.CharField(db_column='PAY_USR_ACCOUNT', max_length=255)  # Field name made lowercase.
    pay_voucher_photo = models.CharField(db_column='PAY_VOUCHER_PHOTO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    pay_voucher_remarks = models.TextField(db_column='PAY_VOUCHER_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'pay_voucher'


class PayVoucherPhoto(models.Model):
    pay_voucher_no = models.CharField(db_column='Pay_Voucher_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    pay_voucher_photo = models.CharField(db_column='Pay_Voucher_Photo', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'pay_voucher_photo'


class Product(models.Model):
    product_no = models.AutoField(db_column='PRODUCT_NO', primary_key=True)  # Field name made lowercase.
    product_name = models.CharField(db_column='PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    product_model = models.CharField(db_column='PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    product_measurement = models.CharField(db_column='PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    product_class = models.CharField(db_column='PRODUCT_CLASS', max_length=255, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'product'


class PurchaseAsking(models.Model):
    purask_product_name = models.CharField(db_column='PurAsk_PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    purask_product_model = models.CharField(db_column='PurAsk_PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    purask_product_measurement = models.CharField(db_column='PurAsk_PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    purask_quantity = models.IntegerField(db_column='PurAsk_QUANTITY')  # Field name made lowercase.
    purask_reference_price = models.DecimalField(db_column='PurAsk_REFERENCE_PRICE', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    purask_real_asking_price = models.DecimalField(db_column='PurAsk_REAL_ASKING_PRICE', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    purask_amount = models.DecimalField(db_column='PurAsk_AMOUNT', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    purask_remarks = models.TextField(db_column='PurAsk_REMARKS', blank=True, null=True)  # Field name made lowercase.
    purask_suppliers = models.CharField(db_column='PurAsk_SUPPLIERS', max_length=255)  # Field name made lowercase.
    purask_bidding_time = models.DateTimeField(db_column='PurAsk_BIDDING_TIME', blank=True, null=True)  # Field name made lowercase.
    purask_price_validity = models.DateTimeField(db_column='PurAsk_PRICE_VALIDITY', blank=True, null=True)  # Field name made lowercase.
    purask_status = models.IntegerField(db_column='PurAsk_STATUS')  # Field name made lowercase.
    purask_asking_no = models.CharField(db_column='PurAsk_ ASKING_NO', primary_key=True, max_length=255)  # Field name made lowercase. Field renamed to remove unsuitable characters.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    purask_price_reason = models.CharField(db_column='PurAsk_PRICE_REASON', max_length=255, blank=True, null=True)  # Field name made lowercase.
    purask_lock = models.IntegerField(db_column='PurAsk_Lock')  # Field name made lowercase.
    purask_unlock = models.IntegerField(db_column='PurAsk_Unlock')  # Field name made lowercase.
    purask_already_name = models.TextField(db_column='PurAsk_Already_NAME', blank=True, null=True)  # Field name made lowercase.
    purask_class = models.IntegerField(db_column='PurAsk_CLASS')  # Field name made lowercase.
    purask_review = models.IntegerField(db_column='PurAsk_Review', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_asking'


class PurchaseAskingLog(models.Model):
    purasklg_log_no = models.CharField(db_column='PurAskLg_LOG_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purasklg_user_no = models.CharField(db_column='PurAskLg_USER_NO', max_length=255)  # Field name made lowercase.
    purasklg_time = models.DateTimeField(db_column='PurAskLg_TIME')  # Field name made lowercase.
    purasklg_remarks = models.TextField(db_column='PurAskLg_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_asking_log'


class PurchaseChecking(models.Model):
    purstochck_checking_no = models.CharField(db_column='PurStoChck_CHECKING_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purcontin_contract_no = models.CharField(db_column='PurContIn_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    purstochck_purchase_quantity = models.IntegerField(db_column='PurStoChck_PURCHASE_QUANTITY')  # Field name made lowercase.
    purstochck_inspection_quantity = models.IntegerField(db_column='PurStoChck_INSPECTION_QUANTITY')  # Field name made lowercase.
    purstochck_qualified_quantity = models.IntegerField(db_column='PurStoChck_QUALIFIED_QUANTITY')  # Field name made lowercase.
    purstochck_amount = models.DecimalField(db_column='PurStoChck_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase.
    purstochck_supplier = models.CharField(db_column='PurStoChck_SUPPLIER', max_length=255)  # Field name made lowercase.
    purstochck_storage_warehouse = models.CharField(db_column='PurStoChck_STORAGE_WAREHOUSE', max_length=255)  # Field name made lowercase.
    purstochck_responsible_man = models.CharField(db_column='PurStoChck_RESPONSIBLE_MAN', max_length=255)  # Field name made lowercase.
    purstochck_payable_amount = models.DecimalField(db_column='PurStoChck_ PAYABLE_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase. Field renamed to remove unsuitable characters.
    purstochck_checking_time = models.DateTimeField(db_column='PurStoChck_CHECKING_TIME')  # Field name made lowercase.
    purstochck_broker = models.CharField(db_column='PurStoChck_BROKER', max_length=255)  # Field name made lowercase.
    purstochck_status = models.IntegerField(db_column='PurStoChck_STATUS')  # Field name made lowercase.
    purstochck_remarks = models.TextField(db_column='PurStoChck_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_checking'


class PurchaseContract(models.Model):
    purcont_contract_no = models.CharField(db_column='PurCont_CONTRACT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purcont_template_no = models.IntegerField(db_column='PurCont_TEMPLATE_NO', blank=True, null=True)  # Field name made lowercase.
    purcont_abstract = models.TextField(db_column='PurCont_ABSTRACT', blank=True, null=True)  # Field name made lowercase.
    purcont_contract_content = models.TextField(db_column='PurCont_CONTRACT_CONTENT', blank=True, null=True)  # Field name made lowercase.
    purcont_attachment = models.CharField(db_column='PurCont_ATTACHMENT', max_length=255, blank=True, null=True)  # Field name made lowercase.
    purcont_supplier_no = models.CharField(db_column='PurCont_SUPPLIER_NO', max_length=255)  # Field name made lowercase.
    purcont_responsible_man_no = models.CharField(db_column='PurCont_RESPONSIBLE_MAN_NO', max_length=255)  # Field name made lowercase.
    purcont_date = models.DateField(db_column='PurCont_DATE')  # Field name made lowercase.
    purcont_amount = models.FloatField(db_column='PurCont_AMOUNT')  # Field name made lowercase.
    purcont_account_payable = models.FloatField(db_column='PurCont_Account_Payable')  # Field name made lowercase.
    purcont_account_advance = models.FloatField(db_column='PurCont_Account_Advance')  # Field name made lowercase.
    purcont_status = models.IntegerField(db_column='PurCont_STATUS')  # Field name made lowercase.
    purcont_history = models.CharField(db_column='PurCont_History', max_length=255, blank=True, null=True)  # Field name made lowercase.
    purcont_remarks = models.TextField(db_column='PurCont_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_contract'


class PurchaseContractInput(models.Model):
    purcontin_contract_product_no = models.CharField(db_column='PurContIn_CONTRACT_PRODUCT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    purcontin_quantity = models.FloatField(db_column='PurContIn_QUANTITY')  # Field name made lowercase.
    purcontin_unit_price = models.DecimalField(db_column='PurContIn_UNIT_PRICE', max_digits=10, decimal_places=0)  # Field name made lowercase.
    purcontin_discount_amount = models.FloatField(db_column='PurContIn_DISCOUNT_AMOUNT', blank=True, null=True)  # Field name made lowercase.
    purcontin_discounted_price = models.DecimalField(db_column='PurContIn_DISCOUNTED_PRICE', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    purcontin_amount_paid = models.DecimalField(db_column='PurContIn_AMOUNT_PAID', max_digits=10, decimal_places=0)  # Field name made lowercase.
    purcontin_supplier = models.CharField(db_column='PurContIn_SUPPLIER', max_length=255)  # Field name made lowercase.
    purcontin_original_amount = models.DecimalField(db_column='PurContIn_ORIGINAL_AMOUNT', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    purcontin_discounted_amount = models.DecimalField(db_column='PurContIn_DISCOUNTED_AMOUNT', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    purcontin_receipt_created_man = models.CharField(db_column='PurContIn_RECEIPT_CREATED_MAN', max_length=255)  # Field name made lowercase.
    purcontin_broker = models.CharField(db_column='PurContIn_BROKER', max_length=255)  # Field name made lowercase.
    purcontin_storage_quantity = models.FloatField(db_column='PurContIn_STORAGE_QUANTITY')  # Field name made lowercase.
    purcontin_delivery_quantity = models.FloatField(db_column='PurContIn_Delivery_Quantity')  # Field name made lowercase.
    purcontin_status = models.IntegerField(db_column='PurContIn_STATUS')  # Field name made lowercase.
    purcontin_error = models.IntegerField(db_column='PurContIn_ERROR', blank=True, null=True)  # Field name made lowercase.
    purcontin_remarks = models.TextField(db_column='PurContIn_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_contract_input'


class PurchaseContractLog(models.Model):
    purcontlg_log_no = models.CharField(db_column='PurContLg_LOG_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purcontin_contract_no = models.CharField(db_column='PurContIn_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    purcontlg_user_no = models.CharField(db_column='PurContLg_USER_NO', max_length=255)  # Field name made lowercase.
    purcontlg_recorded_time = models.CharField(db_column='PurContLg_RECORDED_TIME', max_length=255)  # Field name made lowercase.
    purcontlg_remarks = models.TextField(db_column='PurContLg_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_contract_log'


class PurchaseInvoice(models.Model):
    purchase_invoice_no = models.CharField(db_column='PURCHASE_INVOICE_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purchase_invoice_type = models.CharField(db_column='PURCHASE_INVOICE_TYPE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    special_invoice_no = models.CharField(db_column='SPECIAL_INVOICE_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    sell_invoice_no = models.CharField(db_column='SELL_INVOICE_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    buyer_invoice_date = models.CharField(db_column='BUYER_INVOICE_DATE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    buyer_no = models.IntegerField(db_column='BUYER_NO', blank=True, null=True)  # Field name made lowercase.
    cargo_labor_name = models.CharField(db_column='CARGO_LABOR_NAME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    buyer_num = models.IntegerField(db_column='BUYER_NUM', blank=True, null=True)  # Field name made lowercase.
    buyer_money = models.DecimalField(db_column='BUYER_MONEY', max_digits=15, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    buyer_name = models.CharField(db_column='BUYER_NAME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    checker_name = models.CharField(db_column='CHECKER_NAME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    drawer_name = models.CharField(db_column='DRAWER_NAME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    purchase_invoice_status = models.IntegerField(db_column='PURCHASE_INVOICE_STATUS')  # Field name made lowercase.
    sales_invoice_photo = models.CharField(db_column='SALES_INVOICE_PHOTO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    sales_invoice_remarks = models.TextField(db_column='SALES_INVOICE_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_invoice'


class PurchaseInvoicePhoto(models.Model):
    purchase_invoice_no = models.CharField(db_column='PURCHASE_INVOICE_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purchase_invoice_photo = models.CharField(db_column='PURCHASE_INVOICE_PHOTO', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_invoice_photo'


class PurchaseMapping(models.Model):
    purcontin_contract_no = models.CharField(db_column='PurContIn_CONTRACT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    pursto_storage_no = models.TextField(db_column='PurSto_STORAGE_NO', blank=True, null=True)  # Field name made lowercase.
    purstochck_checking_no = models.TextField(db_column='PurStoChck_CHECKING_NO', blank=True, null=True)  # Field name made lowercase.
    purstorej_reject_no = models.TextField(db_column='PurStoRej_REJECT_NO', blank=True, null=True)  # Field name made lowercase.
    purmap_remarks = models.TextField(db_column='PurMap_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_mapping'


class PurchaseRelation(models.Model):
    purchase_relation_no = models.AutoField(db_column='PURCHASE_RELATION_NO', primary_key=True)  # Field name made lowercase.
    purcontin_contract_no = models.CharField(db_column='PurContIn_CONTRACT_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    purchase_invoice_no = models.TextField(db_column='PURCHASE_INVOICE_NO', blank=True, null=True)  # Field name made lowercase.
    purchase_invoice_status = models.IntegerField(db_column='PURCHASE_INVOICE_STATUS', blank=True, null=True)  # Field name made lowercase.
    sales_invoice_remarks = models.TextField(db_column='SALES_INVOICE_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_relation'


class PurchaseStorage(models.Model):
    purcontin_contract_no = models.CharField(db_column='PurContIn_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    pursto_storage_no = models.CharField(db_column='PurSto_STORAGE_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    pursto_product_name = models.CharField(db_column='PurSto_PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    pursto_product_model = models.CharField(db_column='PurSto_PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    pursto_product_measurement = models.CharField(db_column='PurSto_PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    pursto_storage_quantity = models.IntegerField(db_column='PurSto_STORAGE_QUANTITY')  # Field name made lowercase.
    pursto_already_quantity = models.IntegerField(db_column='PurSto_ALREADY_QUANTITY')  # Field name made lowercase.
    pursto_purchase_quantity = models.IntegerField(db_column='PurSto_PURCHASE_QUANTITY', blank=True, null=True)  # Field name made lowercase.
    pursto_unit_price = models.DecimalField(db_column='PurSto_UNIT_PRICE', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    pursto_amount_paid = models.DecimalField(db_column='PurSto_AMOUNT_PAID', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    pursto_supplier = models.CharField(db_column='PurSto_SUPPLIER', max_length=255)  # Field name made lowercase.
    pursto_entry_warehouse = models.CharField(db_column='PurSto_ENTRY_WAREHOUSE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    pursto_original_amount = models.DecimalField(db_column='PurSto_ORIGINAL_AMOUNT', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    pursto_payable_amount = models.DecimalField(db_column='PurSto_PAYABLE_AMOUNT', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    pursto_storage_time = models.DateTimeField(db_column='PurSto_STORAGE_TIME')  # Field name made lowercase.
    pursto_receipt_created_man = models.CharField(db_column='PurSto_RECEIPT_CREATED_MAN', max_length=255)  # Field name made lowercase.
    pursto_status = models.IntegerField(db_column='PurSto_STATUS', blank=True, null=True)  # Field name made lowercase.
    pursto_broker = models.CharField(db_column='PurSto_BROKER', max_length=255, blank=True, null=True)  # Field name made lowercase.
    pursto_remarks = models.TextField(db_column='PurSto_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_storage'


class PurchaseStorageLog(models.Model):
    purstolg_log_no = models.CharField(db_column='PurStoLg_LOG_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    pursto_storage_no = models.CharField(db_column='PurSto_STORAGE_NO', max_length=255)  # Field name made lowercase.
    purstolg_user_no = models.CharField(db_column='PurStoLg_USER_NO', max_length=255)  # Field name made lowercase.
    purstolg_storage_time = models.CharField(db_column='PurStoLg_STORAGE_TIME', max_length=255)  # Field name made lowercase.
    purstolg_remarks = models.TextField(db_column='PurStoLg_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_storage_log'


class PurchaseStorageReject(models.Model):
    purstorej_reject_no = models.CharField(db_column='PurStoRej_REJECT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purcontin_contract_no = models.CharField(db_column='PurContIn_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    product_no = models.CharField(db_column='PRODUCT_NO', max_length=255)  # Field name made lowercase.
    purstorej_reject_quantity = models.IntegerField(db_column='PurStoRej_REJECT_QUANTITY')  # Field name made lowercase.
    purstorej_unit_price = models.DecimalField(db_column='PurStoRej_UNIT_PRICE', max_digits=10, decimal_places=0)  # Field name made lowercase.
    purstorej_refund_amount = models.DecimalField(db_column='PurStoRej_REFUND_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase.
    purstorej_supplier = models.CharField(db_column='PurStoRej_SUPPLIER', max_length=255)  # Field name made lowercase.
    purstorej_storage_warehouse = models.CharField(db_column='PurStoRej_STORAGE_WAREHOUSE', max_length=255)  # Field name made lowercase.
    purstorej_responsible_man = models.DecimalField(db_column='PurStoRej_RESPONSIBLE_MAN', max_digits=10, decimal_places=0)  # Field name made lowercase.
    purstorej_reject_time = models.DateField(db_column='PurStoRej_REJECT_TIME')  # Field name made lowercase.
    purstorej_broker = models.CharField(db_column='PurStoRej_BROKER', max_length=255)  # Field name made lowercase.
    purstorej_remarks = models.TextField(db_column='PurStoRej_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'purchase_storage_reject'


class RegisterApprove(models.Model):
    register_no = models.AutoField(db_column='Register_No', primary_key=True)  # Field name made lowercase.
    register_company = models.CharField(db_column='Register_Company', max_length=255)  # Field name made lowercase.
    register_person = models.CharField(db_column='Register_Person', max_length=255)  # Field name made lowercase.
    register_business_no = models.CharField(db_column='Register_Business_No', max_length=255)  # Field name made lowercase.
    register_business_address = models.CharField(db_column='Register_Business_Address', max_length=255)  # Field name made lowercase.
    register_phone = models.CharField(db_column='Register_Phone', max_length=255)  # Field name made lowercase.
    register_password = models.CharField(db_column='Register_Password', max_length=255)  # Field name made lowercase.
    register_mobile_phone = models.CharField(db_column='Register_Mobile_Phone', max_length=255)  # Field name made lowercase.
    register_bank_account = models.CharField(db_column='Register_Bank_Account', max_length=255)  # Field name made lowercase.
    register_business_photo = models.CharField(db_column='Register_Business_Photo', max_length=255)  # Field name made lowercase.
    register_status = models.IntegerField(db_column='Register_Status')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'register_approve'


class SalesBiddingLog(models.Model):
    slsbdlg_log_no = models.AutoField(db_column='SlsBdLg_LOG_NO', primary_key=True)  # Field name made lowercase.
    slsbdlg_user_no = models.CharField(db_column='SlsBdLg_USER_NO', max_length=255)  # Field name made lowercase.
    slsbdlg_time = models.DateTimeField(db_column='SlsBdLg_TIME')  # Field name made lowercase.
    slsbdlg_remarks = models.TextField(db_column='SlsBdLg_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_bidding_log'


class SalesContract(models.Model):
    slscont_contract_no = models.CharField(db_column='SlsCont_CONTRACT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    slscont_template_no = models.IntegerField(db_column='SlsCont_TEMPLATE_NO', blank=True, null=True)  # Field name made lowercase.
    slscont_contract_content = models.TextField(db_column='SlsCont_CONTRACT_CONTENT', blank=True, null=True)  # Field name made lowercase.
    slscont_deposit = models.FloatField(db_column='SlsCont_DEPOSIT', blank=True, null=True)  # Field name made lowercase.
    slscont_customer_no = models.CharField(db_column='SlsCont_CUSTOMER_NO', max_length=255)  # Field name made lowercase.
    slscont_responsible_man_no = models.CharField(db_column='SlsCont_RESPONSIBLE_MAN_NO', max_length=255)  # Field name made lowercase.
    slscont_date = models.DateField(db_column='SlsCont_DATE')  # Field name made lowercase.
    slscont_amount = models.FloatField(db_column='SlsCont_AMOUNT')  # Field name made lowercase.
    slscont_account_receivable = models.FloatField(db_column='SlsCont_Account_Receivable')  # Field name made lowercase.
    slscont_account_advance = models.FloatField(db_column='SlsCont_Account_Advance')  # Field name made lowercase.
    slscont_status = models.IntegerField(db_column='SlsCont_STATUS')  # Field name made lowercase.
    slscont_history = models.CharField(db_column='SlsCont_History', max_length=255, blank=True, null=True)  # Field name made lowercase.
    slscont_remarks = models.TextField(db_column='SlsCont_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_contract'


class SalesContractAttachment(models.Model):
    sales_contract_no = models.CharField(db_column='Sales_CONTRACT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    sales_contract_photo = models.CharField(db_column='Sales_CONTRACT_PHOTO', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_contract_attachment'


class SalesContractInput(models.Model):
    slscontin_contract_product_no = models.CharField(db_column='SlsContIn_CONTRACT_PRODUCT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    slscontin_order_quantity = models.DecimalField(db_column='SlsContIn_ORDER_QUANTITY', max_digits=10, decimal_places=0)  # Field name made lowercase.
    slscontin_tax_unit_price = models.DecimalField(db_column='SlsContIn_TAX_UNIT_PRICE', max_digits=11, decimal_places=0)  # Field name made lowercase.
    slscontin_pur_asking_price = models.DecimalField(db_column='SlsContIn_PUR_ASKING_PRICE', max_digits=10, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    slscontin_tax_rate = models.DecimalField(db_column='SlsContIn_TAX_RATE', max_digits=15, decimal_places=2)  # Field name made lowercase.
    slscontin_unit_price = models.DecimalField(db_column='SlsContIn_UNIT_PRICE', max_digits=10, decimal_places=0)  # Field name made lowercase.
    slscontin_tax_amount = models.DecimalField(db_column='SlsContIn_TAX_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase.
    slscontin_amount = models.DecimalField(db_column='SlsContIn_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase.
    slscontin_total_amount = models.DecimalField(db_column='SlsContIn_TOTAL_AMOUNT', max_digits=10, decimal_places=2)  # Field name made lowercase.
    slscontin_discounted_amount = models.DecimalField(db_column='SlsContIn_DISCOUNTED_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase.
    slscontin_sales_bidding_no = models.CharField(db_column='SlsContIn_SALES_BIDDING_NO', max_length=255)  # Field name made lowercase.
    slscontin_customer_no = models.CharField(db_column='SlsContIn_CUSTOMER_NO', max_length=255)  # Field name made lowercase.
    slscontin_receipt_created_man = models.CharField(db_column='SlsContIn_RECEIPT_CREATED_MAN', max_length=255)  # Field name made lowercase.
    slscontin_responsible_man = models.CharField(db_column='SlsContIn_RESPONSIBLE_MAN', max_length=255)  # Field name made lowercase.
    slscontin_delivery_date = models.DateTimeField(db_column='SlsContIn_DELIVERY_DATE', blank=True, null=True)  # Field name made lowercase.
    slscontin_delivery_address = models.CharField(db_column='SlsContIn_DELIVERY_ADDRESS', max_length=255, blank=True, null=True)  # Field name made lowercase.
    slscontin_error = models.IntegerField(db_column='SlsContIn_ERROR')  # Field name made lowercase.
    slscontin_status = models.IntegerField(db_column='SlsContIn_STATUS')  # Field name made lowercase.
    slscontin_remarks = models.TextField(db_column='SlsContIn_REMARKS', blank=True, null=True)  # Field name made lowercase.
    slscontin_supplier = models.CharField(db_column='SlsContIn_SUPPLIER', max_length=255)  # Field name made lowercase.
    slscontin_delivery_quantity = models.DecimalField(db_column='SlsContIn_DELIVERY_QUANTITY', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    slscontin_storage_quantity = models.DecimalField(db_column='SlsContIn_STORAGE_QUANTITY', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_contract_input'


class SalesContractLog(models.Model):
    slscontlg_log_no = models.AutoField(db_column='SlsContLg_LOG_NO', primary_key=True)  # Field name made lowercase.
    slscontlg_contract_no = models.CharField(db_column='SlsContLg_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    slscontlg_user_no = models.CharField(db_column='SlsContLg_USER_NO', max_length=255)  # Field name made lowercase.
    slscontlg_recorded_time = models.CharField(db_column='SlsContLg_RECORDED_TIME', max_length=255)  # Field name made lowercase.
    slscontlg_remarks = models.TextField(db_column='SlsContLg_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_contract_log'


class SalesDelivery(models.Model):
    slsdeli_delivery_no = models.CharField(db_column='SlsDeli_DELIVERY_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    slscontin_contract_no = models.CharField(db_column='SlsContIn_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    slsdeli_product_name = models.CharField(db_column='SlsDeli_PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    slsdeli_product_model = models.CharField(db_column='SlsDeli_PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    slsdeli_product_measurement = models.CharField(db_column='SlsDeli_PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    slsdeli_order_quantity = models.IntegerField(db_column='SlsDeli_ORDER_QUANTITY')  # Field name made lowercase.
    slsdeli_delivery_quantity = models.IntegerField(db_column='SlsDeli_DELIVERY_QUANTITY')  # Field name made lowercase.
    slsdeli_already_quantity = models.IntegerField(db_column='SlsDeli_ALREADY_QUANTITY')  # Field name made lowercase.
    slsdeli_unit_price = models.DecimalField(db_column='SlsDeli_UNIT_PRICE', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    slsdeli_original_amount = models.DecimalField(db_column='SlsDeli_ORIGINAL_AMOUNT', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    slsdeli_amount_paid = models.DecimalField(db_column='SlsDeli_AMOUNT_PAID', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    slsdeli_customer_no = models.CharField(db_column='SlsDeli_CUSTOMER_NO', max_length=255)  # Field name made lowercase.
    slsdeli_delivery_time = models.DateTimeField(db_column='SlsDeli_DELIVERY_TIME')  # Field name made lowercase.
    slsdeli_shipping_warehouse = models.CharField(db_column='SlsDeli_SHIPPING_WAREHOUSE', max_length=255)  # Field name made lowercase.
    slsdeli_shipping_address = models.CharField(db_column='SlsDeli_SHIPPING_ADDRESS', max_length=255)  # Field name made lowercase.
    slsdeli_receipt_created_man = models.CharField(db_column='SlsDeli_RECEIPT_CREATED_MAN', max_length=255)  # Field name made lowercase.
    slsdeli_broker = models.CharField(db_column='SlsDeli_BROKER', max_length=255)  # Field name made lowercase.
    slsdeli_product_photo = models.TextField(db_column='SlsDeli_PRODUCT_PHOTO', blank=True, null=True)  # Field name made lowercase.
    slsdeli_status = models.IntegerField(db_column='SlsDeli_STATUS', blank=True, null=True)  # Field name made lowercase.
    slsdeli_remarks = models.TextField(db_column='SlsDeli_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_delivery'


class SalesDeliveryLog(models.Model):
    slsdelilg_log_no = models.CharField(db_column='SlsDeliLg_LOG_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    slsdeli_delivery_no = models.CharField(db_column='SlsDeli_DELIVERY_NO', max_length=255)  # Field name made lowercase.
    slsdelilg_user_no = models.CharField(db_column='SlsDeliLg_USER_NO', max_length=11)  # Field name made lowercase.
    slsdelilg_delivery_time = models.CharField(db_column='SlsDeliLg_DELIVERY_TIME', max_length=255)  # Field name made lowercase.
    slsdelilg_remarks = models.TextField(db_column='SlsDeliLg_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_delivery_log'


class SalesInvoice(models.Model):
    sales_invoice_no = models.CharField(db_column='SALES_INVOICE_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    sales_invoice_type = models.CharField(db_column='SALES_INVOICE_TYPE', max_length=255, blank=True, null=True)  # Field name made lowercase.
    special_invoice_no = models.CharField(db_column='SPECIAL_INVOICE_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    buy_invoice_no = models.CharField(db_column='BUY_INVOICE_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    sales_invoice_date = models.DateField(db_column='SALES_INVOICE_DATE', blank=True, null=True)  # Field name made lowercase.
    buyer_no = models.CharField(db_column='BUYER_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    cargo_labor_name = models.CharField(db_column='CARGO_LABOR_NAME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    sales_num = models.IntegerField(db_column='SALES_NUM', blank=True, null=True)  # Field name made lowercase.
    sales_money = models.DecimalField(db_column='SALES_MONEY', max_digits=15, decimal_places=2)  # Field name made lowercase.
    seller_no = models.IntegerField(db_column='SELLER_NO', blank=True, null=True)  # Field name made lowercase.
    checker_name = models.CharField(db_column='CHECKER_NAME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    drawer_name = models.CharField(db_column='DRAWER_NAME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    sales_status = models.IntegerField(db_column='SALES_STATUS')  # Field name made lowercase.
    sales_invoice_photo = models.CharField(db_column='SALES_INVOICE_PHOTO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    sales_invoice_remarks = models.TextField(db_column='SALES_INVOICE_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_invoice'


class SalesInvoicePhoto(models.Model):
    sales_invoice_no = models.CharField(db_column='SALES_INVOICE_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    sales_invoice_photo = models.CharField(db_column='SALES_INVOICE_PHOTO', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_invoice_photo'


class SalesMapping(models.Model):
    slscontin_contract_no = models.CharField(db_column='SlsContIn_CONTRACT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    slsdeli_delivery_no = models.TextField(db_column='SlsDeli_DELIVERY_NO', blank=True, null=True)  # Field name made lowercase.
    shpchck_checking_no = models.TextField(db_column='ShpChck_CHECKING_NO', blank=True, null=True)  # Field name made lowercase.
    slsprodrej_reject_no = models.TextField(db_column='SlsProdRej_REJECT_NO', blank=True, null=True)  # Field name made lowercase.
    slsmap_remarks = models.TextField(db_column='SlsMap_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_mapping'


class SalesProductReject(models.Model):
    slsprodrej_reject_no = models.CharField(db_column='SlsProdRej_REJECT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    slscontin_contract_no = models.CharField(db_column='SlsContIn_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    shpchck_checking_no = models.CharField(db_column='ShpChck_CHECKING_NO', max_length=255)  # Field name made lowercase.
    product_no = models.CharField(db_column='PRODUCT_NO', max_length=255)  # Field name made lowercase.
    slsprodrej_reject_quantity = models.IntegerField(db_column='SlsProdRej_REJECT_QUANTITY')  # Field name made lowercase.
    slsprodrej_unit_price = models.DecimalField(db_column='SlsProdRej_UNIT_PRICE', max_digits=10, decimal_places=0)  # Field name made lowercase.
    slsprodrej_amount = models.DecimalField(db_column='SlsProdRej_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase.
    slsprodrej_cunstomer_name = models.CharField(db_column='SlsProdRej_CUNSTOMER_NAME', max_length=255)  # Field name made lowercase.
    slsprodrej_storage_warehouse = models.CharField(db_column='SlsProdRej_STORAGE_WAREHOUSE', max_length=255)  # Field name made lowercase.
    slsprodrej_responsible_man = models.CharField(db_column='SlsProdRej_RESPONSIBLE_MAN', max_length=255)  # Field name made lowercase.
    slsprodrej_reject_time = models.DateField(db_column='SlsProdRej_REJECT_TIME')  # Field name made lowercase.
    slsprodrej_status = models.IntegerField(db_column='SlsProdRej_STATUS')  # Field name made lowercase.
    slsprodrej_remarks = models.TextField(db_column='SlsProdRej_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_product_reject'


class SalesPurchaseMapping(models.Model):
    slscontin_contract_no = models.CharField(db_column='SlsContIn_CONTRACT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purcontin_contract_no = models.TextField(db_column='PurContIn_CONTRACT_NO', blank=True, null=True)  # Field name made lowercase.
    slspurmap_remarks = models.TextField(db_column='SlsPurMap_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_purchase_mapping'


class SalesQuotationLog(models.Model):
    sales_quotation_log_no = models.AutoField(primary_key=True)
    sales_quotation_no = models.CharField(max_length=255)
    sales_quotation_approve = models.TextField()
    sales_quotation_usr = models.CharField(max_length=255)
    sales_quotation_time = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'sales_quotation_log'


class SalesRelation(models.Model):
    sales_relation_no = models.AutoField(db_column='SALES_RELATION_NO', primary_key=True)  # Field name made lowercase.
    slscontin_contract_no = models.CharField(db_column='SlsContIn_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    sales_invoice_no = models.TextField(db_column='SALES_INVOICE_NO')  # Field name made lowercase.
    sales_relation_status = models.CharField(db_column='SALES_RELATION_STATUS', max_length=255)  # Field name made lowercase.
    sales_relation_remarks = models.TextField(db_column='SALES_RELATION_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_relation'


class SalesVoucher(models.Model):
    sales_voucher_no = models.CharField(db_column='Sales_voucher_no', primary_key=True, max_length=255)  # Field name made lowercase.
    slscontin_contract_no = models.CharField(db_column='SlsContIn_contract_no', max_length=255)  # Field name made lowercase.
    payer_no = models.CharField(db_column='Payer_no', max_length=255)  # Field name made lowercase.
    receiver_no = models.CharField(db_column='Receiver_no', max_length=255)  # Field name made lowercase.
    money = models.DecimalField(db_column='Money', max_digits=15, decimal_places=2)  # Field name made lowercase.
    pay_time = models.DateField(db_column='Pay_time')  # Field name made lowercase.
    sales_voucher_broker = models.CharField(db_column='Sales_voucher_broker', max_length=255)  # Field name made lowercase.
    sales_sup_account = models.CharField(db_column='Sales_sup_account', max_length=255)  # Field name made lowercase.
    sales_usr_account = models.CharField(db_column='Sales_usr_account', max_length=255)  # Field name made lowercase.
    sales_voucher_remarks = models.TextField(db_column='Sales_voucher_remarks', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sales_voucher'


class ShippingChecking(models.Model):
    shpchck_checking_no = models.CharField(db_column='ShpChck_CHECKING_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    slsdeli_delivery_no = models.CharField(db_column='SlsDeli_DELIVERY_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    shpchck_price = models.DecimalField(db_column='ShpChck_PRICE', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    shpchck_shipping_quantity = models.IntegerField(db_column='ShpChck_SHIPPING_QUANTITY')  # Field name made lowercase.
    shpchck_qualified_quantity = models.IntegerField(db_column='ShpChck_QUALIFIED_QUANTITY', blank=True, null=True)  # Field name made lowercase.
    shpchck_amount = models.DecimalField(db_column='ShpChck_AMOUNT', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    shpchck_receivable_amount = models.DecimalField(db_column='ShpChck_RECEIVABLE_AMOUNT', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    shpchck_customer_no = models.CharField(db_column='ShpChck_CUSTOMER_NO', max_length=255)  # Field name made lowercase.
    shpchck_responsible_man = models.CharField(db_column='ShpChck_RESPONSIBLE_MAN', max_length=255, blank=True, null=True)  # Field name made lowercase.
    shpchck_checking_time = models.DateTimeField(db_column='ShpChck_CHECKING_TIME', blank=True, null=True)  # Field name made lowercase.
    shpchck_broker = models.CharField(db_column='ShpChck_BROKER', max_length=255, blank=True, null=True)  # Field name made lowercase.
    shpchck_status = models.IntegerField(db_column='ShpChck_STATUS')  # Field name made lowercase.
    shpchck_remarks = models.TextField(db_column='ShpChck_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'shipping_checking'


class Status(models.Model):
    stat_no = models.IntegerField(db_column='Stat_NO', primary_key=True)  # Field name made lowercase.
    stat_name = models.CharField(db_column='Stat_NAME', max_length=255, blank=True, null=True)  # Field name made lowercase.
    stat_remarks = models.TextField(db_column='Stat_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'status'


class Supplier(models.Model):
    supp_no = models.CharField(db_column='Supp_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    supp_name = models.CharField(db_column='Supp_NAME', max_length=255)  # Field name made lowercase.
    supp_contacts = models.CharField(db_column='Supp_CONTACTS', max_length=255)  # Field name made lowercase.
    supp_address = models.CharField(db_column='Supp_ADDRESS', max_length=50, blank=True, null=True)  # Field name made lowercase.
    supp_phone_no = models.CharField(db_column='Supp_PHONE_NO', max_length=50)  # Field name made lowercase.
    supp_email = models.CharField(db_column='Supp_EMAIL', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supp_bank_account = models.CharField(db_column='Supp_Bank_Account', max_length=255)  # Field name made lowercase.
    supp_remarks = models.TextField(db_column='Supp_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supplier'


class SupplierAgentMapping(models.Model):
    supplier_mapping_no = models.AutoField(db_column='SUPPLIER_MAPPING_NO', primary_key=True)  # Field name made lowercase.
    supplier_no = models.CharField(db_column='SUPPLIER_NO', max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    customer_no = models.CharField(db_column='CUSTOMER_NO', max_length=255)  # Field name made lowercase.
    agent_name = models.CharField(db_column='AGENT_NAME', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supplier_agent_mapping'


class SupplierBidding(models.Model):
    supbd_product_name = models.CharField(db_column='SupBd_PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    supbd_product_model = models.CharField(db_column='SupBd_PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    supbd_product_measurement = models.CharField(db_column='SupBd_PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    supbd_quantity = models.IntegerField(db_column='SupBd_QUANTITY')  # Field name made lowercase.
    supbd_real_asking_price = models.DecimalField(db_column='SupBd_REAL_ASKING_PRICE', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    supbd_amount = models.DecimalField(db_column='SupBd_AMOUNT', max_digits=10, decimal_places=0, blank=True, null=True)  # Field name made lowercase.
    supbd_bidding_time = models.DateTimeField(db_column='SupBd_BIDDING_TIME', blank=True, null=True)  # Field name made lowercase.
    supbd_price_validity = models.DateTimeField(db_column='SupBd_PRICE_VALIDITY', blank=True, null=True)  # Field name made lowercase.
    supbd_supplier = models.CharField(db_column='SupBd_SUPPLIER', max_length=255)  # Field name made lowercase.
    supbd_remarks = models.TextField(db_column='SupBd_REMARKS', blank=True, null=True)  # Field name made lowercase.
    supbd_product_photo = models.CharField(db_column='SupBd_PRODUCT_PHOTO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supbd_product_description = models.CharField(db_column='SupBd_PRODUCT_DESCRIPTION', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supbd_status = models.IntegerField(db_column='SupBd_STATUS')  # Field name made lowercase.
    supbd_bidding_no = models.CharField(db_column='SupBd_BIDDING_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    supbd_customer = models.CharField(db_column='SupBd_CUSTOMER', max_length=255)  # Field name made lowercase.
    supbd_staff = models.CharField(db_column='SupBd_STAFF', max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supplier_bidding'


class SupplierSalesDelivery(models.Model):
    supslsdeli_delivery_no = models.CharField(db_column='SupSlsDeli_DELIVERY_NO', max_length=255)  # Field name made lowercase.
    supsupcont_contract_no = models.CharField(db_column='SupSupCont_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    supslsdeli_product_name = models.CharField(db_column='SupSlsDeli_PRODUCT_NAME', max_length=255)  # Field name made lowercase.
    supslsdeli_product_model = models.CharField(db_column='SupSlsDeli_PRODUCT_MODEL', max_length=255)  # Field name made lowercase.
    supslsdeli_product_measurement = models.CharField(db_column='SupSlsDeli_PRODUCT_MEASUREMENT', max_length=255)  # Field name made lowercase.
    supslsdeli_order_quantity = models.IntegerField(db_column='SupSlsDeli_ORDER_QUANTITY')  # Field name made lowercase.
    supslsdeli_delivery_quantity = models.IntegerField(db_column='SupSlsDeli_DELIVERY_QUANTITY')  # Field name made lowercase.
    supslsdeli_unit_price = models.DecimalField(db_column='SupSlsDeli_UNIT_PRICE', max_digits=10, decimal_places=0)  # Field name made lowercase.
    supslsdeli_original_amount = models.DecimalField(db_column='SupSlsDeli_ORIGINAL_AMOUNT', max_digits=10, decimal_places=0)  # Field name made lowercase.
    supslsdeli_amount_paid = models.DecimalField(db_column='SupSlsDeli_AMOUNT_PAID', max_digits=10, decimal_places=0)  # Field name made lowercase.
    supslsdeli_customer_no = models.IntegerField(db_column='SupSlsDeli_CUSTOMER_NO')  # Field name made lowercase.
    supslsdeli_delivery_time = models.DateTimeField(db_column='SupSlsDeli_DELIVERY_TIME')  # Field name made lowercase.
    supslsdeli_shipping_warehouse = models.CharField(db_column='SupSlsDeli_SHIPPING_WAREHOUSE', max_length=255)  # Field name made lowercase.
    supslsdeli_shipping_address = models.CharField(db_column='SupSlsDeli_SHIPPING_ADDRESS', max_length=255)  # Field name made lowercase.
    supslsdeli_receipt_created_man = models.CharField(db_column='SupSlsDeli_RECEIPT_CREATED_MAN', max_length=255)  # Field name made lowercase.
    supslsdeli_broker = models.CharField(db_column='SupSlsDeli_BROKER', max_length=255)  # Field name made lowercase.
    supslsdeli_product_photo = models.TextField(db_column='SupSlsDeli_PRODUCT_PHOTO', blank=True, null=True)  # Field name made lowercase.
    supslsdeli_status = models.TextField(db_column='SupSlsDeli_STATUS', blank=True, null=True)  # Field name made lowercase.
    supslsdeli_remarks = models.TextField(db_column='SupSlsDeli_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supplier_sales_delivery'


class SupplierSalesDeliveryLog(models.Model):
    supslsdelilg_log_no = models.CharField(db_column='SupSlsDeliLg_LOG_NO', max_length=255)  # Field name made lowercase.
    supslsdeli_delivery_no = models.CharField(db_column='SupSlsDeli_DELIVERY_NO', max_length=255)  # Field name made lowercase.
    supslsdelilg_user_no = models.IntegerField(db_column='SupSlsDeliLg_USER_NO')  # Field name made lowercase.
    supslsdelilg_delivery_time = models.DateField(db_column='SupSlsDeliLg_DELIVERY_TIME')  # Field name made lowercase.
    supslsdelilg_remarks = models.TextField(db_column='SupSlsDeliLg_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supplier_sales_delivery_log'


class SupplierSalesInvoice(models.Model):
    supplier_sales_invoice_no = models.IntegerField(db_column='SUPPLIER_SALES _INVOICE_NO', primary_key=True)  # Field name made lowercase. Field renamed to remove unsuitable characters.
    supplier_sales_invoice_type = models.CharField(db_column='SUPPLIER_SALES _INVOICE_TYPE', max_length=255)  # Field name made lowercase. Field renamed to remove unsuitable characters.
    supplier_special_invoice_no = models.CharField(db_column='SUPPLIER_SPECIAL_INVOICE_NO', max_length=255)  # Field name made lowercase.
    supplier_buy_invoice_no = models.CharField(db_column='SUPPLIER_BUY_INVOICE_NO', max_length=255)  # Field name made lowercase.
    supplier_sales_invoice_date = models.DateField(db_column='SUPPLIER_SALES_INVOICE_DATE')  # Field name made lowercase.
    supplier_buyer_no = models.IntegerField(db_column='SUPPLIER_BUYER_NO')  # Field name made lowercase.
    supplier_cargo_labor_name = models.CharField(db_column='SUPPLIER_CARGO_LABOR_NAME', max_length=255)  # Field name made lowercase.
    supplier_sales_num = models.IntegerField(db_column='SUPPLIER_SALES _NUM')  # Field name made lowercase. Field renamed to remove unsuitable characters.
    supplier_sales_money = models.DecimalField(db_column='SUPPLIER_SALES _MONEY', max_digits=15, decimal_places=2)  # Field name made lowercase. Field renamed to remove unsuitable characters.
    supplier_seller_no = models.IntegerField(db_column='SUPPLIER_SELLER _ NO')  # Field name made lowercase. Field renamed to remove unsuitable characters.
    supplier_checker_name = models.CharField(db_column='SUPPLIER_CHECKER_NAME', max_length=255)  # Field name made lowercase.
    supplier_drawer_name = models.CharField(db_column='SUPPLIER_DRAWER_NAME', max_length=255)  # Field name made lowercase.
    supplier_sales_invoice_photo = models.CharField(db_column='SUPPLIER_SALES_INVOICE_PHOTO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supplier_sales_invoice_remarks = models.TextField(db_column='SUPPLIER_SALES_INVOICE_REMARKS', blank=True, null=True)  # Field name made lowercase.
    supplier_sales_status = models.IntegerField(db_column='SUPPLIER_SALES_STATUS')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supplier_sales_invoice'


class SupplierSalesRelation(models.Model):
    supplier_sales_relation_no = models.AutoField(db_column='SUPPLIER_SALES _RELATION_NO', primary_key=True)  # Field name made lowercase. Field renamed to remove unsuitable characters.
    supplier_supcont_contract_no = models.CharField(db_column='SUPPLIER_SupCont_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    supplier_sales_invoice_no = models.TextField(db_column='SUPPLIER_SALES _INVOICE_NO')  # Field name made lowercase. Field renamed to remove unsuitable characters.
    supplier_sales_relation_status = models.CharField(db_column='SUPPLIER_SALES_RELATION _STATUS', max_length=255)  # Field name made lowercase. Field renamed to remove unsuitable characters.
    supplier_sales_relation_remarks = models.TextField(db_column='SUPPLIER_SALES_RELATION _REMARKS', blank=True, null=True)  # Field name made lowercase. Field renamed to remove unsuitable characters.

    class Meta:
        managed = False
        db_table = 'supplier_sales_relation'


class SupplyContract(models.Model):
    supcont_contract_no = models.CharField(db_column='SupCont_CONTRACT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    supcont_template_no = models.IntegerField(db_column='SupCont_TEMPLATE_NO', blank=True, null=True)  # Field name made lowercase.
    supcont_abstract = models.TextField(db_column='SupCont_ABSTRACT', blank=True, null=True)  # Field name made lowercase.
    supcont_contract_content = models.TextField(db_column='SupCont_CONTRACT_CONTENT', blank=True, null=True)  # Field name made lowercase.
    supcont_attachment = models.CharField(db_column='SupCont_ATTACHMENT', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supcont_customer = models.CharField(db_column='SupCont_CUSTOMER', max_length=255)  # Field name made lowercase.
    supcont_date = models.DateTimeField(db_column='SupCont_DATE')  # Field name made lowercase.
    supcont_amount = models.FloatField(db_column='SupCont_AMOUNT')  # Field name made lowercase.
    supcont_status = models.IntegerField(db_column='SupCont_STATUS')  # Field name made lowercase.
    supcont_remarks = models.TextField(db_column='SupCont_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supply_contract'


class SupplyContractInput(models.Model):
    supcontin_contract_product_no = models.CharField(db_column='SupContIn_CONTRACT_PRODUCT_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    product_no = models.IntegerField(db_column='PRODUCT_NO')  # Field name made lowercase.
    supcontin_bidding_quantity = models.DecimalField(db_column='SupContIn_BIDDING_QUANTITY', max_digits=15, decimal_places=2)  # Field name made lowercase.
    supcontin_supply_quantity = models.DecimalField(db_column='SupContIn_SUPPLY_QUANTITY', max_digits=15, decimal_places=2)  # Field name made lowercase.
    supcontin_tax_unit_price = models.DecimalField(db_column='SupContIn_TAX_UNIT_PRICE', max_digits=15, decimal_places=2)  # Field name made lowercase.
    supcontin_tax_rate = models.DecimalField(db_column='SupContIn_TAX_RATE', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    supcontin_unit_price = models.DecimalField(db_column='SupContIn_UNIT_PRICE', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    supcontin_tax_amount = models.DecimalField(db_column='SupContIn_TAX_AMOUNT', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    supcontin_amount = models.DecimalField(db_column='SupContIn_AMOUNT', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    supcontin_total_amount = models.DecimalField(db_column='SupContIn_TOTAL_AMOUNT', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    supcontin_discounted_amount = models.DecimalField(db_column='SupContIn_DISCOUNTED_AMOUNT', max_digits=15, decimal_places=2, blank=True, null=True)  # Field name made lowercase.
    supcontin_agent_bidding_no = models.CharField(db_column='SupContIn_AGENT_BIDDING_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supcontin_customer_no = models.CharField(db_column='SupContIn_CUSTOMER_NO', max_length=255)  # Field name made lowercase.
    supcontin_receipt_created_man = models.CharField(db_column='SupContIn_RECEIPT_CREATED_MAN', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supcontin_responsible_man = models.CharField(db_column='SupContIn_RESPONSIBLE_MAN', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supcontin_delivery_date = models.DateTimeField(db_column='SupContIn_DELIVERY_DATE', blank=True, null=True)  # Field name made lowercase.
    supcontin_delivery_address = models.CharField(db_column='SupContIn_DELIVERY_ADDRESS', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supcontin_status = models.IntegerField(db_column='SupContIn_STATUS')  # Field name made lowercase.
    supcontin_remarks = models.TextField(db_column='SupContIn_REMARKS', blank=True, null=True)  # Field name made lowercase.
    supcontin_delivery_quantity = models.DecimalField(db_column='SupContIn_DELIVERY_QUANTITY', max_digits=10, decimal_places=2, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supply_contract_input'


class SupplyContractLog(models.Model):
    supcontlg_log_no = models.CharField(db_column='SupContLg_LOG_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    supcont_contract_no = models.CharField(db_column='SupCont_CONTRACT_NO', max_length=255)  # Field name made lowercase.
    supcontlg_user_no = models.IntegerField(db_column='SupContLg_USER_NO')  # Field name made lowercase.
    supcontlg_recorded_time = models.CharField(db_column='SupContLg_RECORDED_TIME', max_length=255)  # Field name made lowercase.
    supcontlg_remarks = models.TextField(db_column='SupContLg_REMARKS')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supply_contract_log'


class SupplyWarehouse(models.Model):
    supwaho_warehouse_no = models.IntegerField(db_column='SupWaho_WAREHOUSE_NO', primary_key=True)  # Field name made lowercase.
    supwaho_warehouse_name = models.CharField(db_column='SupWaho_WAREHOUSE_NAME', max_length=255)  # Field name made lowercase.
    supwaho_remarks = models.TextField(db_column='SupWaho_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'supply_warehouse'


class TableMapping(models.Model):
    hnask_asking_no = models.CharField(db_column='HNAsk_ASKING_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purask_asking_no = models.CharField(db_column='PurAsk_ASKING_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnslsbd_bidding_no = models.CharField(db_column='HNSlsBd_BIDDING_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    tbmap_remarks = models.TextField(db_column='TbMap_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'table_mapping'


class TableMappings(models.Model):
    hnask_asking_no = models.CharField(db_column='HNAsk_ASKING_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    purask_asking_no = models.CharField(db_column='PurAsk_ASKING_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    hnslsbd_bidding_no = models.CharField(db_column='HNSlsBd_BIDDING_NO', max_length=255, blank=True, null=True)  # Field name made lowercase.
    tbmap_remarks = models.TextField(db_column='TbMap_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'table_mappings'


class TaxRate(models.Model):
    txrt_no = models.AutoField(db_column='TxRt_NO', primary_key=True)  # Field name made lowercase.
    txrt_name = models.CharField(db_column='TxRt_NAME', max_length=50, blank=True, null=True)  # Field name made lowercase.
    txrt_value = models.DecimalField(db_column='TxRt_VALUE', max_digits=10, decimal_places=3, blank=True, null=True)  # Field name made lowercase.
    txrt_remarks = models.TextField(db_column='TxRt_REMARKS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'tax_rate'


class TemplateContract(models.Model):
    template_no = models.AutoField(db_column='TEMPLATE_NO', primary_key=True)  # Field name made lowercase.
    customer_no = models.IntegerField(db_column='CUSTOMER_NO')  # Field name made lowercase.
    template_name = models.CharField(db_column='TEMPLATE_NAME', max_length=255)  # Field name made lowercase.
    template_content = models.TextField(db_column='TEMPLATE_CONTENT', blank=True, null=True)  # Field name made lowercase.
    template_remarks = models.CharField(db_column='TEMPLATE_REMARKS', max_length=255, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'template_contract'


class Users(models.Model):
    usr_duties = models.CharField(db_column='USR_DUTIES', max_length=50, blank=True, null=True)  # Field name made lowercase.
    usr_employed_time = models.DateTimeField(db_column='USR_EMPLOYED_TIME', blank=True, null=True)  # Field name made lowercase.
    usr_password = models.CharField(db_column='USR_PASSWORD', max_length=50)  # Field name made lowercase.
    usr_department = models.CharField(db_column='USR_DEPARTMENT', max_length=255)  # Field name made lowercase.
    usr_mobile_no = models.CharField(db_column='USR_MOBILE_NO', max_length=50)  # Field name made lowercase.
    usr_email = models.CharField(db_column='USR_EMAIL', max_length=255, blank=True, null=True)  # Field name made lowercase.
    usr_rights = models.CharField(db_column='USR_RIGHTS', max_length=255)  # Field name made lowercase.
    usr_mask = models.IntegerField(db_column='USR_MASK', blank=True, null=True)  # Field name made lowercase.
    usr_true_name = models.CharField(db_column='USR_TRUE_NAME', max_length=50, blank=True, null=True)  # Field name made lowercase.
    usr_no = models.CharField(db_column='USR_NO', primary_key=True, max_length=255)  # Field name made lowercase.
    usr_remarks = models.TextField(db_column='USR_REMARKS', blank=True, null=True)  # Field name made lowercase.
    usr_name = models.CharField(db_column='USR_NAME', max_length=50, blank=True, null=True)  # Field name made lowercase.
    usr_wages = models.FloatField(db_column='USR_WAGES', blank=True, null=True)  # Field name made lowercase.
    usr_vip_level = models.CharField(db_column='USR_VIP_LEVEL', max_length=255)  # Field name made lowercase.
    usr_status = models.CharField(db_column='USR_STATUS', max_length=255)  # Field name made lowercase.
    usr_login = models.IntegerField(db_column='USR_LOGIN', blank=True, null=True)  # Field name made lowercase.
    usr_bank_account = models.CharField(db_column='USR_BANK_ACCOUNT', max_length=255)  # Field name made lowercase.
    usr_settings = models.IntegerField(db_column='USR_SETTINGS', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'users'


class WorkLog(models.Model):
    work_log_no = models.AutoField(db_column='Work_Log_No', primary_key=True)  # Field name made lowercase.
    work_log_usr_no = models.CharField(db_column='Work_Log_Usr_No', max_length=255)  # Field name made lowercase.
    work_log_content = models.TextField(db_column='Work_Log_Content')  # Field name made lowercase.
    work_log_time = models.DateTimeField(db_column='Work_Log_Time')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'work_log'