| 12345678910111213 |
- // 公司媒体资源库 collection（MongoDB）—— 由 media-library-schema 生成，未来建库直接执行
- db.createCollection('media_library');
- db.media_library.createIndex({"platform":1,"blogger_id":1}, {"name":"uk_blogger_id","unique":true});
- db.media_library.createIndex({"platform":1,"fans_count":-1}, {"name":"idx_platform_fans_desc"});
- db.media_library.createIndex({"platform":1,"tier":1,"fans_count":-1}, {"name":"idx_platform_tier"});
- db.media_library.createIndex({"platform":1,"tax_inclusive_price":1}, {"name":"idx_platform_price_asc"});
- db.media_library.createIndex({"platform":1,"interaction_rate":-1}, {"name":"idx_platform_interaction_desc"});
- db.media_library.createIndex({"platform":1,"verticality":-1}, {"name":"idx_platform_verticality"});
- db.media_library.createIndex({"platform":1,"cpe":1,"cpv":1}, {"name":"idx_platform_cpe_asc"});
- // 必填字段（缺一不可，对应模板「*」标记）：
- // platform, content_type, nickname, fans_count, homepage_url, quote_url, fans_profile, tax_inclusive_price
|
