Skip to main content

Database

1st Server

103.52.147.114:5432

production

No. DB Total Schemas Total Tables Used by
1.

ondelivery-agent

 

4

83

 

api.ondelivery.id

stagingapi.ondelivery.id

mpapi.ondelivery.id

1. eatsok
  1. courier_availability_lists
  2. courier_details
  3. image_lists
  4. schedule_lists
  5. schedule_members
  6. tracking_lists

2. master_location
  1. all_clusters
  2. all_locations
  3. location_cities
  4. location_countries
  5. locations_provinces
  6. location_sub_districts

3. price_lists
  1. BDO_coverages
  2. BDO_ondel_coverages
  3. CGK_coverages
  4. CGK_coverages_clone
  5. CGK_lc_coverages
  6. CGK_ondel_coverages
  7. CGK_pcp_coverages
  8. JOG_coverages
  9. JOG_ondel_coverages
  10. MLG_coverages
  11. MLG_ondel_coverages
  12. SRG_coverages
  13. SRG_ondel_coverages
  14. SUB_coverages
  15. SUB_ondel_coverages
  16. trucking_coverages

4. public
  1. access_menus
  2. action_logs
  3. agent_customers
  4. agent_locations
  5. all_location_revs
  6. all_locations
  7. all_services
  8. awb_books
  9. awb_lists
  10. awb_lists_clone
  11. awb_pickups
  12. bagging_list_completes
  13. bagging_lists
  14. bagging_member_completes
  15. bagging_members
  16. courier_partners
  17. coverage_area_services
  18. delivery_scans
  19. exclusion_lists
  20. handover_pcp_scans
  21. handover_scans
  22. image_lists
  23. indopaket_data_stores
  24. indopaket_temps
  25. info_lists
  26. login_sessions
  27. manifest_pcp_lists
  28. manifest_pos_lists
  29. packed_scans
  30. partners
  31. pcp_coverage_areas
  32. pcp_goods_types
  33. preset_locations
  34. problem_scans
  35. promos
  36. promos_clones
  37. receiving_scans
  38. receiving_scans_completes
  39. resi_3p_lists
  40. roles
  41. scans
  42. search_tracks
  43. service_lists
  44. service_new_lists
  45. services
  46. sheet_lists
  47. sla_monitors
  48. transaction
  49. trucking_configs
  50. trucking_shipments
  51. upc_lists
  52. used_bagging_numbers
  53. user_lists
  54. user_roles
  55. user_stats
2.
 userstate

1

14

usapi.onindonesia.id

1. public
  1. address_lists
  2. api_keys
  3. bank_accounts
  4. bank_channels
  5. counters
  6. deactivate_reasons
  7. fcms
  8. marketing_offers
  9. otp_trackers
  10. user_balances
  11. user_infos
  12. uers_logins
  13. user_transactions
  14. voucher_redemption
3.
 sunshine

4

47

sunshine.onindonesia.id

1. approval
  1. approval_keys
  2. approval_masters
  3. areas
  4. keyword_approvals
  5. notification_approvals
  6. template_jsons

2. cms
  1. ad_lists
  2. ads
  3. blog_lists
  4. blogs
  5. career
  6. departments
  7. dept_list
  8. drop_points
  9. training_views
  10. trainings
  11. vacancies

3. cta
  1. agent_inquiries
  2. business_inquiries

4. public
  1. access_menus
  2. agents
  3. asset_configurations
  4. asset_inventories
  5. asset_pictures
  6. asset_trackings
  7. asset_vendors
  8. attendances
  9. bank_infos
  10. center_locations
  11. company_lists
  12. emp_copys
  13. employee_shifts
  14. employees
  15. employement_status
  16. meeting_rooms
  17. placement_employees
  18. positions
  19. problem_types
  20. roles
  21. schedule_rooms
  22. shifts
  23. ticket_comments
  24. tickets
  25. users
  26. vendors
  27. voucher_configs
  28. vouchers
4.
 onticket

1

 9

onticket-api.onindonesia.id
onticket-demoapi.onindonesia.id
onticket-stagingapi.onindonesia.id

1. public
  1. booking_details
  2. id_trackers
  3. organizer_details
  4. ticket_categories
  5. ticket_details
  6. ticket_guest_details
  7. ticket_promotion_lists
  8. ticket_statistics
  9. ticket_tiers
5.
 ondelivery-user

1

 3

onapps-api.onindonesia.id

public
  1. agent_register
  2. user_waybills
  3. waybill_lottery
6.
 onagent

1

 4



public
  1. bank_infos
  2. customers
  3. user_infos
  4. user_logins
7.
 on_mitra

1

 3



