Как сделать связь один-ко-многим в sqlite3?

import sqlite3
 
 
def create_db():
    conn = sqlite3.connect(r"strek.db")
    cur = conn.cursor()
    cur.execute("""CREATE TABLE IF NOT EXISTS kinds (id INTEGER PRIMARY KEY, k_name TEXT);""")
    cur.execute("""CREATE TABLE IF NOT EXISTS dragons (id INTEGER PRIMARY KEY AUTOINCREMENT, d_name TEXT,
            kinds INTEGER NOT NULL, FOREIGN KEY (kinds) REFERENCES kinds(id));""")
 
    cur.execute('INSERT INTO kinds (id, k_name) VALUES (1, "Прямокрылые");')
    cur.execute('INSERT INTO kinds (id, k_name) VALUES (2, "Разнокрылые");')
 
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Лютка-дриада", 1);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Лютка-невеста", 2);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Стрелка-красивая", 2);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Стрелка-изящная", 1);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Красотка-девушка", 1);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Красотка-блестящая", 2);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Четырехпятнистая", 2);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Желтая", 1);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Бабка бронзовая", 2);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Бабка металлическая", 2);')
    cur.execute('INSERT INTO dragons (d_name, kinds) VALUES ("Коромысло большое", 1);')
    conn.commit()
    conn.close()
 
 
create_db()
conn = sqlite3.connect(r"strek.db")
cur = conn.cursor()
cur.execute('''SELECT dragons.d_name, kinds.k_name FROM
        dragons INNER JOIN kinds ON dragons.kinds=kinds.id
        WHERE kinds.k_name='Разнокрылые';''')
for i in cur.fetchall():
    print(i)
conn.close()

from flask import Flask, render_template, url_for
from flask_sqlalchemy import SQLAlchemy
 
 
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///db2.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
 
 
class Kinds(db.Model):
    __tablename__ = 'kinds'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(30))
    pets = db.relationship('Dragonflies', backref='family')
 
 
class Dragonflies(db.Model):
    __tablename__ = 'dragonflies'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(30))
    family_id = db.Column(db.Integer, db.ForeignKey('kinds.id'))