50 lines
800 B
Python
50 lines
800 B
Python
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"
|
|
) |