from sqlalchemy import Column, BigInteger, String, Text, DateTime, ForeignKey from sqlalchemy import func from app.core.database import Base class SystemLog(Base): __tablename__ = "system_logs" id = Column(BigInteger, primary_key=True, autoincrement=True) level = Column(String(20), nullable=False, default="error") message = Column(Text, nullable=False) traceback = Column(Text, nullable=True) endpoint = Column(String(255), nullable=True) method = Column(String(10), nullable=True) account_id = Column(BigInteger, nullable=True) user_id = Column(BigInteger, nullable=True) ip_address = Column(String(45), nullable=True) created_at = Column(DateTime, server_default=func.now())