Python Column示例

示例#1

class User(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(100), unique=True)
    password = db.Column(db.String(100))
    username = db.Column(db.String(100), unique=True)
    score = db.relationship('Score', backref="user_score", uselist=False)
    solve = db.relationship('Solve', backref="user_solve")

示例#2

class Challenge(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100))
    value = db.Column(db.Integer)
    requirement = db.Column(db.Integer)
    solves = db.Column(db.Integer, default=0)
    desc = db.Column(db.String(300))
    link = db.Column(db.String(300))
    base_flag = db.Column(db.String(100))
    cur_flag = db.Column(db.String(100))
    category_id = db.Column(db.String, db.ForeignKey('category.name'))
    solve = db.relationship("Solve", backref="challenge_solve")

示例#3

文件： Category.py 项目： owenofengland/lCTF-Platform

class Category(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), unique=True)
    challenges = db.relationship("Challenge", backref="category_challenge")

示例#4

class Solve(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String, db.ForeignKey('user.username'))
    challenge = db.Column(db.String, db.ForeignKey('challenge.name'))
    solved = db.Column(db.Boolean, default=False)

示例#5

class Score(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    score = db.Column(db.Integer, default=0)
    username = db.Column(db.String, db.ForeignKey('user.username'))