Saltar al contenido principal

Account Signers

Table Metadata​

PropertyConfiguration
Natural Key(s)account_id, signer, closed_at
Partition Field(s)batch_run_date (MONTH partition)
Clustered Field(s)account_id, signer, last_modified_ledger
Documentationdbt docs

Column Details​

NameDescriptionData TypeDomain ValuesRequired?Notes
account_idThe unique identifier of the account.stringYes
signerThe address of the account that is allowed to authorize (sign) transactions for another account. This process is called multi-sig.stringYes
weightThe numeric weight of the signer. All weights on a transaction are added up and used to determine if a transaction meets the threshold requirements to complete the transaction.floatYes
sponsorThe account address of the sponsor who is paying the reserves for this ledger entry.stringNo
last_modified_ledgerThe ledger sequence number when the ledger entry (this unique signer for the account) was modified. Deletions do not count as a modification and will report the prior modification sequence numberintegerYes
ledger_entry_changeCode that describes the ledger entry change type that was applied to the ledger entry.integerYes
deletedIndicates whether the ledger entry (balance id) has been deleted or not. Once an entry is deleted, it cannot be recovered.booleanYes
batch_idString representation of the run id for a given DAG in Airflow. Takes the form of "scheduled__<batch_end_date>-<dag_alias>". Batch ids are unique to the batch and help with monitoring and rerun capabilitiesstringYes
batch_run_dateThe start date for the batch interval. When taken with the date in the batch_id, the date represents the interval of ledgers processed. The batch run date can be seen as a proxy of closed_at for a ledger.datetimeYes
batch_insert_tsThe timestamp in UTC when a batch of records was inserted into the database. This field can help identify if a batch executed in real time or as part of a backfilltimestampYes
closed_atTimestamp in UTC when this ledger closed and committed to the network. Ledgers are expected to close ~every 5 secondstimestampYes
ledger_sequenceThe 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.integerYes