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.
 
 
 
 
 

597 lines
22 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=2)
  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=2)
  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.CharField(max_length=4)
  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=2)
  171. closed_commission = models.DecimalField(max_digits=10, decimal_places=2)
  172. total_commission = models.DecimalField(max_digits=10, decimal_places=2)
  173. apply_commission = models.DecimalField(max_digits=10, decimal_places=2)
  174. remaining_sum = models.DecimalField(max_digits=10, decimal_places=2)
  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=2)
  187. remaining_sum = models.DecimalField(max_digits=10, decimal_places=2)
  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=2)
  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 OrderHotelExtra(models.Model):
  271. main_order_id = models.IntegerField()
  272. hotel_id = models.IntegerField()
  273. room_id = models.IntegerField()
  274. hotel_name = models.CharField(max_length=255)
  275. room_name = models.CharField(max_length=255)
  276. breakfast = models.CharField(max_length=20)
  277. total_details = models.CharField(max_length=255)
  278. remarks = models.CharField(max_length=255)
  279. is_gift = models.IntegerField()
  280. gift_describe = models.TextField()
  281. is_confirm = models.IntegerField()
  282. class Meta:
  283. managed = False
  284. db_table = 'order_hotel_extra'
  285. class OrderInfo(models.Model):
  286. order_id = models.IntegerField()
  287. prod_id = models.IntegerField()
  288. count = models.IntegerField()
  289. unit_price = models.DecimalField(max_digits=10, decimal_places=2)
  290. total_price = models.DecimalField(max_digits=10, decimal_places=2)
  291. delete_flag = models.IntegerField()
  292. commission = models.DecimalField(max_digits=10, decimal_places=2)
  293. prod_name = models.CharField(max_length=255)
  294. class Meta:
  295. managed = False
  296. db_table = 'order_info'
  297. class OrderMain(models.Model):
  298. order_id = models.AutoField(primary_key=True)
  299. order_name = models.CharField(max_length=255)
  300. spider_order_id = models.CharField(max_length=255)
  301. total_money = models.DecimalField(max_digits=10, decimal_places=2)
  302. category_id = models.IntegerField()
  303. prod_cate_id = models.IntegerField()
  304. prod_source = models.IntegerField()
  305. prod_cnt = models.IntegerField()
  306. sh_uid = models.IntegerField()
  307. fx_uid = models.IntegerField()
  308. start_time = models.TimeField(blank=True, null=True)
  309. end_time = models.TimeField(blank=True, null=True)
  310. start_date = models.DateField()
  311. end_date = models.DateField()
  312. order_status = models.IntegerField()
  313. update_time = models.DateTimeField()
  314. create_time = models.DateTimeField()
  315. delete_flag = models.IntegerField()
  316. system = models.IntegerField()
  317. start_area = models.CharField(max_length=255, blank=True, null=True)
  318. end_area = models.CharField(max_length=255, blank=True, null=True)
  319. main_user_id = models.IntegerField()
  320. original_price = models.DecimalField(max_digits=10, decimal_places=2)
  321. class Meta:
  322. managed = False
  323. db_table = 'order_main'
  324. class OrderTravel(models.Model):
  325. travel_id = models.AutoField(primary_key=True)
  326. start_time = models.DateTimeField()
  327. end_time = models.DateTimeField()
  328. u_id = models.IntegerField()
  329. cs_order_id = models.IntegerField()
  330. prod_id = models.CharField(max_length=255, blank=True, null=True)
  331. start_res_id = models.IntegerField(blank=True, null=True)
  332. start_res = models.CharField(max_length=255, blank=True, null=True)
  333. end_res_id = models.IntegerField(blank=True, null=True)
  334. end_res = models.CharField(max_length=255, blank=True, null=True)
  335. start_area_name = models.CharField(max_length=255, blank=True, null=True)
  336. end_area_name = models.CharField(max_length=255, blank=True, null=True)
  337. start_longitude = models.FloatField(blank=True, null=True)
  338. start_latitude = models.FloatField(blank=True, null=True)
  339. contacts_name = models.CharField(max_length=120, blank=True, null=True)
  340. contacts_phone = models.CharField(max_length=120, blank=True, null=True)
  341. contacts_id = models.CharField(db_column='contacts_ID', max_length=120, blank=True, null=True) # Field name made lowercase.
  342. class Meta:
  343. managed = False
  344. db_table = 'order_travel'
  345. class PayMain(models.Model):
  346. pay_type = models.IntegerField()
  347. order_money = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True)
  348. amount_money = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True)
  349. pay_time = models.DateTimeField()
  350. pay_user = models.IntegerField()
  351. order_id = models.IntegerField()
  352. delete_flag = models.IntegerField()
  353. pay_order_id = models.CharField(max_length=255)
  354. app_id = models.CharField(max_length=255, blank=True, null=True)
  355. open_id = models.CharField(max_length=255, blank=True, null=True)
  356. class Meta:
  357. managed = False
  358. db_table = 'pay_main'
  359. class PayRefush(models.Model):
  360. order_id = models.IntegerField()
  361. pay_order_id = models.CharField(max_length=255)
  362. pay_type = models.IntegerField()
  363. refush_money = models.DecimalField(max_digits=10, decimal_places=2)
  364. amount_money = models.DecimalField(max_digits=10, decimal_places=2)
  365. fx_uid = models.IntegerField()
  366. sh_uid = models.IntegerField()
  367. status = models.IntegerField()
  368. create_time = models.DateTimeField()
  369. refund_time = models.DateTimeField()
  370. delete_flag = models.IntegerField()
  371. category_id = models.IntegerField()
  372. app_id = models.CharField(max_length=255, blank=True, null=True)
  373. open_id = models.CharField(max_length=255, blank=True, null=True)
  374. class Meta:
  375. managed = False
  376. db_table = 'pay_refush'
  377. class ProdCategory(models.Model):
  378. pro_cate_id = models.AutoField(primary_key=True)
  379. sign = models.CharField(max_length=255, blank=True, null=True)
  380. pro_cate_name = models.CharField(max_length=100)
  381. prod_des = models.TextField(blank=True, null=True)
  382. category_id = models.IntegerField()
  383. show_price = models.DecimalField(max_digits=10, decimal_places=2)
  384. original_price = models.DecimalField(max_digits=10, decimal_places=2)
  385. show_img = models.CharField(max_length=255)
  386. sales_count = models.IntegerField()
  387. memo = models.TextField(blank=True, null=True)
  388. trip_desc = models.TextField(blank=True, null=True)
  389. feature = models.TextField(blank=True, null=True)
  390. commission = models.DecimalField(max_digits=10, decimal_places=0)
  391. create_user_id = models.IntegerField()
  392. is_recom = models.IntegerField()
  393. start_area = models.CharField(max_length=255, blank=True, null=True)
  394. address = models.CharField(max_length=255, blank=True, null=True)
  395. close_sale_time = models.CharField(max_length=50)
  396. star = models.CharField(max_length=4)
  397. create_time = models.DateTimeField()
  398. update_time = models.DateTimeField()
  399. delete_flag = models.IntegerField()
  400. update_user = models.CharField(max_length=50)
  401. bus_ticket_id = models.IntegerField()
  402. bus_line_type = models.IntegerField()
  403. class Meta:
  404. managed = False
  405. db_table = 'prod_category'
  406. class ProdCategoryInfo(models.Model):
  407. pro_cate_id = models.IntegerField(primary_key=True)
  408. comment_cnt = models.IntegerField()
  409. class Meta:
  410. managed = False
  411. db_table = 'prod_category_info'
  412. class ProdComment(models.Model):
  413. travel_id = models.IntegerField(blank=True, null=True)
  414. prod_id = models.CharField(max_length=255, blank=True, null=True)
  415. star = models.IntegerField()
  416. title = models.CharField(max_length=30)
  417. content = models.TextField()
  418. u_name = models.CharField(max_length=100)
  419. u_id = models.IntegerField(blank=True, null=True)
  420. create_time = models.DateTimeField()
  421. look_over = models.IntegerField()
  422. type = models.IntegerField()
  423. comment_id = models.IntegerField()
  424. parent_id = models.IntegerField()
  425. cancel_flag = models.IntegerField()
  426. class Meta:
  427. managed = False
  428. db_table = 'prod_comment'
  429. class ProdImg(models.Model):
  430. pro_cate_id = models.IntegerField()
  431. img_url = models.CharField(max_length=255)
  432. redirect_url = models.CharField(max_length=255, blank=True, null=True)
  433. memo = models.CharField(max_length=255, blank=True, null=True)
  434. img_type = models.IntegerField()
  435. create_time = models.DateTimeField()
  436. class Meta:
  437. managed = False
  438. db_table = 'prod_img'
  439. class ProdMain(models.Model):
  440. prod_id = models.AutoField(primary_key=True)
  441. prod_cate_id = models.IntegerField()
  442. prod_name = models.CharField(max_length=100)
  443. prod_price = models.DecimalField(max_digits=10, decimal_places=2)
  444. create_user = models.CharField(max_length=50)
  445. create_time = models.DateTimeField()
  446. update_time = models.DateTimeField()
  447. delete_flag = models.IntegerField()
  448. update_user = models.CharField(max_length=50)
  449. bus_id = models.CharField(max_length=255)
  450. commission = models.DecimalField(max_digits=10, decimal_places=2)
  451. class Meta:
  452. managed = False
  453. db_table = 'prod_main'
  454. class ShUser(models.Model):
  455. uid = models.AutoField(primary_key=True)
  456. user_name = models.CharField(max_length=100, blank=True, null=True)
  457. phone = models.CharField(unique=True, max_length=20, blank=True, null=True)
  458. head_img = models.CharField(max_length=255, blank=True, null=True)
  459. status = models.IntegerField(blank=True, null=True)
  460. reg_time = models.DateTimeField(blank=True, null=True)
  461. last_login = models.DateTimeField(blank=True, null=True)
  462. class Meta:
  463. managed = False
  464. db_table = 'sh_user'
  465. class SysItinerary(models.Model):
  466. category_id = models.IntegerField()
  467. category_name = models.CharField(max_length=50)
  468. scenc_introduce = models.TextField(blank=True, null=True)
  469. scenc_play = models.TextField(blank=True, null=True)
  470. folk_customs = models.TextField(blank=True, null=True)
  471. local_specialities = models.TextField(blank=True, null=True)
  472. travel_tips = models.TextField(blank=True, null=True)
  473. class Meta:
  474. managed = False
  475. db_table = 'sys_itinerary'
  476. class ZzNews(models.Model):
  477. class_id = models.IntegerField()
  478. news_title = models.CharField(max_length=100)
  479. navi_content = models.CharField(max_length=255)
  480. content = models.TextField()
  481. create_user = models.CharField(max_length=50)
  482. create_time = models.DateTimeField()
  483. update_time = models.DateTimeField()
  484. delete_flag = models.IntegerField()
  485. class Meta:
  486. managed = False
  487. db_table = 'zz_news'