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