| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments | 1 |
|---|
ID | NUMBER | 22 | N | | Primary key2 |
SERVICE_ID | NUMBER | 22 | Y | | Reference to SERVICE (main relation)3 |
START_DATE | DATE | 7 | Y | | 4 |
END_DATE | DATE | 7 | Y | | 5 |
STATUS_ID | NUMBER | 22 | Y | | 6 |
PRODUCT_OPTION_ID | NUMBER | 22 | Y | | Reference to PRODUCT_OPTION |
| 7 | LAST_CHANGED_BY | VARCHAR2 | 40 | Y | | 8 |
RECURRENT_FEE_ID | NUMBER | 22 | Y | | Reference to SUBSCRIPTION_FEES9 |
NETWORK_STATUS_ID | VARCHAR2 | 50 | Y | | 10 |
SUBSCRIPTION_CAMPAIGN_ID | NUMBER | 22 | Y | | Reference to SUBSCRIPTION_CAMPAIGN |
| 11 | PROVISIONING_TASK_ID | NUMBER | 22 | Y | | Reference to PROVISIONING_TASK12 |
OBJECT_ID | NUMBER | 22 | Y | | Not used in application |
| 13 | CODE | VARCHAR2 | 50 | Y | | 14 |
SOURCE_OBJECT_ID | NUMBER | 22 | Y | | Reference to SERVICE (for now - available for extension to other tables) |