Groups
SERVICE_OPTION
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | 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_FEES | |
| 9 | 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_TASK | |
| 12 | 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) |