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))