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)