new
Tables (7)
auth_user
- id — int — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime(6)
- 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
- doctor_id — varchar(20)
- department — varchar(30) — NOT NULL
- is_staff — tinyint(1) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- date_joined — datetime(6) — NOT NULL
lung_record
- id — bigint — Primary key — NOT NULL
- patient_id — char(50) — Foreign key → patients_patient.patient_id — NOT NULL
- gender — varchar(10) — NOT NULL
- age — int — NOT NULL
- smoking — tinyint(1) — NOT NULL
- yellow_fingers — tinyint(1) — NOT NULL
- anxiety — tinyint(1) — NOT NULL
- peer_pressure — tinyint(1) — NOT NULL
- chronic_disease — tinyint(1) — NOT NULL
- fatigue — tinyint(1) — NOT NULL
- allergy — tinyint(1) — NOT NULL
- wheezing — tinyint(1) — NOT NULL
- alcohol_consuming — tinyint(1) — NOT NULL
- coughing — tinyint(1) — NOT NULL
- shortness_of_breath — tinyint(1) — NOT NULL
- swallowing_difficulty — tinyint(1) — NOT NULL
- chest_pain — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- patient_fk_id — bigint — Foreign key → patients_patient.id — NOT NULL
lung_result
- id — bigint — Primary key — NOT NULL
- lung_record_id — bigint — Foreign key → lung_record.id
- prediction — varchar(10) — NOT NULL
- risk_score — decimal(5,2) — NOT NULL
- created_at — datetime(6) — NOT NULL
medical_record
- id — bigint — Primary key — NOT NULL
- patient_id — varchar(10) — 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_fk_id — bigint — Foreign key → patients_patient.id — NOT NULL
- doctor_fk_id — int — Foreign key → auth_user.id
patient_user
- id — bigint — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime(6)
- is_superuser — tinyint(1) — NOT NULL
- account_id — varchar(50) — NOT NULL
- email — varchar(254) — NOT NULL
- name — varchar(100) — NOT NULL
- patient_id — varchar(50) — NOT NULL
- phone — varchar(20) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- is_staff — tinyint(1) — NOT NULL
- date_joined — datetime(6) — NOT NULL
patients_appointment
- id — char(32) — Primary key — NOT NULL
- title — varchar(200) — NOT NULL
- type — varchar(30) — NOT NULL
- start_time — datetime(6) — NOT NULL
- end_time — datetime(6)
- patient_identifier — varchar(50) — NOT NULL
- patient_name — varchar(100) — NOT NULL
- patient_gender — varchar(1) — NOT NULL
- patient_age — int
- doctor_code — varchar(20) — NOT NULL
- doctor_username — varchar(150) — NOT NULL
- doctor_name — varchar(150) — NOT NULL
- doctor_department — varchar(30) — NOT NULL
- status — varchar(20) — NOT NULL
- memo — longtext — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- created_by_id — int — Foreign key → auth_user.id
- doctor_id — int — Foreign key → auth_user.id — NOT NULL
- patient_id — bigint — Foreign key → patients_patient.id
patients_patient
- id — bigint — Primary key — NOT NULL
- patient_id — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- birth_date — date
- age — int
- blood_type — varchar(5)
- gender — varchar(1)
- phone — varchar(20) — NOT NULL
- address — longtext — NOT NULL
- emergency_contact — varchar(100) — NOT NULL
- medical_history — longtext — NOT NULL
- allergies — longtext — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_account_id — bigint — Foreign key → patient_user.id — NOT NULL