# Note table id = Column(Integer, primary_key=True) title = Column(String(), nullable=False) doc = Column(Text, nullable=False) date_created = Column(DateTime, nullable=False, default=dt.datetime.utcnow) date_updated = Column(DateTime, onupdate=dt.datetime.utcnow) user_email = Column(String(), ForeignKey("user.email"), nullable=True) # NEW date_reviewed -- set to date last studied # Flashcard table id = PK note_id = FK term = str definition = str # CardStats num_attempts = int correct_attempts = int user_id card_id note_id