...
| Info | ||
|---|---|---|
| ||
this module is in development and is not in production! |
Database
WorkFlow
Adding a customer
| Drawio | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
DB synchronization
- forward update: nmsprime –> nmsprime_ccc, via a ISP service user
- reverse update: nmsprime_ccc –> nmsprime, from customer via CCC
...
availability/product checking
address / product mapping
| Drawio | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
- zip
- city
- street
- house_number
Structure
| DB name | nmsprime_ccc | |
| DB user | nmsprime_ccc | |
| required tables | contract | |
| sepamandate | ||
| item | ||
KDG OTC Example
| View file | ||||
|---|---|---|---|---|
|
| View file | ||||
|---|---|---|---|---|
|