Customer_subsidiary_map

Customer Subsidiary Map

Columns

Name Type Length Precision Scale References In Description
customer_id NUMBER 39 0 customer_id
Customers
Customer ID
subsidiary_id NUMBER 39 0 subsidiary_id
Subsidiaries
Subsidiary ID

Primary key (Composite)

PK Column Name
customer_id
subsidiary_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
customer_subsidiary_map_customers_fk customer_id Customers customer_id 1
customer_subsidiary_map_subsidiaries_fk subsidiary_id Subsidiaries subsidiary_id 1