from app.models.experience_task import ExperienceTask
from app.models.experience_link import ExperienceLink

from sqlalchemy import (
    Column,
    Integer,
    String
)

from sqlalchemy.orm import relationship

from app.database import Base


class Experience(Base):
    __tablename__ = "experiences"

    id = Column(
        Integer,
        primary_key=True,
        index=True,
        nullable=False
    )

    company = Column(
        String(255),
        nullable=False
    )

    location = Column(
        String(255),
        nullable=False
    )

    duration = Column(
        String(255),
        nullable=False
    )

    role = Column(
        String(255),
        nullable=False
    )

    tasks = relationship(
        "ExperienceTask",
        back_populates="experience",
        cascade="all, delete-orphan"
    )

    links = relationship(
        "ExperienceLink",
        back_populates="experience",
        cascade="all, delete-orphan"
    )