from sqlalchemy import Boolean, Column, ForeignKey, Integer, String,DateTime,Float
from datetime import datetime
import database

class SentimentResult(database.Base):

    __tablename__ = "sentiment_results"

    id = Column(Integer, primary_key=True, index=True)
    text_id = Column(Integer, ForeignKey("textinputs.id"))
    positive_score = Column(Float)
    negative_score = Column(Float)
    neutral_score = Column(Float)
    created_at = Column(DateTime, default=datetime.utcnow)