backend/app/models/audit_model.py

from sqlalchemy import Column, Integer, String, DateTime, JSON, ForeignKey
from app.db.database import Base
from datetime import datetime, UTC

class AuditLog(Base):
    __tablename__ = "audit_logs"

    id = Column(Integer, primary_key=True, index=True)
    user_id = Column(Integer, ForeignKey("users.id", ondelete="SET NULL"), nullable=True)
    action = Column(String, index=True, nullable=False)
    timestamp = Column(DateTime, default=datetime.now(UTC), index=True)
    ip = Column(String, nullable=True)
    metadata_info = Column(JSON, nullable=True)