SUBSCRIPTION_CAMPAIGN
- Søren Duusgaard (Deactivated)
- Former user (Deleted)
Owned by Søren Duusgaard (Deactivated)
Groups
SUBSCRIPTION_CAMPAIGN
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Â | Primary key |
| 2 | SUBSCRIPTION_ID | NUMBER | 22 | Y | Â | Reference to SUBSCRIPTION |
| 3 | CAMPAIGN_ID | NUMBER | 22 | Y | Â | Reference to CAMPAIGN |
| 4 | STATUS_ID | NUMBER | 22 | Y | Â | Â |
| 5 | FROM_DATE | DATE | 7 | Y | Â | Â |
| 6 | TO_DATE | DATE | 7 | Y | Â | Â |
| 7 | FEE_ID | NUMBER | 22 | Y | Â | Â |
| 8 | OBJECT_ID | NUMBER | 22 | Y | Â | Â |
| 9 | OBJECT_CODE | VARCHAR2 | 20 | Y | Â | Â |
| 10 | PARAMETER_STRING | VARCHAR2 | 4000 | Y | Â | Â |
| 11 | AUTO_EXTEND | VARCHAR2 | 4 | Y | Â | Â |
| 12 | EXPIRED_ON_DATE | DATE | 7 | Y | Â | Â |
Contains information about which subscription a campaign subscribes to at a given time