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