team_django_flutter
Tables (6)
UserProfile (Untitled)
- id (use_id) — INT — Foreign key → auth_user.id
- role — VARCHAR(20)
auth_user
- id (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 (record_id) — INT — Primary key — NOT NULL
- id (user_id) — INT — Foreign key → patient.id
- 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
lung_result
- id (record_id) — INT — Foreign key
- lung_record_id — BIGINT
- prediction — VARCHAR(10) — NOT NULL
- risk_score — DECIMAL(5,2) — NOT NULL
- created_at — DATETIME
medical_record
- id — INT — Foreign key → patient.id
- Key — Foreign key → patient.id — 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 (patient_id) — VARCHAR(10) — Primary key — NOT NULL
- id (user_id) — INT — Foreign key → auth_user.id
- 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