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