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