from sqlalchemy import Column, Integer, String, DateTime, Numeric
from src.infrastructure.models.user_model import Base

class ApplicationModel(Base):
    """
    SQLAlchemy ORM model mapping to existing 'consumer_application' table in MySQL.
    """
    __tablename__ = "consumer_application"

    id = Column(Integer, primary_key=True, index=True)
    name = Column(String(255))
    approved_amount = Column(Numeric(10, 2))
    state = Column(String(255))
    dob = Column(String(255)) # Or Date, depending on MySQL schema 
    pan_number = Column(String(255))
    aadhar_number = Column(String(255))
    gender = Column(String(255))
    marital_status = Column(String(255))
    education = Column(String(255))
    created_at = Column(DateTime)
    updated_at = Column(DateTime)