19 lines
728 B
Python
19 lines
728 B
Python
from sqlalchemy import Column, String, ForeignKey
|
|
from sqlalchemy.orm import relationship
|
|
from app.domain.models.base import BaseModel
|
|
from sqlalchemy.dialects.postgresql import UUID
|
|
|
|
class Channel(BaseModel):
|
|
'''채널 모델'''
|
|
__tablename__ = "channels"
|
|
|
|
# 외래키 추가 (BaseModel의 id를 참조)
|
|
user_id = Column(UUID(as_uuid=True), ForeignKey('users.id'), nullable=False)
|
|
|
|
channel_id = Column(String, nullable=False, unique=True)
|
|
name = Column(String, nullable=False)
|
|
custom_url = Column(String, nullable=True)
|
|
platform = Column(String, nullable=False, default="youtube")
|
|
|
|
# 관계 설정 ( channels --- N:1 --- users )
|
|
user = relationship("User", back_populates="channels") |