SQLAlchemy对于一个表中有多个外键该怎么定义

新手上路,请多包涵

如果一个表中有多个外键,例如:有学生表、课程表和分数表,想我这样定义是否正确?

class Student(Base):
    __tablename__ = 'students'
    id = Column(Integer, primary_key=True)
    name = Column(String(20), nullable=False, index=True)
    sex = Column(Integer, nullable=True)
    score = relationship('Score', backref='student')

class Subject(Base):
    __tablename__ = 'subjects'
    id = Column(Integer, primary_key=True)
    Name = Column(String(10), nullable=False, index=True)
    score = relationship('Score', backref='score')

class Score(Base):
    __tablename__ = 'score'
    id = Column(Integer, primary_key=True)
    score = Column(Integer, nullable=False)
    subject_id = Column(Integer, ForeignKey('subjects.id'))
    student_id = Column(Integer, ForeignKey('students.id'))

如果要同时添加学生信息和分数信息该怎么添加?

阅读 1.5k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题