from sqlalchemy import INTEGER, VARCHAR
from sqlalchemy.orm import Mapped, mapped_column, relationship
from app.models.main import Base

class TblFullCourse(Base):
    __tablename__ = "tbl_full_courses"

    full_course_id: Mapped[int] = mapped_column(INTEGER, primary_key=True, autoincrement=True)
    program: Mapped[str] = mapped_column(VARCHAR(255), nullable=True)
    batch: Mapped[str] = mapped_column(VARCHAR(255), nullable=True)
    course: Mapped[str] = mapped_column(VARCHAR(255), nullable=True)
    batch_course_code: Mapped[str] = mapped_column(VARCHAR(255), nullable=True, unique=True)

    courses = relationship("TblCourseList", back_populates="full_course")