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")