You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 

579 lines
21 KiB

  1. # This is an auto-generated Django model module.
  2. # You'll have to do the following manually to clean this up:
  3. # * Rearrange models' order
  4. # * Make sure each model has one field with primary_key=True
  5. # * Make sure each ForeignKey has `on_delete` set to the desired behavior.
  6. # * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
  7. # Feel free to rename the models, but don't rename db_table values or field names.
  8. from __future__ import unicode_literals
  9. from django.db import models
  10. class AdmUser(models.Model):
  11. uid = models.AutoField(primary_key=True)
  12. u_name = models.CharField(unique=True, max_length=100)
  13. pwd = models.CharField(max_length=255)
  14. phone = models.CharField(max_length=22, blank=True, null=True)
  15. create_time = models.DateTimeField()
  16. status = models.IntegerField()
  17. last_login = models.CharField(max_length=20, blank=True, null=True)
  18. class Meta:
  19. managed = False
  20. db_table = 'adm_user'
  21. class BaseArea(models.Model):
  22. id = models.IntegerField(db_column='ID', primary_key=True) # Field name made lowercase.
  23. parent_id = models.IntegerField(db_column='PARENT_ID') # Field name made lowercase.
  24. cancel_flag = models.IntegerField(db_column='CANCEL_FLAG') # Field name made lowercase.
  25. create_user_id = models.IntegerField(db_column='CREATE_USER_ID') # Field name made lowercase.
  26. create_time = models.CharField(db_column='CREATE_TIME', max_length=20) # Field name made lowercase.
  27. update_user_id = models.IntegerField(db_column='UPDATE_USER_ID') # Field name made lowercase.
  28. update_time = models.CharField(db_column='UPDATE_TIME', max_length=20) # Field name made lowercase.
  29. area_name = models.CharField(db_column='AREA_NAME', max_length=100) # Field name made lowercase.
  30. postcode = models.CharField(db_column='POSTCODE', max_length=20) # Field name made lowercase.
  31. poi_type = models.CharField(db_column='POI_TYPE', max_length=20) # Field name made lowercase.
  32. poi_type1 = models.IntegerField(db_column='POI_TYPE1') # Field name made lowercase.
  33. poi_type2 = models.CharField(db_column='POI_TYPE2', max_length=255) # Field name made lowercase.
  34. class Meta:
  35. managed = False
  36. db_table = 'base_area'
  37. class BaseCategory(models.Model):
  38. category_id = models.AutoField(primary_key=True)
  39. category_name = models.CharField(max_length=255)
  40. parent_id = models.IntegerField()
  41. delete_flag = models.IntegerField()
  42. create_time = models.DateTimeField()
  43. update_time = models.DateTimeField()
  44. update_user = models.CharField(max_length=50)
  45. class Meta:
  46. managed = False
  47. db_table = 'base_category'
  48. class BusTicket(models.Model):
  49. ticket_id = models.IntegerField(unique=True)
  50. start_area_id = models.IntegerField()
  51. start_area_name = models.CharField(max_length=50)
  52. end_area_id = models.IntegerField()
  53. end_area_name = models.CharField(max_length=50)
  54. start_res_id = models.IntegerField()
  55. start_res_name = models.CharField(max_length=50)
  56. end_res_id = models.IntegerField()
  57. end_res_name = models.CharField(max_length=50)
  58. line_id = models.IntegerField()
  59. line_type = models.IntegerField()
  60. prod_price = models.DecimalField(max_digits=10, decimal_places=0)
  61. line_name = models.CharField(max_length=255)
  62. start_res_longitude = models.FloatField(blank=True, null=True)
  63. start_res_latitude = models.FloatField(blank=True, null=True)
  64. end_res_longitude = models.FloatField(blank=True, null=True)
  65. end_res_latitude = models.FloatField(blank=True, null=True)
  66. class Meta:
  67. managed = False
  68. db_table = 'bus_ticket'
  69. class ClientOpinion(models.Model):
  70. name = models.CharField(max_length=255)
  71. e_mail = models.CharField(db_column='e-mail', max_length=255) # Field renamed to remove unsuitable characters.
  72. opinion = models.CharField(max_length=1000)
  73. client_ip = models.CharField(db_column='client _ip', max_length=255) # Field renamed to remove unsuitable characters.
  74. create_time = models.DateTimeField()
  75. class Meta:
  76. managed = False
  77. db_table = 'client_opinion'
  78. class CmsCategory(models.Model):
  79. cms_category_id = models.AutoField(primary_key=True)
  80. category_name = models.CharField(max_length=50)
  81. show_sort = models.IntegerField()
  82. delete_flag = models.IntegerField()
  83. create_time = models.DateTimeField()
  84. update_time = models.DateTimeField()
  85. update_user = models.CharField(max_length=50)
  86. category_code = models.CharField(max_length=255)
  87. system = models.IntegerField(blank=True, null=True)
  88. class Meta:
  89. managed = False
  90. db_table = 'cms_category'
  91. class CmsCategoryExtra(models.Model):
  92. category_id = models.IntegerField(unique=True)
  93. category_name = models.CharField(max_length=50)
  94. category_describe = models.CharField(max_length=255)
  95. img_url = models.CharField(max_length=255)
  96. area_id = models.IntegerField()
  97. class Meta:
  98. managed = False
  99. db_table = 'cms_category_extra'
  100. class CmsCategoryProd(models.Model):
  101. prod_cate_id = models.IntegerField()
  102. cms_cate_id = models.IntegerField()
  103. show_sort = models.IntegerField()
  104. delete_flag = models.IntegerField()
  105. create_time = models.DateTimeField()
  106. update_time = models.DateTimeField()
  107. update_user = models.CharField(max_length=50)
  108. system = models.IntegerField()
  109. class Meta:
  110. managed = False
  111. db_table = 'cms_category_prod'
  112. class DjangoMigrations(models.Model):
  113. app = models.CharField(max_length=255)
  114. name = models.CharField(max_length=255)
  115. applied = models.DateTimeField()
  116. class Meta:
  117. managed = False
  118. db_table = 'django_migrations'
  119. class FxCommissionApply(models.Model):
  120. fx_uid = models.IntegerField()
  121. apply_money = models.DecimalField(max_digits=10, decimal_places=0)
  122. status = models.IntegerField()
  123. remit_time = models.CharField(max_length=50)
  124. auth_time = models.CharField(max_length=50)
  125. auth_memo = models.CharField(max_length=255)
  126. auth_uid = models.IntegerField()
  127. remit_uid = models.IntegerField()
  128. delete_flag = models.IntegerField()
  129. create_time = models.DateTimeField()
  130. update_time = models.DateTimeField()
  131. update_user = models.CharField(max_length=50)
  132. class Meta:
  133. managed = False
  134. db_table = 'fx_commission_apply'
  135. class FxCommissionInfo(models.Model):
  136. fx_uid = models.IntegerField()
  137. total_money = models.DecimalField(max_digits=10, decimal_places=0)
  138. order_id = models.IntegerField()
  139. status = models.IntegerField()
  140. delete_flag = models.IntegerField()
  141. create_time = models.DateTimeField()
  142. update_time = models.DateTimeField()
  143. update_user = models.CharField(max_length=50)
  144. class Meta:
  145. managed = False
  146. db_table = 'fx_commission_info'
  147. class FxUser(models.Model):
  148. uid = models.AutoField(primary_key=True)
  149. user_name = models.CharField(max_length=100, blank=True, null=True)
  150. openid = models.CharField(unique=True, max_length=120)
  151. phone = models.CharField(max_length=11)
  152. nickname = models.CharField(max_length=21, blank=True, null=True)
  153. headimgurl = models.CharField(max_length=255, blank=True, null=True)
  154. sex = models.IntegerField(blank=True, null=True)
  155. country = models.CharField(max_length=255, blank=True, null=True)
  156. province = models.CharField(max_length=255, blank=True, null=True)
  157. city = models.CharField(max_length=255, blank=True, null=True)
  158. status = models.IntegerField()
  159. reg_time = models.DateTimeField()
  160. delete_flag = models.IntegerField()
  161. wx_openid = models.CharField(max_length=120, blank=True, null=True)
  162. main_user_id = models.IntegerField()
  163. change_price_power = models.IntegerField()
  164. user_area = models.CharField(max_length=255, blank=True, null=True)
  165. class Meta:
  166. managed = False
  167. db_table = 'fx_user'
  168. class FxUserAccount(models.Model):
  169. fx_uid = models.IntegerField(unique=True)
  170. available_commission = models.DecimalField(max_digits=10, decimal_places=0)
  171. closed_commission = models.DecimalField(max_digits=10, decimal_places=0)
  172. total_commission = models.DecimalField(max_digits=10, decimal_places=0)
  173. apply_commission = models.DecimalField(max_digits=10, decimal_places=0)
  174. remaining_sum = models.DecimalField(max_digits=10, decimal_places=0)
  175. create_time = models.DateTimeField()
  176. update_time = models.DateTimeField()
  177. status = models.IntegerField()
  178. delete_flag = models.IntegerField()
  179. class Meta:
  180. managed = False
  181. db_table = 'fx_user_account'
  182. class FxUserAmountLog(models.Model):
  183. log_id = models.AutoField(primary_key=True)
  184. fx_uid = models.IntegerField()
  185. trade_type = models.IntegerField()
  186. amount = models.DecimalField(max_digits=10, decimal_places=0)
  187. remaining_sum = models.DecimalField(max_digits=10, decimal_places=0)
  188. msg = models.CharField(max_length=255, blank=True, null=True)
  189. create_time = models.DateTimeField()
  190. update_time = models.DateTimeField(blank=True, null=True)
  191. class Meta:
  192. managed = False
  193. db_table = 'fx_user_amount_log'
  194. class FxUserAmountOrder(models.Model):
  195. fx_uid = models.IntegerField()
  196. amount = models.DecimalField(max_digits=10, decimal_places=0)
  197. status = models.IntegerField()
  198. recharge_order = models.CharField(max_length=100)
  199. pay_type = models.IntegerField()
  200. create_time = models.DateTimeField(blank=True, null=True)
  201. update_time = models.DateTimeField(blank=True, null=True)
  202. class Meta:
  203. managed = False
  204. db_table = 'fx_user_amount_order'
  205. class FxUserArea(models.Model):
  206. area_id = models.AutoField(primary_key=True)
  207. area_name = models.CharField(max_length=100)
  208. class Meta:
  209. managed = False
  210. db_table = 'fx_user_area'
  211. class FxUserOpenid(models.Model):
  212. open_id = models.CharField(unique=True, max_length=255)
  213. fx_uid = models.IntegerField()
  214. reg_time = models.DateTimeField()
  215. class Meta:
  216. managed = False
  217. db_table = 'fx_user_openid'
  218. class FxUserQrcode(models.Model):
  219. fx_uid = models.IntegerField(blank=True, null=True)
  220. qr_id = models.IntegerField(unique=True)
  221. class Meta:
  222. managed = False
  223. db_table = 'fx_user_qrcode'
  224. class LogOrder(models.Model):
  225. name = models.CharField(max_length=20)
  226. order_id = models.IntegerField()
  227. time = models.DateTimeField()
  228. uid = models.IntegerField()
  229. u_type = models.IntegerField()
  230. log_type = models.IntegerField()
  231. class Meta:
  232. managed = False
  233. db_table = 'log_order'
  234. class LogUserOperation(models.Model):
  235. title = models.CharField(max_length=120)
  236. memo = models.TextField()
  237. uid = models.IntegerField()
  238. user_type = models.IntegerField()
  239. user_name = models.CharField(max_length=255)
  240. resources_id = models.IntegerField(blank=True, null=True)
  241. resources_type = models.IntegerField(blank=True, null=True)
  242. resources_name = models.CharField(max_length=255, blank=True, null=True)
  243. phpsessid = models.CharField(max_length=255, blank=True, null=True)
  244. user_agent = models.CharField(max_length=255, blank=True, null=True)
  245. create_time = models.DateTimeField()
  246. last_login = models.CharField(max_length=255, blank=True, null=True)
  247. class Meta:
  248. managed = False
  249. db_table = 'log_user_operation'
  250. class MainCorpUser(models.Model):
  251. user_name = models.CharField(max_length=255)
  252. main_corp_id = models.IntegerField()
  253. main_corp_name = models.CharField(max_length=255)
  254. class Meta:
  255. managed = False
  256. db_table = 'main_corp_user'
  257. class OrderContacts(models.Model):
  258. order_id = models.IntegerField()
  259. contacts_name = models.CharField(max_length=120)
  260. contacts_phone = models.CharField(max_length=20)
  261. contacts_id = models.CharField(db_column='contacts_ID', max_length=20, blank=True, null=True) # Field name made lowercase.
  262. contacts_type = models.IntegerField()
  263. update_time = models.DateTimeField()
  264. create_time = models.DateTimeField()
  265. delete_flag = models.IntegerField()
  266. bus_run_id = models.IntegerField(blank=True, null=True)
  267. class Meta:
  268. managed = False
  269. db_table = 'order_contacts'
  270. class OrderInfo(models.Model):
  271. order_id = models.IntegerField()
  272. prod_id = models.IntegerField()
  273. count = models.IntegerField()
  274. unit_price = models.DecimalField(max_digits=10, decimal_places=0)
  275. total_price = models.DecimalField(max_digits=10, decimal_places=0)
  276. delete_flag = models.IntegerField()
  277. commission = models.IntegerField()
  278. prod_name = models.CharField(max_length=255)
  279. class Meta:
  280. managed = False
  281. db_table = 'order_info'
  282. class OrderMain(models.Model):
  283. order_id = models.AutoField(primary_key=True)
  284. order_name = models.CharField(max_length=255)
  285. spider_order_id = models.CharField(max_length=255)
  286. total_money = models.DecimalField(max_digits=10, decimal_places=0)
  287. category_id = models.IntegerField()
  288. prod_cate_id = models.IntegerField()
  289. prod_source = models.IntegerField()
  290. prod_cnt = models.IntegerField()
  291. sh_uid = models.IntegerField()
  292. fx_uid = models.IntegerField()
  293. start_time = models.TimeField(blank=True, null=True)
  294. end_time = models.TimeField(blank=True, null=True)
  295. start_date = models.DateField()
  296. end_date = models.DateField()
  297. order_status = models.IntegerField()
  298. update_time = models.DateTimeField()
  299. create_time = models.DateTimeField()
  300. delete_flag = models.IntegerField()
  301. system = models.IntegerField()
  302. start_area = models.CharField(max_length=255, blank=True, null=True)
  303. end_area = models.CharField(max_length=255, blank=True, null=True)
  304. main_user_id = models.IntegerField()
  305. original_price = models.DecimalField(max_digits=10, decimal_places=0)
  306. class Meta:
  307. managed = False
  308. db_table = 'order_main'
  309. class OrderTravel(models.Model):
  310. travel_id = models.AutoField(primary_key=True)
  311. start_time = models.DateTimeField()
  312. end_time = models.DateTimeField()
  313. u_id = models.IntegerField()
  314. cs_order_id = models.IntegerField()
  315. prod_id = models.CharField(max_length=255, blank=True, null=True)
  316. start_res_id = models.IntegerField(blank=True, null=True)
  317. start_res = models.CharField(max_length=255, blank=True, null=True)
  318. end_res_id = models.IntegerField(blank=True, null=True)
  319. end_res = models.CharField(max_length=255, blank=True, null=True)
  320. start_area_name = models.CharField(max_length=255, blank=True, null=True)
  321. end_area_name = models.CharField(max_length=255, blank=True, null=True)
  322. start_longitude = models.FloatField(blank=True, null=True)
  323. start_latitude = models.FloatField(blank=True, null=True)
  324. contacts_name = models.CharField(max_length=120, blank=True, null=True)
  325. contacts_phone = models.CharField(max_length=120, blank=True, null=True)
  326. contacts_id = models.CharField(db_column='contacts_ID', max_length=120, blank=True, null=True) # Field name made lowercase.
  327. class Meta:
  328. managed = False
  329. db_table = 'order_travel'
  330. class PayMain(models.Model):
  331. pay_type = models.IntegerField()
  332. order_money = models.DecimalField(max_digits=10, decimal_places=0, blank=True, null=True)
  333. amount_money = models.DecimalField(max_digits=10, decimal_places=0, blank=True, null=True)
  334. pay_time = models.DateTimeField()
  335. pay_user = models.IntegerField()
  336. order_id = models.IntegerField()
  337. delete_flag = models.IntegerField()
  338. pay_order_id = models.CharField(max_length=255)
  339. app_id = models.CharField(max_length=255, blank=True, null=True)
  340. open_id = models.CharField(max_length=255, blank=True, null=True)
  341. class Meta:
  342. managed = False
  343. db_table = 'pay_main'
  344. class PayRefush(models.Model):
  345. order_id = models.IntegerField()
  346. pay_order_id = models.CharField(max_length=255)
  347. pay_type = models.IntegerField()
  348. refush_money = models.DecimalField(max_digits=10, decimal_places=0)
  349. amount_money = models.DecimalField(max_digits=10, decimal_places=0)
  350. fx_uid = models.IntegerField()
  351. sh_uid = models.IntegerField()
  352. status = models.IntegerField()
  353. create_time = models.DateTimeField()
  354. refund_time = models.DateTimeField()
  355. delete_flag = models.IntegerField()
  356. category_id = models.IntegerField()
  357. app_id = models.CharField(max_length=255, blank=True, null=True)
  358. open_id = models.CharField(max_length=255, blank=True, null=True)
  359. class Meta:
  360. managed = False
  361. db_table = 'pay_refush'
  362. class ProdCategory(models.Model):
  363. pro_cate_id = models.AutoField(primary_key=True)
  364. sign = models.CharField(max_length=255, blank=True, null=True)
  365. pro_cate_name = models.CharField(max_length=100)
  366. prod_des = models.TextField(blank=True, null=True)
  367. category_id = models.IntegerField()
  368. show_price = models.DecimalField(max_digits=10, decimal_places=0)
  369. original_price = models.DecimalField(max_digits=10, decimal_places=0)
  370. show_img = models.CharField(max_length=255)
  371. sales_count = models.IntegerField()
  372. memo = models.TextField(blank=True, null=True)
  373. trip_desc = models.TextField(blank=True, null=True)
  374. feature = models.TextField(blank=True, null=True)
  375. commission = models.DecimalField(max_digits=10, decimal_places=0)
  376. create_user_id = models.IntegerField()
  377. is_recom = models.IntegerField()
  378. start_area = models.CharField(max_length=255, blank=True, null=True)
  379. address = models.CharField(max_length=255, blank=True, null=True)
  380. close_sale_time = models.CharField(max_length=50)
  381. star = models.CharField(max_length=4)
  382. create_time = models.DateTimeField()
  383. update_time = models.DateTimeField()
  384. delete_flag = models.IntegerField()
  385. update_user = models.CharField(max_length=50)
  386. bus_ticket_id = models.IntegerField()
  387. bus_line_type = models.IntegerField()
  388. class Meta:
  389. managed = False
  390. db_table = 'prod_category'
  391. class ProdCategoryInfo(models.Model):
  392. pro_cate_id = models.IntegerField(primary_key=True)
  393. comment_cnt = models.IntegerField()
  394. class Meta:
  395. managed = False
  396. db_table = 'prod_category_info'
  397. class ProdComment(models.Model):
  398. travel_id = models.IntegerField(blank=True, null=True)
  399. prod_id = models.CharField(max_length=255, blank=True, null=True)
  400. star = models.IntegerField()
  401. title = models.CharField(max_length=30)
  402. content = models.TextField()
  403. u_name = models.CharField(max_length=100)
  404. u_id = models.IntegerField(blank=True, null=True)
  405. create_time = models.DateTimeField()
  406. look_over = models.IntegerField()
  407. type = models.IntegerField()
  408. comment_id = models.IntegerField()
  409. parent_id = models.IntegerField()
  410. cancel_flag = models.IntegerField()
  411. class Meta:
  412. managed = False
  413. db_table = 'prod_comment'
  414. class ProdImg(models.Model):
  415. pro_cate_id = models.IntegerField()
  416. img_url = models.CharField(max_length=255)
  417. redirect_url = models.CharField(max_length=255, blank=True, null=True)
  418. memo = models.CharField(max_length=255, blank=True, null=True)
  419. img_type = models.IntegerField()
  420. create_time = models.DateTimeField()
  421. class Meta:
  422. managed = False
  423. db_table = 'prod_img'
  424. class ProdMain(models.Model):
  425. prod_id = models.AutoField(primary_key=True)
  426. prod_cate_id = models.IntegerField()
  427. prod_name = models.CharField(max_length=100)
  428. prod_price = models.DecimalField(max_digits=10, decimal_places=0)
  429. create_user = models.CharField(max_length=50)
  430. create_time = models.DateTimeField()
  431. update_time = models.DateTimeField()
  432. delete_flag = models.IntegerField()
  433. update_user = models.CharField(max_length=50)
  434. bus_id = models.CharField(max_length=255)
  435. commission = models.DecimalField(max_digits=10, decimal_places=0)
  436. class Meta:
  437. managed = False
  438. db_table = 'prod_main'
  439. class ShUser(models.Model):
  440. uid = models.AutoField(primary_key=True)
  441. user_name = models.CharField(max_length=100, blank=True, null=True)
  442. phone = models.CharField(unique=True, max_length=20, blank=True, null=True)
  443. head_img = models.CharField(max_length=255, blank=True, null=True)
  444. status = models.IntegerField(blank=True, null=True)
  445. reg_time = models.DateTimeField(blank=True, null=True)
  446. last_login = models.DateTimeField(blank=True, null=True)
  447. class Meta:
  448. managed = False
  449. db_table = 'sh_user'
  450. class SysItinerary(models.Model):
  451. category_id = models.IntegerField()
  452. category_name = models.CharField(max_length=50)
  453. scenc_introduce = models.TextField(blank=True, null=True)
  454. scenc_play = models.TextField(blank=True, null=True)
  455. folk_customs = models.TextField(blank=True, null=True)
  456. local_specialities = models.TextField(blank=True, null=True)
  457. travel_tips = models.TextField(blank=True, null=True)
  458. class Meta:
  459. managed = False
  460. db_table = 'sys_itinerary'
  461. class ZzNews(models.Model):
  462. class_id = models.IntegerField()
  463. news_title = models.CharField(max_length=100)
  464. navi_content = models.CharField(max_length=255)
  465. content = models.TextField()
  466. create_user = models.CharField(max_length=50)
  467. create_time = models.DateTimeField()
  468. update_time = models.DateTimeField()
  469. delete_flag = models.IntegerField()
  470. class Meta:
  471. managed = False
  472. db_table = 'zz_news'