from sqlalchemy import Column, String, Integer, JSON
from db import Base

class Idiom(Base):
    __tablename__ = "idioms"

    id = Column(String, primary_key=True, index=True)
    idiom = Column(String, nullable=False)
    language = Column(String, nullable=False)
    dialect = Column(String, default="unspecified")
    idiomatic_meaning = Column(String, default="")
    literal_meaning = Column(String, default="")
    example = Column(String, default="")
    validation_count = Column(JSON, default={"approved": 0, "rejected": 0})  # { "approved": 0, "rejected": 0 }
    quality = Column(String, default="seed")
    status = Column(String, default="pending")