Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
created_by_id | NUMBER | 39 | 0 |
employee_id |
Employees |
||
date_created | TIMESTAMP | ||||||
plan_id | NUMBER | 39 | 0 |
plan_id |
Revenue_plans |
||
plan_version | NUMBER | 39 | 0 | ||||
plan_version_id | NUMBER | 39 | 0 |
PK Column Name |
---|
plan_version_id |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
revenue_plan_versions_employees_fk | created_by_id | Employees | employee_id | 1 |
revenue_plan_versions_revenue_plans_fk | plan_id | Revenue_plans | plan_id | 1 |
FK Name | PK Column Name | FK Table Name | FK Column Name | Key Seq |
---|---|---|---|---|
Revenue_plan_version_lines_revenue_plan_versions_fk | plan_version_id | Revenue_plan_version_lines | plan_version_id | 1 |