"""Справочники норм RACION (NORMY_*)."""

from __future__ import annotations

from sqlalchemy import Column, Float, Integer, String, Text, UniqueConstraint

from app import db
from app.models.base import default_uuid


class LabRacionNormyMoskwa(db.Model):
    __tablename__ = "lab_racion_normy_moskwa"
    __table_args__ = (UniqueConstraint("npitv", "pom", name="uq_lab_racion_moskwa_npitv_pom"),)

    id = Column(String(36), primary_key=True, default=default_uuid)
    npitv = Column(Integer, nullable=False, index=True)
    pom = Column(Integer, nullable=False, default=1)
    koef = Column(Float, nullable=True)
    popr_k_json = Column(Text, nullable=True)


class LabRacionNormyMoskwaMeta(db.Model):
    __tablename__ = "lab_racion_normy_moskwa_meta"

    id = Column(String(36), primary_key=True, default=default_uuid)
    meta_key = Column(String(32), nullable=False, unique=True)
    meta_json = Column(Text, nullable=True)


class LabRacionNormyPiter(db.Model):
    __tablename__ = "lab_racion_normy_piter"
    __table_args__ = (
        UniqueConstraint("npitv", "konc", "udoy", name="uq_lab_racion_piter_npitv_konc_udoy"),
    )

    id = Column(String(36), primary_key=True, default=default_uuid)
    npitv = Column(Integer, nullable=False, index=True)
    konc = Column(Float, nullable=False)
    udoy = Column(Float, nullable=False)
    normy_json = Column(Text, nullable=True)


class LabRacionNormyPiterMeta(db.Model):
    __tablename__ = "lab_racion_normy_piter_meta"

    id = Column(String(36), primary_key=True, default=default_uuid)
    meta_key = Column(String(32), nullable=False, unique=True)
    meta_json = Column(Text, nullable=True)


class LabRacionNormyInfo(db.Model):
    __tablename__ = "lab_racion_normy_info"

    id = Column(String(36), primary_key=True, default=default_uuid)
    nperem = Column(Integer, nullable=False, unique=True, index=True)
    znachenie_json = Column(Text, nullable=True)