import enum

from sqlalchemy import Column, Integer, String, ForeignKey, TIMESTAMP, Enum, Float, Text
from sqlalchemy.orm import relationship

from ..database import Base

from .Despesa import Despesa

class TempoFixoPeriodo(enum.Enum):
    Diario = "Diario"
    Semanal = "Semanal"
    Mensal = "Mensal"
    Bimestral = "Bimestral"
    Trimestral = "Trimestral"
    Semestral = "Semestral"
    Anual = "Anual"

class DespesaTempoFixo(Base):
    __tablename__ = "despesa_tempo_fixo"

    id = Column(Integer, ForeignKey(Despesa.id), primary_key=True, name="des_id")
    tempo_fixo_periodo = Column(Enum(TempoFixoPeriodo), name="des_temp_fix_periodo")