• db.Boolean
• db.Integer
• db.Float
• db.String(100)
• db.Text
• db.Date
• db.DateTime

source : Les types de données (docs.sqlalchemy.org)

>>> # Récupère l'enregistrement dont le nom est 'memo'
>>> mc = MarkerCategory.query.where(MarkerCategory.name == 'memo').all()
>>> mc
[<MarkerCategory id=2 name="memo" builtin=True icon=/static/img/notepad_9021656_icon.png marker_icon=None >]

• https://flask-sqlalchemy.palletsprojects.com/en/stable/
• https://docs.sqlalchemy.org/en/20/orm/basic_relationships.html#one-to-one
• https://pythonbasics.org/flask-sqlalchemy/
• https://www.slingacademy.com/article/solving-sqlalchemy-integrityerror-when-inserting-data/
• https://www.codementor.io/@garethdwyer/building-a-crud-application-with-flask-and-sqlalchemy-dm3wv7yu2
• https://www.digitalocean.com/community/tutorials/how-to-use-one-to-many-database-relationships-with-flask-sqlalchemy