대장내시경
테이블 (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