from sqlalchemy import Column, Integer, String, DateTime, Text
from sqlalchemy.orm import relationship
from sqlalchemy.sql import func
from app.database.base import Base
class Doctor(Base):
__tablename__ = "doctors"
id = Column(Integer, primary_key=True, index=True)
first_name = Column(String(100), nullable=False)
last_name = Column(String(100), nullable=False)
email = Column(String, unique=True, index=True)
phone = Column(String(20))
specialization = Column(String(200), nullable=False)
license_number = Column(String(100), unique=True, nullable=False)
years_of_experience = Column(Integer)
bio = Column(Text)
certifications = Column(Text)
languages_spoken = Column(Text)
ratings = Column(Integer)
profile_picture_url = Column(String(255))
department = Column(String(100))
created_at = Column(DateTime(timezone=True), server_default=func.now())
updated_at = Column(DateTime(timezone=True), onupdate=func.now())
# Relationships
appointments = relationship("Appointment", back_populates="doctor")
medical_records = relationship("MedicalRecord", back_populates="doctor")
