| Database | Decision | Reason |
|---|---|---|
| ✨Cities Database | KEEP — Global Hub | Used across Addresses, Bookings, Dance, Events |
| ✨States Database | KEEP — Global Hub | Used across Addresses, Bookings, Dance, Users |
| ✨Countries Database | KEEP — Global Hub | Used across Addresses, Users, Bookings |
| ✨Platforms Database | KEEP — Global Hub | Used across Content, Sync, Payments, Live Stream |
| ✨Tags Database | KEEP — Global Hub | Cross-subject tagging |
| ✨Statuses Database | KEEP — Global Hub | Cross-subject statuses |
| ✨Priorities | KEEP — Global Hub | Cross-subject priorities — master priority hub |
| ✨Priority Levels Database | MERGE INTO → | → Priorities (duplicate concept) |
| ✨Platform Sync | KEEP — Platform System | Backend sync config |
| ✨Platform Sync Frequencies | KEEP — Platform System | Backend config |
| ✨Platform Sync Statuses | KEEP — Platform System | Backend config |
| ✨Platform Rules | KEEP — Platform System | Backend rules engine |
| ✨Platform Rule Types | KEEP — Platform System | Backend config |
| ✨Platform Rule Actions | KEEP — Platform System | Backend config |
| ✨Support Ticket Priorities | MERGE INTO → | → Priorities (same concept) |
| ✨System Notification Priorities | MERGE INTO → | → Priorities (same concept) |
| ❌✨Styles | ARCHIVE | Confirmed archive. ❌ prefix = deletion candidate, no longer needed. |
| ❤️✨Content Types | DO NOT TOUCH | Platform-connected — DO NOT TOUCH |
| Database | Decision | Reason |
|---|---|---|
| ✨Blog Post Categories | KEEP — Subject DB | Blog-specific, keep standalone |
| ✨Blog Post Statuses | CONVERT TO SELECT | Only in Blog Posts DB |
| ✨Blog Post Tags | KEEP — Subject DB | Blog-specific tagging |
| ✨Community Event Statuses | CONVERT TO SELECT | Only in Community Events DB |
| ✨Community Event Types | CONVERT TO SELECT | Only in Community Events DB |
| ✨Community Group Categories | CONVERT TO SELECT | Only in Community Groups DB |
| ✨Community Post Types | CONVERT TO SELECT | Only in Community Posts DB |
| ✨Content Calendar Platforms | MERGE INTO → | → Platforms Database |
| ✨Content Calendar Statuses | CONVERT TO SELECT | Only in Content Calendar DB |
| ✨Content Calendar Types | CONVERT TO SELECT | Only in Content Calendar DB |
| ✨Content Planner Platforms | MERGE INTO → | → Platforms Database (duplicate) |
| ✨Content Planner Types | MERGE INTO → | → Content Calendar Types (duplicate) |
| ✨Content Scheduling Platforms | MERGE INTO → | → Platforms Database (duplicate) |
| ✨Content Scheduling Statuses | MERGE INTO → | → Content Calendar Statuses (duplicate) |
| ✨Content Scheduling Types | MERGE INTO → | → Content Calendar Types (duplicate) |
| ✨Email Template Tags | KEEP — Subject DB | Email-specific tagging |
| ✨Feed Post Statuses | CONVERT TO SELECT | Only in Feed DB |
| ✨Feed Post Types | CONVERT TO SELECT | Only in Feed DB |
| ✨Gaming Platforms | MERGE INTO → | → Platforms Database |
| ✨Live Stream Platforms | MERGE INTO → | → Platforms Database |
| ✨Media Tags | KEEP — Global Hub | Used across Photos, Videos, Content |
| ✨Payment Methods (Taxonomy) | MERGE INTO → | → Payment Methods Database (duplicate) |
| ✨Photo Album Categories | CONVERT TO SELECT | Only in Photo Albums DB |
| ✨Quote Payment Link Statuses | CONVERT TO SELECT | Only in Quotes DB |
| ✨Service Category Type Colors | CONVERT TO SELECT | UI config only |
| ✨Alt Suggestion Service Formats | REVIEW | May merge into Service Formats — check |
| ✨Amateur Content Categories | CONVERT TO SELECT | Only in Amateur Content DB |
| ✨Amateur Content Statuses | CONVERT TO SELECT | Only in Amateur Content DB |
| Database | Decision | Reason |
|---|---|---|
| ✨Notification Types | KEEP — Global Hub | Used across all notification surfaces |
| ✨Notification Statuses | KEEP — Global Hub | Used across all notification surfaces |
| ✨Notification Priorities | MERGE INTO → | → Priorities (same concept) |
| ✨Daily Ops Categories | CONVERT TO SELECT | Only in Daily Ops DB |
| ✨Daily Ops Priorities | MERGE INTO → | → Priorities (same concept) |
| ✨Daily Ops Statuses | CONVERT TO SELECT | Only in Daily Ops DB |
| ✨A/B Test Statuses | CONVERT TO SELECT | Only in A/B Test DB |
| ✨Analytics Event Categories | CONVERT TO SELECT | Only in Analytics DB |
| ✨Badge Categories | CONVERT TO SELECT | Only in Badges DB |
| ✨Business Metric Categories | CONVERT TO SELECT | Only in Metrics DB |
| ✨Progress Tracker Categories | CONVERT TO SELECT | Only in Progress Tracker DB |
| ✨Progress Tracker Priorities | MERGE INTO → | → Priorities (same concept) |
| Database | Decision | Reason |
|---|---|---|
| ✨User Types | KEEP — Global Hub | Used across Users, Permissions, Billing |
| ✨User Countries | MERGE INTO → | → Countries Database (duplicate) |
| ✨User States | MERGE INTO → | → States Database (duplicate) |
| ✨Customer Request Tags | KEEP — Subject DB | Request-specific tagging |
| ✨Customer Role Categories | CONVERT TO SELECT | Only in Customer DB |
| ✨Client Interaction Types | CONVERT TO SELECT | Only in CRM DB |
| ✨Client Relationship Tags | KEEP — Subject DB | CRM-specific tagging |
| ✨Cast Tags | KEEP — Subject DB | Film/scene-specific tagging |
| ✨Presenter Types | CONVERT TO SELECT | Only in Events DB |
| ✨Referral Reward Types | CONVERT TO SELECT | Only in Referrals DB |
| ✨Signup Methods | CONVERT TO SELECT | Only in Users DB |
| ✨User Activity Types | CONVERT TO SELECT | Only in Activity Log DB |
| Database | Decision | Reason |
|---|---|---|
| ✨Legal Document Types | KEEP — Subject DB | Legal-specific taxonomy |
| ✨Legal Document Categories | KEEP — Subject DB | Legal-specific taxonomy |
| ✨Legal Document Statuses | CONVERT TO SELECT | Only in Legal Docs DB |
| ✨2257 ID Types | KEEP — Subject DB | Industry-specific, important for compliance |
| ✨2257 Statuses | KEEP — Subject DB | Industry-specific, important for compliance |
| ✨Email Template Categories | CONVERT TO SELECT | Only in Email Templates DB |
| ✨FAQ Categories | CONVERT TO SELECT | Only in FAQ DB |
| ✨Knowledge Base Categories | KEEP — Subject DB | Used across KB + Help Center |
| ✨Knowledge Base Tags | KEEP — Subject DB | Used across KB + Help Center |
| ✨Push Notification Categories | MERGE INTO → | → Notification Types (same concept) |
| ✨Reading Statuses | CONVERT TO SELECT | Only in Reading/Books DB |
| Database | Decision | Reason |
|---|---|---|
| ✨Product Categories (Store) | KEEP — Subject DB | Store-specific (separate from ❤️Product Categories) |
| ✨Product Statuses | CONVERT TO SELECT | Only in Products DB |
| ✨Inventory Statuses | CONVERT TO SELECT | Only in Inventory DB |
| ✨Item Tags | KEEP — Subject DB | Store item tagging |
| ✨Item Priorities | MERGE INTO → | → Priorities (same concept) |
| ✨For Sale Statuses | CONVERT TO SELECT | Only in For Sale DB |
| ✨Return Request Types | CONVERT TO SELECT | Only in Returns DB |
| ✨Return Request Statuses | CONVERT TO SELECT | Only in Returns DB |
| ✨Discount Code Types | CONVERT TO SELECT | Only in Discounts DB |
| ✨Wishlist Categories | KEEP — Subject DB | Keep — needed for Phase 6.5 unification |
| ✨Wishlist Priorities | KEEP — Subject DB | Keep — needed for Phase 6.5 unification |
| Database | Decision | Reason |
|---|---|---|
| Platform Fees | KEEP — Platform System | Backend billing config |
| ✨Payment Methods Database | KEEP — Global Hub | Used across Billing, Commerce, Requests |
| ✨Payment Methods Database (ready to archive) | KEEP — Subject DB | Move to Finance Planner (KEEP). Old archive label is stale. |
| ✨Payment Statuses | KEEP — Global Hub | Used across all payment flows |
| ✨Payment Link Statuses | KEEP — Subject DB | Move to Finance Planner (KEEP). Keep as standalone DB. |
| ✨Expense Tags | KEEP — Subject DB | Finance-specific tagging |
| Database | Decision | Reason |
|---|---|---|
| ✨Film Agent Payment Statuses | DO NOT TOUCH | Film History system — DO NOT TOUCH |
| ✨Film Agent Tags | DO NOT TOUCH | Film History system — DO NOT TOUCH |
| ✨Dance Cities | DO NOT TOUCH | Dance system — DO NOT TOUCH |
| ✨Dance Ratings | DO NOT TOUCH | Dance system — DO NOT TOUCH |
| ✨Dance States | DO NOT TOUCH | Dance system — DO NOT TOUCH |
| ✨Dance Tags | DO NOT TOUCH | Dance system — DO NOT TOUCH |
| Database | Decision | Reason |
|---|---|---|
| ✨Fashion Tags | KEEP — Subject DB | Closet/outfit tagging |
| ✨Color Inspo Tags | KEEP — Subject DB | Creative/mood board tagging |
| ✨Mood Board Tags | KEEP — Subject DB | Creative tagging |
| ✨Shot List Tags | KEEP — Subject DB | Film/photo shoot |
| ✨Shot Types | KEEP — Subject DB | Film/photo shoot |
| Database | Decision | Reason |
|---|---|---|
| ✨Booking Types Database | KEEP — Global Hub | Used across Bookings, Calendar, Scheduling |
| ✨Booking Calendar Types | MERGE INTO → | → Booking Types Database (duplicate) |
| ✨Booking Record Types | MERGE INTO → | → Booking Types Database (duplicate) |
| ✨Booking Calendar Statuses | KEEP — Subject DB | Calendar-specific lifecycle |
| ✨Companion Booking Statuses | KEEP — Subject DB | Companion-specific lifecycle |
| ✨Companion Booking Screening Statuses | KEEP — Subject DB | Companion screening flow |
| ✨Availability Types | KEEP — Subject DB | Scheduling-specific |
| ✨Blocked Date Statuses | CONVERT TO SELECT | Only in Blocked Dates DB |
| ✨Addresses Database | KEEP — Global Hub | Used across Bookings, Delivery, Events |
| ✨VIP Event Types | KEEP — Subject DB | VIP-specific |
| ✨VIP Event Statuses | CONVERT TO SELECT | Only in VIP Events DB |
| ✨Shift Statuses | CONVERT TO SELECT | Only in Shifts DB |
| ✨Video Call Platforms | MERGE INTO → | → Platforms Database |
| ✨Video Call Session Statuses | CONVERT TO SELECT | Only in Video Calls DB |
| Venue Types | CONVERT TO SELECT | Only in Events/Bookings DB |
| Service Category | KEEP — Subject DB | Service catalog taxonomy |
| Service Category Types | MERGE INTO → | → Service Category (duplicate) |
| Service Formats (ready to archive) | KEEP — Global Hub | Real data: Premade Video, Custom Video, Skype Show, Photo Set + pricing + Usage Count + 3 relations. Cross-subject service taxonomy. Old archive label is stale — actively needed. |
| ✨Service Types Database | KEEP — Subject DB | Service taxonomy |
| Database | Decision | Reason |
|---|---|---|
| Rating the day (×12 copies) | ARCHIVE | Massive duplication — keep 1, archive rest |
| Tags 🙌🏻 | REVIEW | Likely duplicate of Tags Database — check usage |
| ✨Personal Formats Database | KEEP — Subject DB | Personal planning formats |
| ✨Personal Priority Levels Database | MERGE INTO → | → Priorities (same concept) |
| ✨Article Types Database | KEEP — Subject DB | Content/blog article taxonomy |
| ✨Document Types Database | KEEP — Subject DB | Document taxonomy |
| ✨Formats Database (DELETE?) | KEEP — Subject DB | Move to Services & Content → Taxonomy & Config. Old delete label is stale. |
| ✨Guide Tags | KEEP — Subject DB | Help/guide tagging |
| ✨System Tags | MERGE INTO → | → Tags Database (same concept) |
| ✨Rider Requirement Categories | KEEP — Subject DB | Rider/booking specific |
| ✨Rider Requirement Priorities | MERGE INTO → | → Priorities (same concept) |
| ❤️Product Categories | DO NOT TOUCH | Platform-connected — DO NOT TOUCH |
| ❤️✨Product Types | DO NOT TOUCH | Platform-connected — DO NOT TOUCH |
| ❤️✨Service Categories | DO NOT TOUCH | Platform-connected — DO NOT TOUCH |
| ❤️✨Service Formats | DO NOT TOUCH | Platform-connected — DO NOT TOUCH |
| ❤️Interaction Styles | DO NOT TOUCH | Platform-connected — DO NOT TOUCH |
| Indulgon — Platform Stats | KEEP — Platform System | Analytics — keep standalone |