from db.base import Base
from sqlalchemy import Column, String, DateTime, func, ForeignKey, JSON
import uuid

class AuditLog(Base):
    __tablename__ = "audit_logs"
    id = Column(String(36), primary_key=True, default=lambda: str(uuid.uuid4()))
    user_id = Column(String(36), ForeignKey("users.id"))
    action = Column(String(100))
    resource_type = Column(String(50))
    resource_id = Column(String(36))
    metadata_json = Column(JSON, default={})
    ip_address = Column(String(45))
    created_at = Column(DateTime, server_default=func.now())