?? 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)