database schema

Database Name: edithai

Users Collection

Users (document structure)

{
  "_id",
  "walletAddress",
  "createdAt",
  "updatedAt",
  "totalPrompts",
  "totalSpent",
  "isBlocked"
}

Prompts Collection

Prompts (document structure)

{
  "_id",
  "userId",
  "promptText",
  "modelUsed",
  "inputTokens",
  "outputTokens",
  "computeUnits",
  "cost",
  "status",
  "createdAt"
}

UsageReceipts Collection

UsageReceipts (document structure)

{
  "_id",
  "userId",
  "promptId",
  "cost",
  "signature",
  "timestamp",
  "settled",
  "txHash",
  "chainId"
}

Settlements Collection

Settlements (document structure)

{
  "_id",
  "receiptId",
  "txHash",
  "blockNumber",
  "amount",
  "confirmed",
  "createdAt"
}