The tblmember table includes the member name, address, contact, email, age and gender the table also includes the date of membership and the expiration date of membership. Tblmember (member_id, member_id_no, member_name, address, contact, email, age, gender, joining_date, end_of_membership_date, membership_id, user_id)ĭescription: to avail the different workout plan of the gym, you need to register to become a member of the gym and can access the facilities available in the gym. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 `instructor_id` int(11) NOT NULL AUTO_INCREMENT, The tblinstructor table will store their personal information such as the complete name, contact address and email.Ĭreate Table SQL Statement: CREATE TABLE IF NOT EXISTS `tblinstructor` ( Tblinstructor (instructor_id, instructor_name, contact, address, email, user_id)ĭescription: one of the modules of the gym management system is the encoding of the different gym instructors they serve as the teacher or trainer and prepare the different workout plan. Gym Management System List of Tablesĭatabase Design and List of Database Tables You are allowed to use our database design as long as you will give credit to the site, LIKE and SHARE of this article and our facebook page is highly appreciated. This article will provide you with the list of database tables that you might use in the development of your own gym management system. The project entitled gym management system is a web based system that manages the member records that includes the personal information, payment history and schedule of workout and exercises.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |