# models/group_data.py
from sqlalchemy import Column, Integer, String, Float
from app.models.main import Base

class TblGroupData(Base):
    __tablename__ = "tbl_group_data"

    id = Column(Integer, primary_key=True, autoincrement=True)
    group_no = Column(String(100), nullable=True)
    format_type = Column(String(100), nullable=True)
    reference_retailer = Column(String(255), nullable=True)
    no_of_stores = Column(Integer, nullable=True)
    indicative_categories = Column(String(500), nullable=True)
    no_of_sub_cats_l = Column(Integer, nullable=True)
    no_of_sub_cats_m = Column(Integer, nullable=True)
    no_of_sub_cats_h = Column(Integer, nullable=True)
    indicative_size_sqft = Column(Float, nullable=True)
    indicative_capital_rs_cr = Column(Float, nullable=True)
    approx_investment_per_store_lakhs = Column(Float, nullable=True)
    competition_intensity_l = Column(String(100), nullable=True)
    competition_intensity_m = Column(String(100), nullable=True)
    competition_intensity_h = Column(String(100), nullable=True)
    tech_investment_h_lakhs = Column(Float, nullable=True)
    tech_investment_m_lakhs = Column(Float, nullable=True)
    tech_investment_l_lakhs = Column(Float, nullable=True)
    spillage_factor_h = Column(Float, nullable=True)
    spillage_factor_l = Column(Float, nullable=True)