class User(db.Model):
    __tablename__ = 'User'

    id = db.Column(db.Integer, primary_key=True, nullable=False)
    email = db.Column(db.String(255), unique=True, nullable=False)
    password = db.Column(db.String(255), nullable=False)
    phone_number = db.Column(db.String(255), nullable=True)
    name = db.Column(db.String(255), nullable=False)
    teams = db.relationship('Team', secondary='Team_Members')
    notify_emails = db.Column(ARRAY(db.String(255)), nullable=True)
    # Does user have super privileges?
    is_admin = db.Column(db.Boolean, nullable=False, default=False)
    roles = db.Column(ArraySet(db.String(255)), nullable=False)

class Team(db.Model):
    __tablename__ = 'Team'
    id = db.Column(db.Integer, primary_key=True, nullable=False)
    name = db.Column(db.String(120), nullable=False)
    website = db.Column(db.String(255), nullable=False)
    phone_number = db.Column(db.String(255), nullable=True)

    hq_address_fkey = db.ForeignKey('Address.id')
    hq_address_id = db.Column(db.Integer, hq_address_fkey, nullable=True)
    hq_address = db.relationship('Address', foreign_keys='Team.hq_address_id')

    subscriptions = db.relationship('Subscription', back_populates='team')

    members = db.relationship('User', secondary='Team_Members')


class TeamMember(db.Model):
    __tablename__ = 'Team_Members'

    id = db.Column(db.Integer, primary_key=True, nullable=False)

    team_fkey = db.ForeignKey('Team.id')
    team_id = db.Column(db.Integer, team_fkey, nullable=False)
    team = db.relationship('Team', foreign_keys='TeamMember.team_id')

    user_fkey = db.ForeignKey('User.id')
    user_id = db.Column(db.Integer, user_fkey, nullable=False)
    user = db.relationship('User', foreign_keys='TeamMember.user_id')

    is_member_confirmed = db.Column(db.Boolean, nullable=False, default=False)
    is_team_confirmed = db.Column(db.Boolean, nullable=False, default=False)