models.py

# models.py
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import relationship
from database import Base

class Empresa(Base):
    __tablename__ = "empresas"

    id = Column(Integer, primary_key=True, index=True)
    nome = Column(String, unique=True, index=True)
    senha = Column(String)
    promocoes = relationship("Promocao", back_populates="empresa")

class Promocao(Base):
    __tablename__ = "promocoes"

    id = Column(Integer, primary_key=True, index=True)
    titulo = Column(String, index=True)
    descricao = Column(String, index=True)
    imagem = Column(String)
    empresa_id = Column(Integer, ForeignKey("empresas.id"))  # Relação com Empresa
    empresa = relationship("Empresa", back_populates="promocoes")