종피종11_16_1
테이블 (7)
accounts_userprofile
- id — bigint — 기본 키 — NOT NULL
- role — varchar(20) — NOT NULL
- user_id — int — 외래 키 → auth_user.id — NOT NULL
auth_user
- id — int — 기본 키 — 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
- is_staff — tinyint(1) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- date_joined — datetime(6) — NOT NULL
doctors_doctor
- id — bigint — 기본 키 — NOT NULL
- license_number — varchar(50)
- department — varchar(50) — NOT NULL
- specialty — varchar(100) — NOT NULL
- phone_work — varchar(30) — NOT NULL
- active — tinyint(1) — NOT NULL
- user_id — int — 외래 키 → auth_user.id — NOT NULL
patients_patient
- id — bigint — 기본 키 — NOT NULL
- name — varchar(100) — NOT NULL
- birth_year — int
- phone — varchar(20) — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by_id — int — 외래 키 → auth_user.id
- reservation_date — datetime(6)
- sex — varchar(1)
patients_patient_assigned_doctors
- id — bigint — 기본 키 — NOT NULL
- patient_id — bigint — 외래 키 → patients_patient.id — NOT NULL
- doctor_id — bigint — 외래 키 → doctors_doctor.id — NOT NULL
predictions_predictionresult
- id — bigint — 기본 키 — NOT NULL
- model_name — varchar(100) — NOT NULL
- input_data — json — NOT NULL
- output_label — int — NOT NULL
- output_proba — double — NOT NULL
- created_at — datetime(6) — NOT NULL
- created_by_id — int — 외래 키 → auth_user.id
- patient_id — bigint — 외래 키 → patients_patient.id — NOT NULL
- requested_by_doctor_id — bigint — 외래 키 → doctors_doctor.id
prescription_prescription
- id — bigint — 기본 키 — NOT NULL
- title — varchar(200) — NOT NULL
- content_delta — longtext — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- doctor_id — bigint — 외래 키 → doctors_doctor.id
- patient_id — bigint — 외래 키 → patients_patient.id