naver_shopping_erd

테이블 (10)

attach_file

  • mall_review_id — int — 외래 키 → review_table.mall_review_id
  • unique_key — varchar — 외래 키 → review_table.unique_key
  • mall_product_id — int — 외래 키 → review_table.mall_product_id
  • rank_date — date — 외래 키 → review_table.rank_date — NOT NULL
  • c_id — varchar — 외래 키 → review_table.c_id — NOT NULL
  • image_yn — varchar
  • image_cnt — int4
  • video_yn — varchar
  • video_cnt — int4

category

  • c_id — varchar — 기본 키 — NOT NULL
  • c_name — varchar
  • crawl_date — date

mallinfo

  • mall_product_id — int — 기본 키
  • mall_id — varchar
  • mall_name — varchar
  • mall_logo — varchar
  • mall_seq — int

parent_cat

  • c_id — varchar — 외래 키 → category.c_id — NOT NULL
  • parent_id — varchar
  • crawl_date — date

rank_prod

  • rank_date — date — 기본 키 — NOT NULL
  • c_id — varchar — 외래 키 → category.c_id — NOT NULL
  • prod_name (Field) — varchar
  • prod_link (Field2) — varchar
  • prod_reviewNm (Field3) — int4
  • prod_price (Field4) — int4

review_table

  • mall_review_id — int — 기본 키
  • unique_key — varchar — 기본 키
  • mall_product_id — int — 외래 키 → mallinfo.mall_product_id
  • rank_date — date — 외래 키 → rank_prod.rank_date — NOT NULL
  • c_id — varchar — 외래 키 → rank_prod.c_id — NOT NULL
  • updatetype — varchar
  • nvmid — varchar
  • match_nvmid — varchar
  • user_id — varchar
  • content — varchar
  • register_date — date
  • modify_date — date
  • page_url — varchar
  • create_time — bigint
  • quality_score — float
  • star_score — int4
  • topic_yn — varchar
  • topic_cnt — int4

search_brand_ranking

  • search_date — date — 기본 키 — NOT NULL
  • search_rank — int4 — 기본 키 — NOT NULL
  • c_id — varchar — 외래 키 → category.c_id — NOT NULL
  • brand_name — varchar

search_word_ranking

  • s_date — date — 기본 키 — NOT NULL
  • search_rank — int4 — 기본 키 — NOT NULL
  • c_id — varchar — 외래 키 → category.c_id — NOT NULL
  • search_name — varchar
  • Field

topic

  • mall_review_id — int — 외래 키 → review_table.mall_review_id
  • unique_key — varchar — 외래 키 → review_table.unique_key
  • mall_product_id — int — 외래 키 → review_table.mall_product_id
  • rank_date — date — 외래 키 → review_table.rank_date — NOT NULL
  • c_id — varchar — 외래 키 → review_table.c_id — NOT NULL
  • topic_code — varchar
  • topic_name — varchar
  • topicname_raw — varchar
  • start_position — int4
  • end_position — int4
  • reputation_score — int4
  • positive_yn — varchar

원본 데이터 (CopyOfreviews)

  • Field3 (mallReviewId) — 기본 키
  • Field (mallId)
  • Field2 (updateType)
  • Field4 (mallSeq)
  • Field5 (nvMid)
  • Field6 (matchNvMid)
  • Field7 (userId)
  • Field8 (title)
  • Field (content)
  • Field2 (registerDate)
  • Field3 (modifyDate)
  • Field (pageUrl)
  • Field2 (createTime)
  • Field3 (qualityScore)
  • Field4 (starScore)
  • Field5 (imageYn)
  • Field6 (imageCount)
  • Field (videoYn)
  • Field2 (videoCount)
  • Field3 (topicYn)
  • Field (topicCount)