from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()

sc = db.Table('sc',

db.Column('sno', db.String(10), db.ForeignKey('students.sno')),
db.Column('cno', db.String(10), db.ForeignKey('courses.cno'))
)

class Students(db.Model):

__tablename__ = 'students'
sno = db.Column(db.String(10), primary_key=True)
sname = db.Column(db.String(10))

class Course(db.Model):

__tablename__ = 'courses'
cno = db.Column(db.String(10), primary_key=True)
cname = db.Column(db.String(10), index=True)
students = db.relationship('Student',
     secondary=sc,
     backref=db.backref('courses',lazy='dynamic'),
     lazy='dynamic'
     )

比如上面這種，sc為關(guān)聯(lián)表，因為關(guān)聯(lián)表包含所有學(xué)生和課程的對應(yīng)關(guān)系，感覺正好可以加個分?jǐn)?shù)字段。如果我現(xiàn)在要給sc表加個字段“分?jǐn)?shù)”，s = Students.query.get(id),如果查詢學(xué)生學(xué)號為id的某門課或所有課程的分?jǐn)?shù)？