# Environments

# Frontends

### Website

<table border="1" id="bkmrk-environment-current-" style="border-collapse: collapse; width: 100%; height: 406.281px;"><colgroup><col style="width: 23.3622%;"></col><col style="width: 13.4734%;"></col><col style="width: 12.6082%;"></col><col style="width: 24.9691%;"></col><col style="width: 25.5871%;"></col></colgroup><tbody><tr style="height: 46.5938px;"><td style="height: 46.5938px;">**Environment**</td><td style="height: 46.5938px;">**Framework**</td><td style="height: 46.5938px;">**Current version**</td><td style="height: 46.5938px;">**Latest version**</td><td style="height: 46.5938px;">**Notes**</td></tr><tr style="height: 80.1719px;"><td style="height: 80.1719px;">OSAS

agent.ondelivery.id

</td><td rowspan="3" style="height: 195.734px;">Angular  
</td><td style="height: 80.1719px;">14</td><td rowspan="3" style="height: 195.734px;">17 (Active)  
16 (LTS until 2024-11-08)

15 (LTS until 2024-05-18)

</td><td style="height: 80.1719px;">Dialogue modals are not

working after upgrading to version 15

</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">ONMARKET

onmarket.id

</td><td style="height: 57.7812px;">12</td><td style="height: 57.7812px;"></td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">ONMARKET SELLER

seller.onmarket.id

</td><td style="height: 57.7812px;">11</td><td style="height: 57.7812px;"></td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">SUNSHINE

sunshine.onindonesia.id

</td><td style="height: 57.7812px;">  
</td><td style="height: 57.7812px;">12</td><td style="height: 57.7812px;"></td><td style="height: 57.7812px;">Framework cannot start after upgrading to version 13

</td></tr><tr style="height: 35.3906px;"><td style="height: 35.3906px;">ondelivery.id

</td><td style="height: 35.3906px;">  
</td><td style="height: 35.3906px;">11</td><td style="height: 35.3906px;"></td><td style="height: 35.3906px;"></td></tr><tr style="height: 35.3906px;"><td style="height: 35.3906px;">onindonesia.id

</td><td style="height: 35.3906px;">  
</td><td style="height: 35.3906px;">11</td><td style="height: 35.3906px;"></td><td style="height: 35.3906px;"></td></tr><tr style="height: 35.3906px;"><td style="height: 35.3906px;">Freelance marketing

</td><td style="height: 35.3906px;">  
</td><td style="height: 35.3906px;">16</td><td style="height: 35.3906px;"></td><td style="height: 35.3906px;">inactive

</td></tr></tbody></table>

# Backends

#### Production

<table border="1" id="bkmrk-environment-status-s" style="border-collapse: collapse; width: 100%; height: 758.562px;"><colgroup><col style="width: 24.9691%;"></col><col style="width: 10.136%;"></col><col style="width: 19.2831%;"></col><col style="width: 9.76514%;"></col><col style="width: 35.7231%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">**Environment**</td><td style="height: 29.7969px;">**Status**</td><td style="height: 29.7969px;">**Server**</td><td style="height: 29.7969px;">**Port**</td><td style="height: 29.7969px;">**Audit info**</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">OSAS

api.ondelivery.id

</td><td style="height: 57.7812px;">Active</td><td rowspan="12" style="height: 670.984px;">103.52.147.114  
</td><td style="height: 57.7812px;">4224</td><td style="height: 57.7812px;">0 vulnerability</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">OSAS Marketplace

mpapi.ondelivery.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">4250</td><td style="height: 57.7812px;">0 vulnerability</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">ONAPPS api

onapps-api.onindonesia.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">3400</td><td style="height: 57.7812px;">4 moderate vulnerabilities</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">onbooking

apisat.ondelivery.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">5000</td><td style="height: 57.7812px;">0 vulnerability</td></tr><tr style="height: 35.3906px;"><td style="height: 35.3906px;">PCP Express updater

