Spaces:
Sleeping
Sleeping
File size: 1,733 Bytes
971e6cc 948e704 971e6cc 24886e1 971e6cc 3a56abd 971e6cc | 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 50 51 52 | 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) |