from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import relationship
from db.session import Base

class LMSPlatform(Base):
    __tablename__ = "lms_platforms"

    id = Column(Integer, primary_key=True, index=True)
    issuer = Column(String(255), nullable=False)
    tenant_domain = Column(String(255))
    tenant_id = Column(String(255))
    tenant_name = Column(String(255))
    client_id = Column(String(255), nullable=False)
    jwks_url = Column(String(500), nullable=False)
    token_url = Column(String(500), nullable=False)

    # Relation with users table (One-to-Many)
    users = relationship("User", back_populates="lms_platform")
    userCourseLogs = relationship("UserCourseLog", back_populates="lmsPlateForm")