"""Label model."""

from db import db
from sqlalchemy.dialects.postgresql import ARRAY


class Label(db.Model):
    """Label model."""

    __tablename__ = "Label"

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, nullable=False)
    rep_owner_key = db.Column(db.String, unique=True, nullable=True)
    external_name = db.Column(db.String, nullable=False)
    abbreviation = db.Column(db.String, nullable=True)
    country = db.Column(db.String, nullable=True)
    child_rep_owner_keys = db.Column(ARRAY(db.String()), nullable=True)

    marketing_accounts = db.relationship("MarketingAccount", back_populates="label")
    connectors = db.relationship("Connector", back_populates="label")
    users = db.relationship("User", secondary="UserLabel", back_populates="labels")