"""ReferenceSigningEntity Model."""

from abacus_common_logic.connectors.database import db
from abacus_common_logic.models.base import CRUDMixin


class ReferenceSigningEntity(db.Model, CRUDMixin):
    """ReferenceSigningEntity Model."""

    __tablename__ = 'reference_signing_entity'

    reference_signing_entity_id = db.Column(db.Integer, primary_key=True)
    reference_sap_profit_center_id = db.Column(
        db.Integer,
        db.ForeignKey('reference_sap_profit_center.reference_sap_profit_center_id'),
        nullable=False
    )
    reference_payment_entity_id = db.Column(
        db.Integer,
        db.ForeignKey('reference_payment_entity.reference_payment_entity_id'),
        nullable=False
    )
    company_code = db.Column(db.String(8), nullable=False)
    legal_name = db.Column(db.String(180), nullable=False)
    vat_number = db.Column(db.String(30), nullable=True)
    company_registration_number = db.Column(db.String(30), nullable=True)
    address = db.Column(db.String(180), nullable=True)

    reference_sap_profit_center = db.relationship(
        'ReferenceSapProfitCenter',
        back_populates='reference_signing_entities'
    )