| SchemaSpy Analysis of zooqini_checkin_dev | Generated by SchemaSpy |
| Generated by SchemaSpy on Thu Sep 13 12:16 PDT 2012 | |
| Database Type: MySQL - 5.1.39-log |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| account_activation_request | 5 | 109 | |||
| activities | 6 | 0 | |||
| activity_members | 3 | 0 | |||
| activity_types | 2 | 22 | |||
| addresses | 9 | 71 | |||
| authority | 4 | 37 | |||
| barcode | 4 | 36 | |||
| business | 10 | 6 | |||
| business_images | 2 | 26 | |||
| business_payment | 2 | 0 | |||
| business_urls | 3 | 20 | |||
| calendar_event | 3 | 56 | |||
| event_frequency | 3 | 0 | |||
| event_images | 2 | 2 | |||
| event_members | 5 | 134 | |||
| events | 14 | 33 | |||
| fr_group_type | 3 | 0 | |||
| fr_groups | 4 | 0 | |||
| franchises | 8 | 1 | |||
| group_images | 2 | 37 | |||
| group_mapping | 3 | 25 | |||
| group_members | 8 | 133 | |||
| group_required | 2 | 25 | |||
| group_types | 3 | 3 | |||
| group_waiver | 5 | 50 | |||
| groups | 18 | 24 | |||
| images | 4 | 164 | |||
| logs | 1 | 37 | |||
| milestones | 4 | 14 | |||
| milestones_rewards | 3 | 9 | |||
| offline_checkin | 4 | 14 | |||
| pd_reset_request | 4 | 19 | |||
| Points | 3 | 1 | |||
| recess_tools_classes | 6 | 6 | |||
| recess_tools_packages | 3 | 8 | |||
| rest_test | 2 | 1 | |||
| rewards | 3 | 9 | |||
| signup | 2 | 7 | |||
| sponser_logo | 5 | 3 | |||
| store_mapping | 3 | 8 | |||
| training_types | 2 | 9 | |||
| user_emergency_contacts | 5 | 45 | |||
| user_follow | 3 | 0 | |||
| user_images | 2 | 1 | |||
| user_journals | 12 | 281 | |||
| user_profile | 10 | 33 | |||
| users | 15 | 52 | |||
| weather_cache | 3 | 1 | |||
| zip_code | 11 | 42,624 | |||
| zipcodes | 3 | 43,191 | |||
| 50 Tables | 246 | 87,387 | |||
| 0 Views | 0 |