from sqlalchemy import (
    Column,
    Integer,
    String,
    ForeignKey
)

from sqlalchemy.orm import relationship

from app.database import Base


class ExperienceLink(Base):
    __tablename__ = "experience_links"

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

    label = Column(
        String(255),
        nullable=True
    )

    link = Column(
        String(255),
        nullable=True
    )

    icon_path = Column(
        String(255),
        nullable=True
    )

    experience_id = Column(
        Integer,
        ForeignKey(
            "experiences.id",
            ondelete="CASCADE"
        ),
        nullable=False
    )

    experience = relationship(
        "Experience",
        back_populates="links"
    )