PostgreSQL / Oracle
Database Schema
Full table definitions extracted from the IM system ER diagram
💡
Schema based on ER diagram
These tables were extracted from the DrawSQL diagram provided. All field types are varchar unless otherwise noted. The diagram shows the primary keys, relations, and module groupings.
Entity Relationship Overview
IM System Entity Relationship Diagram — DrawSQL
Tables
Click a table above to see its columns and relationships
Module Groupings
Customer & Service
Core subscriber data — who has what service, and what hardware they have.
Work Orders
Inbound orders from OM. IM_TASK_FORM stores the raw SOAP payload fields.
Geography & Network
Spatial and network topology data. Defines which exchange/OLT serves which zone.
Resources
Physical and logical resource inventory. SERVICE_RESOURCE links services to consumed resources.
Audit & Logging
All data changes and login events are recorded here for audit purposes.