scraper

Tables (6)

kakao_info (kakao 정보)

  • id — NOT NULL — Primary key — NOT NULL
  • place_id (카카오 ID) — NOT NULL — Foreign key → kcd_info.id — NOT NULL
  • place_name (사업장명) — NOT NULL
  • address (주소) — NULL
  • tel (전화번호) — NULL
  • platform (플랫폼명) — NULL
  • task_id (task Id) — NOT NULL — Foreign key → scraping_jobs.id — NOT NULL

kakao_review (kakao 리뷰)

  • id — NOT NULL — Primary key — NOT NULL
  • review_id (카카오 리뷰 Id) — NOT NULL
  • user_id (유저 Id) — NOT NULL
  • nickname (유저 닉네임) — NULL
  • contents (리뷰 내용) — NULL
  • ratings (평점) — NULL
  • updated_at (업데이트 날짜) — NULL
  • place_id (카카오 Id) — NOT NULL — Foreign key → kakao_info.id — NOT NULL
  • place_name (사업장명) — NOT NULL
  • task _id (task Id) — NOT NULL — Foreign key → scraping_jobs.id — NOT NULL

kcd_info (KCD 정보)

  • id (KCD_id) — NOT NULL — Primary key — NOT NULL
  • place_name (사업장명)
  • naver_id (네이버 Id)
  • kakao_id (카카오 Id)

naver_info (naver 정보)

  • id — NOT NULL — Primary key — NOT NULL
  • place_id (네이버 ID) — NOT NULL — Foreign key → kcd_info.id — NOT NULL
  • place_name (사업장명) — NOT NULL
  • address (주소) — NULL
  • tel (전화번호) — NULL
  • platform (플랫폼명) — NULL
  • task_id (task Id) — NOT NULL — Foreign key → scraping_jobs.id — NOT NULL

naver_review (Naver 리뷰)

  • id — NOT NULL — Primary key — NOT NULL
  • review_id (네이버 리뷰 Id) — NOT NULL
  • user_id (유저 Id) — NOT NULL
  • nickname (유저 닉네임) — NULL
  • contents (리뷰 내용) — NULL
  • ratings (평점) — NULL
  • updated_at (업데이트 날짜) — NULL
  • place_id (네이버 Id) — NOT NULL — Foreign key → naver_info.id — NOT NULL
  • place_name (사업장명) — NOT NULL
  • task_id (task Id) — NOT NULL — Foreign key → scraping_jobs.id — NOT NULL

scraping_jobs (logging)

  • id — NOT NULL — Primary key — NOT NULL
  • task_id (task Id) — NOT NULL
  • status (상태) — NOT NULL
  • platform (플랫폼명) — NULL
  • place_name (사업장명) — NULL
  • created_at (생성일시) — NULL
  • updated_at (업데이트 일시) — NULL
  • error_log (에러) — NULL