Groups
PRODUCT_OPTION
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | NAME | VARCHAR2 | 256 | Y | ||
| 3 | DESCRIPTION | VARCHAR2 | 256 | Y | ||
| 4 | LABEL | VARCHAR2 | 256 | Y | ||
| 5 | PARENT_ID | NUMBER | 22 | Y | Reference to PRODUCT_OPTION (parent) | |
| 6 | SUB_OPTIONS_EXCLUSIVE | CHAR | 1 | Y | ||
| 7 | CODE | VARCHAR2 | 20 | Y | ||
| 8 | TAG | VARCHAR2 | 20 | Y | ||
| 9 | HANDLER_TAG | VARCHAR2 | 20 | Y | ||
| 10 | PROVISIONING_TAG | VARCHAR2 | 25 | Y | ||
| 11 | PRICE_CODE | VARCHAR2 | 40 | Y | ||
| 12 | OPTION_KEY | VARCHAR2 | 50 | Y | ||
| 13 | WEB_DESCRIPTION | VARCHAR2 | 4000 | Y | ||
| 14 | HAS_LICENSE_AGREEMENT | CHAR | 1 | Y | ||
| 15 | LICENSE_AGREEMENT | VARCHAR2 | 4000 | Y | ||
| 16 | ON_SELECT_METHOD | VARCHAR2 | 100 | Y | ||
| 17 | COMPLETE_IT_METHOD | VARCHAR2 | 100 | Y | ||
| 18 | ON_UNSUBSCRIBE_METHOD | VARCHAR2 | 100 | Y | ||
| 19 | DEFAULT_SUBSCRIBE_STATUS_ID | NUMBER | 22 | Y | ||
| 20 | DEFAULT_UNSUBSCRIBE_STATUS_ID | NUMBER | 22 | Y | ||
| 21 | TYPE_ID | NUMBER | 22 | Y | ||
| 22 | CATEGORY | VARCHAR2 | 30 | Y | ||
| 23 | PRODUCT_OPTION_CATEGORY_ID | NUMBER | 22 | Y | Reference to PRODUCT_OPTION_CATEGORY | |
| 24 | SUB_LOCKIN_TYPE_ID | NUMBER | 22 | Y | Reference to SUBSCRIPTION_LOCKIN_TYPE | |
| 25 | CAMPAIGN_ID | NUMBER | 22 | Y | Reference to CAMPAIGN | |
| 26 | CAN_MODIFY_METHOD | VARCHAR2 | 100 | Y | ||
| 27 | IS_EXCLUSIVE | CHAR | 4 | Y | ||
| 28 | GROUP_NAME | VARCHAR2 | 400 | Y |