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

# L1 Mapping

> Lighter account-to-wallet address mapping.

The `lighter_robinhood.raw.l1_mapping` table contains lighter account-to-wallet address mapping.

## Table Columns

**Unique key:** `l1_address`, `account_id`

| Column Name   | Data Type          | Description                                     |
| ------------- | ------------------ | ----------------------------------------------- |
| `l1_address`  | `VARCHAR`          | EVM wallet address associated with the account. |
| `account_id`  | `NUMBER(38,0)`     | Lighter internal account identifier.            |
| `_created_at` | `TIMESTAMP_NTZ(9)` | Timestamp when the row was first recorded.      |
| `_updated_at` | `TIMESTAMP_NTZ(9)` | Timestamp when the row was last updated.        |

### Sample Query

```sql theme={null}
SELECT
    account_id,
    l1_address
FROM lighter_robinhood.raw.l1_mapping
LIMIT 100;
```