doctoreye

Tables (5)

Diseases (질병)

  • DiseaseId (disease_id) — UUIDField — Primary key — NOT NULL
  • EyeImageId (eyeimage_id) — UUIDField — Foreign key → EyeImage(SoftDeletableModel).EyeImageId — NOT NULL
  • 병명1 — CharField(choice)
  • 병명2 — CharField(choice)
  • 병명3 — CharField(choice)

Doctors(SoftDeletableModel) (의사정보(권한체크))

  • DoctorId (doctor_id) — UUIDField — Primary key — NOT NULL
  • USERID (user_id) — UUIDField — Foreign key → Users(SoftDeletableModel).USERID — NOT NULL
  • Name (name) — EncryptedCharField

EyeImage(SoftDeletableModel) (안저이미지)

  • EyeImageId (eyeimage_id) — UUIDField — Primary key — NOT NULL
  • PatientId (patient_id) — UUIDField — Foreign key → Patients(SoftDeletableModel).PatientId — NOT NULL
  • LeftSide (leftside) — ImageField(null=True, blank=True)
  • Rightside (rightside) — ImageField(null=True, blank=True)

Patients(SoftDeletableModel) (환자정보)

  • PatientId (patient_id) — UUIDField — Primary key — NOT NULL
  • DoctorId (doctor_id) — UUIDField — Foreign key → Doctors(SoftDeletableModel).DoctorId — NOT NULL
  • PatientName (patient_name) — EncryptedCharField
  • PatientGender (patient_gender) — CharField(max_length=1)
  • PatientAge (patient_age) — PositiveSmallIntegerField

Users(SoftDeletableModel) (모든유저)

  • USERID (user_id) — UUIDField — Primary key — NOT NULL
  • Account (account) — EncryptedcharField
  • Password (password) — EncryptedcharField