# MaaRmk

Remarks associated with specific MAA records and columns, providing additional free-form descriptive information

**Source:** NASR table `MAA_RMK` · version `e25086c3e952` · effective 2026-04-16

> Ordered by MAA_ID, TAB_NAME, REF_COL_NAME, REF_COL_SEQ_NO. References MAA_ID in MAA_BASE. Non-specific remarks are identified as GENERAL_REMARK in REF_COL_NAME.

## Example query

```graphql
# Introspect the MaaRmk type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    maaId
    tabName
    refColName
  # }
}
```

Run at https://api.nav.sortie.co/graphql (GraphiQL available in-browser).

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `effDate` | `String` | The 28-day NASR Subscription Effective Date in format YYYY/MM/DD |  |  |
| `maaId` | `String` | Unique identifier for a Miscellaneous Activity Area; references MAA_ID in MAA_BASE |  |  |
| `tabName` | `String` | NASR table name associated with the remark |  |  |
| `refColName` | `String` | NASR column name associated with the remark; non-specific remarks use the value GENERAL_REMARK |  |  |
| `refColSeqNo` | `Int` | Sequence number assigned to the reference column remark, used to order multi-line remarks |  |  |
| `remark` | `String` | Free-form remark text that further describes a specific information item for the referenced MAA column |  |  |

## Column provenance

Every field maps 1:1 to a column in the `MAA_RMK` table of `nasr.db`. Original FAA column names:

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `maaId` | `MAA_ID` |
| `tabName` | `TAB_NAME` |
| `refColName` | `REF_COL_NAME` |
| `refColSeqNo` | `REF_COL_SEQ_NO` |
| `remark` | `REMARK` |