Python ForeignKey Exemples

Exemple #1

class TeamModel(db.Model):
    __tablename__ = "team"

    id = db.Column(db.Integer, primary_key=True)
    leader_id = db.Column(db.Integer, db.ForeignKey("student.id"))
    assignment_id = db.Column(db.Integer, db.ForeignKey("homework.id"))
    name = db.Column(db.String)

    members = db.relationship("MemberModel")

Exemple #2

Fichier : self_evaluation.py Projet : Science-assignment-reps-for-student/Chateaubriand

class SelfEvaluationModel(db.Model):
    __tablename__ = "self_evaluation"

    id = db.Column(db.Integer, primary_key=True)
    student_id = db.Column(db.Integer, db.ForeignKey("student.id"))
    assignment_id = db.Column(db.Integer, db.ForeignKey("homework.id"))
    scientific_accuracy = db.Column(db.Integer, nullable=False)
    communication = db.Column(db.Integer, nullable=False)
    attitude = db.Column(db.Integer, nullable=False)
    created_at = db.Column(db.DateTime, nullable=False)

Exemple #3

class TeamFileModel(db.Model):
    __tablename__ = "team_file"

    id = db.Column(db.Integer, primary_key=True)
    assignment_id = db.Column(db.Integer, db.ForeignKey("homework.id"))
    team_id = db.Column(db.Integer, db.ForeignKey("team.id"))
    file_name = db.Column(db.String, nullable=False)
    path = db.Column(db.String, nullable=False, unique=True)
    created_at = db.Column(db.DateTime, nullable=False)
    is_late = db.Column(db.Boolean, nullable=False)

Exemple #4

class MutualEvaluationModel(db.Model):
    __tablename__ = "mutual_evaluation"

    id = db.Column(db.Integer, primary_key=True)
    student_id = db.Column(db.Integer, db.ForeignKey("student.id"))
    assignment_id = db.Column(db.Integer, db.ForeignKey("homework.id"))
    target_id = db.Column(db.Integer, db.ForeignKey("student.id"))
    communication = db.Column(db.Integer, nullable=False)
    cooperation = db.Column(db.Integer, nullable=False)
    created_at = db.Column(db.DateTime, nullable=False)

Exemple #5

class PersonalFileModel(db.Model):
    __tablename__ = "personal_file"

    id = db.Column(db.Integer, primary_key=True)
    student_id = db.Column(db.Integer, db.ForeignKey("student.id"))
    assignment_id = db.Column(db.Integer, db.ForeignKey("homework.id"))
    file_name = db.Column(db.String, nullable=False)
    path = db.Column(db.String, nullable=False)
    created_at = db.Column(db.DateTime, nullable=False)
    is_late = db.Column(db.Boolean, nullable=False)

    student = db.relationship("StudentModel")

Exemple #6

class MemberModel(db.Model):
    __tablename__ = "member"

    id = db.Column(db.Integer, primary_key=True)
    team_id = db.Column(db.Integer, db.ForeignKey("team.id"))
    student_id = db.Column(db.Integer, db.ForeignKey("student.id"))