DAIA
Tables (25)
AiOutputs (AI 분석 결과)
- ai_output_id (Key) — uuid — Primary key — NOT NULL
- ai_run_id (AI 분석 결과 ID) — uuid — Foreign key → AiRuns.ai_run_id — NOT NULL
- image_id (이미지 ID) — uuid — Foreign key → Images.Image_id — NOT NULL
- confidence (AI 신뢰도) — float
- category (질환 종류) — varchar — NOT NULL — CARIES, CALCULUS, PERIAPICAL, IMPACTED, IMPLANT_LOSS, ABRASION, TMJ
- tooth_number (치아 번호) — int — NOT NULL
- surface (치면) — varchar
- geometry (AI가 인식한 영역 좌표) — json — NOT NULL
- color_hex (색상값) — char — NOT NULL
- level (중증도) — int — NOT NULL — 1~3 단계
- ai_treatment_items (AI 추천 치료 방법) — varchar[] — INLAY, ROOT_CANAL_TREATMENT, RETREATMENT, PERIODONTAL_TREATMENT, SCALING, EXTRACTION, IMPLANT, OTHER
- created_at (생성일) — timestamptz — NOT NULL
- copy_from_annotation_id (원본 표식 ID) — uuid
- copy_from_treatment_item_id (원본 치료 계획 항목 ID) — uuid
AiRuns (AI 실행 이력)
- ai_run_id (Key) — uuid — Primary key — NOT NULL
- exam_id (진단 ID) — uuid — Foreign key → Exams.exam_id — NOT NULL
- model_name (AI 모델명) — varchar — NOT NULL
- model_version (버전) — varchar
- params (실행 파라미터) — json — NOT NULL
- status (실행 상태) — varchar — NOT NULL — QUEUED, RUNNING, SUCCEEDED, FAILED
- started_at (시작 시간) — timestamp — NOT NULL
- finished_at (완료 시간) — timestamp
- log_uri (로그 파일 위치) — varchar
AnnotationHistory (과거 표식)
- ai_output_id (AI 분석 ID) — uuid — Foreign key → AiOutputs.ai_output_id — NOT NULL
- annotaion_id (표식 ID) — uuid — Foreign key → Annotations.annotaion_id — NOT NULL
- created_at (생성일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
Annotations (표식)
- annotaion_id (표식 ID) — uuid — Primary key — NOT NULL
- exam_id (진단 ID) — uuid — Foreign key → Exams.exam_id — NOT NULL
- image_id (이미지 ID) — uuid — Foreign key → Images.Image_id — NOT NULL
- patients_id (환자 ID) — uuid — Foreign key → Patients.patients_id — NOT NULL
- ai_output_id (AI 진단 ID) — uuid — Foreign key → AiOutputs.ai_output_id — NOT NULL
- copy_from_id (원본 표식 ID) — uuid
- category (질환 분류) — varchar — NOT NULL — CARIES, CALCULUS, PERIAPICAL, IMPACTED, IMPLANT_LOSS, ABRASION, TMJ
- tooth_number (치아번호) — int — NOT NULL
- surface (치면) — varchar — NOT NULL
- geometry (도형 좌표) — json — NOT NULL
- color_hex (도형 색상값) — char — NOT NULL
- source (생성 주체) — varhar — NOT NULL — HUMAN AI
- confidence (AI 신뢰도) — float
- level (중증도) — int — NOT NULL — 1~3단계
- status (상태) — varchar — NOT NULL — OPEN, CONFIRMED, DISMISSED
- treatment_items (치료 항목) — varchar[] — INLAY, ROOT_CANAL_TREATMENT, RETREATMENT, PERIODONTAL_TREATMENT, SCALING, EXTRACTION, IMPLANT, OTHER
- note (비고) — varchar
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
AuditLogs (감사 로그)
- log_id (Key) — uuid — Primary key — NOT NULL
- exam_id (진단 ID) — uuid — Foreign key → Exams.exam_id — NOT NULL
- user_id (조작한 사용자 ID) — uuid — Foreign key → Users.user_id — NOT NULL
- entity (변경된 엔티티명) — varchar — NOT NULL
- action (동작) — varchar — NOT NULL — CREATE, UPDATE, DELETE
- before (변경 전 데이터) — json
- after (변경 후 데이터) — json — NOT NULL
- created_at (생성일) — timestamptz — NOT NULL
- ip (아이피) — varchar — NOT NULL
- body (바디값) — json
DeletedLogs (삭제 항목 로그)
- user_id (사용자 ID) — uuid — Foreign key → Users.user_id — NOT NULL
- deleted_log_id (삭제 항목 로그 ID) — uuid — NOT NULL
- ip (아이피) — varchar — NOT NULL
- endpoint (엔드포인트) — varchar — NOT NULL
- body (호출 값) — json — NOT NULL
- created_at (생성일) — timestamptz — NOT NULL
Draws (그림)
- draw_id (그림 ID) — uuid — Primary key — NOT NULL
- draw (그림) — json
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
- type (이미지 타입) — enum — NOT NULL — PANO, PERI
- image_id (이미지 ID) — uuid — Foreign key → Images.Image_id — NOT NULL
EmailVerification (회원가입/비밀번호 재설정용 인증 코드)
- 재설정용 인증 ID (email_verification_id) — uuid — Primary key — NOT NULL
- user_id (사용자 ID) — uuid — Foreign key → Users.user_id — NOT NULL
- email (이메일) — varchar — NOT NULL
- codeHash (코드) — varchar — NOT NULL
- verificationToken (토큰) — varchar — NOT NULL
- attemptCount (인증 시도 횟수) — int — NOT NULL
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- expires_at (만료일) — timestampz — NOT NULL
- tokenHash (Field) — string
- resendCount (Field2) — int — NOT NULL
- verifiedAt (Field3) — datetime
- lastSentAt (Field4) — datetime
- type (인증 타입) — enum — NOT NULL
Exams (진단)
- exam_id (진단 ID) — uuid — Primary key — NOT NULL
- hospital_id (병원 ID) — uuid — Foreign key → hospital.hospital_id — NOT NULL
- doctor_id (담당의 ID) — uuid — Foreign key → Users.user_id — NOT NULL
- patient_id (환자 ID) — uuid — Foreign key → Patients.patients_id — NOT NULL
- chart_num (차트 번호) — varchar — NOT NULL
- exam_date (진단일) — datetime — NOT NULL
- status (진단 상태) — varchar — NOT NULL — PENDING, ADDITIONAL_IMAGING, DIAGNOSING, DIAGNOSED, COUNSELED
- additional_image_tooth_numbers (추가 촬영 치아) — int[]
- note (비고) — varchar
- saveStatus (저장 상태) — enum — NOT NULL — TEMP , FINAL
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
HospitalProcedurePrices (병원별 진료 항목 가격)
- id (항목 ID) — uuid — Primary key — NOT NULL
- hospital_id (병원 ID) — uuid — Foreign key → hospital.hospital_id — NOT NULL
- category (중분류) — string — NOT NULL
- subcategory (소분류) — string — NOT NULL
- detail_category (상세분류) — string — NOT NULL
- min_price (최소금액) — int — NOT NULL
- max_price (최대금액) — int — NOT NULL
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
Images (이미지)
- Image_id (파노라마 이미지 ID) — uuid — Primary key — NOT NULL
- patients_id (환자 ID) — uuid — Foreign key → Patients.patients_id — NOT NULL
- hospital_id (병원 ID) — uuid — Foreign key → hospital.hospital_id — NOT NULL
- type (이미지 타입) — varchar — NOT NULL — ORIGINAL, THUMB, TILED
- uri (경로) — varchar — NOT NULL
- width (픽셀 너비) — int — NOT NULL
- height (픽셀 높이) — int — NOT NULL
- pixel_spacing_x (1픽셀 당 실제 거리 mm x축) — float — NOT NULL
- pixel_spacing_y (1픽셀 당 실제 거리 mm y축) — float — NOT NULL
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- tooth_number (치아 번호) — int[]
- modality (촬영 종류) — enum — NOT NULL — PANORAMIC, PERIAPICAL
- device_info (촬영 장비명) — varchar
Measurements (측정값)
- measurement_id (측정값 ID) — uuid — Primary key — NOT NULL
- exam_id (진단 ID) — uuid — Foreign key → Exams.exam_id — NOT NULL
- image_id (이미지 ID) — uuid — Foreign key → Images.Image_id — NOT NULL
- type (측정 유형) — varchar — NOT NULL — EDJ_TO_BONE, LENGTH, ANGLE, DEPTH, CUSTOM
- value (측정값) — float — NOT NULL
- unit (측정 단위) — varchar — NOT NULL
- points (측정 지점 좌표) — json — NOT NULL
- created_at (생성일) — timestamptz — NOT NULL
MissingTeeth (상실 치아)
- missing_tooth_id (상실 치아 ID) — uuid — Primary key — NOT NULL
- exam_id (진단 ID) — uuid — Foreign key → Exams.exam_id — NOT NULL
- tooth_number (치아 번호) — int — NOT NULL
- status (상태) — Enum — NOT NULL — 발치, 발치 예정, 보철 치료 항목 ...
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
PartnerGroups (병원 별 파트너)
- partner_group_id (파트너 그룹 ID) — int — Primary key — NOT NULL
- partner_id (파트너 ID) — int — Foreign key → Partners.partner_id — NOT NULL
- status (상태) — enum — NOT NULL — ACTIVE, INACTIVE
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
Partners (파트너)
- partner_id (파트너 ID) — int — Primary key — NOT NULL
- status (상태) — enum — NOT NULL — ACTIVE, INACTIVE
- name (이름) — varchar — NOT NULL
- email (이메일) — varchar — NOT NULL — unique
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
Patients (환자)
- patients_id (환자 ID) — uuid — Primary key — NOT NULL
- doctor_id (주치의 ID) — uuid — Foreign key → Users.user_id — NOT NULL
- name (이름) — varchar — NOT NULL
- gender (성별) — varchar — MALE, FEMALE, UNKNOWN
- birth_date (생년월일) — date
- phone (연락처) — varchar — NOT NULL
- email (이메일) — varchar
- address (주소) — varchar
- latest_exam_id (최신 진단 ID) — uuid
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
ProstheticItems (보철 치료 항목)
- prosthetic_item_id (보철 치료 항목 ID) — uuid — Primary key — NOT NULL
- prosthetic_plan_id (보철 치료 계획 ID) — uuid — Foreign key → ProstheticPlans.prosthetic_plan_id — NOT NULL
- tooth_number (치아번호) — int — NOT NULL
- treatment_items (치료 항목) — varchar — NOT NULL — 임플란트, 치아 각각의 치료 항목
- note (비고) — text
ProstheticPlans (보철 치료 계획)
- prosthetic_plan_id (보철 치료 계획 ID) — uuid — Primary key — NOT NULL
- exam_id (진단 ID) — uuid — Foreign key → Exams.exam_id — NOT NULL
- treatment_plan_id (치료 계획 ID) — uuid — Foreign key → TreatmentPlans.treatment_plan_id — NOT NULL
- prosthetic_type (보철 치료 케이스) — varchar — NOT NULL — 임플란트, 틀니, 브릿지...
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
TreatmentGroups (치료 항목 별 그룹)
- treatment_group_id (치료 항목 별 그룹 ID) — uuid — Primary key — NOT NULL
- treatment_plan_id (치료 계획 ID) — uuid — Foreign key → TreatmentPlans.treatment_plan_id — NOT NULL
- category (병변 타입) — varchar — NOT NULL — CARIES, CALCULUS, PERIAPICAL, IMPACTED, IMPLANT_LOSS, ABRASION, TMJ
- treatment_item_types (치료 계획 아이템) — varchar — INLAY, ROOT_CANAL_TREATMENT, RETREATMENT, PERIODONTAL_TREATMENT, SCALING, EXTRACTION, IMPLANT, OTHER
- status (상태) — varchar — NOT NULL — 미확정, 진행중, 확정, 취소
- note (비고) — varchar
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz
- deleted_at (삭제일) — timestamptz
TreatmentItems (치료 항목)
- treatment_item_id (치료 항목 ID) — uuid — Primary key — NOT NULL
- treatment_plan_id (치료 계획 ID) — uuid — Foreign key → TreatmentPlans.treatment_plan_id — NOT NULL
- treatment_group_id (치료 항목 별 그룹 ID) — uuid — Foreign key → TreatmentGroups.treatment_group_id — NOT NULL
- tooth_number (치아 번호) — varchar — NOT NULL
- surface (치면) — varchar
- procedure_code (처치 코드) — varchar — NOT NULL — 보험 자체
- title (항목 이름) — varchar — NOT NULL
- quantity (수량) — int — NOT NULL
- unit_price (단가) — int — NOT NULL
- recommended_by (추천자) — varchar — NOT NULL — AI, HUMAN
- reason_text (추천 근거) — varchar
- accepted (확정 여부) — boolean — NOT NULL
- order_index (정렬 순서) — int — NOT NULL
- note (비고) — varchar
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
- copy_from_id (원본 치료 항목 ID) — uuid
TreatmentPlans (치료계획)
- treatment_plan_id (치료 계획 ID) — uuid — Primary key — NOT NULL
- exam_id (진단 ID) — uuid — Foreign key → Exams.exam_id — NOT NULL
- writer_id (작성자 ID) — uuid — Foreign key → Users.user_id — NOT NULL
- editor_id (수정자 ID) — uuid — Foreign key → Users.user_id — NOT NULL
- doctor_id (담당의 ID) — uuid — Foreign key → Users.user_id — NOT NULL
- consultant_id (상담사 ID) — uuid — Foreign key → Users.user_id — NOT NULL
- version (버전) — int — NOT NULL
- status (상태) — varchar — NOT NULL — DRAFT, FINAL, COUNSELED
- total_cost (총 비용) — int — NOT NULL
- note (비고) — varchar
- discount (할인금액) — int
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
Users (병원 사용자)
- user_id (사용자 ID) — uuid — Primary key — NOT NULL
- hospital_id (병원 ID) — uuid — Foreign key → hospital.hospital_id
- role_id (역할ID) — uuid — Foreign key → roles.role_id — NOT NULL
- label (권한) — enum — ORIGIN_ADMIN
- status (상태) — enum — NOT NULL — ACTIVE, INACTIVE
- name (이름) — varchar — NOT NULL
- email (이메일) — varchar — NOT NULL — unique
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
- promotionEmailConsent (프로모션 메일 수신 여부) — boolean — NOT NULL
- refreshToken (리프레시 토큰) — string
- sessionId (세션 아이디) — string
- passwordResetCodeHash (비밀번호 재설정용 이메일 인증코드 해시) — string
- passwordResetCodeExpiresAt (비밀번호 재설정용 코드 만료 시각) — datetime
- password_changed_at (비밀번호 변경 시각) — datetime
hospital (병원)
- hospital_id (병원 ID) — uuid — Primary key — NOT NULL
- business_no (사업자등록번호) — varchar — NOT NULL — 의료기관 개설신고번호가 필요한건지 확인 필요
- name (병원명) — varchar — NOT NULL
- address (주소) — varchar — NOT NULL
- isPromoAddreed (광고 메일 수신 여부) — boolean — NOT NULL
- latitude (Field) — float
- longitude (Field2) — float
- is_open (영업 활성 여부) — boolean — NOT NULL
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
hospital_role_licenses (병원 별 권한)
- role_license_id (병원 별 권한 ID) — uuid — Primary key — NOT NULL
- hospital_id (병원 ID) — uuid — Foreign key → hospital.hospital_id — NOT NULL
- role_id (역할ID) — uuid — Foreign key → roles.role_id — NOT NULL
- billing_cycle (결제 주기) — varchar — NOT NULL — YEARLY, MONTHLY
- seat_limit (권한 갯수) — int — NOT NULL
- starts_at (권한 부여 시작일) — date — NOT NULL
- ends_at (권한 유효기간) — date — null인 경우 유효기간 없음
- created_at (생성일) — timestamptz — NOT NULL
- updated_at (수정일) — timestamptz — NOT NULL
- deleted_at (삭제일) — timestamptz
roles (역할)
- role_id (역할ID) — uuid — Primary key — NOT NULL
- code (코드) — varchar — NOT NULL — ADMIN, DENTIST, CONSULTANT, NURSE, VIEWER
- label (표시명) — varchar — NOT NULL — ex) 관리자, 의사, 상담사, 간호사, 관찰자
- unit_price (권한 별 가격) — int — NOT NULL
- created_at (생성일) — timestamptz — NOT NULL