from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import relationship
from app.database import Base

class SeatLayout(Base):
    __tablename__ = "seat_layout"
    id = Column(Integer, primary_key=True, index=True)
    template_id = Column(Integer, ForeignKey("mass_templates.id", ondelete="CASCADE"), nullable=True)
    special_mass_id = Column(Integer, ForeignKey("special_masses.id", ondelete="CASCADE"), nullable=True)
    position_number = Column(String(20), nullable=False)
    view_type = Column(String(10), nullable=False)  # 'duduk' or 'altar'
    row_index = Column(Integer, nullable=False)
    col_index = Column(Integer, nullable=False)
    side = Column(String(10), nullable=True)    # 'kuning' or 'biru'
    section = Column(String(20), nullable=True)  # 'samping_kiri', 'samping_kanan', 'depan'

    template = relationship("MassTemplate")
    special_mass = relationship("SpecialMass")