Revenue_plan_versions

Columns

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

Primary key

PK Column Name
plan_version_id

Foreign keys in this table

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

Foreign keys referencing this table

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