app/models/request_model.py - master - idsich/sber_hack24

app/models/request_model.py

16 строк598 B

Arseniy Yolkin

nu tipo final

22 сен 2024, 09:52

22 сен 2024, 09:5233ce9d3

from app.models.base_model import BaseModel
from app.models.student_model import Student
from app.models.vacancy_model import Vacancies
from sqlalchemy import ForeignKey, VARCHAR
from sqlalchemy.orm import Mapped, mapped_column, relationship


class Requests(BaseModel):
    __tablename__ = 'requests'

    stud_id: Mapped[int] = mapped_column(ForeignKey(Student.id))
    vacancy_id: Mapped[int] = mapped_column(ForeignKey(Vacancies.id))
    status: Mapped[str]

    students = relationship("Student", back_populates="requests")
    vacancies = relationship("Vacancies", back_populates="requests")