from sqlalchemy import Column, BigInteger, String, Text, TIMESTAMP, func
from app.core.database import Base


class Card(Base):
    __tablename__ = "card"

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    image = Column(String(255), nullable=False)
    title = Column(String(255), nullable=False)
    content = Column(Text, nullable=False)
    label = Column(String(255), nullable=True)
    country = Column(String(255), nullable=True)
    additional_info = Column(String(255), nullable=True)
    culture = Column(String(100), default="english")
    created_at = Column(TIMESTAMP, server_default=func.now())
    updated_at = Column(TIMESTAMP, server_default=func.now(), onupdate=func.now())