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 | 250 | Vendor code | ||||
vendor_id | NUMBER | 39 | 0 |
vendor_id |
Vendors |
Vendor ID |
PK Column Name |
---|
item_id |
vendor_id |
subsidiary_id |
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 |