Python Column примеры использования

Пример #1

class Ammo_Lift(db.Model):
    __tablename__ = "ammo_lift"
    id = db.Column(db.Integer, primary_key=True)
    gender = db.Column(db.String(1), unique=False, nullable=False)
    age = db.Column(db.Integer, unique=False, nullable=False)
    reps = db.Column(db.Integer, unique=False, nullable=False)
    score = db.Column(db.Integer, unique=False, nullable=False)

Пример #2

class Pushups(db.Model):
    __tablename__ = "pushups"
    id = db.Column(db.Integer, primary_key=True)
    gender = db.Column(db.String(1), unique=False, nullable=False)
    age = db.Column(db.Integer, unique=False, nullable=False)
    reps = db.Column(db.Integer, unique=False, nullable=False)
    score = db.Column(db.Integer, unique=False, nullable=False)

Пример #3

class Plank(db.Model):
    __tablename__ = "plank"
    id = db.Column(db.Integer, primary_key=True)
    gender = db.Column(db.String(1), unique=False, nullable=False)
    age = db.Column(db.Integer, unique=False, nullable=False)
    time = db.Column(db.Integer, unique=False, nullable=False)
    score = db.Column(db.Integer, unique=False, nullable=False)

Пример #4

class Movement_Contact(db.Model):
    __tablename__ = "movement_contact"
    id = db.Column(db.Integer, primary_key=True)
    gender = db.Column(db.String(1), unique=False, nullable=False)
    age = db.Column(db.Integer, unique=False, nullable=False)
    time = db.Column(db.Integer, unique=False, nullable=False)
    score = db.Column(db.Integer, unique=False, nullable=False)
    high_alt = db.Column(db.Boolean, unique=False, nullable=False)

Пример #5

class Maneuver_Fire(db.Model):
    __tablename__ = "maneuver_fire"
    id = db.Column(db.Integer, primary_key=True)
    gender = db.Column(db.String(1), unique=False, nullable=False)
    age = db.Column(db.Integer, unique=False, nullable=False)
    time = db.Column(db.Integer, unique=False, nullable=False)
    score = db.Column(db.Integer, unique=False, nullable=False)
    high_alt = db.Column(db.Boolean, unique=False, nullable=False)

Пример #6

class Three_Mile(db.Model):
    __tablename__ = "three_mile"
    id = db.Column(db.Integer, primary_key=True)
    gender = db.Column(db.String(1), unique=False, nullable=False)
    age = db.Column(db.Integer, unique=False, nullable=False)
    time = db.Column(db.Integer, unique=False, nullable=False)
    score = db.Column(db.Integer, unique=False, nullable=False)
    high_alt = db.Column(db.Boolean, unique=False, nullable=False)