tihao-ai/claude-code-tihao-sourcing/docs/pgy-collection-ddl.txt

// 蒲公英博主 collection（MongoDB）—— 由 pgy-schema 生成，未来建库直接执行
db.createCollection('pgy_blogger');

db.pgy_blogger.createIndex({"blogger_id":1}, {"name":"uk_blogger_id","unique":true});
db.pgy_blogger.createIndex({"follower_count":-1}, {"name":"idx_fans_desc"});
db.pgy_blogger.createIndex({"trade_type":1,"follower_count":-1}, {"name":"idx_trade_fans"});
db.pgy_blogger.createIndex({"interaction_rate":-1}, {"name":"idx_interaction_desc"});
db.pgy_blogger.createIndex({"lower_price":1}, {"name":"idx_price_asc"});
db.pgy_blogger.createIndex({"content_tags":1,"feature_tags":1}, {"name":"idx_tags"});
db.pgy_blogger.createIndex({"location":1}, {"name":"idx_location"});
db.pgy_blogger.createIndex({"is_active":1,"active_days_in_last7":-1}, {"name":"idx_active"});
db.pgy_blogger.createIndex({"estimate_video_cpm":1,"estimate_picture_cpm":1}, {"name":"idx_cpm_asc"});

// 必采报价字段（列表接口）示例文档：
// { blogger_id, nickname, follower_count, picture_price, video_price, lower_price, trade_type, content_tags }