"""Team improvement notes from coach."""

from app.extensions import db
from app.time_utils import utc_now_naive


class TeamNote(db.Model):
    """Team improvement notes from coach."""

    __tablename__ = 'team_notes'
    id = db.Column(db.Integer, primary_key=True)
    org_team_id = db.Column(db.Integer, db.ForeignKey('org_teams.id'), nullable=False)
    coach_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
    content = db.Column(db.Text, nullable=False)
    created_at = db.Column(db.DateTime, default=utc_now_naive)
    updated_at = db.Column(db.DateTime, default=utc_now_naive, onupdate=utc_now_naive)

    team = db.relationship('OrgTeam', backref='team_notes')
    coach = db.relationship('User', foreign_keys=[coach_id])