21 lines
904 B
Python
21 lines
904 B
Python
from sqlalchemy import Column, String
|
|
from sqlalchemy.orm import relationship
|
|
from app.domain.models.base import BaseModel
|
|
|
|
class User(BaseModel):
|
|
'''사용자 모델'''
|
|
__tablename__ = "users"
|
|
|
|
user_id = Column(String, nullable=False, unique=True) # 로그인용 실제 아이디
|
|
name = Column(String, nullable=False)
|
|
password = Column(String, nullable=False)
|
|
|
|
# 추 후, 필요하면 column 수정 ( nullable 수정 )
|
|
email = Column(String, nullable=True, unique=True)
|
|
phone_number = Column(String, nullable=True, unique=True)
|
|
|
|
|
|
# 관계 설정 ( users --- 1:N --- items, orders, channels )
|
|
items = relationship("Item", back_populates="user", cascade="all, delete-orphan")
|
|
orders = relationship("Order", back_populates="user", cascade="all, delete-orphan")
|
|
channels = relationship("Channel", back_populates="user", cascade="all, delete-orphan") |