|
- # 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'
|