Annotated database schema

GET https://api.rewind.rest/v1/schema

Returns the curated, annotated schema for the query endpoint: every queryable table with its columns, types, semantic notes, join keys, and global conventions (single user_id, ISO timestamps, rating scales, image URL composition). Secret/system tables are intentionally omitted.

Authorization

Authorizationheaderstringrequired

API key. Read keys (rw_live_...) access GET endpoints. Admin keys (rw_admin_...) access all endpoints.

Response

application/json

Annotated schema

notesarray of stringrequired

Global conventions a model needs before writing queries.

tablesarray of objectrequired

Every queryable table with columns, notes, and join keys.

cURL

curl -X GET 'https://api.rewind.rest/v1/schema' \
  -H 'Authorization: Bearer <token>'

200

{
  "notes": [
    "string"
  ],
  "tables": [
    {
      "name": "string",
      "purpose": "string",
      "columns": [
        "\u2026"
      ],
      "joins": [
        "\u2026"
      ]
    }
  ]
}

Annotated database schema

GET https://api.rewind.rest/v1/schema

Authorization

Authorizationheaderstringrequired

API key. Read keys (rw_live_...) access GET endpoints. Admin keys (rw_admin_...) access all endpoints.

Response

application/json

Annotated schema

notesarray of stringrequired

Global conventions a model needs before writing queries.

tablesarray of objectrequired

Every queryable table with columns, notes, and join keys.

cURL

curl -X GET 'https://api.rewind.rest/v1/schema' \
  -H 'Authorization: Bearer <token>'

200

{
  "notes": [
    "string"
  ],
  "tables": [
    {
      "name": "string",
      "purpose": "string",
      "columns": [
        "\u2026"
      ],
      "joins": [
        "\u2026"
      ]
    }
  ]
}

Authorization

Response

properties

Authorization

Response

properties