Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. |
| log_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. |
| event_type | VARCHAR(16777216) | Type of session event (e.g. open, settle, refund). |
| channel_id | VARCHAR(16777216) | Identifier of the payment channel. |
| payer_address | VARCHAR(42) | Address funding the payment channel. |
| payee_address | VARCHAR(42) | Address of the service being paid through the channel. |
| deposit_amount | FLOAT | Amount deposited into the channel. |
| settled_to_service_amount | FLOAT | Amount settled to the service on channel close. |
| refunded_to_payer_amount | FLOAT | Amount refunded to the payer on channel close. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |