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