test2
Tables (22)
auth_group
- id — int — Primary key — NOT NULL
- name — varchar(150) — NOT NULL
auth_group_permissions
- id — bigint — Primary key — NOT NULL
- group_id — int — Foreign key → auth_group.id — NOT NULL
- permission_id — int — Foreign key → auth_permission.id — NOT NULL
auth_permission
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- content_type_id — int — Foreign key → django_content_type.id — NOT NULL
- codename — varchar(100) — NOT NULL
authentication_myuser
- id — bigint — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime(6)
- is_superuser — tinyint(1) — NOT NULL
- username — varchar(150) — NOT NULL
- email — varchar(254) — NOT NULL
- is_staff — tinyint(1) — NOT NULL
- date_of_birth — date — NOT NULL
- user_type — int — NOT NULL
- is_admin — tinyint(1) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- date_joined — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- last_password_updated — datetime(6) — NOT NULL
authentication_myuser_groups
- id — bigint — Primary key — NOT NULL
- myuser_id — bigint — Foreign key → authentication_myuser.id — NOT NULL
- group_id — int — Foreign key → auth_group.id — NOT NULL
authentication_myuser_user_permissions
- id — bigint — Primary key — NOT NULL
- myuser_id — bigint — Foreign key → authentication_myuser.id — NOT NULL
- permission_id — int — Foreign key → auth_permission.id — NOT NULL
device_device
- id — bigint — Primary key — NOT NULL
- is_removed — tinyint(1) — NOT NULL
- device_type — int — NOT NULL
- serial_number — varchar(50) — NOT NULL
- firmware_ver — varchar(50)
- manufacturer — varchar(50)
- manufacturing_date — date
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
device_patchdevice
- device_ptr_id — bigint — Foreign key → device_device.id — NOT NULL
- patch_type — int — NOT NULL
django_admin_log
- id — int — Primary key — NOT NULL
- action_time — datetime(6) — NOT NULL
- object_id — longtext
- object_repr — varchar(200) — NOT NULL
- action_flag — smallint — NOT NULL
- change_message — longtext — NOT NULL
- content_type_id — int — Foreign key → django_content_type.id
- user_id — bigint — Foreign key → authentication_myuser.id — NOT NULL
django_content_type
- id — int — Primary key — NOT NULL
- app_label — varchar(100) — NOT NULL
- model — varchar(100) — NOT NULL
django_migrations
- id — bigint — Primary key — NOT NULL
- app — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- applied — datetime(6) — NOT NULL
django_session
- session_key — varchar(40) — Primary key — NOT NULL
- session_data — longtext — NOT NULL
- expire_date — datetime(6) — NOT NULL
ecg_test_ecgtest
- id — bigint — Primary key — NOT NULL
- tid — char(32) — NOT NULL
- ecg_test_status — int — NOT NULL
- hospital_name — varchar(100)
- wing_name — varchar(100)
- ward_name — varchar(100)
- bed_name — varchar(100)
- doctor_name — varchar(100)
- prescription_duration — int — NOT NULL
- time_zone — varchar(63) — NOT NULL
- comment — longtext
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_removed — tinyint(1) — NOT NULL
- device_id — bigint — Foreign key → device_patchdevice.device_ptr_id — NOT NULL
- gateway_id — bigint — Foreign key → gateway_gateway.id — NOT NULL
- patient_id — bigint — Foreign key → patient_patient.id — NOT NULL
gateway_gateway
- id — bigint — Primary key — NOT NULL
- is_removed — tinyint(1) — NOT NULL
- serial_number — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- ip — varchar(50) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- wing_id — bigint — Foreign key → hospital_wing.id — NOT NULL
hospital_bed
- id — bigint — Primary key — NOT NULL
- is_removed — tinyint(1) — NOT NULL
- bed_name — varchar(150) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- doctor_id — bigint — Foreign key → medical_staff_medicalstaff.myuser_ptr_id — NOT NULL
- hospital_id — bigint — Foreign key → hospital_hospital.id — NOT NULL
- ward_id — bigint — Foreign key → hospital_ward.id — NOT NULL
- wing_id — bigint — Foreign key → hospital_wing.id — NOT NULL
hospital_hospital
- id — bigint — Primary key — NOT NULL
- is_removed — tinyint(1) — NOT NULL
- hospital_name — varchar(150) — NOT NULL
- hospital_scale — int — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
hospital_ward
- id — bigint — Primary key — NOT NULL
- is_removed — tinyint(1) — NOT NULL
- ward_name — varchar(150) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- hospital_id — bigint — Foreign key → hospital_hospital.id — NOT NULL
- wing_id — bigint — Foreign key → hospital_wing.id — NOT NULL
hospital_wing
- id — bigint — Primary key — NOT NULL
- is_removed — tinyint(1) — NOT NULL
- wing_name — varchar(150) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- hospital_id — bigint — Foreign key → hospital_hospital.id — NOT NULL
medical_staff_medicalstaff
- myuser_ptr_id — bigint — Foreign key → authentication_myuser.id — NOT NULL
- staff_type — int — NOT NULL
- access_level — int — NOT NULL
- is_hospital_admin — tinyint(1) — NOT NULL
- hospital_name — varchar(150) — NOT NULL
patient_patient
- id — bigint — Primary key — NOT NULL
- is_removed — tinyint(1) — NOT NULL
- patient_number — varchar(30) — NOT NULL
- patient_name — varchar(100) — NOT NULL
- patient_sex — varchar(2) — NOT NULL
- patient_phone_number — varchar(30) — NOT NULL
- patient_birth — date — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
token_blacklist_blacklistedtoken
- id — bigint — Primary key — NOT NULL
- blacklisted_at — datetime(6) — NOT NULL
- token_id — bigint — Foreign key → token_blacklist_outstandingtoken.id — NOT NULL
token_blacklist_outstandingtoken
- id — bigint — Primary key — NOT NULL
- token — longtext — NOT NULL
- created_at — datetime(6)
- expires_at — datetime(6) — NOT NULL
- user_id — bigint — Foreign key → authentication_myuser.id
- jti — varchar(255) — NOT NULL