{
  "version": "6",
  "dialect": "sqlite",
  "id": "f4082a2d-a685-440a-8f05-93f7aa6b1dfc",
  "prevId": "8b492774-a545-4435-ae8c-40f50b3fb100",
  "tables": {
    "pack_catalog": {
      "name": "pack_catalog",
      "columns": {
        "pack_key": {
          "name": "pack_key",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "kind": {
          "name": "kind",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "state": {
          "name": "state",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "tier": {
          "name": "tier",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "seq_lo": {
          "name": "seq_lo",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "seq_hi": {
          "name": "seq_hi",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "object_count": {
          "name": "object_count",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "pack_bytes": {
          "name": "pack_bytes",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "idx_bytes": {
          "name": "idx_bytes",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "created_at": {
          "name": "created_at",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "superseded_by": {
          "name": "superseded_by",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        }
      },
      "indexes": {
        "idx_pack_catalog_state_seqhi": {
          "name": "idx_pack_catalog_state_seqhi",
          "columns": ["state", "\"seq_hi\" desc"],
          "isUnique": false
        },
        "idx_pack_catalog_state_tier_seqlo": {
          "name": "idx_pack_catalog_state_tier_seqlo",
          "columns": ["state", "tier", "seq_lo"],
          "isUnique": false
        }
      },
      "foreignKeys": {},
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {
        "chk_pack_catalog_kind": {
          "name": "chk_pack_catalog_kind",
          "value": "\"kind\" IN ('receive','compact','legacy')"
        },
        "chk_pack_catalog_state": {
          "name": "chk_pack_catalog_state",
          "value": "\"state\" IN ('active','superseded')"
        },
        "chk_pack_catalog_tier": {
          "name": "chk_pack_catalog_tier",
          "value": "\"tier\" >= 0"
        },
        "chk_pack_catalog_seq": {
          "name": "chk_pack_catalog_seq",
          "value": "\"seq_lo\" <= \"seq_hi\""
        },
        "chk_pack_catalog_object_count": {
          "name": "chk_pack_catalog_object_count",
          "value": "\"object_count\" >= 0"
        },
        "chk_pack_catalog_pack_bytes": {
          "name": "chk_pack_catalog_pack_bytes",
          "value": "\"pack_bytes\" >= 0"
        },
        "chk_pack_catalog_idx_bytes": {
          "name": "chk_pack_catalog_idx_bytes",
          "value": "\"idx_bytes\" >= 0"
        }
      }
    }
  },
  "views": {},
  "enums": {},
  "_meta": {
    "schemas": {},
    "tables": {},
    "columns": {}
  },
  "internal": {
    "indexes": {
      "idx_pack_catalog_state_seqhi": {
        "columns": {
          "\"seq_hi\" desc": {
            "isExpression": true
          }
        }
      }
    }
  }
}