</td><td style="height: 35.3906px;">Active</td><td style="height: 35.3906px;">4204</td><td style="height: 35.3906px;">4 moderate vulnerabilities</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">POS INDONESIA status updater

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">4205</td><td style="height: 57.7812px;">4 moderate vulnerabilities</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">POS INDONESIA minor status updater

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">4206</td><td style="height: 57.7812px;">6 moderate vulnerabilities

12 high vulnerabilities

</td></tr><tr style="height: 35.3906px;"><td style="height: 35.3906px;">sociolla status updater

</td><td style="height: 35.3906px;">Active</td><td style="height: 35.3906px;">4207</td><td style="height: 35.3906px;">0 vulnerability

</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">SUNSHINE api

sunshineapi.onindonesia.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">3600</td><td style="height: 57.7812px;">2 high vulnerabilities

2 critical vulnerabilities

</td></tr><tr style="height: 80.1719px;"><td style="height: 80.1719px;">Userstate api

usapi.onindonesia.id

</td><td style="height: 80.1719px;">Active</td><td style="height: 80.1719px;">3300</td><td style="height: 80.1719px;">7 moderate vulnerabilities

3 high vulnerabilities

3 critical vulnerabilities

</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">onpoint api

onpointapi.onindonesia.id

</td><td style="height: 57.7812px;">Inactive</td><td style="height: 57.7812px;">3500</td><td style="height: 57.7812px;"></td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">onticket api

onticket-api.onindonesia.id

</td><td style="height: 57.7812px;">Inactive</td><td style="height: 57.7812px;">3630</td><td style="height: 57.7812px;"></td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">ONMARKET api

api.onmarket.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">103.84.192.98</td><td style="height: 57.7812px;">3610</td><td style="height: 57.7812px;">1 moderate vulnerability

</td></tr></tbody></table>

---

#### Staging

<table border="1" id="bkmrk-environment-status-s-1" style="border-collapse: collapse; width: 100%; height: 712.75px;"><colgroup><col style="width: 24.9691%;"></col><col style="width: 10.136%;"></col><col style="width: 19.2831%;"></col><col style="width: 9.76514%;"></col><col style="width: 35.7231%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">**Environment**</td><td style="height: 29.7969px;">**Status**</td><td style="height: 29.7969px;">**Server**</td><td style="height: 29.7969px;">**Port**</td><td style="height: 29.7969px;">**Audit info**</td></tr><tr style="height: 11.9688px;"><td style="height: 11.9688px;">OSAS

stagingapi.ondelivery.id

</td><td style="height: 11.9688px;">Active</td><td style="height: 11.9688px;">103.52.147.114  
</td><td style="height: 11.9688px;">4222</td><td style="height: 11.9688px;">0 vulnerability</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">onbooking

stagingapisat.ondelivery.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">  
</td><td style="height: 57.7812px;">5002</td><td style="height: 57.7812px;">0 vulnerability</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">SUNSHINE api

stagingsunshineapi.onindonesia.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">  
</td><td style="height: 57.7812px;">3602</td><td style="height: 57.7812px;">2 high vulnerabilities

2 critical vulnerabilities

</td></tr><tr style="height: 80.1719px;"><td style="height: 80.1719px;">Userstate api

stagingusapi.onindonesia.id

</td><td style="height: 80.1719px;">Active</td><td style="height: 80.1719px;">  
</td><td style="height: 80.1719px;">3302</td><td style="height: 80.1719px;">7 moderate vulnerabilities

3 high vulnerabilities

3 critical vulnerabilities

</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">onticket api

stagingonticket-api.onindonesia.id

</td><td style="height: 57.7812px;">Inactive</td><td style="height: 57.7812px;">  
</td><td style="height: 57.7812px;">3632</td><td style="height: 57.7812px;"></td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">ONMARKET api

stagingapi.onmarket.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">103.84.192.98</td><td style="height: 57.7812px;">3612</td><td style="height: 57.7812px;">1 moderate vulnerability

