"""ObejectiveMetricsField model."""

from db import db


class ObjectiveMetricsField(db.Model):
    __tablename__ = "ObjectiveMetricsField"

    id = db.Column(db.Integer, primary_key=True)
    objective_id = db.Column(db.Integer, db.ForeignKey("CampaignObjective.id", ondelete="CASCADE"), nullable=False)
    metrics_field_id = db.Column(db.Integer, db.ForeignKey("MetricsField.id", ondelete="CASCADE"), nullable=False)
    index = db.Column(db.Integer, nullable=True)

    objective = db.relationship("CampaignObjective")
    metrics_field = db.relationship("MetricsField")