"""Territory model."""

from db import db


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

    __tablename__ = "Territory"

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, nullable=False)
    code = db.Column(db.String, nullable=False)
    external_google_id = db.Column(db.Integer, nullable=True)

    territory_type_id = db.Column(db.Integer, db.ForeignKey("TerritoryType.id"), nullable=False)

    parent_id = db.Column(db.Integer, db.ForeignKey("Territory.id"), nullable=True, default=None)

    parent = db.relationship("Territory", remote_side=[id])

    territory_type = db.relationship("TerritoryType")