</td></tr></tbody></table>

---

#### Demo

<table border="1" id="bkmrk-environment-status-s-2" style="border-collapse: collapse; width: 100%; height: 758.562px;"><colgroup><col style="width: 24.9691%;"></col><col style="width: 10.136%;"></col><col style="width: 19.2831%;"></col><col style="width: 9.76514%;"></col><col style="width: 35.7231%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">**Environment**</td><td style="height: 29.7969px;">**Status**</td><td style="height: 29.7969px;">**Server**</td><td style="height: 29.7969px;">**Port**</td><td style="height: 29.7969px;">**Audit info**</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">OSAS

demoapi.ondelivery.id

</td><td style="height: 57.7812px;">Active</td><td rowspan="6" style="height: 670.984px;">103.52.147.114  
</td><td style="height: 57.7812px;">4220</td><td style="height: 57.7812px;">0 vulnerability</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">OSAS Marketplace

demompapi.ondelivery.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">4252</td><td style="height: 57.7812px;">0 vulnerability</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">onbooking

demoapisat.ondelivery.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">5001</td><td style="height: 57.7812px;">0 vulnerability</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">SUNSHINE api

demosunshineapi.onindonesia.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">3601</td><td style="height: 57.7812px;">2 high vulnerabilities

2 critical vulnerabilities

</td></tr><tr style="height: 80.1719px;"><td style="height: 80.1719px;">Userstate api

demousapi.onindonesia.id

</td><td style="height: 80.1719px;">Active</td><td style="height: 80.1719px;">3301</td><td style="height: 80.1719px;">7 moderate vulnerabilities

3 high vulnerabilities

3 critical vulnerabilities

</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">onpoint api

demoonpointapi.onindonesia.id

</td><td style="height: 57.7812px;">Inactive</td><td style="height: 57.7812px;">3502</td><td style="height: 57.7812px;"></td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">ONMARKET api

demoapi.onmarket.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">103.84.192.98</td><td style="height: 57.7812px;">3611</td><td style="height: 57.7812px;">1 moderate vulnerability

</td></tr></tbody></table>

---

#### Test

<table border="1" id="bkmrk-environment-status-s-3" style="border-collapse: collapse; width: 100%; height: 758.562px;"><colgroup><col style="width: 24.9691%;"></col><col style="width: 10.136%;"></col><col style="width: 19.2831%;"></col><col style="width: 9.76514%;"></col><col style="width: 35.7231%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">**Environment**</td><td style="height: 29.7969px;">**Status**</td><td style="height: 29.7969px;">**Server**</td><td style="height: 29.7969px;">**Port**</td><td style="height: 29.7969px;">**Audit info**</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">OSAS

testapi.ondelivery.id

</td><td style="height: 57.7812px;">Active</td><td rowspan="3" style="height: 670.984px;">103.52.147.114  
</td><td style="height: 57.7812px;">4221</td><td style="height: 57.7812px;">0 vulnerability</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">OSAS Marketplace

testmpapi.ondelivery.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">4251</td><td style="height: 57.7812px;">0 vulnerability</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">onpoint api

testonpointapi.onindonesia.id

</td><td style="height: 57.7812px;">Inactive</td><td style="height: 57.7812px;">3502</td><td style="height: 57.7812px;"></td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">ONMARKET api

testapi.onmarket.id

</td><td style="height: 57.7812px;">Active</td><td style="height: 57.7812px;">103.84.192.98</td><td style="height: 57.7812px;">3610</td><td style="height: 57.7812px;">1 moderate vulnerability

</td></tr></tbody></table>

# Database

## 1st Server

### 103.52.147.114:5432

#### production

