new

Tables (7)

auth_user

  • id — int — Primary key — 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
  • doctor_id — varchar(20)
  • department — varchar(30) — NOT NULL
  • is_staff — tinyint(1) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • date_joined — datetime(6) — NOT NULL

lung_record

  • id — bigint — Primary key — NOT NULL
  • patient_id — char(50) — Foreign key → patients_patient.patient_id — NOT NULL
  • gender — varchar(10) — NOT NULL
  • age — int — NOT NULL
  • smoking — tinyint(1) — NOT NULL
  • yellow_fingers — tinyint(1) — NOT NULL
  • anxiety — tinyint(1) — NOT NULL
  • peer_pressure — tinyint(1) — NOT NULL
  • chronic_disease — tinyint(1) — NOT NULL
  • fatigue — tinyint(1) — NOT NULL
  • allergy — tinyint(1) — NOT NULL
  • wheezing — tinyint(1) — NOT NULL
  • alcohol_consuming — tinyint(1) — NOT NULL
  • coughing — tinyint(1) — NOT NULL
  • shortness_of_breath — tinyint(1) — NOT NULL
  • swallowing_difficulty — tinyint(1) — NOT NULL
  • chest_pain — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • patient_fk_id — bigint — Foreign key → patients_patient.id — NOT NULL

lung_result

  • id — bigint — Primary key — NOT NULL
  • lung_record_id — bigint — Foreign key → lung_record.id
  • prediction — varchar(10) — NOT NULL
  • risk_score — decimal(5,2) — NOT NULL
  • created_at — datetime(6) — NOT NULL

medical_record

  • id — bigint — Primary key — NOT NULL
  • patient_id — varchar(10) — NOT NULL
  • name — varchar(100) — NOT NULL
  • department — varchar(20) — NOT NULL
  • status — varchar(20) — NOT NULL
  • notes — longtext
  • reception_start_time — datetime(6) — NOT NULL
  • treatment_end_time — datetime(6)
  • is_treatment_completed — tinyint(1) — NOT NULL
  • patient_fk_id — bigint — Foreign key → patients_patient.id — NOT NULL
  • doctor_fk_id — int — Foreign key → auth_user.id

patient_user

  • id — bigint — Primary key — NOT NULL
  • password — varchar(128) — NOT NULL
  • last_login — datetime(6)
  • is_superuser — tinyint(1) — NOT NULL
  • account_id — varchar(50) — NOT NULL
  • email — varchar(254) — NOT NULL
  • name — varchar(100) — NOT NULL
  • patient_id — varchar(50) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • is_staff — tinyint(1) — NOT NULL
  • date_joined — datetime(6) — NOT NULL

patients_appointment

  • id — char(32) — Primary key — NOT NULL
  • title — varchar(200) — NOT NULL
  • type — varchar(30) — NOT NULL
  • start_time — datetime(6) — NOT NULL
  • end_time — datetime(6)
  • patient_identifier — varchar(50) — NOT NULL
  • patient_name — varchar(100) — NOT NULL
  • patient_gender — varchar(1) — NOT NULL
  • patient_age — int
  • doctor_code — varchar(20) — NOT NULL
  • doctor_username — varchar(150) — NOT NULL
  • doctor_name — varchar(150) — NOT NULL
  • doctor_department — varchar(30) — NOT NULL
  • status — varchar(20) — NOT NULL
  • memo — longtext — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • created_by_id — int — Foreign key → auth_user.id
  • doctor_id — int — Foreign key → auth_user.id — NOT NULL
  • patient_id — bigint — Foreign key → patients_patient.id

patients_patient

  • id — bigint — Primary key — NOT NULL
  • patient_id — varchar(50) — NOT NULL
  • name — varchar(100) — NOT NULL
  • birth_date — date
  • age — int
  • blood_type — varchar(5)
  • gender — varchar(1)
  • phone — varchar(20) — NOT NULL
  • address — longtext — NOT NULL
  • emergency_contact — varchar(100) — NOT NULL
  • medical_history — longtext — NOT NULL
  • allergies — longtext — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • user_account_id — bigint — Foreign key → patient_user.id — NOT NULL