from app.extensions import db
from datetime import datetime

class Feedback(db.Model):
    __tablename__ = 'feedbacks'
    
    id = db.Column(db.Integer, primary_key=True)
    student_id = db.Column(db.Integer, db.ForeignKey('students.id'), nullable=False)
    teacher_id = db.Column(db.Integer, db.ForeignKey('teachers.id'), nullable=False)
    booking_id = db.Column(db.Integer, db.ForeignKey('bookings.id'), nullable=False)
    
    # 评价内容
    rating = db.Column(db.Integer, nullable=False)  # 1-5分
    comment = db.Column(db.Text)
    categories = db.Column(db.String(500))  # 评价分类，JSON格式
    
    # 状态
    is_verified = db.Column(db.Boolean, default=False)  # 是否审核通过
    is_public = db.Column(db.Boolean, default=True)  # 是否公开显示
    
    # 时间戳
    created_at = db.Column(db.DateTime, default=datetime.utcnow)
    updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
    
    def __repr__(self):
        return f'<Feedback {self.id} - Rating: {self.rating}>'