<table border="1" id="bkmrk-no.-db-total-schemas" style="border-collapse: collapse; width: 100%; height: 3458.27px;"><colgroup><col style="width: 5.06799%;"></col><col style="width: 15.6984%;"></col><col style="width: 17.3053%;"></col><col style="width: 30.9023%;"></col><col style="width: 31.026%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">No.</td><td style="height: 29.7969px;">DB</td><td style="height: 29.7969px;">Total Schemas</td><td style="height: 29.7969px;">Total Tables</td><td style="height: 29.7969px;">Used by</td></tr><tr style="height: 57.7812px;"><td rowspan="5" style="height: 1631.27px;">1.  
</td><td rowspan="5" style="height: 1631.27px;">ondelivery-agent

</td><td style="height: 57.7812px;">4

</td><td style="height: 57.7812px;">83

</td><td rowspan="5" style="height: 1631.27px;">api.ondelivery.id

stagingapi.ondelivery.id

mpapi.ondelivery.id

</td></tr><tr style="height: 137.219px;"><td style="height: 137.219px;">1\. eatsok

</td><td style="height: 137.219px;">1. courier\_availability\_lists
2. courier\_details
3. image\_lists
4. schedule\_lists
5. schedule\_members
6. tracking\_lists

</td></tr><tr style="height: 137.219px;"><td style="height: 137.219px;">2\. master\_location

</td><td style="height: 137.219px;">1. all\_clusters
2. all\_locations
3. location\_cities
4. location\_countries
5. locations\_provinces
6. location\_sub\_districts

</td></tr><tr style="height: 305.188px;"><td style="height: 305.188px;">3\. price\_lists

</td><td style="height: 305.188px;">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

</td></tr><tr style="height: 993.859px;"><td style="height: 993.859px;">4\. public

</td><td style="height: 993.859px;">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

</td></tr><tr style="height: 35.3906px;"><td rowspan="2" style="height: 306.985px;">2.  
</td><td rowspan="2" style="height: 306.985px;">userstate  
</td><td style="height: 35.3906px;">1

</td><td style="height: 35.3906px;">14

</td><td rowspan="2" style="height: 306.985px;">usapi.onindonesia.id

</td></tr><tr style="height: 271.594px;"><td style="height: 271.594px;">1\. public

</td><td style="height: 271.594px;">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

</td></tr><tr style="height: 35.3906px;"><td rowspan="5" style="height: 970.594px;">3.  
</td><td rowspan="5" style="height: 970.594px;">sunshine  
</td><td style="height: 35.3906px;">4

</td><td style="height: 35.3906px;">47

</td><td rowspan="5" style="height: 970.594px;">sunshine.onindonesia.id

</td></tr><tr style="height: 137.219px;"><td style="height: 137.219px;">1\. approval

</td><td style="height: 137.219px;">1. approval\_keys
2. approval\_masters
3. areas
4. keyword\_approvals
5. notification\_approvals
6. template\_jsons

</td></tr><tr style="height: 221.203px;"><td style="height: 221.203px;">2\. cms

</td><td style="height: 221.203px;">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

</td></tr><tr style="height: 70.0312px;"><td style="height: 70.0312px;">3\. cta

</td><td style="height: 70.0312px;">1. agent\_inquiries
2. business\_inquiries

</td></tr><tr style="height: 506.75px;"><td style="height: 506.75px;">4\. public

</td><td style="height: 506.75px;">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

</td></tr><tr style="height: 35.3906px;"><td rowspan="2" style="height: 223px;">4.  
</td><td rowspan="2" style="height: 223px;">onticket  
</td><td style="height: 35.3906px;">1

</td><td style="height: 35.3906px;">9</td><td rowspan="2" style="height: 223px;">onticket-api.onindonesia.id  
onticket-demoapi.onindonesia.id  
onticket-stagingapi.onindonesia.id

</td></tr><tr style="height: 187.609px;"><td style="height: 187.609px;">1\. public

</td><td style="height: 187.609px;">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

