models.py

from sqlalchemy import Column, Integer, String, Text, ForeignKey
from sqlalchemy.orm import declarative_base

Base = declarative_base()
    
# 病患資料
class Patient(Base):
    __tablename__ = "patients"

    id = Column(Integer, primary_key=True, index=True)
    mrn = Column(String, nullable=False)
    name = Column(String, nullable=False)
    birth = Column(String, nullable=True)
    gender = Column(String, nullable=True)
    phone = Column(String, nullable=True)
    email = Column(String, nullable=True)

    emg_name = Column(String, nullable=True)
    emg_phone = Column(String, nullable=True)
    emg_relation = Column(String, nullable=True)

    room = Column(String, nullable=False)
    department = Column(String, nullable=False)
    doctor = Column(String, nullable=True)
    diagnosis = Column(String, nullable=False)
    risk = Column(String, nullable=False)
    admit_date = Column(String, nullable=False)


# 護士資料
class Nurse(Base):
    __tablename__ = "nurses"

    id = Column(Integer, primary_key=True, index=True)
    name = Column(String, nullable=False)
    staff_id = Column(String, nullable=False, unique=True)
    password = Column(String, nullable=False)
    department = Column(String, nullable=True)
    position = Column(String, nullable=True)
    phone = Column(String, nullable=True)
    email = Column(String, nullable=True)


# 護理紀錄
class Record(Base):
    __tablename__ = "records"

    id = Column(Integer, primary_key=True, index=True)
    patient_id = Column(Integer, ForeignKey("patients.id"), nullable=False)
    nurse_id = Column(Integer, ForeignKey("nurses.id"), nullable=False)
    content = Column(Text, nullable=False)
    created_at = Column(String, nullable=False)