class NewsItem(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100))
message = db.Column(db.String(500), nullable=False)
created_on = db.Column(db.DateTime(timezone=True),
server_default=db.func.now(),
nullable=False)
created_by = db.Column(db.Integer,
db.ForeignKey('app_user.id'),
nullable=False)
updated_on = db.Column(db.DateTime)
updated_by = db.Column(db.Integer, db.ForeignKey('app_user.id'))
user1 = db.relationship(AppUser, foreign_keys=created_by)
user2 = db.relationship(AppUser, foreign_keys=updated_by)
class Team(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
email = db.Column(db.String(80))
home_id = db.Column(db.Integer, db.ForeignKey('home.id'), nullable=False)
created_on = db.Column(db.DateTime(timezone=True),
server_default=db.func.now(),
nullable=False)
created_by = db.Column(db.Integer,
db.ForeignKey('app_user.id'),
nullable=False)
updated_on = db.Column(db.DateTime)
updated_by = db.Column(db.Integer, db.ForeignKey('app_user.id'))
home = db.relationship(Home)
user1 = db.relationship(AppUser, foreign_keys=created_by)
user2 = db.relationship(AppUser, foreign_keys=updated_by)
comp = db.relationship(Comp, secondary='comp_reg')
class Home(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
address = db.Column(db.String(300))
lat = db.Column(db.Float)
lon = db.Column(db.Float)
surface_id = db.Column(db.Integer,
db.ForeignKey('surface.id'),
nullable=False)
created_on = db.Column(db.DateTime(timezone=True),
server_default=db.func.now(),
nullable=False)
created_by = db.Column(db.Integer,
db.ForeignKey('app_user.id'),
nullable=False)
updated_on = db.Column(db.DateTime)
updated_by = db.Column(db.Integer, db.ForeignKey('app_user.id'))
surface = db.relationship(Surface)
user1 = db.relationship(AppUser, foreign_keys=created_by)
user2 = db.relationship(AppUser, foreign_keys=updated_by)
class Comp(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
rank = db.Column(db.Integer, nullable=False)
section_id = db.Column(db.Integer,
db.ForeignKey('section.id'),
nullable=False)
cup = db.Column(db.Boolean, default=0, nullable=False)
day_id = db.Column(db.Integer)
created_on = db.Column(db.DateTime(timezone=True),
server_default=db.func.now(),
nullable=False)
created_by = db.Column(db.Integer,
db.ForeignKey('app_user.id'),
nullable=False)
updated_on = db.Column(db.DateTime)
updated_by = db.Column(db.Integer, db.ForeignKey('app_user.id'))
section = db.relationship(Section)
user1 = db.relationship(AppUser, foreign_keys=created_by)
user2 = db.relationship(AppUser, foreign_keys=updated_by)
teams = db.relationship('Team', secondary='comp_reg')
class AppUser(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
email = db.Column(db.String(80), nullable=False)
picture = db.Column(db.String(80))
