> ## 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.

# Orders

### Table Details

| Property     | Value              |
| ------------ | ------------------ |
| Table Name   | `tempo.dex.orders` |
| Table Status | Production-Ready   |

### Table Columns

| Column Name               | Data Type         | Description |
| ------------------------- | ----------------- | ----------- |
| order\_id                 | NUMBER(38,0)      |             |
| maker                     | VARCHAR(42)       |             |
| status                    | VARCHAR(16777216) |             |
| token                     | VARCHAR(42)       |             |
| base\_symbol              | VARCHAR(16777216) |             |
| quote\_symbol             | VARCHAR(16777216) |             |
| is\_bid                   | BOOLEAN           |             |
| side                      | VARCHAR(16777216) |             |
| tick                      | NUMBER(38,0)      |             |
| price                     | FLOAT             |             |
| amount\_raw               | NUMBER(38,0)      |             |
| amount                    | FLOAT             |             |
| filled\_raw               | NUMBER(38,0)      |             |
| filled                    | FLOAT             |             |
| remaining\_raw            | NUMBER(38,0)      |             |
| remaining                 | FLOAT             |             |
| amount\_usd               | FLOAT             |             |
| filled\_usd               | FLOAT             |             |
| remaining\_usd            | FLOAT             |             |
| is\_flip\_order           | BOOLEAN           |             |
| flip\_tick                | NUMBER(38,0)      |             |
| fill\_count               | NUMBER(38,0)      |             |
| placed\_at                | TIMESTAMP\_NTZ(9) |             |
| placed\_block\_number     | NUMBER(38,0)      |             |
| placed\_transaction\_hash | VARCHAR(66)       |             |
| last\_fill\_at            | TIMESTAMP\_NTZ(9) |             |
| cancelled\_at             | TIMESTAMP\_NTZ(9) |             |