대장내시경

테이블 (8)

Comments (소견)

  • id — int — 기본 키 — NOT NULL
  • comment_user_id — text(500)
  • comment_group_name — varchar(50)
  • comment_description — text
  • comment_contents — text
  • computer_order (computer_order2) — int — 외래 키 → 컴퓨터.computer_order
  • hospital_order (hospital_order2) — int — 외래 키 → 병원.hospital_order — NOT NULL

Copy Of 병원 (CopyOfHospitals)

  • id — int — 기본 키 — NOT NULL
  • Field
  • hospital_name — varchar(50)
  • hospital_address — text(500)
  • hospital_contact — varchar(20)
  • Field2
  • id (id2) — int — 외래 키 → 내시경검사실.id — NOT NULL

Snapshots (사진)

  • id — int — 기본 키 — NOT NULL
  • snapshot_order — interger
  • snapshot_detection_filepath — text
  • snapshot_fullscreen_filepath — text
  • snapshot_plain_filepath — text
  • snapshot_polyp_detected — boolean
  • snapshot_elimination_by_ai — boolean
  • snapshot_elimination_by_doctor — boolean
  • snapshot_group_option — JSONB
  • snapshot_remark — text
  • snapshot_created_at — time
  • hospital_order (hospital_order2) — int — 외래 키 → 병원.hospital_order — NOT NULL
  • computer_order (computer_order2) — int — 외래 키 → 컴퓨터.computer_order
  • exam_order (exam_order2) — int — 외래 키 → 검사.exam_order

Users

  • user_id — varchar(50) — 기본 키 — NOT NULL
  • user_password — varchar(100) — NOT NULL
  • user_name — varchar(50) — NOT NULL
  • user_contact — varchar(100) — NOT NULL
  • user_email — varchar(100)
  • user_sign_filepath — text — NOT NULL
  • user_stay_signed — boolean — NOT NULL
  • user_refresh_token — text
  • hospital_order — int — 외래 키 → 병원.hospital_order — NOT NULL
  • computer_order (computer_order2) — int — 외래 키 → 컴퓨터.computer_order
  • id — int — NOT NULL

검사 (Examinations)

  • exam_order — int — 기본 키
  • exam_type — varchar(50)
  • exam_datetime — timestamptz
  • doctor_id — varchar(50)
  • patient_id — varchar(50)
  • patient_name — varchar(10)
  • exam_period — time — NOT NULL
  • exam_comment — jsonb
  • exam_remark — text
  • exam_cleanliness — json
  • exam_num_of_snapshots — int
  • exam_num_of_eliminated_polyp — varchar(10)
  • exam_snapshot_option — jsonb
  • exam_checked — boolean
  • video_detection_filepath — text
  • video_fullscreen_filepath — text
  • video_plain_filepath — text
  • exam_created_at — timestamptz
  • exam_updated_at — timestamptz
  • pdf_filepath — text
  • snapshot_elimination_group — jsonb
  • snapshot_remark_group — jsonb
  • exam_kakao_time — timestamptz
  • exam_kakao_checked — boolean
  • exam_pdf_time — timestamptz
  • exam_pdf_checked — boolean
  • exam_email_time — timestamptz
  • exam_email_checked — boolean
  • exam_sms_time — timestamptz
  • exam_sms_checked — boolean
  • hospital_order (hospital_order2) — int — 외래 키 → 병원.hospital_order — NOT NULL
  • computer_order (computer_order2) — int — 외래 키 → 컴퓨터.computer_order
  • id — int — NOT NULL

내시경검사실 (EndoscopyRooms)

  • id — int — 기본 키 — NOT NULL
  • endoscopy_room_name — varchar(100)
  • endoscopy_company — varchar(50)
  • endoscopy_product — varchar(50)
  • endoscopy_serial — varchar(300)
  • endoscopy_connection_type — varchar(10)
  • hospital_order (hospital_order2) — int — 외래 키 → 병원.hospital_order — NOT NULL
  • computer_order (computer_order2) — int — 외래 키 → 컴퓨터.computer_order

병원 (Hospitals)

  • hospital_order — int — 기본 키 — NOT NULL
  • hospital_name — varchar(50)
  • hospital_address — text(500)
  • hospital_contact — varchar(20)
  • id — int — NOT NULL

컴퓨터 (Computers)

  • computer_order — int — 기본 키
  • computer_serial — varchar(300)
  • computer_os_version — varchar(50)
  • manager_version — varchar(10)
  • manager_settings — jsonb
  • hospital_order (hospital_order2) — int — 외래 키 → 병원.hospital_order — NOT NULL
  • id — int — NOT NULL