flutter2

Tables (6)

LungRecord

  • id (record_id) — INT — Primary key
  • id (patient_id2) — INT — Foreign key → Patient.id
  • gender — VARCHAR(10)
  • age — INT
  • smoking — VARCHAR(100)
  • yellow_fingers — BOOLEAN
  • anxiety — BOOLEAN
  • peer_pressure — BOOLEAN
  • chronic_disease — BOOLEAN
  • fatigue — BOOLEAN
  • allergy — BOOLEAN
  • wheezing — BOOLEAN
  • alcohol_consuming — BOOLEAN
  • coughing — BOOLEAN
  • shortness_of_breath — BOOLEAN
  • swallowing_difficulty — BOOLEAN
  • chest_pain — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • patient_id — INT

LungResult

  • id (result_id) — INT — Primary key
  • id (record_id2) — INT — Foreign key → LungRecord.id
  • id (patient_id2) — INT — Foreign key → LungRecord.id
  • prediction — VARCHAR(100)
  • risk_score — FLOAT
  • created_at — DATETIME
  • lung_record_id — INT

MedicalRecord

  • id — INT — Primary key
  • id (patient_id2) — INT — Foreign key → Patient.id
  • name — VARCHAR(100)
  • department — VARCHAR(100)
  • status — VARCHAR(50)
  • notes — TEXT
  • reception_start_time — DATETIME
  • treatement_end_time — DATETIME
  • is_treatment_completed — BOOLEAN
  • patient_id — INT

Patient

  • id (patient_id) — INT — Primary key
  • user_id — INT — Foreign key → auth_user.id
  • name — VARCHAR(100)
  • birth_date — DATE
  • gender — VARCHAR(10)
  • phone — VARCHAR(20)
  • address — VARCHAR(200)
  • emergency_contact — VARCHAR(20)
  • blood_type — VARCHAR(10)
  • created_at — DATETIME
  • updated_at — DATETIME
  • age — INT

UserProfile

  • id — INT — Primary key
  • user_id — INT — Foreign key → auth_user.id
  • role — VARCHAR(50)

auth_user

  • id (user_id) — INT — Primary key
  • password — VARCHAR(128)
  • last_login — DATETIME
  • is_superuser — BOOLEAN
  • username — VARCHAR(150)
  • first_name — VARCHAR(150)
  • last_name — VARCHAR(150)
  • email — VARCHAR(254)
  • is_staff — BOOLEAN
  • is_active — BOOLEAN
  • date_joined — DATETIME