A complete back-end management CRM system for the Magic Castle, world famous Hollywood magic club and restaurant. The system is a dynamic ColdFusion application that uses a SQL back-end to track all aspects of membership. Custom reports were created that give the office staff an easy-to-use yet flexible system to create any report they would ever need. Custom PDF exporting helps with dynamic printing of personalized guest passes.