Expense_categories_subs_map

Columns

Name Type Length Precision Scale References In Description
expense_category_id NUMBER 39 0 expense_category_id
Expense_categories
Expense category ID
subsidiary_id NUMBER 39 0 subsidiary_id
Subsidiaries
Subsidiary ID

Primary key (Composite)

PK Column Name
subsidiary_id
expense_category_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
expense_categories_subs_map_expense_categories_fk expense_category_id Expense_categories expense_category_id 1
expense_categories_subs_map_subsidiaries_fk subsidiary_id Subsidiaries subsidiary_id 1