Skip to main content

Database

1st Server

103.52.147.114

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


demo usapi demo_userstate 103.52.147.114
demo onbooking demo_on_booking_log 103.52.147.114
test osas ondelivery-agent-test 103.52.147.114
test osas mp ondelivery-agent-test 103.52.147.114
demo sunshine demo_sunshine 103.52.147.114
  on_mitra 103.52.147.114
demo onapps api demo-ondelivery-user 103.52.147.114
demo osas ondelivery-agent-test 103.52.147.114
demo osas mp ondelivery-agent-test 103.52.147.114
demo onticket onticket 103.52.147.114
  master_location 103.52.147.114
test onpoint demo_userstate 103.52.147.114
demo onpoint demo_userstate 103.52.147.114