</td></tr><tr style="height: 35.3906px;"><td rowspan="2" style="height: 122.219px;">5.  
</td><td rowspan="2" style="height: 122.219px;">ondelivery-user  
</td><td style="height: 35.3906px;">1

</td><td style="height: 35.3906px;">3</td><td rowspan="2" style="height: 122.219px;">onapps-api.onindonesia.id

</td></tr><tr style="height: 86.8281px;"><td style="height: 86.8281px;">public

</td><td style="height: 86.8281px;">1. agent\_register
2. user\_waybills
3. waybill\_lottery

</td></tr><tr style="height: 35.3906px;"><td rowspan="2" style="height: 139.016px;">6.  
</td><td rowspan="2" style="height: 139.016px;">onagent  
</td><td style="height: 35.3906px;">1

</td><td style="height: 35.3906px;">4</td><td rowspan="2" style="height: 139.016px;"></td></tr><tr style="height: 103.625px;"><td style="height: 103.625px;">public

</td><td style="height: 103.625px;">1. bank\_infos
2. customers
3. user\_infos
4. user\_logins

</td></tr><tr style="height: 35.3906px;"><td rowspan="2" style="height: 35.3906px;">7.  
</td><td rowspan="2" style="height: 35.3906px;">on\_mitra  
</td><td style="height: 35.3906px;">1

</td><td style="height: 35.3906px;">3</td><td rowspan="2" style="height: 35.3906px;"></td></tr><tr><td>public

</td><td>1. driver\_balances
2. driver\_infos
3. driver\_logins

</td></tr><tr><td rowspan="3">8.  
</td><td rowspan="3">on\_booking\_log  
</td><td>2

</td><td>14

</td><td rowspan="3">apisat.ondelivery.id

</td></tr><tr><td>1\. master\_location

</td><td>1. all\_clusters
2. all\_locations
3. location\_cities
4. location\_countries
5. location\_provinces
6. location\_sub\_districts

</td></tr><tr><td>2\. public

</td><td>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

</td></tr></tbody></table>


#### demo

<table border="1" id="bkmrk-no.-db-total-schemas-1" style="border-collapse: collapse; width: 100%; height: 2675.3px;"><colgroup><col style="width: 5.06799%;"></col><col style="width: 20.5192%;"></col><col style="width: 15.4512%;"></col><col style="width: 30.5315%;"></col><col style="width: 28.4302%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">**No.**</td><td style="height: 29.7969px;">**DB**</td><td style="height: 29.7969px;">**Total Schemas**</td><td style="height: 29.7969px;">**Total Tables**</td><td style="height: 29.7969px;">**Used by**</td></tr><tr style="height: 29.7969px;"><td rowspan="2" style="height: 116.625px;">1.  
</td><td rowspan="2" style="height: 116.625px;">demo\_ondelivery\_user  
</td><td style="height: 29.7969px;">1</td><td style="height: 29.7969px;">3</td><td rowspan="2" style="height: 116.625px;">demo-onapps-api.onindonesia.id  
</td></tr><tr style="height: 86.8281px;"><td style="height: 86.8281px;">1. public</td><td style="height: 86.8281px;">1. agent\_register
2. user\_waybills
3. waybill\_lottery

</td></tr><tr style="height: 29.7969px;"><td rowspan="2" style="height: 603.735px;">2.  
</td><td rowspan="2" style="height: 603.735px;">demo\_gigas  
</td><td style="height: 29.7969px;">1</td><td style="height: 29.7969px;">30</td><td rowspan="2" style="height: 603.735px;">demo.gigas.id  
</td></tr><tr style="height: 573.938px;"><td style="height: 573.938px;">1. public</td><td style="height: 573.938px;">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

