Item_vendor_map

Columns

Name Type Length Precision Scale References In Description
is_preferred VARCHAR2 3 Whether is preferred
item_id NUMBER 39 0 item_id
Items
Item ID
subsidiary_id NUMBER 39 0 subsidiary_id
Subsidiaries
Subsidiary ID
vendor_code VARCHAR2 60 Vendor code
vendor_id NUMBER 39 0 vendor_id
Vendors
Vendor ID

Primary key (Composite)

PK Column Name
item_id
vendor_id
subsidiary_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
item_vendor_map_items_fk item_id Items item_id 1
item_vendor_map_subsidiaries_fk subsidiary_id Subsidiaries subsidiary_id 1
item_vendor_map_vendors_fk vendor_id Vendors vendor_id 1