Subsidiary_department_map

Columns

Name	Type	Length	Precision	Scale	References	In	Description
department_id	NUMBER		39	0	department_id	Departments	Department ID
subsidiary_id	NUMBER		39	0	subsidiary_id	Subsidiaries	Subsidiary ID

Primary key (Composite)

PK Column Name
subsidiary_id
department_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
subsidiary_department_map_departments_fk	department_id	Departments	department_id	1
subsidiary_department_map_subsidiaries_fk	subsidiary_id	Subsidiaries	subsidiary_id	1