from app import db
from datetime import datetime

class DictionaryEntry(db.Model):
    __tablename__ = 'dictionary_entries'
    id = db.Column(db.Integer, primary_key=True)
    word = db.Column(db.String(64), nullable=False, unique=True)
    definition = db.Column(db.Text, nullable=False)
    synonyms = db.Column(db.Text)
    antonyms = db.Column(db.Text)
    example_sentence = db.Column(db.Text)
    suggestion = db.Column(db.Text)
    created_at = db.Column(db.DateTime, default=datetime.utcnow)
    added_by_id = db.Column(db.Integer, db.ForeignKey('users.id'))
    added_by = db.relationship('User', backref='dictionary_entries')

    def __repr__(self):
        return f'<DictionaryEntry {self.word}>'