public
  1. driver_balances
  2. driver_infos
  3. driver_logins
8.
 on_booking_log

2

14

apisat.ondelivery.id

1. master_location
  1. all_clusters
  2. all_locations
  3. location_cities
  4. location_countries
  5. location_provinces
  6. location_sub_districts

2. public
  1. agent_fcm_tokens
  2. bank_accounts
  3. booking_onapps
  4. id_trackers
  5. miss_pickup_reports
  6. msg_reports
  7. package_infos
  8. payment_receipts

demo

No. DB Total Schemas Total Tables Used by
1.
 demo_ondelivery_user
 1 3 demo-onapps-api.onindonesia.id
1. public
  1. agent_register
  2. user_waybills
  3. waybill_lottery
2.
 demo_gigas
 1 30 demo.gigas.id
1. public
  1. address_lists
  2. billings
  3. carts
  4. categories
  5. discussions
  6. expedition_methods
  7. expedition_settings
  8. favourite_product_lists
  9. followed_store_lists
  10. id_trackers
  11. invoice_records
  12. payout_records
  13. product_promotion_lists
  14. product_snapshoots
  15. product_statistics
  16. product_variants
  17. product_voucher_lists
  18. products
  19. promos
  20. reputation_ranges
  21. reviews
  22. snapshoot_lists
  23. store_front_lists
  24. store_fronts
  25. store_orders
  26. store_visit_statistics
  27. stores
  28. user_infos
  29. voucher_redemptions
  30. vouchers
3.
 demo_on_booking_log
 2 14 demoapisat.ondelivery.id
1. master_location
  1. all_clusters
  2. all_locations
  3. location_cities
  4. location_countries
  5. location_provinces
  6. location_sub_districts
2. public
  1. agent_fcm_tokens
  2. bank_accounts
  3. booking_onapps
  4. id_trackers
  5. miss_pickup_reports
  6. msg_reports
  7. package_infos
  8. payment_receipts
4.
 demo_sunshine
 4

47

 demosunshineapi.onindonesia.id
1. approval
  1. approval_keys
  2. approval_masters
  3. areas
  4. keyword_approvals
  5. notification_approvals
  6. template_jsons
2. cms
  1. ad_lists
  2. ads
  3. blog_lists
  4. blogs
  5. career
  6. departments
  7. dept_list
  8. drop_points
  9. training_views
  10. trainings
  11. vacancies
3. cta
  1. agent_inquiries
  2. business_inquiries
4. public
  1. access_menus
  2. agents
  3. asset_configurations
  4. asset_inventories
  5. asset_pictures
  6. asset_trackings
  7. asset_vendors
  8. attendances
  9. bank_infos
  10. center_locations
  11. company_lists
  12. emp_copys
  13. employee_shifts
  14. employees
  15. employement_status
  16. meeting_rooms
  17. placement_employees
  18. positions
  19. problem_types
  20. roles
  21. schedule_rooms
  22. shifts
  23. ticket_comments
  24. tickets
  25. users
  26. vendors
  27. voucher_configs
  28. vouchers
5.
 demo_userstate
 1 28 demousapi.onindonesia.id
1. public
  1. access_menus
  2. agents
  3. asset_configurations
  4. asset_inventories
  5. asset_pictures
  6. asset_trackings
  7. asset_vendors
  8. attendances
  9. bank_infos
  10. center_locations
  11. company_lists
  12. emp_copys
  13. employee_shifts
  14. employees
  15. employement_status
  16. meeting_rooms
  17. placement_employees
  18. positions
  19. problem_types
  20. roles
  21. schedule_rooms
  22. shifts
  23. ticket_comments
  24. tickets
  25. users
  26. vendors
  27. voucher_configs
  28. vouchers
6. ondelivery-agent-test 4

85

demoapi.ondelivery.id

testapi.ondelivery.id

testmpapi.ondelivery.id

demompapi.ondelivery.id


1. public
  1. access_menus
  2. action_logs
  3. agent_customers
  4. agent_locations
  5. all_location_revs
  6. all_locations
  7. all_services
  8. alter_weight_lists
  9. awb_books
  10. awb_lists
  11. awb_pickups
  12. bagging_list_completes
  13. bagging_lists
  14. bagging_member_completes
  15. bagging_members
  16. balance_mutations
  17. billing_vip_configs
  18. courier_partners
  19. coverage_area_services
  20. delivery_scans
  21. exclusion_lists
  22. handover_pcp_scans
  23. handover_scans
  24. image_lists
  25. indopaket_data_stores
  26. indopaket_temps
  27. info_lists
  28. login_sessions
  29. manifest_pcp_lists
  30. manifest_pos_lists
  31. packed_scans
  32. partners
  33. pcp_coverage_areas
  34. pcp_goods_types
  35. preset_locations
  36. problem_scans
  37. promos
  38. promos_clones
  39. receiving_scans
  40. receiving_scans_completes
  41. resi_3p_lists
  42. roles
  43. scans
  44. search_tracks
  45. service_lists
  46. service_new_lists
  47. services
  48. sheet_lists
  49. sla_monitors
  50. transaction
  51. trucking_configs
  52. trucking_shipments
  53. upc_lists
  54. used_bagging_numbers
  55. user_lists
  56. user_roles
  57. user_stats





