| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| advance_renewal_period_number | VARCHAR2 | 11 | |||||
| advance_renewal_period_unit_id | VARCHAR2 | 10 | |||||
| class_id | NUMBER | 39 | 0 |
class_id |
Classes |
||
| date_created | TIMESTAMP | ||||||
| date_last_modified | TIMESTAMP | ||||||
| default_renewal_method_id | VARCHAR2 | 30 | |||||
| default_renewal_plan_id | NUMBER | 39 | 0 |
plan_id |
Subscription_plans |
||
| default_renewal_term_id | NUMBER | 39 | 0 |
term_id |
Subscription_terms |
||
| default_renewal_trantype_id | VARCHAR2 | 8 | |||||
| department_id | NUMBER | 39 | 0 |
department_id |
Departments |
||
| description | VARCHAR2 | 4000 | |||||
| display_name | VARCHAR2 | 4000 | |||||
| income_account_id | NUMBER | 39 | 0 |
income_account_id |
Income_accounts |
||
| initial_term_id | NUMBER | 39 | 0 |
term_id |
Subscription_terms |
||
| is_auto_renewal | VARCHAR2 | 3 | |||||
| is_inactive | VARCHAR2 | 3 | |||||
| is_include_children | VARCHAR2 | 3 | |||||
| location_id | NUMBER | 39 | 0 |
location_id |
Locations |
||
| name | VARCHAR2 | 180 | |||||
| plan_extid | VARCHAR2 | 255 | |||||
| plan_id | NUMBER | 39 | 0 | ||||
| subsidiary_id | NUMBER | 39 | 0 |
subsidiary_id |
Subsidiaries |
| PK Column Name |
|---|
| plan_id |
| FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
|---|---|---|---|---|
| subscription_plans_classes_fk | class_id | Classes | class_id | 1 |
| subscription_plans_departments_fk | department_id | Departments | department_id | 1 |
| subscription_plans_income_accounts_fk | income_account_id | Income_accounts | income_account_id | 1 |
| subscription_plans_locations_fk | location_id | Locations | location_id | 1 |
| subscription_plans_subscription_plans_fk | default_renewal_plan_id | Subscription_plans | plan_id | 1 |
| subscription_plans_subscription_terms_fk | initial_term_id | Subscription_terms | term_id | 1 |
| subscription_plans_subscription_terms_fk_2 | default_renewal_term_id | Subscription_terms | term_id | 1 |
| subscription_plans_subsidiaries_fk | subsidiary_id | Subsidiaries | subsidiary_id | 1 |
| FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
|---|---|---|---|---|
| Billing_subscriptions_subscription_plans_fk | plan_id | Billing_subscriptions | default_renewal_plan_id | 1 |
| Billing_subscriptions_subscription_plans_fk_2 | plan_id | Billing_subscriptions | plan_id | 1 |
| Price_books_subscription_plans_fk | plan_id | Price_books | plan_id | 1 |
| Subscription_change_orders_subscription_plans_fk | plan_id | Subscription_change_orders | renewal_subscription_plan_id | 1 |
| Subscription_plan_lines_subscription_plans_fk | plan_id | Subscription_plan_lines | parent_id | 1 |
| Subscription_plans_subscription_plans_fk | plan_id | Subscription_plans | default_renewal_plan_id | 1 |