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