</td></tr><tr style="height: 29.7969px;"><td rowspan="3" style="height: 337.828px;">3.  
</td><td rowspan="3" style="height: 337.828px;">demo\_on\_booking\_log  
</td><td style="height: 29.7969px;">2</td><td style="height: 29.7969px;">14</td><td rowspan="3" style="height: 337.828px;">demoapisat.ondelivery.id  
</td></tr><tr style="height: 137.219px;"><td style="height: 137.219px;">1. master\_location</td><td style="height: 137.219px;">1. all\_clusters
2. all\_locations
3. location\_cities
4. location\_countries
5. location\_provinces
6. location\_sub\_districts

</td></tr><tr style="height: 170.812px;"><td style="height: 170.812px;">2. public</td><td style="height: 170.812px;">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

</td></tr><tr style="height: 35.3906px;"><td rowspan="5" style="height: 970.594px;">4.  
</td><td rowspan="5" style="height: 970.594px;">demo\_sunshine  
</td><td style="height: 35.3906px;">4</td><td style="height: 35.3906px;">47

</td><td rowspan="5" style="height: 970.594px;">demosunshineapi.onindonesia.id  
</td></tr><tr style="height: 137.219px;"><td style="height: 137.219px;">1. approval</td><td style="height: 137.219px;">1. approval\_keys
2. approval\_masters
3. areas
4. keyword\_approvals
5. notification\_approvals
6. template\_jsons

</td></tr><tr style="height: 221.203px;"><td style="height: 221.203px;">2. cms</td><td style="height: 221.203px;">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

</td></tr><tr style="height: 70.0312px;"><td style="height: 70.0312px;">3. cta</td><td style="height: 70.0312px;">1. agent\_inquiries
2. business\_inquiries

</td></tr><tr style="height: 506.75px;"><td style="height: 506.75px;">4. public</td><td style="height: 506.75px;">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

</td></tr><tr style="height: 29.7969px;"><td rowspan="2" style="height: 536.547px;">5.  
</td><td rowspan="2" style="height: 536.547px;">demo\_userstate  
</td><td style="height: 29.7969px;">1</td><td style="height: 29.7969px;">28</td><td rowspan="2" style="height: 536.547px;">demousapi.onindonesia.id  
</td></tr><tr style="height: 506.75px;"><td style="height: 506.75px;">1. public</td><td style="height: 506.75px;">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

</td></tr><tr style="height: 80.1719px;"><td style="height: 80.1719px;">6.</td><td style="height: 80.1719px;">ondelivery-agent-test</td><td style="height: 80.1719px;">4</td><td style="height: 80.1719px;">85

</td><td style="height: 80.1719px;">demoapi.ondelivery.id

testapi.ondelivery.id

testmpapi.ondelivery.id

demompapi.ondelivery.id

</td></tr><tr><td rowspan="4">  
</td><td rowspan="4">  
</td><td>1. public</td><td>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

</td><td rowspan="4"></td></tr><tr><td>2. eatsok</td><td>1. courier\_availability\_lists
2. courier\_details
3. image\_lists
4. schedule\_lists
5. schedule\_members
6. tracking\_lists

</td></tr><tr><td>3. price\_lists</td><td>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

</td></tr><tr><td>4. master\_location</td><td>1. all\_clusters
2. all\_locations
3. location\_cities
4. location\_countries
5. location\_provinces
6. location\_sub\_districts

</td></tr></tbody></table>

## 2nd Server

### 103.84.192.98:54322

#### production

<table border="1" id="bkmrk-no.-db-total-schemas-2" style="border-collapse: collapse; width: 100%; height: 347.016px;"><colgroup><col style="width: 7.16934%;"></col><col style="width: 20.3956%;"></col><col style="width: 20.1483%;"></col><col style="width: 29.9135%;"></col><col style="width: 22.4969%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">**No.**</td><td style="height: 29.7969px;">**DB**</td><td style="height: 29.7969px;">**Total Schemas**</td><td style="height: 29.7969px;">**Total Tables**</td><td style="height: 29.7969px;">**Used by**</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">1.</td><td style="height: 57.7812px;">onmarket</td><td style="height: 57.7812px;">5</td><td style="height: 57.7812px;">60

