{
  "version": "6",
  "dialect": "sqlite",
  "id": "535868c2-6e11-401e-8d00-2399693a5d60",
  "prevId": "00000000-0000-0000-0000-000000000000",
  "tables": {
    "attachments": {
      "name": "attachments",
      "columns": {
        "id": {
          "name": "id",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "email_id": {
          "name": "email_id",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "filename": {
          "name": "filename",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "content_type": {
          "name": "content_type",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "size_bytes": {
          "name": "size_bytes",
          "type": "integer",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false,
          "default": 0
        },
        "storage_key": {
          "name": "storage_key",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        }
      },
      "indexes": {
        "idx_attachments_email": {
          "name": "idx_attachments_email",
          "columns": [
            "email_id"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {
        "attachments_email_id_emails_id_fk": {
          "name": "attachments_email_id_emails_id_fk",
          "tableFrom": "attachments",
          "tableTo": "emails",
          "columnsFrom": [
            "email_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        }
      },
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {}
    },
    "domains": {
      "name": "domains",
      "columns": {
        "id": {
          "name": "id",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "domain": {
          "name": "domain",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "is_active": {
          "name": "is_active",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": true
        },
        "created_at": {
          "name": "created_at",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": "(unixepoch() * 1000)"
        }
      },
      "indexes": {
        "domains_domain_unique": {
          "name": "domains_domain_unique",
          "columns": [
            "domain"
          ],
          "isUnique": true
        },
        "idx_domains_active": {
          "name": "idx_domains_active",
          "columns": [
            "is_active"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {},
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {}
    },
    "emails": {
      "name": "emails",
      "columns": {
        "id": {
          "name": "id",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "inbox_id": {
          "name": "inbox_id",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "recipient_address": {
          "name": "recipient_address",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": "''"
        },
        "from_address": {
          "name": "from_address",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "from_name": {
          "name": "from_name",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        },
        "subject": {
          "name": "subject",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false,
          "default": "'(no subject)'"
        },
        "received_at": {
          "name": "received_at",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": "(unixepoch() * 1000)"
        },
        "is_read": {
          "name": "is_read",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": false
        },
        "size_bytes": {
          "name": "size_bytes",
          "type": "integer",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false,
          "default": 0
        },
        "has_attachments": {
          "name": "has_attachments",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": false
        },
        "body_key": {
          "name": "body_key",
          "type": "text",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        }
      },
      "indexes": {
        "idx_emails_inbox_received_id": {
          "name": "idx_emails_inbox_received_id",
          "columns": [
            "inbox_id",
            "received_at",
            "id"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {
        "emails_inbox_id_inboxes_id_fk": {
          "name": "emails_inbox_id_inboxes_id_fk",
          "tableFrom": "emails",
          "tableTo": "inboxes",
          "columnsFrom": [
            "inbox_id"
          ],
          "columnsTo": [
            "id"
          ],
          "onDelete": "cascade",
          "onUpdate": "no action"
        }
      },
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {}
    },
    "inboxes": {
      "name": "inboxes",
      "columns": {
        "id": {
          "name": "id",
          "type": "text",
          "primaryKey": true,
          "notNull": true,
          "autoincrement": false
        },
        "local_part": {
          "name": "local_part",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "domain": {
          "name": "domain",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "full_address": {
          "name": "full_address",
          "type": "text",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false
        },
        "is_permanent": {
          "name": "is_permanent",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": false
        },
        "created_at": {
          "name": "created_at",
          "type": "integer",
          "primaryKey": false,
          "notNull": true,
          "autoincrement": false,
          "default": "(unixepoch() * 1000)"
        },
        "expires_at": {
          "name": "expires_at",
          "type": "integer",
          "primaryKey": false,
          "notNull": false,
          "autoincrement": false
        }
      },
      "indexes": {
        "inboxes_full_address_unique": {
          "name": "inboxes_full_address_unique",
          "columns": [
            "full_address"
          ],
          "isUnique": true
        },
        "idx_inboxes_local_domain": {
          "name": "idx_inboxes_local_domain",
          "columns": [
            "local_part",
            "domain"
          ],
          "isUnique": true
        },
        "idx_inboxes_domain": {
          "name": "idx_inboxes_domain",
          "columns": [
            "domain"
          ],
          "isUnique": false
        },
        "idx_inboxes_permanent_expires": {
          "name": "idx_inboxes_permanent_expires",
          "columns": [
            "is_permanent",
            "expires_at"
          ],
          "isUnique": false
        },
        "idx_inboxes_permanent_created": {
          "name": "idx_inboxes_permanent_created",
          "columns": [
            "is_permanent",
            "created_at"
          ],
          "isUnique": false
        },
        "idx_inboxes_permanent_domain_local": {
          "name": "idx_inboxes_permanent_domain_local",
          "columns": [
            "is_permanent",
            "domain",
            "local_part"
          ],
          "isUnique": false
        }
      },
      "foreignKeys": {},
      "compositePrimaryKeys": {},
      "uniqueConstraints": {},
      "checkConstraints": {}
    }
  },
  "views": {},
  "enums": {},
  "_meta": {
    "schemas": {},
    "tables": {},
    "columns": {}
  },
  "internal": {
    "indexes": {}
  }
}