995 lines
29 KiB
Plaintext
995 lines
29 KiB
Plaintext
|
|
?? assistant_accounts_master
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. site_id (bigint)
|
|
4. assistant_no (text)
|
|
5. nickname (text)
|
|
6. real_name (text)
|
|
7. mobile (text)
|
|
8. team_id (bigint)
|
|
9. team_name (text)
|
|
10. user_id (bigint)
|
|
11. level (text)
|
|
12. assistant_status (integer)
|
|
13. work_status (integer)
|
|
14. leave_status (integer)
|
|
15. entry_time (timestamp without time zone)
|
|
16. resign_time (timestamp without time zone)
|
|
17. start_time (timestamp without time zone)
|
|
18. end_time (timestamp without time zone)
|
|
19. create_time (timestamp without time zone)
|
|
20. update_time (timestamp without time zone)
|
|
21. order_trade_no (text)
|
|
22. staff_id (bigint)
|
|
23. staff_profile_id (bigint)
|
|
24. system_role_id (bigint)
|
|
25. avatar (text)
|
|
26. birth_date (timestamp without time zone)
|
|
27. gender (integer)
|
|
28. height (numeric)
|
|
29. weight (numeric)
|
|
30. job_num (text)
|
|
31. show_status (integer)
|
|
32. show_sort (integer)
|
|
33. sum_grade (numeric)
|
|
34. assistant_grade (numeric)
|
|
35. get_grade_times (integer)
|
|
36. introduce (text)
|
|
37. video_introduction_url (text)
|
|
38. group_id (bigint)
|
|
39. group_name (text)
|
|
40. shop_name (text)
|
|
41. charge_way (integer)
|
|
42. entry_type (integer)
|
|
43. allow_cx (integer)
|
|
44. is_guaranteed (integer)
|
|
45. salary_grant_enabled (integer)
|
|
46. light_status (integer)
|
|
47. online_status (integer)
|
|
48. is_delete (integer)
|
|
49. cx_unit_price (numeric)
|
|
50. pd_unit_price (numeric)
|
|
51. last_table_id (bigint)
|
|
52. last_table_name (text)
|
|
53. person_org_id (bigint)
|
|
54. serial_number (bigint)
|
|
55. is_team_leader (integer)
|
|
56. criticism_status (integer)
|
|
57. last_update_name (text)
|
|
58. ding_talk_synced (integer)
|
|
59. site_light_cfg_id (bigint)
|
|
60. light_equipment_id (text)
|
|
61. entry_sign_status (integer)
|
|
62. resign_sign_status (integer)
|
|
63. source_file (text)
|
|
64. source_endpoint (text)
|
|
65. fetched_at (timestamp with time zone)
|
|
66. payload (jsonb)
|
|
67. content_hash (text)
|
|
|
|
?? assistant_cancellation_records
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. siteid (bigint)
|
|
3. siteprofile (jsonb)
|
|
4. assistantname (text)
|
|
5. assistantabolishamount (numeric)
|
|
6. assistanton (integer)
|
|
7. pdchargeminutes (integer)
|
|
8. tableareaid (bigint)
|
|
9. tablearea (text)
|
|
10. tableid (bigint)
|
|
11. tablename (text)
|
|
12. trashreason (text)
|
|
13. createtime (timestamp without time zone)
|
|
14. source_file (text)
|
|
15. source_endpoint (text)
|
|
16. fetched_at (timestamp with time zone)
|
|
17. payload (jsonb)
|
|
18. content_hash (text)
|
|
|
|
?? assistant_service_records
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. site_id (bigint)
|
|
4. siteprofile (jsonb)
|
|
5. site_table_id (bigint)
|
|
6. order_settle_id (bigint)
|
|
7. order_trade_no (text)
|
|
8. order_pay_id (bigint)
|
|
9. order_assistant_id (bigint)
|
|
10. order_assistant_type (integer)
|
|
11. assistantname (text)
|
|
12. assistantno (text)
|
|
13. assistant_level (text)
|
|
14. levelname (text)
|
|
15. site_assistant_id (bigint)
|
|
16. skill_id (bigint)
|
|
17. skillname (text)
|
|
18. system_member_id (bigint)
|
|
19. tablename (text)
|
|
20. tenant_member_id (bigint)
|
|
21. user_id (bigint)
|
|
22. assistant_team_id (bigint)
|
|
23. nickname (text)
|
|
24. ledger_name (text)
|
|
25. ledger_group_name (text)
|
|
26. ledger_amount (numeric)
|
|
27. ledger_count (numeric)
|
|
28. ledger_unit_price (numeric)
|
|
29. ledger_status (integer)
|
|
30. ledger_start_time (timestamp without time zone)
|
|
31. ledger_end_time (timestamp without time zone)
|
|
32. manual_discount_amount (numeric)
|
|
33. member_discount_amount (numeric)
|
|
34. coupon_deduct_money (numeric)
|
|
35. service_money (numeric)
|
|
36. projected_income (numeric)
|
|
37. real_use_seconds (integer)
|
|
38. income_seconds (integer)
|
|
39. start_use_time (timestamp without time zone)
|
|
40. last_use_time (timestamp without time zone)
|
|
41. create_time (timestamp without time zone)
|
|
42. is_single_order (integer)
|
|
43. is_delete (integer)
|
|
44. is_trash (integer)
|
|
45. trash_reason (text)
|
|
46. trash_applicant_id (bigint)
|
|
47. trash_applicant_name (text)
|
|
48. operator_id (bigint)
|
|
49. operator_name (text)
|
|
50. salesman_name (text)
|
|
51. salesman_org_id (bigint)
|
|
52. salesman_user_id (bigint)
|
|
53. person_org_id (bigint)
|
|
54. add_clock (integer)
|
|
55. returns_clock (integer)
|
|
56. composite_grade (numeric)
|
|
57. composite_grade_time (timestamp without time zone)
|
|
58. skill_grade (numeric)
|
|
59. service_grade (numeric)
|
|
60. sum_grade (numeric)
|
|
61. grade_status (integer)
|
|
62. get_grade_times (integer)
|
|
63. is_not_responding (integer)
|
|
64. is_confirm (integer)
|
|
65. payload (jsonb)
|
|
66. source_file (text)
|
|
67. source_endpoint (text)
|
|
68. fetched_at (timestamp with time zone)
|
|
69. content_hash (text)
|
|
|
|
?? goods_stock_movements
|
|
------------------------------------------------------------
|
|
1. sitegoodsstockid (bigint)
|
|
2. tenantid (bigint)
|
|
3. siteid (bigint)
|
|
4. sitegoodsid (bigint)
|
|
5. goodsname (text)
|
|
6. goodscategoryid (bigint)
|
|
7. goodssecondcategoryid (bigint)
|
|
8. unit (text)
|
|
9. price (numeric)
|
|
10. stocktype (integer)
|
|
11. changenum (numeric)
|
|
12. startnum (numeric)
|
|
13. endnum (numeric)
|
|
14. changenuma (numeric)
|
|
15. startnuma (numeric)
|
|
16. endnuma (numeric)
|
|
17. remark (text)
|
|
18. operatorname (text)
|
|
19. createtime (timestamp without time zone)
|
|
20. source_file (text)
|
|
21. source_endpoint (text)
|
|
22. fetched_at (timestamp with time zone)
|
|
23. payload (jsonb)
|
|
24. content_hash (text)
|
|
|
|
?? goods_stock_summary
|
|
------------------------------------------------------------
|
|
1. sitegoodsid (bigint)
|
|
2. goodsname (text)
|
|
3. goodsunit (text)
|
|
4. goodscategoryid (bigint)
|
|
5. goodscategorysecondid (bigint)
|
|
6. categoryname (text)
|
|
7. rangestartstock (numeric)
|
|
8. rangeendstock (numeric)
|
|
9. rangein (numeric)
|
|
10. rangeout (numeric)
|
|
11. rangesale (numeric)
|
|
12. rangesalemoney (numeric)
|
|
13. rangeinventory (numeric)
|
|
14. currentstock (numeric)
|
|
15. source_file (text)
|
|
16. source_endpoint (text)
|
|
17. fetched_at (timestamp with time zone)
|
|
18. payload (jsonb)
|
|
19. content_hash (text)
|
|
|
|
?? group_buy_packages
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. package_id (bigint)
|
|
3. package_name (text)
|
|
4. selling_price (numeric)
|
|
5. coupon_money (numeric)
|
|
6. date_type (integer)
|
|
7. date_info (text)
|
|
8. start_time (timestamp without time zone)
|
|
9. end_time (timestamp without time zone)
|
|
10. start_clock (text)
|
|
11. end_clock (text)
|
|
12. add_start_clock (text)
|
|
13. add_end_clock (text)
|
|
14. duration (integer)
|
|
15. usable_count (integer)
|
|
16. usable_range (integer)
|
|
17. table_area_id (bigint)
|
|
18. table_area_name (text)
|
|
19. table_area_id_list (jsonb)
|
|
20. tenant_table_area_id (bigint)
|
|
21. tenant_table_area_id_list (jsonb)
|
|
22. site_id (bigint)
|
|
23. site_name (text)
|
|
24. tenant_id (bigint)
|
|
25. card_type_ids (jsonb)
|
|
26. group_type (integer)
|
|
27. system_group_type (integer)
|
|
28. type (integer)
|
|
29. effective_status (integer)
|
|
30. is_enabled (integer)
|
|
31. is_delete (integer)
|
|
32. max_selectable_categories (integer)
|
|
33. area_tag_type (integer)
|
|
34. creator_name (text)
|
|
35. create_time (timestamp without time zone)
|
|
36. source_file (text)
|
|
37. source_endpoint (text)
|
|
38. fetched_at (timestamp with time zone)
|
|
39. payload (jsonb)
|
|
40. content_hash (text)
|
|
|
|
?? group_buy_redemption_records
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. site_id (bigint)
|
|
4. sitename (text)
|
|
5. table_id (bigint)
|
|
6. tablename (text)
|
|
7. tableareaname (text)
|
|
8. tenant_table_area_id (bigint)
|
|
9. order_trade_no (text)
|
|
10. order_settle_id (bigint)
|
|
11. order_pay_id (bigint)
|
|
12. order_coupon_id (bigint)
|
|
13. order_coupon_channel (integer)
|
|
14. coupon_code (text)
|
|
15. coupon_money (numeric)
|
|
16. coupon_origin_id (bigint)
|
|
17. ledger_name (text)
|
|
18. ledger_group_name (text)
|
|
19. ledger_amount (numeric)
|
|
20. ledger_count (numeric)
|
|
21. ledger_unit_price (numeric)
|
|
22. ledger_status (integer)
|
|
23. table_charge_seconds (integer)
|
|
24. promotion_activity_id (bigint)
|
|
25. promotion_coupon_id (bigint)
|
|
26. promotion_seconds (integer)
|
|
27. offer_type (integer)
|
|
28. assistant_promotion_money (numeric)
|
|
29. assistant_service_promotion_money (numeric)
|
|
30. table_service_promotion_money (numeric)
|
|
31. goods_promotion_money (numeric)
|
|
32. recharge_promotion_money (numeric)
|
|
33. reward_promotion_money (numeric)
|
|
34. goodsoptionprice (numeric)
|
|
35. salesman_name (text)
|
|
36. sales_man_org_id (bigint)
|
|
37. salesman_role_id (bigint)
|
|
38. salesman_user_id (bigint)
|
|
39. operator_id (bigint)
|
|
40. operator_name (text)
|
|
41. is_single_order (integer)
|
|
42. is_delete (integer)
|
|
43. create_time (timestamp without time zone)
|
|
44. payload (jsonb)
|
|
45. source_file (text)
|
|
46. source_endpoint (text)
|
|
47. fetched_at (timestamp with time zone)
|
|
48. content_hash (text)
|
|
|
|
?? member_balance_changes
|
|
------------------------------------------------------------
|
|
1. tenant_id (bigint)
|
|
2. site_id (bigint)
|
|
3. register_site_id (bigint)
|
|
4. registersitename (text)
|
|
5. paysitename (text)
|
|
6. id (bigint)
|
|
7. tenant_member_id (bigint)
|
|
8. tenant_member_card_id (bigint)
|
|
9. system_member_id (bigint)
|
|
10. membername (text)
|
|
11. membermobile (text)
|
|
12. card_type_id (bigint)
|
|
13. membercardtypename (text)
|
|
14. account_data (numeric)
|
|
15. before (numeric)
|
|
16. after (numeric)
|
|
17. refund_amount (numeric)
|
|
18. from_type (integer)
|
|
19. payment_method (integer)
|
|
20. relate_id (bigint)
|
|
21. remark (text)
|
|
22. operator_id (bigint)
|
|
23. operator_name (text)
|
|
24. is_delete (integer)
|
|
25. create_time (timestamp without time zone)
|
|
26. source_file (text)
|
|
27. source_endpoint (text)
|
|
28. fetched_at (timestamp with time zone)
|
|
29. payload (jsonb)
|
|
30. content_hash (text)
|
|
|
|
?? member_profiles
|
|
------------------------------------------------------------
|
|
1. tenant_id (bigint)
|
|
2. register_site_id (bigint)
|
|
3. site_name (text)
|
|
4. id (bigint)
|
|
5. system_member_id (bigint)
|
|
6. member_card_grade_code (bigint)
|
|
7. member_card_grade_name (text)
|
|
8. mobile (text)
|
|
9. nickname (text)
|
|
10. point (numeric)
|
|
11. growth_value (numeric)
|
|
12. referrer_member_id (bigint)
|
|
13. status (integer)
|
|
14. user_status (integer)
|
|
15. create_time (timestamp without time zone)
|
|
16. source_file (text)
|
|
17. source_endpoint (text)
|
|
18. fetched_at (timestamp with time zone)
|
|
19. payload (jsonb)
|
|
20. content_hash (text)
|
|
|
|
?? member_stored_value_cards
|
|
------------------------------------------------------------
|
|
1. tenant_id (bigint)
|
|
2. tenant_member_id (bigint)
|
|
3. system_member_id (bigint)
|
|
4. register_site_id (bigint)
|
|
5. site_name (text)
|
|
6. id (bigint)
|
|
7. member_card_grade_code (bigint)
|
|
8. member_card_grade_code_name (text)
|
|
9. member_card_type_name (text)
|
|
10. member_name (text)
|
|
11. member_mobile (text)
|
|
12. card_type_id (bigint)
|
|
13. card_no (text)
|
|
14. card_physics_type (text)
|
|
15. balance (numeric)
|
|
16. denomination (numeric)
|
|
17. table_discount (numeric)
|
|
18. goods_discount (numeric)
|
|
19. assistant_discount (numeric)
|
|
20. assistant_reward_discount (numeric)
|
|
21. table_service_discount (numeric)
|
|
22. assistant_service_discount (numeric)
|
|
23. coupon_discount (numeric)
|
|
24. goods_service_discount (numeric)
|
|
25. assistant_discount_sub_switch (integer)
|
|
26. table_discount_sub_switch (integer)
|
|
27. goods_discount_sub_switch (integer)
|
|
28. assistant_reward_discount_sub_switch (integer)
|
|
29. table_service_deduct_radio (numeric)
|
|
30. assistant_service_deduct_radio (numeric)
|
|
31. goods_service_deduct_radio (numeric)
|
|
32. assistant_deduct_radio (numeric)
|
|
33. table_deduct_radio (numeric)
|
|
34. goods_deduct_radio (numeric)
|
|
35. coupon_deduct_radio (numeric)
|
|
36. assistant_reward_deduct_radio (numeric)
|
|
37. tablecarddeduct (numeric)
|
|
38. tableservicecarddeduct (numeric)
|
|
39. goodscardeduct (numeric)
|
|
40. goodsservicecarddeduct (numeric)
|
|
41. assistantcarddeduct (numeric)
|
|
42. assistantservicecarddeduct (numeric)
|
|
43. assistantrewardcarddeduct (numeric)
|
|
44. cardsettlededuct (numeric)
|
|
45. couponcarddeduct (numeric)
|
|
46. deliveryfeededuct (numeric)
|
|
47. use_scene (integer)
|
|
48. able_cross_site (integer)
|
|
49. able_site_transfer (integer)
|
|
50. is_allow_give (integer)
|
|
51. is_allow_order_deduct (integer)
|
|
52. is_delete (integer)
|
|
53. bind_password (text)
|
|
54. goods_discount_range_type (integer)
|
|
55. goodscategoryid (bigint)
|
|
56. tableareaid (bigint)
|
|
57. effect_site_id (bigint)
|
|
58. start_time (timestamp without time zone)
|
|
59. end_time (timestamp without time zone)
|
|
60. disable_start_time (timestamp without time zone)
|
|
61. disable_end_time (timestamp without time zone)
|
|
62. last_consume_time (timestamp without time zone)
|
|
63. create_time (timestamp without time zone)
|
|
64. status (integer)
|
|
65. sort (integer)
|
|
66. tenantavatar (text)
|
|
67. tenantname (text)
|
|
68. pdassisnatlevel (text)
|
|
69. cxassisnatlevel (text)
|
|
70. source_file (text)
|
|
71. source_endpoint (text)
|
|
72. fetched_at (timestamp with time zone)
|
|
73. payload (jsonb)
|
|
74. content_hash (text)
|
|
|
|
?? payment_transactions
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. site_id (bigint)
|
|
3. siteprofile (jsonb)
|
|
4. relate_type (integer)
|
|
5. relate_id (bigint)
|
|
6. pay_amount (numeric)
|
|
7. pay_status (integer)
|
|
8. pay_time (timestamp without time zone)
|
|
9. create_time (timestamp without time zone)
|
|
10. payment_method (integer)
|
|
11. online_pay_channel (integer)
|
|
12. source_file (text)
|
|
13. source_endpoint (text)
|
|
14. fetched_at (timestamp with time zone)
|
|
15. payload (jsonb)
|
|
16. content_hash (text)
|
|
|
|
?? platform_coupon_redemption_records
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. verify_id (bigint)
|
|
3. certificate_id (text)
|
|
4. coupon_code (text)
|
|
5. coupon_name (text)
|
|
6. coupon_channel (integer)
|
|
7. groupon_type (integer)
|
|
8. group_package_id (bigint)
|
|
9. sale_price (numeric)
|
|
10. coupon_money (numeric)
|
|
11. coupon_free_time (numeric)
|
|
12. coupon_cover (text)
|
|
13. coupon_remark (text)
|
|
14. use_status (integer)
|
|
15. consume_time (timestamp without time zone)
|
|
16. create_time (timestamp without time zone)
|
|
17. deal_id (text)
|
|
18. channel_deal_id (text)
|
|
19. site_id (bigint)
|
|
20. site_order_id (bigint)
|
|
21. table_id (bigint)
|
|
22. tenant_id (bigint)
|
|
23. operator_id (bigint)
|
|
24. operator_name (text)
|
|
25. is_delete (integer)
|
|
26. siteprofile (jsonb)
|
|
27. source_file (text)
|
|
28. source_endpoint (text)
|
|
29. fetched_at (timestamp with time zone)
|
|
30. payload (jsonb)
|
|
31. content_hash (text)
|
|
|
|
?? recharge_settlements
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenantid (bigint)
|
|
3. siteid (bigint)
|
|
4. sitename (text)
|
|
5. balanceamount (numeric)
|
|
6. cardamount (numeric)
|
|
7. cashamount (numeric)
|
|
8. couponamount (numeric)
|
|
9. createtime (timestamp with time zone)
|
|
10. memberid (bigint)
|
|
11. membername (text)
|
|
12. tenantmembercardid (bigint)
|
|
13. membercardtypename (text)
|
|
14. memberphone (text)
|
|
15. tableid (bigint)
|
|
16. consumemoney (numeric)
|
|
17. onlineamount (numeric)
|
|
18. operatorid (bigint)
|
|
19. operatorname (text)
|
|
20. revokeorderid (bigint)
|
|
21. revokeordername (text)
|
|
22. revoketime (timestamp with time zone)
|
|
23. payamount (numeric)
|
|
24. pointamount (numeric)
|
|
25. refundamount (numeric)
|
|
26. settlename (text)
|
|
27. settlerelateid (bigint)
|
|
28. settlestatus (integer)
|
|
29. settletype (integer)
|
|
30. paytime (timestamp with time zone)
|
|
31. roundingamount (numeric)
|
|
32. paymentmethod (integer)
|
|
33. adjustamount (numeric)
|
|
34. assistantcxmoney (numeric)
|
|
35. assistantpdmoney (numeric)
|
|
36. couponsaleamount (numeric)
|
|
37. memberdiscountamount (numeric)
|
|
38. tablechargemoney (numeric)
|
|
39. goodsmoney (numeric)
|
|
40. realgoodsmoney (numeric)
|
|
41. servicemoney (numeric)
|
|
42. prepaymoney (numeric)
|
|
43. salesmanname (text)
|
|
44. orderremark (text)
|
|
45. salesmanuserid (bigint)
|
|
46. canberevoked (boolean)
|
|
47. pointdiscountprice (numeric)
|
|
48. pointdiscountcost (numeric)
|
|
49. activitydiscount (numeric)
|
|
50. serialnumber (bigint)
|
|
51. assistantmanualdiscount (numeric)
|
|
52. allcoupondiscount (numeric)
|
|
53. goodspromotionmoney (numeric)
|
|
54. assistantpromotionmoney (numeric)
|
|
55. isusecoupon (boolean)
|
|
56. isusediscount (boolean)
|
|
57. isactivity (boolean)
|
|
58. isbindmember (boolean)
|
|
59. isfirst (integer)
|
|
60. rechargecardamount (numeric)
|
|
61. giftcardamount (numeric)
|
|
62. source_file (text)
|
|
63. source_endpoint (text)
|
|
64. fetched_at (timestamp with time zone)
|
|
65. payload (jsonb)
|
|
66. content_hash (text)
|
|
|
|
?? refund_transactions
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. tenantname (text)
|
|
4. site_id (bigint)
|
|
5. siteprofile (jsonb)
|
|
6. relate_type (integer)
|
|
7. relate_id (bigint)
|
|
8. pay_sn (text)
|
|
9. pay_amount (numeric)
|
|
10. refund_amount (numeric)
|
|
11. round_amount (numeric)
|
|
12. pay_status (integer)
|
|
13. pay_time (timestamp without time zone)
|
|
14. create_time (timestamp without time zone)
|
|
15. payment_method (integer)
|
|
16. pay_terminal (integer)
|
|
17. pay_config_id (bigint)
|
|
18. online_pay_channel (integer)
|
|
19. online_pay_type (integer)
|
|
20. channel_fee (numeric)
|
|
21. channel_payer_id (text)
|
|
22. channel_pay_no (text)
|
|
23. member_id (bigint)
|
|
24. member_card_id (bigint)
|
|
25. cashier_point_id (bigint)
|
|
26. operator_id (bigint)
|
|
27. action_type (integer)
|
|
28. check_status (integer)
|
|
29. is_revoke (integer)
|
|
30. is_delete (integer)
|
|
31. balance_frozen_amount (numeric)
|
|
32. card_frozen_amount (numeric)
|
|
33. source_file (text)
|
|
34. source_endpoint (text)
|
|
35. fetched_at (timestamp with time zone)
|
|
36. payload (jsonb)
|
|
37. content_hash (text)
|
|
|
|
?? settlement_records
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenantid (bigint)
|
|
3. siteid (bigint)
|
|
4. sitename (text)
|
|
5. balanceamount (numeric)
|
|
6. cardamount (numeric)
|
|
7. cashamount (numeric)
|
|
8. couponamount (numeric)
|
|
9. createtime (timestamp with time zone)
|
|
10. memberid (bigint)
|
|
11. membername (text)
|
|
12. tenantmembercardid (bigint)
|
|
13. membercardtypename (text)
|
|
14. memberphone (text)
|
|
15. tableid (bigint)
|
|
16. consumemoney (numeric)
|
|
17. onlineamount (numeric)
|
|
18. operatorid (bigint)
|
|
19. operatorname (text)
|
|
20. revokeorderid (bigint)
|
|
21. revokeordername (text)
|
|
22. revoketime (timestamp with time zone)
|
|
23. payamount (numeric)
|
|
24. pointamount (numeric)
|
|
25. refundamount (numeric)
|
|
26. settlename (text)
|
|
27. settlerelateid (bigint)
|
|
28. settlestatus (integer)
|
|
29. settletype (integer)
|
|
30. paytime (timestamp with time zone)
|
|
31. roundingamount (numeric)
|
|
32. paymentmethod (integer)
|
|
33. adjustamount (numeric)
|
|
34. assistantcxmoney (numeric)
|
|
35. assistantpdmoney (numeric)
|
|
36. couponsaleamount (numeric)
|
|
37. memberdiscountamount (numeric)
|
|
38. tablechargemoney (numeric)
|
|
39. goodsmoney (numeric)
|
|
40. realgoodsmoney (numeric)
|
|
41. servicemoney (numeric)
|
|
42. prepaymoney (numeric)
|
|
43. salesmanname (text)
|
|
44. orderremark (text)
|
|
45. salesmanuserid (bigint)
|
|
46. canberevoked (boolean)
|
|
47. pointdiscountprice (numeric)
|
|
48. pointdiscountcost (numeric)
|
|
49. activitydiscount (numeric)
|
|
50. serialnumber (bigint)
|
|
51. assistantmanualdiscount (numeric)
|
|
52. allcoupondiscount (numeric)
|
|
53. goodspromotionmoney (numeric)
|
|
54. assistantpromotionmoney (numeric)
|
|
55. isusecoupon (boolean)
|
|
56. isusediscount (boolean)
|
|
57. isactivity (boolean)
|
|
58. isbindmember (boolean)
|
|
59. isfirst (integer)
|
|
60. rechargecardamount (numeric)
|
|
61. giftcardamount (numeric)
|
|
62. source_file (text)
|
|
63. source_endpoint (text)
|
|
64. fetched_at (timestamp with time zone)
|
|
65. payload (jsonb)
|
|
66. content_hash (text)
|
|
|
|
?? settlement_ticket_details
|
|
------------------------------------------------------------
|
|
1. ordersettleid (bigint)
|
|
2. actualpayment (numeric)
|
|
3. adjustamount (numeric)
|
|
4. assistantmanualdiscount (numeric)
|
|
5. balanceamount (numeric)
|
|
6. cashiername (text)
|
|
7. consumemoney (numeric)
|
|
8. couponamount (numeric)
|
|
9. deliveryaddress (text)
|
|
10. deliveryfee (numeric)
|
|
11. ledgeramount (numeric)
|
|
12. memberdeductamount (numeric)
|
|
13. memberofferamount (numeric)
|
|
14. onlinereturnamount (numeric)
|
|
15. orderremark (text)
|
|
16. ordersettlenumber (bigint)
|
|
17. paymemberbalance (numeric)
|
|
18. paytime (timestamp without time zone)
|
|
19. paymentmethod (integer)
|
|
20. pointdiscountcost (numeric)
|
|
21. pointdiscountprice (numeric)
|
|
22. prepaymoney (numeric)
|
|
23. refundamount (numeric)
|
|
24. returngoodsamount (numeric)
|
|
25. rewardname (text)
|
|
26. settletype (text)
|
|
27. siteaddress (text)
|
|
28. sitebusinesstel (text)
|
|
29. siteid (bigint)
|
|
30. sitename (text)
|
|
31. tenantid (bigint)
|
|
32. tenantname (text)
|
|
33. ticketcustomcontent (text)
|
|
34. ticketremark (text)
|
|
35. vouchermoney (numeric)
|
|
36. memberprofile (jsonb)
|
|
37. orderitem (jsonb)
|
|
38. tenantmembercardlogs (jsonb)
|
|
39. payload (jsonb)
|
|
40. source_file (text)
|
|
41. source_endpoint (text)
|
|
42. fetched_at (timestamp with time zone)
|
|
43. content_hash (text)
|
|
|
|
?? site_tables_master
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. site_id (bigint)
|
|
3. sitename (text)
|
|
4. appletQrCodeUrl (text)
|
|
5. areaname (text)
|
|
6. audit_status (integer)
|
|
7. charge_free (integer)
|
|
8. create_time (timestamp without time zone)
|
|
9. delay_lights_time (integer)
|
|
10. is_online_reservation (integer)
|
|
11. is_rest_area (integer)
|
|
12. light_status (integer)
|
|
13. only_allow_groupon (integer)
|
|
14. order_delay_time (integer)
|
|
15. self_table (integer)
|
|
16. show_status (integer)
|
|
17. site_table_area_id (bigint)
|
|
18. tablestatusname (text)
|
|
19. table_cloth_use_cycle (integer)
|
|
20. table_cloth_use_time (timestamp without time zone)
|
|
21. table_name (text)
|
|
22. table_price (numeric)
|
|
23. table_status (integer)
|
|
24. temporary_light_second (integer)
|
|
25. virtual_table (integer)
|
|
26. source_file (text)
|
|
27. source_endpoint (text)
|
|
28. fetched_at (timestamp with time zone)
|
|
29. payload (jsonb)
|
|
30. content_hash (text)
|
|
|
|
?? stock_goods_category_tree
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. category_name (text)
|
|
4. alias_name (text)
|
|
5. pid (bigint)
|
|
6. business_name (text)
|
|
7. tenant_goods_business_id (bigint)
|
|
8. open_salesman (integer)
|
|
9. categoryboxes (jsonb)
|
|
10. sort (integer)
|
|
11. is_warehousing (integer)
|
|
12. source_file (text)
|
|
13. source_endpoint (text)
|
|
14. fetched_at (timestamp with time zone)
|
|
15. payload (jsonb)
|
|
16. content_hash (text)
|
|
|
|
?? store_goods_master
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. site_id (bigint)
|
|
4. sitename (text)
|
|
5. tenant_goods_id (bigint)
|
|
6. goods_name (text)
|
|
7. goods_bar_code (text)
|
|
8. goods_category_id (bigint)
|
|
9. goods_second_category_id (bigint)
|
|
10. onecategoryname (text)
|
|
11. twocategoryname (text)
|
|
12. unit (text)
|
|
13. sale_price (numeric)
|
|
14. cost_price (numeric)
|
|
15. cost_price_type (integer)
|
|
16. min_discount_price (numeric)
|
|
17. safe_stock (numeric)
|
|
18. stock (numeric)
|
|
19. stock_a (numeric)
|
|
20. sale_num (numeric)
|
|
21. total_purchase_cost (numeric)
|
|
22. total_sales (numeric)
|
|
23. average_monthly_sales (numeric)
|
|
24. batch_stock_quantity (numeric)
|
|
25. days_available (integer)
|
|
26. provisional_total_cost (numeric)
|
|
27. enable_status (integer)
|
|
28. audit_status (integer)
|
|
29. goods_state (integer)
|
|
30. is_delete (integer)
|
|
31. is_warehousing (integer)
|
|
32. able_discount (integer)
|
|
33. able_site_transfer (integer)
|
|
34. forbid_sell_status (integer)
|
|
35. freeze (integer)
|
|
36. send_state (integer)
|
|
37. custom_label_type (integer)
|
|
38. option_required (integer)
|
|
39. sale_channel (integer)
|
|
40. sort (integer)
|
|
41. remark (text)
|
|
42. pinyin_initial (text)
|
|
43. goods_cover (text)
|
|
44. create_time (timestamp without time zone)
|
|
45. update_time (timestamp without time zone)
|
|
46. payload (jsonb)
|
|
47. source_file (text)
|
|
48. source_endpoint (text)
|
|
49. fetched_at (timestamp with time zone)
|
|
50. content_hash (text)
|
|
|
|
?? store_goods_sales_records
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. site_id (bigint)
|
|
4. siteid (bigint)
|
|
5. sitename (text)
|
|
6. site_goods_id (bigint)
|
|
7. tenant_goods_id (bigint)
|
|
8. order_settle_id (bigint)
|
|
9. order_trade_no (text)
|
|
10. order_goods_id (bigint)
|
|
11. ordergoodsid (bigint)
|
|
12. order_pay_id (bigint)
|
|
13. order_coupon_id (bigint)
|
|
14. ledger_name (text)
|
|
15. ledger_group_name (text)
|
|
16. ledger_amount (numeric)
|
|
17. ledger_count (numeric)
|
|
18. ledger_unit_price (numeric)
|
|
19. ledger_status (integer)
|
|
20. discount_money (numeric)
|
|
21. discount_price (numeric)
|
|
22. coupon_deduct_money (numeric)
|
|
23. member_discount_amount (numeric)
|
|
24. option_coupon_deduct_money (numeric)
|
|
25. option_member_discount_money (numeric)
|
|
26. point_discount_money (numeric)
|
|
27. point_discount_money_cost (numeric)
|
|
28. real_goods_money (numeric)
|
|
29. cost_money (numeric)
|
|
30. push_money (numeric)
|
|
31. sales_type (integer)
|
|
32. is_single_order (integer)
|
|
33. is_delete (integer)
|
|
34. goods_remark (text)
|
|
35. option_price (numeric)
|
|
36. option_value_name (text)
|
|
37. option_name (text)
|
|
38. member_coupon_id (bigint)
|
|
39. package_coupon_id (bigint)
|
|
40. sales_man_org_id (bigint)
|
|
41. salesman_name (text)
|
|
42. salesman_role_id (bigint)
|
|
43. salesman_user_id (bigint)
|
|
44. operator_id (bigint)
|
|
45. operator_name (text)
|
|
46. opensalesman (text)
|
|
47. returns_number (integer)
|
|
48. site_table_id (bigint)
|
|
49. tenant_goods_business_id (bigint)
|
|
50. tenant_goods_category_id (bigint)
|
|
51. create_time (timestamp without time zone)
|
|
52. payload (jsonb)
|
|
53. source_file (text)
|
|
54. source_endpoint (text)
|
|
55. fetched_at (timestamp with time zone)
|
|
56. content_hash (text)
|
|
|
|
?? table_fee_discount_records
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. site_id (bigint)
|
|
4. siteprofile (jsonb)
|
|
5. site_table_id (bigint)
|
|
6. tableprofile (jsonb)
|
|
7. tenant_table_area_id (bigint)
|
|
8. adjust_type (integer)
|
|
9. ledger_amount (numeric)
|
|
10. ledger_count (numeric)
|
|
11. ledger_name (text)
|
|
12. ledger_status (integer)
|
|
13. applicant_id (bigint)
|
|
14. applicant_name (text)
|
|
15. operator_id (bigint)
|
|
16. operator_name (text)
|
|
17. order_settle_id (bigint)
|
|
18. order_trade_no (text)
|
|
19. is_delete (integer)
|
|
20. create_time (timestamp without time zone)
|
|
21. source_file (text)
|
|
22. source_endpoint (text)
|
|
23. fetched_at (timestamp with time zone)
|
|
24. payload (jsonb)
|
|
25. content_hash (text)
|
|
|
|
?? table_fee_transactions
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. site_id (bigint)
|
|
4. siteprofile (jsonb)
|
|
5. site_table_id (bigint)
|
|
6. site_table_area_id (bigint)
|
|
7. site_table_area_name (text)
|
|
8. tenant_table_area_id (bigint)
|
|
9. order_trade_no (text)
|
|
10. order_pay_id (bigint)
|
|
11. order_settle_id (bigint)
|
|
12. ledger_name (text)
|
|
13. ledger_amount (numeric)
|
|
14. ledger_count (numeric)
|
|
15. ledger_unit_price (numeric)
|
|
16. ledger_status (integer)
|
|
17. ledger_start_time (timestamp without time zone)
|
|
18. ledger_end_time (timestamp without time zone)
|
|
19. start_use_time (timestamp without time zone)
|
|
20. last_use_time (timestamp without time zone)
|
|
21. real_table_use_seconds (integer)
|
|
22. real_table_charge_money (numeric)
|
|
23. add_clock_seconds (integer)
|
|
24. adjust_amount (numeric)
|
|
25. coupon_promotion_amount (numeric)
|
|
26. member_discount_amount (numeric)
|
|
27. used_card_amount (numeric)
|
|
28. mgmt_fee (numeric)
|
|
29. service_money (numeric)
|
|
30. fee_total (numeric)
|
|
31. is_single_order (integer)
|
|
32. is_delete (integer)
|
|
33. member_id (bigint)
|
|
34. operator_id (bigint)
|
|
35. operator_name (text)
|
|
36. salesman_name (text)
|
|
37. salesman_org_id (bigint)
|
|
38. salesman_user_id (bigint)
|
|
39. create_time (timestamp without time zone)
|
|
40. payload (jsonb)
|
|
41. source_file (text)
|
|
42. source_endpoint (text)
|
|
43. fetched_at (timestamp with time zone)
|
|
44. content_hash (text)
|
|
|
|
?? tenant_goods_master
|
|
------------------------------------------------------------
|
|
1. id (bigint)
|
|
2. tenant_id (bigint)
|
|
3. goods_name (text)
|
|
4. goods_bar_code (text)
|
|
5. goods_category_id (bigint)
|
|
6. goods_second_category_id (bigint)
|
|
7. categoryname (text)
|
|
8. unit (text)
|
|
9. goods_number (text)
|
|
10. out_goods_id (text)
|
|
11. goods_state (integer)
|
|
12. sale_channel (integer)
|
|
13. able_discount (integer)
|
|
14. able_site_transfer (integer)
|
|
15. is_delete (integer)
|
|
16. is_warehousing (integer)
|
|
17. isinsite (integer)
|
|
18. cost_price (numeric)
|
|
19. cost_price_type (integer)
|
|
20. market_price (numeric)
|
|
21. min_discount_price (numeric)
|
|
22. common_sale_royalty (numeric)
|
|
23. point_sale_royalty (numeric)
|
|
24. pinyin_initial (text)
|
|
25. commoditycode (text)
|
|
26. commodity_code (text)
|
|
27. goods_cover (text)
|
|
28. supplier_id (bigint)
|
|
29. remark_name (text)
|
|
30. create_time (timestamp without time zone)
|
|
31. update_time (timestamp without time zone)
|
|
32. payload (jsonb)
|
|
33. source_file (text)
|
|
34. source_endpoint (text)
|
|
35. fetched_at (timestamp with time zone)
|
|
36. content_hash (text)
|