Spaces:
Sleeping
Sleeping
File size: 1,262 Bytes
cd7e4a8 b8bc5bb b6adf8a cd7e4a8 b6adf8a cd7e4a8 b8bc5bb b6adf8a b8bc5bb cd7e4a8 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | from sqlalchemy import Column, Integer, String, LargeBinary, DateTime, Text, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from datetime import datetime
from app.core.config import settings
from app.database.connection import engine
Base=declarative_base()
class Patient(Base):
__tablename__ = "patients"
id = Column(Integer, primary_key=True, index=True)
username = Column(String(100))
email = Column(String(255), unique=True)
password = Column(String(255))
city = Column(String(100))
state = Column(String(100))
country = Column(String(100))
tumor_type = Column(String(100))
mri_image = Column(LargeBinary)
created_at = Column(DateTime, default=datetime.utcnow)
class ChatMessage(Base):
__tablename__ = "chat_messages"
id = Column(Integer, primary_key=True, index=True)
patient_id = Column(Integer, ForeignKey("patients.id", ondelete="CASCADE"))
patient_query = Column(Text)
bot_response = Column(Text)
timestamp = Column(DateTime, default=datetime.utcnow)
def create_tables():
Base.metadata.create_all(bind=engine)
# if __name__ == "__main__":
# create_tables()
# print("Tables created successfully")
|