dentruth

Tables (12)

address (주소)

  • id (고유 id) — BigInt — Primary key — NOT NULL
  • city (시/도) — varchar — NOT NULL
  • district (시/군/구) — varchar — NOT NULL
  • detail (상세 주소) — varchar — 암호화
  • created_at (생성 날짜) — Instant — NOT NULL
  • updated_at (변경 날짜) — Instant — NOT NULL

chief_complaints (방문 목적)

  • id (Key) — BigInt — Primary key — NOT NULL
  • visit_purpose (방문 목적) — varchar — NOT NULL — 자
  • appointment_card_id (상담 카드 식별값) — varchar — Foreign key → consult_cards.id — NOT NULL
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL

consult_cards (상담 전 상담 카드)

  • id (Key) — varchar — Primary key — NOT NULL — 보안때문에 UUID로 설정
  • user_id (유저 식별값) — varchar — Foreign key → users.id — NOT NULL
  • date (방문 날짜) — date
  • clinic_name (병원 이름) — varchar — NOT NULL — 자
  • current_status (현재 상황) — varchar — NOT NULL — enum(EMERGENCY, SHORT_STAY, LONG_STAY) 암호화
  • pain_existence (통증 여부) — bool — NOT NULL — true면 pain_area, pain_severity, pain_type, pain_duration 설정
  • pain_location (통증 부위) — varchar — 암호화, 자
  • pain_level (통증 심각도) — varchar — enum(NONE, MILE, MIDERATE, SEVERE)
  • pain_type (통증 기간) — varchar — enum(CONSTANT, INTERMITTENT, GONE)
  • pain_duration (통증 지속 기간) — varchar — 자
  • worried_issue (걱정되는점) — text — 자, 암호화
  • question (궁금한 점) — text — 자, 암호화
  • is_deleted (삭제 여부) — bool — NOT NULL
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL

consult_dental_histories (치과 과거력 매핑)

  • id (Key) — BigInt — Primary key — NOT NULL
  • appointment_card_id (상담 카드 식별값) — varchar — Foreign key → consult_cards.id — NOT NULL
  • dental_history_id (치과 과거력 고유 id) — BigInt — Foreign key → dental_histories.id — NOT NULL — 선택의 경우
  • custom_value (치과 과거력) — varchar — 유저가 직접 입력할 경우(기타), 자
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL

consult_medical_histories (의과 과거력 매핑)

  • id (Key) — BigInt — Primary key — NOT NULL
  • appointment_card_id (상담 카드 식별값) — varchar — Foreign key → consult_cards.id — NOT NULL
  • medical_history_id (의과 과거력 고유 id) — BigInt — Foreign key → medical_histories.id
  • custom_value (의과 과거력) — varchar — 유저가 직접 입력할 경우(기타), 자
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL

consult_session (상담 카드)

  • 카드 id (Key) — Primary key — NOT NULL
  • 추천 질문 (Field)
  • 준비 id (Key2) — varchar — Foreign key → consult_cards.id — NOT NULL — 보안때문에 UUID로 설정

consultation (상담)

  • id (고유 id) — varchar — Primary key — NOT NULL — 보안을 위해 UUID
  • user_id (유저 식별값) — varchar — Foreign key → users.id — NOT NULL
  • audio_link (S3 녹음본 링크) — varchar — 암호화
  • date (상담 날짜) — date — NOT NULL
  • title (제목) — varchar — 자
  • clinic_name (병원 이름) — varchar — NOT NULL — 자
  • diagnostic_result_title (진단 결과) — varchar — 암호화
  • treatment_summary (치료 계획 요약) — varchar — 암호화
  • diagnostic_results (요약본 전체 json 파일) — text — 암호화
  • is_deleted (삭제 여부) — bool — NOT NULL
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL
  • status (ai 요약 진행 상태) — varchar — NOT NULL — enum(UPLOADING, PENDING, ANALYZING, COMPLETED, FAILED, RETRYING)

dental_histories (치과 과거력)

  • id (Key) — BigInt — Primary key — NOT NULL
  • dental_history (치과 과거력) — varchar — NOT NULL
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL

medical_histories (의과 과거력)

  • id (Key) — BigInt — Primary key — NOT NULL
  • medicalHistory (의과 과거력) — varchar — NOT NULL
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL

schedule (일정)

  • id (Key) — BigInt — Primary key — NOT NULL
  • user_id (유저 식별값) — varchar — Foreign key → users.id — NOT NULL
  • date (상담 날짜) — date — NOT NULL
  • time (상담 시간) — time
  • clinic_name (병원 이름) — varchar — 자
  • purpose (방문 목적) — varchar — NOT NULL — 자
  • memo (메모) — varchar — 자
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL
  • consultation_id (고유 id) — varchar — Foreign key → consultation.id — 보안을 위해 UUID
  • consult_card_id (Key2) — varchar — Foreign key → consult_cards.id — 보안때문에 UUID로 설정

social_histories (사회력)

  • id (Key) — BigInt — Primary key — NOT NULL
  • smoking (흡연 여부) — varchar — NOT NULL — enum(L1, L2, L3, NONE)
  • dringking (음주 여부) — varchar — NOT NULL — enum(L1, L2, L3, NONE)
  • exercise (운동 여부) — varchar — NOT NULL — enum(L1, L2, NONE)
  • appointment_card_id (상담 카드 식별값) — varchar — Foreign key → consult_cards.id — NOT NULL
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL

users (유저)

  • id (고유 id) — varchar — Primary key — NOT NULL
  • email (이메일) — varchar — NOT NULL — 자
  • password (비밀번호) — varchar — 암호화
  • user_type (공급자) — varchar — NOT NULL — enum(LOCAL, GOOGLE)
  • name (이름) — varchar — NOT NULL — 자
  • language (언어) — varchar — NOT NULL — enum(ENGLISH, KOREAN, SPAINISH?)
  • birth_date (생년월일) — date — NOT NULL
  • gender (성별) — varchar — NOT NULL — enum(M, F, O, U)
  • stay_duration (체류기간) — varchar — NOT NULL — enum(UNDER_ONE_M, ONE_TO_THREE_M, THREE_TO_SIX_M, OVER_SIX_M)
  • insurance_status (보험 여부) — varchar — NOT NULL — enum(insurance, NOT_insurance, PLANNING)
  • status (유저 계정 상태) — varchar — NOT NULL — enum(GUEST, WITHDRAWN, DELETED, SUSPENDED, BLOCKED, ACTIVE)
  • address_id (주소 식별값) — BigInt — Foreign key → address.id — 주소 식별값
  • created_at (Field) — Instant — NOT NULL
  • updated_at (Field2) — Instant — NOT NULL
  • deleted_at (Field3) — Instant