40 lines
663 B
Python
40 lines
663 B
Python
from sqlalchemy import (
|
|
Column,
|
|
Integer,
|
|
String,
|
|
ForeignKey
|
|
)
|
|
|
|
from sqlalchemy.orm import relationship
|
|
|
|
from app.database import Base
|
|
|
|
|
|
class ExperienceTask(Base):
|
|
__tablename__ = "experience_tasks"
|
|
|
|
id = Column(
|
|
Integer,
|
|
primary_key=True,
|
|
index=True,
|
|
nullable=False
|
|
)
|
|
|
|
description = Column(
|
|
String(255),
|
|
nullable=True
|
|
)
|
|
|
|
experience_id = Column(
|
|
Integer,
|
|
ForeignKey(
|
|
"experiences.id",
|
|
ondelete="CASCADE"
|
|
),
|
|
nullable=False
|
|
)
|
|
|
|
experience = relationship(
|
|
"Experience",
|
|
back_populates="tasks"
|
|
) |