2. eatsok
  1. courier_availability_lists
  2. courier_details
  3. image_lists
  4. schedule_lists
  5. schedule_members
  6. tracking_lists
3. price_lists
  1. BDO_coverages
  2. BDO_ondel_coverages
  3. CGK_coverages
  4. CGK_coverages_clone
  5. CGK_lc_coverages
  6. CGK_ondel_coverages
  7. CGK_pcp_coverages
  8. JOG_coverages
  9. JOG_ondel_coverages
  10. MLG_coverages
  11. MLG_ondel_coverages
  12. SRG_coverages
  13. SRG_ondel_coverages
  14. SUB_coverages
  15. SUB_ondel_coverages
  16. trucking_coverages
4. master_location
  1. all_clusters
  2. all_locations
  3. location_cities
  4. location_countries
  5. location_provinces
  6. location_sub_districts

2nd Server

103.84.192.98:54322

production

No. DB Total Schemas Total Tables Used by
1. onmarket 5

60

api.onmarket.id

adminapi.onmarket.id


1. admin
  1. access_menus
  2. inactive_users
  3. roles
  4. users




2. config_expedition
  1. coverage_areas
  2. expedition_lists
  3. expedition_methods
  4. expedition_settings
  5. services




3. master_location
  1. all_clusters
  2. all_locations
  3. location_cities
  4. location_countries
  5. location_provinces
  6. location_sub_districts




4. pricelist
  1. cargo_prices
  2. regular_prices




5. public
  1. address_lists
  2. balance_mutations
  3. bank_infos
  4. billings
  5. cancel_requests
  6. carts
  7. categories
  8. category_trees
  9. discussions
  10. expedition_methods
  11. expedition_settings
  12. favourite_product_lists
  13. followed_store_lists
  14. id_trackers
  15. invoice_items
  16. invoice_payments
  17. invoice_records
  18. invoice_shipping_infos
  19. invoice_xendits
  20. otp_trackers
  21. payout_records
  22. product_promotion_lists
  23. product_snapshots
  24. product_statistics
  25. product_variants
  26. product_voucher_lists
  27. products
  28. promos
  29. reputation_ranges
  30. reviews
  31. secret_keys
  32. shipping_datas
  33. snapshot_lists
  34. store_front_lists
  35. store_fronts
  36. store_orders
  37. store_visit_statistics
  38. stores
  39. tier_lists
  40. transaction_summaries
  41. user_infos
  42. voucher_redemptions
  43. vouchers


 

demo

No. DB Total Schemas Total Tables Used by
1. onmarket-test 5

60

testapi.onmarket.id

testadminapi.onmarket.id


1. admin
  1. access_menus
  2. inactive_users
  3. roles
  4. users




2. config_expedition
  1. coverage_areas
  2. expedition_lists
  3. expedition_methods
  4. expedition_settings
  5. services




3. master_location
  1. all_clusters
  2. all_locations
  3. location_cities
  4. location_countries
  5. location_provinces
  6. location_sub_districts




4. pricelist
  1. cargo_prices
  2. regular_prices




5. public
  1. address_lists
  2. balance_mutations
  3. bank_infos
  4. billings
  5. cancel_requests
  6. carts
  7. categories
  8. category_trees
  9. discussions
  10. expedition_methods
  11. expedition_settings
  12. favourite_product_lists
  13. followed_store_lists
  14. id_trackers
  15. invoice_items
  16. invoice_payments
  17. invoice_records
  18. invoice_shipping_infos
  19. invoice_xendits
  20. otp_trackers
  21. payout_records
  22. product_promotion_lists
  23. product_snapshots
  24. product_statistics
  25. product_variants
  26. product_voucher_lists
  27. products
  28. promos
  29. reputation_ranges
  30. reviews
  31. secret_keys
  32. shipping_datas
  33. snapshot_lists
  34. store_front_lists
  35. store_fronts
  36. store_orders
  37. store_visit_statistics
  38. stores
  39. tier_lists
  40. transaction_summaries
  41. user_infos
  42. voucher_redemptions
  43. vouchers

 
No Comments
Back to top