18 lines
618 B
Python
18 lines
618 B
Python
from sqlalchemy import Column, Integer, String
|
|
from sqlalchemy.orm import declarative_base, relationship
|
|
from database import Base
|
|
|
|
class Advisor(Base):
|
|
__tablename__ = 'advisor'
|
|
id = Column(Integer, primary_key=True, autoincrement=True)
|
|
advisor_no = Column(String(32), unique=True, nullable=False)
|
|
name = Column(String(50), nullable=False)
|
|
gender = Column(String(2), nullable=False)
|
|
phone = Column(String(20), nullable=False)
|
|
remark=Column(String(500), nullable=True)
|
|
statu = Column(Integer, default=1, nullable=False)
|
|
students=relationship("Student", back_populates="advisor")
|
|
|
|
|
|
|