Billing_rate_cards_versions

Columns

Name Type Length Precision Scale References In Description
billing_rate_card_id NUMBER 39 0 Billing rate card ID
date_created TIMESTAMP Date created
date_effective TIMESTAMP Date effective
date_last_modified TIMESTAMP Date last modified
last_modified_by_id NUMBER 39 0 employee_id
Employees
Last modified by ID
version_0 NUMBER 39 0 Version 0

Primary key (Composite)

PK Column Name
billing_rate_card_id
version_0

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
billing_rate_cards_versions_employees_fk last_modified_by_id Employees employee_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Billing_rate_cards_prices_billing_rate_cards_versions_fk billing_rate_card_id Billing_rate_cards_prices billing_rate_card_id 1
Billing_rate_cards_prices_billing_rate_cards_versions_fk version_0 Billing_rate_cards_prices version_0 2