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

from django.db import models


class AdmUser(models.Model):
    uid = models.AutoField(primary_key=True)
    u_name = models.CharField(unique=True, max_length=100)
    pwd = models.CharField(max_length=255)
    phone = models.CharField(max_length=22, blank=True, null=True)
    create_time = models.DateTimeField()
    status = models.IntegerField()
    last_login = models.CharField(max_length=20, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'adm_user'


class BaseArea(models.Model):
    id = models.IntegerField(db_column='ID', primary_key=True)  # Field name made lowercase.
    parent_id = models.IntegerField(db_column='PARENT_ID')  # Field name made lowercase.
    cancel_flag = models.IntegerField(db_column='CANCEL_FLAG')  # Field name made lowercase.
    create_user_id = models.IntegerField(db_column='CREATE_USER_ID')  # Field name made lowercase.
    create_time = models.CharField(db_column='CREATE_TIME', max_length=20)  # Field name made lowercase.
    update_user_id = models.IntegerField(db_column='UPDATE_USER_ID')  # Field name made lowercase.
    update_time = models.CharField(db_column='UPDATE_TIME', max_length=20)  # Field name made lowercase.
    area_name = models.CharField(db_column='AREA_NAME', max_length=100)  # Field name made lowercase.
    postcode = models.CharField(db_column='POSTCODE', max_length=20)  # Field name made lowercase.
    poi_type = models.CharField(db_column='POI_TYPE', max_length=20)  # Field name made lowercase.
    poi_type1 = models.IntegerField(db_column='POI_TYPE1')  # Field name made lowercase.
    poi_type2 = models.CharField(db_column='POI_TYPE2', max_length=255)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'base_area'


class BaseCategory(models.Model):
    category_id = models.AutoField(primary_key=True)
    category_name = models.CharField(max_length=255)
    parent_id = models.IntegerField()
    delete_flag = models.IntegerField()
    create_time = models.DateTimeField()
    update_time = models.DateTimeField()
    update_user = models.CharField(max_length=50)

    class Meta:
        managed = False
        db_table = 'base_category'


class BusTicket(models.Model):
    ticket_id = models.IntegerField(unique=True)
    start_area_id = models.IntegerField()
    start_area_name = models.CharField(max_length=50)
    end_area_id = models.IntegerField()
    end_area_name = models.CharField(max_length=50)
    start_res_id = models.IntegerField()
    start_res_name = models.CharField(max_length=50)
    end_res_id = models.IntegerField()
    end_res_name = models.CharField(max_length=50)
    line_id = models.IntegerField()
    line_type = models.IntegerField()
    prod_price = models.DecimalField(max_digits=10, decimal_places=0)
    line_name = models.CharField(max_length=255)
    start_res_longitude = models.FloatField(blank=True, null=True)
    start_res_latitude = models.FloatField(blank=True, null=True)
    end_res_longitude = models.FloatField(blank=True, null=True)
    end_res_latitude = models.FloatField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'bus_ticket'


class ClientOpinion(models.Model):
    name = models.CharField(max_length=255)
    e_mail = models.CharField(db_column='e-mail', max_length=255)  # Field renamed to remove unsuitable characters.
    opinion = models.CharField(max_length=1000)
    client_ip = models.CharField(db_column='client _ip', max_length=255)  # Field renamed to remove unsuitable characters.
    create_time = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'client_opinion'


class CmsCategory(models.Model):
    cms_category_id = models.AutoField(primary_key=True)
    category_name = models.CharField(max_length=50)
    show_sort = models.IntegerField()
    delete_flag = models.IntegerField()
    create_time = models.DateTimeField()
    update_time = models.DateTimeField()
    update_user = models.CharField(max_length=50)
    category_code = models.CharField(max_length=255)
    system = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cms_category'


class CmsCategoryExtra(models.Model):
    category_id = models.IntegerField(unique=True)
    category_name = models.CharField(max_length=50)
    category_describe = models.CharField(max_length=255)
    img_url = models.CharField(max_length=255)
    area_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'cms_category_extra'


class CmsCategoryProd(models.Model):
    prod_cate_id = models.IntegerField()
    cms_cate_id = models.IntegerField()
    show_sort = models.IntegerField()
    delete_flag = models.IntegerField()
    create_time = models.DateTimeField()
    update_time = models.DateTimeField()
    update_user = models.CharField(max_length=50)
    system = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'cms_category_prod'


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 FxCommissionApply(models.Model):
    fx_uid = models.IntegerField()
    apply_money = models.DecimalField(max_digits=10, decimal_places=2)
    status = models.IntegerField()
    remit_time = models.CharField(max_length=50)
    auth_time = models.CharField(max_length=50)
    auth_memo = models.CharField(max_length=255)
    auth_uid = models.IntegerField()
    remit_uid = models.IntegerField()
    delete_flag = models.IntegerField()
    create_time = models.DateTimeField()
    update_time = models.DateTimeField()
    update_user = models.CharField(max_length=50)

    class Meta:
        managed = False
        db_table = 'fx_commission_apply'


class FxCommissionInfo(models.Model):
    fx_uid = models.IntegerField()
    total_money = models.DecimalField(max_digits=10, decimal_places=2)
    order_id = models.IntegerField()
    status = models.IntegerField()
    delete_flag = models.IntegerField()
    create_time = models.DateTimeField()
    update_time = models.DateTimeField()
    update_user = models.CharField(max_length=50)

    class Meta:
        managed = False
        db_table = 'fx_commission_info'


class FxUser(models.Model):
    uid = models.AutoField(primary_key=True)
    user_name = models.CharField(max_length=100, blank=True, null=True)
    openid = models.CharField(unique=True, max_length=120)
    phone = models.CharField(max_length=11)
    nickname = models.CharField(max_length=21, blank=True, null=True)
    headimgurl = models.CharField(max_length=255, blank=True, null=True)
    sex = models.IntegerField(blank=True, null=True)
    country = models.CharField(max_length=255, blank=True, null=True)
    province = models.CharField(max_length=255, blank=True, null=True)
    city = models.CharField(max_length=255, blank=True, null=True)
    status = models.IntegerField()
    reg_time = models.DateTimeField()
    delete_flag = models.IntegerField()
    wx_openid = models.CharField(max_length=120, blank=True, null=True)
    main_user_id = models.IntegerField()
    change_price_power = models.CharField(max_length=4)
    user_area = models.CharField(max_length=255, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fx_user'


class FxUserAccount(models.Model):
    fx_uid = models.IntegerField(unique=True)
    available_commission = models.DecimalField(max_digits=10, decimal_places=2)
    closed_commission = models.DecimalField(max_digits=10, decimal_places=2)
    total_commission = models.DecimalField(max_digits=10, decimal_places=2)
    apply_commission = models.DecimalField(max_digits=10, decimal_places=2)
    remaining_sum = models.DecimalField(max_digits=10, decimal_places=2)
    create_time = models.DateTimeField()
    update_time = models.DateTimeField()
    status = models.IntegerField()
    delete_flag = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'fx_user_account'


class FxUserAmountLog(models.Model):
    log_id = models.AutoField(primary_key=True)
    fx_uid = models.IntegerField()
    trade_type = models.IntegerField()
    amount = models.DecimalField(max_digits=10, decimal_places=2)
    remaining_sum = models.DecimalField(max_digits=10, decimal_places=2)
    msg = models.CharField(max_length=255, blank=True, null=True)
    create_time = models.DateTimeField()
    update_time = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fx_user_amount_log'


class FxUserAmountOrder(models.Model):
    fx_uid = models.IntegerField()
    amount = models.DecimalField(max_digits=10, decimal_places=2)
    status = models.IntegerField()
    recharge_order = models.CharField(max_length=100)
    pay_type = models.IntegerField()
    create_time = models.DateTimeField(blank=True, null=True)
    update_time = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fx_user_amount_order'


class FxUserArea(models.Model):
    area_id = models.AutoField(primary_key=True)
    area_name = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'fx_user_area'


class FxUserOpenid(models.Model):
    open_id = models.CharField(unique=True, max_length=255)
    fx_uid = models.IntegerField()
    reg_time = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'fx_user_openid'


class FxUserQrcode(models.Model):
    fx_uid = models.IntegerField(blank=True, null=True)
    qr_id = models.IntegerField(unique=True)

    class Meta:
        managed = False
        db_table = 'fx_user_qrcode'


class LogOrder(models.Model):
    name = models.CharField(max_length=20)
    order_id = models.IntegerField()
    time = models.DateTimeField()
    uid = models.IntegerField()
    u_type = models.IntegerField()
    log_type = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'log_order'


class LogUserOperation(models.Model):
    title = models.CharField(max_length=120)
    memo = models.TextField()
    uid = models.IntegerField()
    user_type = models.IntegerField()
    user_name = models.CharField(max_length=255)
    resources_id = models.IntegerField(blank=True, null=True)
    resources_type = models.IntegerField(blank=True, null=True)
    resources_name = models.CharField(max_length=255, blank=True, null=True)
    phpsessid = models.CharField(max_length=255, blank=True, null=True)
    user_agent = models.CharField(max_length=255, blank=True, null=True)
    create_time = models.DateTimeField()
    last_login = models.CharField(max_length=255, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'log_user_operation'


class MainCorpUser(models.Model):
    user_name = models.CharField(max_length=255)
    main_corp_id = models.IntegerField()
    main_corp_name = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'main_corp_user'


class OrderContacts(models.Model):
    order_id = models.IntegerField()
    contacts_name = models.CharField(max_length=120)
    contacts_phone = models.CharField(max_length=20)
    contacts_id = models.CharField(db_column='contacts_ID', max_length=20, blank=True, null=True)  # Field name made lowercase.
    contacts_type = models.IntegerField()
    update_time = models.DateTimeField()
    create_time = models.DateTimeField()
    delete_flag = models.IntegerField()
    bus_run_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'order_contacts'


class OrderHotelExtra(models.Model):
    main_order_id = models.IntegerField()
    hotel_id = models.IntegerField()
    room_id = models.IntegerField()
    hotel_name = models.CharField(max_length=255)
    room_name = models.CharField(max_length=255)
    breakfast = models.CharField(max_length=20)
    total_details = models.CharField(max_length=255)
    remarks = models.CharField(max_length=255)
    is_gift = models.IntegerField()
    gift_describe = models.TextField()
    is_confirm = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'order_hotel_extra'


class OrderInfo(models.Model):
    order_id = models.IntegerField()
    prod_id = models.IntegerField()
    count = models.IntegerField()
    unit_price = models.DecimalField(max_digits=10, decimal_places=2)
    total_price = models.DecimalField(max_digits=10, decimal_places=2)
    delete_flag = models.IntegerField()
    commission = models.DecimalField(max_digits=10, decimal_places=2)
    prod_name = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'order_info'


class OrderMain(models.Model):
    order_id = models.AutoField(primary_key=True)
    order_name = models.CharField(max_length=255)
    spider_order_id = models.CharField(max_length=255)
    total_money = models.DecimalField(max_digits=10, decimal_places=2)
    category_id = models.IntegerField()
    prod_cate_id = models.IntegerField()
    prod_source = models.IntegerField()
    prod_cnt = models.IntegerField()
    sh_uid = models.IntegerField()
    fx_uid = models.IntegerField()
    start_time = models.TimeField(blank=True, null=True)
    end_time = models.TimeField(blank=True, null=True)
    start_date = models.DateField()
    end_date = models.DateField()
    order_status = models.IntegerField()
    update_time = models.DateTimeField()
    create_time = models.DateTimeField()
    delete_flag = models.IntegerField()
    system = models.IntegerField()
    start_area = models.CharField(max_length=255, blank=True, null=True)
    end_area = models.CharField(max_length=255, blank=True, null=True)
    main_user_id = models.IntegerField()
    original_price = models.DecimalField(max_digits=10, decimal_places=2)

    class Meta:
        managed = False
        db_table = 'order_main'


class OrderTravel(models.Model):
    travel_id = models.AutoField(primary_key=True)
    start_time = models.DateTimeField()
    end_time = models.DateTimeField()
    u_id = models.IntegerField()
    cs_order_id = models.IntegerField()
    prod_id = models.CharField(max_length=255, blank=True, null=True)
    start_res_id = models.IntegerField(blank=True, null=True)
    start_res = models.CharField(max_length=255, blank=True, null=True)
    end_res_id = models.IntegerField(blank=True, null=True)
    end_res = models.CharField(max_length=255, blank=True, null=True)
    start_area_name = models.CharField(max_length=255, blank=True, null=True)
    end_area_name = models.CharField(max_length=255, blank=True, null=True)
    start_longitude = models.FloatField(blank=True, null=True)
    start_latitude = models.FloatField(blank=True, null=True)
    contacts_name = models.CharField(max_length=120, blank=True, null=True)
    contacts_phone = models.CharField(max_length=120, blank=True, null=True)
    contacts_id = models.CharField(db_column='contacts_ID', max_length=120, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'order_travel'


class PayMain(models.Model):
    pay_type = models.IntegerField()
    order_money = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True)
    amount_money = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True)
    pay_time = models.DateTimeField()
    pay_user = models.IntegerField()
    order_id = models.IntegerField()
    delete_flag = models.IntegerField()
    pay_order_id = models.CharField(max_length=255)
    app_id = models.CharField(max_length=255, blank=True, null=True)
    open_id = models.CharField(max_length=255, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'pay_main'


class PayRefush(models.Model):
    order_id = models.IntegerField()
    pay_order_id = models.CharField(max_length=255)
    pay_type = models.IntegerField()
    refush_money = models.DecimalField(max_digits=10, decimal_places=2)
    amount_money = models.DecimalField(max_digits=10, decimal_places=2)
    fx_uid = models.IntegerField()
    sh_uid = models.IntegerField()
    status = models.IntegerField()
    create_time = models.DateTimeField()
    refund_time = models.DateTimeField()
    delete_flag = models.IntegerField()
    category_id = models.IntegerField()
    app_id = models.CharField(max_length=255, blank=True, null=True)
    open_id = models.CharField(max_length=255, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'pay_refush'


class ProdCategory(models.Model):
    pro_cate_id = models.AutoField(primary_key=True)
    sign = models.CharField(max_length=255, blank=True, null=True)
    pro_cate_name = models.CharField(max_length=100)
    prod_des = models.TextField(blank=True, null=True)
    category_id = models.IntegerField()
    show_price = models.DecimalField(max_digits=10, decimal_places=2)
    original_price = models.DecimalField(max_digits=10, decimal_places=2)
    show_img = models.CharField(max_length=255)
    sales_count = models.IntegerField()
    memo = models.TextField(blank=True, null=True)
    trip_desc = models.TextField(blank=True, null=True)
    feature = models.TextField(blank=True, null=True)
    commission = models.DecimalField(max_digits=10, decimal_places=0)
    create_user_id = models.IntegerField()
    is_recom = models.IntegerField()
    start_area = models.CharField(max_length=255, blank=True, null=True)
    address = models.CharField(max_length=255, blank=True, null=True)
    close_sale_time = models.CharField(max_length=50)
    star = models.CharField(max_length=4)
    create_time = models.DateTimeField()
    update_time = models.DateTimeField()
    delete_flag = models.IntegerField()
    update_user = models.CharField(max_length=50)
    bus_ticket_id = models.IntegerField()
    bus_line_type = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'prod_category'


class ProdCategoryInfo(models.Model):
    pro_cate_id = models.IntegerField(primary_key=True)
    comment_cnt = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'prod_category_info'


class ProdComment(models.Model):
    travel_id = models.IntegerField(blank=True, null=True)
    prod_id = models.CharField(max_length=255, blank=True, null=True)
    star = models.IntegerField()
    title = models.CharField(max_length=30)
    content = models.TextField()
    u_name = models.CharField(max_length=100)
    u_id = models.IntegerField(blank=True, null=True)
    create_time = models.DateTimeField()
    look_over = models.IntegerField()
    type = models.IntegerField()
    comment_id = models.IntegerField()
    parent_id = models.IntegerField()
    cancel_flag = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'prod_comment'


class ProdImg(models.Model):
    pro_cate_id = models.IntegerField()
    img_url = models.CharField(max_length=255)
    redirect_url = models.CharField(max_length=255, blank=True, null=True)
    memo = models.CharField(max_length=255, blank=True, null=True)
    img_type = models.IntegerField()
    create_time = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'prod_img'


class ProdMain(models.Model):
    prod_id = models.AutoField(primary_key=True)
    prod_cate_id = models.IntegerField()
    prod_name = models.CharField(max_length=100)
    prod_price = models.DecimalField(max_digits=10, decimal_places=2)
    create_user = models.CharField(max_length=50)
    create_time = models.DateTimeField()
    update_time = models.DateTimeField()
    delete_flag = models.IntegerField()
    update_user = models.CharField(max_length=50)
    bus_id = models.CharField(max_length=255)
    commission = models.DecimalField(max_digits=10, decimal_places=2)

    class Meta:
        managed = False
        db_table = 'prod_main'


class ShUser(models.Model):
    uid = models.AutoField(primary_key=True)
    user_name = models.CharField(max_length=100, blank=True, null=True)
    phone = models.CharField(unique=True, max_length=20, blank=True, null=True)
    head_img = models.CharField(max_length=255, blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    reg_time = models.DateTimeField(blank=True, null=True)
    last_login = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'sh_user'


class SysItinerary(models.Model):
    category_id = models.IntegerField()
    category_name = models.CharField(max_length=50)
    scenc_introduce = models.TextField(blank=True, null=True)
    scenc_play = models.TextField(blank=True, null=True)
    folk_customs = models.TextField(blank=True, null=True)
    local_specialities = models.TextField(blank=True, null=True)
    travel_tips = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'sys_itinerary'


class ZzNews(models.Model):
    class_id = models.IntegerField()
    news_title = models.CharField(max_length=100)
    navi_content = models.CharField(max_length=255)
    content = models.TextField()
    create_user = models.CharField(max_length=50)
    create_time = models.DateTimeField()
    update_time = models.DateTimeField()
    delete_flag = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'zz_news'