models/user_info.py

# from sqlalchemy import Column, String, BigInteger, DateTime, ForeignKey
# from config.database import Base
# from sqlalchemy.dialects.mysql import TINYINT  # MySQL TINYINT 타입

# class UserInfo(Base):
#     __tablename__ = "USER_INFO"
    
#     id = Column(String(36), primary_key=True, comment="ID")
#     preferred_username = Column(String(50), nullable=True, comment="로그인아이디")
#     mobile = Column(String(15), nullable=True, comment="모바일")
#     business_cd = Column(String(8), nullable=True, comment="소속기관일련번")
#     role_seq = Column(BigInteger, ForeignKey("ROLE.SEQ"), nullable=True, comment="역할일련번호")
#     name = Column(String(255), nullable=True, comment="사용자이름")
#     email = Column(String(255), nullable=True, comment="이메일")
#     profile = Column(String(255), nullable=True, comment="프로필")
#     school_code = Column(String(50), nullable=True, comment="학교코드")
#     grade = Column(TINYINT, nullable=True, comment="학년")
#     class_name = Column(String(50), nullable=True, comment="학급")
#     student_no = Column(TINYINT, nullable=True, comment="학생번호")
#     created_at = Column(DateTime, nullable=False, comment="생성일")
#     creator_id = Column(String(36), nullable=True, comment="생성자아이디")
#     creator_ip = Column(String(50), nullable=True, comment="생성자IP")
#     updated_at = Column(DateTime, nullable=True, comment="수정일")
#     updater_id = Column(String(36), nullable=True, comment="수정자아이디")
#     updater_ip = Column(String(50), nullable=True, comment="수정자IP")