team_django_react

Tables (5)

auth_user

  • id — INT — Primary key
  • password — VARCHAR(128) — NOT NULL
  • last_login — DATETIME
  • 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 — NOT NULL

lung_record

  • id — BIGINT — Primary key — NOT NULL
  • gender — VARCHAR(10)
  • age — INT
  • smoking — TINYINT(1)
  • yellow_fingers — TINYINT(1)
  • anxiety — TINYINT(1)
  • peer_pressure — TINYINT(1)
  • chronic_disease — TINYINT(1)
  • fatigue — TINYINT(1)
  • allergy — TINYINT(1)
  • wheezing — TINYINT(1)
  • alcohol_consuming — TINYINT(1)
  • coughing — TINYINT(1)
  • shortness_of_breath — TINYINT(1)
  • swallowing_difficulty — TINYINT(1)
  • chest_pain — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME
  • patient_id — VARCHAR(10) — Foreign key → patient.id — NOT NULL

lung_result

  • id — BIGINT — Primary key — NOT NULL
  • prediction — VARCHAR(10) — NOT NULL
  • risk_score — DECIMAL(5,2) — NOT NULL
  • created_at — DATETIME
  • lung_record_id — BIGINT — Foreign key → lung_record.id — NOT NULL

medical_record

  • id — BIGINT — Primary key — 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_id — VARCHAR(10) — Foreign key → patient.id — NOT NULL

patient

  • id — VARCHAR(10) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • phone — VARCHAR(20)
  • address — LONGTEXT
  • emergency_contact — VARCHAR(20)
  • blood_type — VARCHAR(5)
  • created_at — DATETIME
  • updated_at — DATETIME
  • age — INT