Transaction_shipping_groups

Columns

Name Type Length Precision Scale References In Description
handling_line_id NUMBER 39 0 Handling line ID
shipping_group_id NUMBER 39 0 Shipping group ID
shipping_item_id NUMBER 39 0 Shipping item ID
shipping_line_id NUMBER 39 0 Shipping line ID
transaction_address_id NUMBER 39 0 Transaction address ID
transaction_id NUMBER 39 0 transaction_id
Transactions
Transaction ID

Primary key (Composite)

PK Column Name
transaction_id
shipping_group_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
transaction_shipping_groups_transactions_fk transaction_id Transactions transaction_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Transaction_lines_transaction_shipping_groups_fk transaction_id Transaction_lines transaction_id 1
Transaction_lines_transaction_shipping_groups_fk shipping_group_id Transaction_lines shipping_group_id 2