| slot_number | NUMBER(38,0) | Beacon Chain slot number of when the pending deposit state was indexed |
| slot_timestamp | TIMESTAMP_NTZ(9) | Beacon Chain slot timestamp of slot when the pending deposit state was indexed |
| epoch_number | NUMBER(38,0) | Epoch number of when the pending deposit state was indexed |
| pubkey | VARCHAR(16777216) | The validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive. |
| amount | VARCHAR(16777216) | The amount of ETH deposited in gwei (1e9 gwei = 1 ETH on Beacon Chain). |
| withdrawal_credentials | VARCHAR(16777216) | Withdrawal credentials is a 32-byte field associated with every validator, initially set during deposit, for verifying the destination of valid withdrawals. |
| signature | VARCHAR(16777216) | The BLS signature that aggregates the signatures of individual validators. |
| execution_optimistic | BOOLEAN | It’s true if the response references an unverified execution payload. The optimistic information may be invalidated at a later time. If the field is not present, assume the false value |
| finalized | BOOLEAN | Indicates whether the response data is finalized |
| pending_deposit_index | NUMBER(38,0) | Array index of the pending deposit for the given epoch. |
| slot | NUMBER(38,0) | The slot number where the deposit is made into beacon chain. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the pending deposit data creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the pending deposit data update. |