stock_items_to_contracts_v1
The stock_items_to_contracts mart is a relational table that establishes a many-to-many relationship between stock items and contracts. It serves as a bridge table to associate stock items with the contracts in which they are included. This mart allows for a stock item to be associated with multiple contracts, and a contract to include multiple stock items.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the stock item to contract relation record. |
| _stock_item_id | NUMBER(38,0) | The identifier of the stock item. This column references the stock_items table, linking each record to a specific stock item. |
| _contract_id | NUMBER(38,0) | The identifier of the contract. This column references the contracts table, linking each record to a specific contract. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the stock item to contract record was last refreshed. |