</td><td style="height: 57.7812px;">api.onmarket.id

adminapi.onmarket.id

</td></tr><tr style="height: 103.625px;"><td style="height: 103.625px;">  
</td><td style="height: 103.625px;">  
</td><td style="height: 103.625px;">1\. admin

</td><td style="height: 103.625px;">1. access\_menus
2. inactive\_users
3. roles
4. users

</td><td style="height: 103.625px;"></td></tr><tr style="height: 120.422px;"><td style="height: 120.422px;">  
</td><td style="height: 120.422px;">  
</td><td style="height: 120.422px;">2\. config\_expedition

</td><td style="height: 120.422px;">1. coverage\_areas
2. expedition\_lists
3. expedition\_methods
4. expedition\_settings
5. services

</td><td style="height: 120.422px;"></td></tr><tr style="height: 35.3906px;"><td style="height: 35.3906px;">  
</td><td style="height: 35.3906px;">  
</td><td style="height: 35.3906px;">3\. master\_location

</td><td style="height: 35.3906px;">1. all\_clusters
2. all\_locations
3. location\_cities
4. location\_countries
5. location\_provinces
6. location\_sub\_districts

</td><td style="height: 35.3906px;"></td></tr><tr><td>  
</td><td>  
</td><td>4\. pricelist

</td><td>1. cargo\_prices
2. regular\_prices

</td><td></td></tr><tr><td>  
</td><td>  
</td><td>5\. public

</td><td>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

</td><td></td></tr></tbody></table>

#### demo

<table border="1" id="bkmrk-no.-db-total-schemas-3" style="border-collapse: collapse; width: 100%; height: 347.016px;"><colgroup><col style="width: 7.16934%;"></col><col style="width: 20.3956%;"></col><col style="width: 20.1483%;"></col><col style="width: 29.9135%;"></col><col style="width: 22.4969%;"></col></colgroup><tbody><tr style="height: 29.7969px;"><td style="height: 29.7969px;">**No.**</td><td style="height: 29.7969px;">**DB**</td><td style="height: 29.7969px;">**Total Schemas**</td><td style="height: 29.7969px;">**Total Tables**</td><td style="height: 29.7969px;">**Used by**</td></tr><tr style="height: 57.7812px;"><td style="height: 57.7812px;">1.</td><td style="height: 57.7812px;">onmarket-test</td><td style="height: 57.7812px;">5</td><td style="height: 57.7812px;">60

</td><td style="height: 57.7812px;">testapi.onmarket.id

testadminapi.onmarket.id

</td></tr><tr style="height: 103.625px;"><td style="height: 103.625px;">  
</td><td style="height: 103.625px;">  
</td><td style="height: 103.625px;">1\. admin

</td><td style="height: 103.625px;">1. access\_menus
2. inactive\_users
3. roles
4. users

</td><td style="height: 103.625px;"></td></tr><tr style="height: 120.422px;"><td style="height: 120.422px;">  
</td><td style="height: 120.422px;">  
</td><td style="height: 120.422px;">2\. config\_expedition

</td><td style="height: 120.422px;">1. coverage\_areas
2. expedition\_lists
3. expedition\_methods
4. expedition\_settings
5. services

</td><td style="height: 120.422px;"></td></tr><tr style="height: 35.3906px;"><td style="height: 35.3906px;">  
</td><td style="height: 35.3906px;">  
</td><td style="height: 35.3906px;">3\. master\_location

</td><td style="height: 35.3906px;">1. all\_clusters
2. all\_locations
3. location\_cities
4. location\_countries
5. location\_provinces
6. location\_sub\_districts

</td><td style="height: 35.3906px;"></td></tr><tr><td>  
</td><td>  
</td><td>4\. pricelist

</td><td>1. cargo\_prices
2. regular\_prices

</td><td></td></tr><tr><td>  
</td><td>  
</td><td>5\. public

</td><td>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

</td><td></td></tr></tbody></table>