1 / 22

Fighter_University_Membership

Fighter_University_Membership. Membership_Type. Member_Fighter. Member_Coach /Trainer. Member_Fan. Member_Promotor. Member_Gym. Membership Type. Member_Fighter. Martial Art. Muay Thai. MMA. Boxing. Kickboxing. All other Arts. Wrestling. BJJ. Martial Art Style. Muay Thai. Wins.

urit
Download Presentation

Fighter_University_Membership

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Fighter_University_Membership Membership_Type Member_Fighter Member_Coach/Trainer Member_Fan Member_Promotor Member_Gym

  2. Membership Type Member_Fighter Martial Art Muay Thai MMA Boxing Kickboxing All other Arts Wrestling BJJ

  3. Martial Art Style Muay Thai Wins DQ No_Contest Losses Draws

  4. Martial Art Style Boxing Wins DQ No_Contest Losses Draws

  5. Martial Art Style Kickboxing Wins DQ No_Contest Losses Draws

  6. Martial Art Style Wrestling

  7. Martial Art Style BJJ

  8. Membership Type • Member_Fan • style_follow • Fighter_follow • Gym_follow • Promotion_follow

  9. Membership Type Member_Coach/Trainer -

  10. Membership Type • Member_Gym • -Fighters • -Martial_Art_Style • Coaches/Trainers • Country • Province/State • Mailing_Address • Postal_Code/Zip_Code

  11. Membership Type • Member_Promoter • -Name_of_Promotion • Country • Province/State • Mailing_Address • Postal_Code/Zip_Code

  12. Membership Type Member_Commission_Member

  13. Tables and Fields • Fighter_University_Membership • Membership_Num** • Name_Last • Name_First • Handle • Membership_Type • Date_Enrolled • Email • Country • Province/State • Mailing_Address • - Postal_Code/Zip_Code ** Primary Key

  14. Tables and Fields • Fighter_University_Membership • membership_num** • Member_Fighter • Member_Fan • Member_Promoter • Member_Coach_Trainer • Member_Gym_Club • Member_Commision_Member ** Primary Key

  15. Tables and Fields • Member_Fighter • Membership_Num** • Martial_Art_Style (Links to Martial_Arts table) • Gym • Trainer(s)_Coaches • Height • Weight • Reach ** Primary Key

  16. Tables and Fields • Martial_Art_Style • membership_num** • Muay_Thai • Boxing • Kickboxing • Wrestling • BJJ • Other_Styles ** Primary Key

  17. Tables and Fields • Muay_Thai • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key

  18. Tables and Fields • Kickboxing • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key

  19. Tables and Fields • Boxing • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key

  20. Tables and Fields • BJJ • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key

  21. Tables and Fields • Wrestling • membership_num** • Wins • Losses • Draws • DQ • No_Contest ** Primary Key

More Related