class users(db.Model):
    id = db.Column(Integer, autoincrement=True, primary_key=True)
    username = db.Column(String, unique=True,  nullable=False)
    password = db.Column(String, nullable=False)
    first_name = db.Column(String, nullable=False)
    last_name = db.Column(String, nullable=False)
    age = db.Column(Integer, CheckConstraint( 'age>=14' ), nullable=False)
    nationality = db.Column(String, nullable=True)
    picture_url = db.Column(String)
    email = db.Column(String, unique=True, nullable=False)
    role = db.Column(String, nullable=False)
    auto_scratch = db.Column(Boolean, default=False)
    home_country = db.Column(String, nullable=False)
    countries = db.relationship('users_countries_join', backref=db.backref('user_list'), lazy='dynamic') #, lazy='dynamic

    def __init__(self, username, password, first_name, last_name, age, nationality, picture_url, email, role, auto_scratch, home_country, countries):
        self.username = username
        self.password = password
        self.first_name = first_name
        self.last_name = last_name
        self.age = age
        self.nationality = nationality
        self.picture_url = picture_url
        self.email = email
        self.role = role
        self.auto_scratch = auto_scratch
        self.home_country = home_country
        self.countries = countries

    def __repr__(self):
        return '<{}>' % self.__name__

class countries(db.Model):
    id = db.Column(Integer, autoincrement=True, primary_key=True)
    country_name = db.Column(String, nullable=False)
    flag = db.Column(String, nullable=False)
    country_img = db.Column(String, nullable=False)
    code = db.Column(String, nullable=False)
    users = db.relationship('users_countries_join', backref=db.backref('country_list'))

    def __init__(self, country_name, flag, country_img, code, users):
        self.country_name = country_name
        self.flag = flag
        self.country_img = country_img
        self.users = users


    def __repr__(self):
        return '<{}>' % self.__name__

class users_countries_join(db.Model):
    id = db.Column(Integer, autoincrement=True, primary_key=True)
    user_id = db.Column(Integer, ForeignKey(users.id), nullable=False)
    country_id = db.Column(Integer, ForeignKey(countries.id), nullable=False)
    status = db.Column(String, nullable=False)
    notes = db.Column(TEXT, nullable=True)

    def __init__(self, user, country, status, notes):
        self.user_id = user.id
        self.country_id = country.id
        self.status = status
        self.notes = notes
        self.country_code = country.code


    def __repr__(self):
        return '<{}>' % self.__name__



 - List item