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