Cocokin / Shopee Fashion Data
Data license: Internal Use · Data source: wuz.web.id
Tables
affiliate_offers
id, product_id, offer_id, offer_link, affiliate_link, commission_text, commission_rate, sample_free, listing_page, affiliate_account, tag_used, first_seen_at, last_seen_at
107 rows
fashion_compatibility_rules
id, rule_type, input_key, input_value, output_key, output_value, score, reasoning, active, created_at
0 rows
outfit_item_feedback
id, outfit_id, outfit_item_id, role, feedback_type, reason_code, comment_text, replacement_product_id, created_by, created_at
34 rows
outfit_items
id, outfit_id, product_id, role, position, item_status, candidate_group, replaced_from_item_id, notes, selection_score, generated_description, description_source, description_model, description_updated_at
697 rows
outfits
id, name, description, gender, occasion, total_score, reasoning, meta_json, created_at, updated_at, workflow_status, source_type, parent_outfit_id, anchor_product_id, approved_at, rejected_at, reviewed_by, revision_count, generated_prompt, prompt_updated_at
208 rows
product_fashion_attributes
id, product_id, item_role, item_type, gender, age_group, primary_color, color_group, secondary_color, pattern_type, material_type, fit_type, formality_level, season_tag, confidence, source, image_analyzed, created_at, updated_at
7,062 rows
product_image_analysis
id, product_image_id, image_url, image_width, image_height, aspect_ratio, dominant_color_ratio, border_uniformity, brightness_mean, saturation_mean, visual_noise_score, text_like_score, image_role, prompt_safe, background_cleanliness_score, isolation_score, style_reference_score, combine_suitability_score, confidence, source, notes, analyzed_at, created_at, updated_at, visual_use_tier, domain_relevance
2,942 rows
product_visual_selection
id, product_id, hero_product_image_id, prompt_product_image_id, hero_analysis_id, prompt_analysis_id, selection_source, selection_confidence, notes, created_at, updated_at
2,815 rows
products
id, canonical_key, resolution_status, shop_id, item_id, offer_id, product_url, offer_link, name, brand, description, category_root, category_sub, category_breadcrumb, gender_target, fashion_flag, primary_image_url, current_price, original_price, discount_text, sold_text, sold_count, rating, rating_count_text, shop_name, shop_location, stock_status, source_first_seen_at, source_last_seen_at, last_successful_scrape_at, created_at, updated_at, notes
7,066 rows
scrape_runs
id, run_type, source_type, trigger_ref, status, started_at, finished_at, total_targets, success_count, fail_count, inserted_count, updated_count, skipped_duplicate_count, error_summary, meta_json
41 rows
scrape_targets
id, run_id, product_id, target_type, target_ref, status, started_at, finished_at, discovered_new_product, updated_existing_product, raw_artifact_path, error_message, meta_json
443 rows
shopee_category_nodes
id, root_id, subcategory_name, subcategory_url, snapshot_date, created_at
124 rows
shopee_mall_categories
id, category_key, category_id, category_name, category_url, source_page, snapshot_date, created_at
24 rows
shopee_mall_category_products
id, mall_category_id, product_id, page_number, sort_type, source_url, discovered_at, last_seen_at
4,531 rows
Download SQLite DB: shopee_cocokin.db 8.6 MB