AcidificationModel/api/app/database_models.py

from . import db

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

    ModelID = db.Column(db.Integer, primary_key=True)
    ModelName = db.Column(db.Text, nullable=False)
    ModelType = db.Column(db.Text, nullable=False)
    CreatedAt = db.Column(db.TIMESTAMP, default=db.func.current_timestamp())
    Description = db.Column(db.Text)
    
    # # 添加与 ModelParameters 表的关系
    # parameters = db.relationship('ModelParameters', backref='model', lazy=True)

class ModelParameters(db.Model):
    __tablename__ = 'ModelParameters'  # 指定表名

    ParamID = db.Column(db.Integer, primary_key=True, autoincrement=True)  # 主键
    ModelID = db.Column(db.Integer, db.ForeignKey('Models.ModelID'), nullable=False)  # 外键，指向 Models 表的 ModelID
    ParamName = db.Column(db.Text, nullable=False)  # 参数名
    ParamValue = db.Column(db.Text, nullable=False)  # 参数值

    # 定义反向关系
    model = db.relationship('Model', backref=db.backref('parameters', lazy=True))