종피종11_16_1

테이블 (7)

accounts_userprofile

  • id — bigint — 기본 키 — NOT NULL
  • role — varchar(20) — NOT NULL
  • user_id — int — 외래 키 → auth_user.id — NOT NULL

auth_user

  • id — int — 기본 키 — NOT NULL
  • password — varchar(128) — NOT NULL
  • last_login — datetime(6)
  • is_superuser — tinyint(1) — NOT NULL
  • username — varchar(150) — NOT NULL
  • first_name — varchar(150) — NOT NULL
  • last_name — varchar(150) — NOT NULL
  • email — varchar(254) — NOT NULL
  • is_staff — tinyint(1) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • date_joined — datetime(6) — NOT NULL

doctors_doctor

  • id — bigint — 기본 키 — NOT NULL
  • license_number — varchar(50)
  • department — varchar(50) — NOT NULL
  • specialty — varchar(100) — NOT NULL
  • phone_work — varchar(30) — NOT NULL
  • active — tinyint(1) — NOT NULL
  • user_id — int — 외래 키 → auth_user.id — NOT NULL

patients_patient

  • id — bigint — 기본 키 — NOT NULL
  • name — varchar(100) — NOT NULL
  • birth_year — int
  • phone — varchar(20) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • created_by_id — int — 외래 키 → auth_user.id
  • reservation_date — datetime(6)
  • sex — varchar(1)

patients_patient_assigned_doctors

  • id — bigint — 기본 키 — NOT NULL
  • patient_id — bigint — 외래 키 → patients_patient.id — NOT NULL
  • doctor_id — bigint — 외래 키 → doctors_doctor.id — NOT NULL

predictions_predictionresult

  • id — bigint — 기본 키 — NOT NULL
  • model_name — varchar(100) — NOT NULL
  • input_data — json — NOT NULL
  • output_label — int — NOT NULL
  • output_proba — double — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • created_by_id — int — 외래 키 → auth_user.id
  • patient_id — bigint — 외래 키 → patients_patient.id — NOT NULL
  • requested_by_doctor_id — bigint — 외래 키 → doctors_doctor.id

prescription_prescription

  • id — bigint — 기본 키 — NOT NULL
  • title — varchar(200) — NOT NULL
  • content_delta — longtext — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • doctor_id — bigint — 외래 키 → doctors_doctor.id
  • patient_id — bigint — 외래 키 → patients_patient.id