> ## Documentation Index
> Fetch the complete documentation index at: https://developers.stellar.org/llms.txt
> Use this file to discover all available pages before exploring further.

# Trustlines

> Reference documentation for the Trustlines table in Hubble's Bronze data dictionary.

## Table Metadata

| Property | Configuration |
| - | - |
| Natural Key(s) | account\_id, asset\_type, asset\_issuer, asset\_code, liquidity\_pool\_id, closed\_at |
| Partition Field(s) | batch\_run\_date (MONTH partition) |
| Clustered Field(s) | account\_id, asset\_id, liquidity\_pool\_id, last\_modified\_ledger |
| Documentation | [dbt docs](http://www.stellar-dbt-docs.com/#!/source/source.stellar_dbt_public.crypto_stellar.trust_lines) |

## Column Details

| Name | Description | Data Type | Domain Values | Required? | Notes |
| - | - | - | - | - | - |
| ledger\_key | The unique ledger key when the trust line state last changed | string | | Yes | |
| account\_id | The account address | string | | Yes | |
| asset\_type | The identifier for type of asset code held by the trustline: an alphanumeric code of 4 or 12 characters, or a liquidity pool share. | string | <ul><li>credit\_alphanum4</li><li>credit\_alphanum12</li><li>pool\_share</li></ul> | Yes | Trustlines never report `native`. XLM is held directly on the account and is reported in the `accounts` table, not here. `pool_share` identifies a trustline holding shares in a liquidity pool. |
| asset\_issuer | The account address of the original asset issuer that created the asset held by this account | string | | No | |
| asset\_code | The 4 or 12 character code representation of the asset held by this account | string | | No | |
| liquidity\_pool\_id | If the asset held is part of a liquidity pool share, the unique pool id from which the asset balance originates | string | | No | |
| balance | The number of units of an asset held by this account | float | | Yes | |
| trust\_line\_limit | The maximum amount of this asset that this account is willing to accept. The limit is specified when opening a trust line | integer | | Yes | |
| buying\_liabilities | The sum of all buy offers owned by this account for non-native assets | float | | Yes | |
| selling\_liabilities | The sum of all sell offers owned by this account for non-native assets | float | | Yes | |
| flags | Denotes the enabling and disabling of certain asset issuer privileges | integer | <ul><li>0 - None, Default</li><li>1 - Authorized</li><li>2 - Authorized to Maintain Liabilities</li><li>4 - Clawback Enabled</li></ul> | Yes | Flags are set on the issuer accounts for an asset. When user accounts trust an asset, the flags applied to the asset originate from this account |
| last\_modified\_ledger | The ledger sequence number when the ledger entry (this unique signer for the account) was modified | integer | | Yes | |
| ledger\_entry\_change | Code that describes the ledger entry change type that was applied to the ledger entry | integer | <ul><li>0 - Ledger Entry Created</li><li>1 - Ledger Entry Updated</li><li>2 - Ledger Entry Deleted</li><li>3 - Ledger Entry State</li></ul> | Yes | Valid entry change types are 0, 1, and 2 for ledger entries of type `trust_lines`. |
| deleted | Indicates whether the ledger entry (trust line) has been deleted or not. Once an entry is deleted, it cannot be recovered | boolean | | Yes | |
| closed\_at | Timestamp in UTC when this ledger closed and committed to the network. Ledgers are expected to close \~every 5 seconds | timestamp | | Yes | |
| ledger\_sequence | The sequence number of this ledger. It represents the order of the ledger within the Stellar blockchain. Each ledger has a unique sequence number that increments with every new ledger, ensuring that ledgers are processed in the correct order. | integer | | Yes | |
| batch\_id | String representation of the run id for a given DAG in Airflow | string | | Yes | |
| batch\_run\_date | The start date for the batch interval. When taken with the date in the batch\_id, the date represents the interval of ledgers processed | datetime | | Yes | The table is partitioned on batch\_run\_date. It is recommended to always include the batch\_run\_date in the filter if possible to help reduce query cost. |
| batch\_insert\_ts | The timestamp in UTC when a batch of records was inserted into the database | timestamp | | Yes | |
| sponsor | The account address that is sponsoring the base reserves for the trust line | string | | No | |
| asset\_id | Unique identifier for asset\_code, asset\_issuer | integer | | No | |
| liquidity\_pool\_id\_strkey | The StrKey (`L...`) representation of the liquidity pool id. | string | | No | Same pool as `liquidity_pool_id`, StrKey-encoded rather than hex. StrKey encoding is defined by [SEP-23](https://github.com/stellar/stellar-protocol/blob/master/ecosystem/sep-0023.md). |