Douzone

Tables (7)

ai_comments (Ai_comment)

  • comment_id (인조키) — UUID — Primary key — NOT NULL
  • search_id (외래키) — UUID — Foreign key → search_logs.search_id — NOT NULL
  • comment (ai코멘트) — string

clinics (Clinic)

  • clinic_cd (진료코드) — string — Primary key — NOT NULL
  • name (진료명) — string

hospitals (Hospital)

  • hospital_id (인조키) — UUID — Primary key
  • sggu_cd (시군구코드) — string — Foreign key → sigungus.sggu_cd — NOT NULL
  • name (병원명) — string — NOT NULL
  • hospital_url (병원웹주소) — string
  • hospital_addr (병원주소) — string
  • ykiho (요양기호) — string

results (Result)

  • result_id (인조키) — UUID — Primary key — NOT NULL
  • search_id (외래키) — UUID — Foreign key → search_logs.search_id — NOT NULL
  • hospital_name (병원명) — string
  • clinic_name (진료명) — string
  • max_price (최대가격) — string
  • min_price (최소가격) — int
  • hospital_url (병원웹주소) — string
  • hospital_addr (Field) — string

search_logs (Search_log)

  • search_id (인조키) — UUID — Primary key — NOT NULL
  • created_at (생성 시간) — localDateTime
  • search_keyword (검색키워드) — string

sidos (Sido)

  • sido_cd (시도코드) — string — Primary key — NOT NULL
  • name (시도명) — string

sigungus (Sigungu)

  • sggu_cd (시군구코드) — string — Primary key — NOT NULL
  • sido_cd (시도코드) — string — Foreign key → sidos.sido_cd — NOT NULL
  • name (시군구명) — string