flutter3
Tables (6)
LungRecord
- record_id — INT
- patient_id — INT
- 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
LungResult
- result_id — INT
- record_id — INT
- prediction — VARCHAR(100)
- risk_score — FLOAT
- created_at — DATETIME
MedicalRecord
- record_id — INT
- patient_id — INT
- name — VARCHAR(100)
- department — VARCHAR(100)
- status — VARCHAR(50)
- notes — TEXT
- reception_start_time — DATETIME
- treatement_end_time — DATETIME
- is_treatment_completed — BOOLEAN
Patient
- patient_id — INT
- user_id — INT
- 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
- profile_id — INT — Primary key
- user_id — INT
- role — VARCHAR(50)
auth_user
- 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