| 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") | |