from app.main.data_management.data_base import *


class P2pGameMissionDecision(Schema.base):
    __tablename__ = 'p2p_game_mission_decision'

    id = Column(INTEGER(11), primary_key=True, nullable=False)
    mission_id = Column(ForeignKey('p2p_game_mission.id'), nullable=False, index=True)
    decision_id = Column(ForeignKey('p2p_game_decision.id'), nullable=False, index=True)
    day_id = Column(ForeignKey('p2p_game_day.id'), nullable=False, index=True)
    mission = relationship('P2pGameMission')
    decision = relationship('P2pGameDecision')
    day = relationship('P2pGameDay')

    def __init__(self, mission_id, decision_id, day_id):
        self.mission_id = mission_id
        self.decision_id = decision_id
        self.day_id = day_id