LAST UPDATED DATE = 25-July-2020 By = Adhi Notes: - New Table cfg_client_type, gym_fitness_center_membership_packages & gym_fitness_center_member Conceptual Note ================ LIST OF Tables ========================================= cfg_role_type cfg_user_type cfg_business_account_type cfg_Life_Style_type cfg_Activity_type cfg_asset_type cfg_Business_Day_Type cfg_possesion_type cfg_employee_type cfg_equipment_category_type cfg_session_type cfg_session_slot_schedule_type cfg_session_slot_mapping_type cfg_day_type cfg_equipment_variant_type cfg_Session_slot_duration_Type cfg_equipment_session_daily_slots cfg_client_type glb_business_accounts glb_affiliation glb_business_invite_code glb_user glb_forgot_password_otp glb_user_verfication glb_user_login glb_business_hours glb_Holidays glb_countries gym_fitness_center gym_fitness_center_staff gym_assets gym_equipment_group gym_equipment_reservation gym_equipment_reservation_full gym_equipment_category_slot_wise_reservation_count gym_fitness_center_member gym_fitness_center_membership_packages lst_brands lst_models lst_Business_days dft_session_slot_Parameters -------------------------- Table Description -------------------------- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ CFG +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ cfg_role_type; +-----------------+------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------+------+-----+-------------------+-----------------------------+ | RoleTypeID | int(11) | NO | PRI | NULL | auto_increment | | RoleTypeUID | int(11) | YES | | NULL | | | BizAccTypeID | int(11) | YES | | NULL | | | ActvTypeID | int(11) | YES | MUL | NULL | | | ActvLevelTypeID | int(11) | YES | | NULL | | | Description | ENUM | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-----------------+------------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Role Types allowed in Minute.fit Ecosystem. 1. Admin 2. Co-Admin 3. Staff 4. Members 5. Consultant 6. Contractor cfg_user_type; +-------------+-----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-----------+------+-----+---------+----------------+ | UserTypeID | int(11) | NO | PRI | NULL | auto_increment | | UserTypeUID | char(3) | NO | | NULL | | | Description | ENUM | YES | | NULL | | +-------------+-----------+------+-----+---------+----------------+ ** Table sets out the different User Types allowed in Minute.fit Ecosystem. 1. Employee 2. Hosted 3. Client cfg_business_account_type; +-----------------+------------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------+------+-----+---------------------+-------------------------------+ | BizAccTypeID | int(11) | NO | PRI | NULL | auto_increment | | BizAccTypeUID | varChar(11)| YES | | NULL | | | Description | ENUM | YES | | NULL | | | Lmts | timestamp | NO | | current_timestamp() | on update current_timestamp() | +-----------------+------------+------+-----+---------------------+-------------------------------+ ** Table sets out the different Business Account Types allowed in Minute.fit Ecosystem. 1. Fitness Center 2. Fitness Trainer 3. Fitness Supplier 4. Fitness Food cfg_Life_Style_type; +------------------+-------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------------+------+-----+-------------------+-----------------------------+ | LifeStyleTypeID | int(11) | NO | PRI | NULL | auto_increment | | LifeStyleTypeUID | varchar(11) | YES | | NULL | | | Description | enum('GYM','SPA') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +------------------+-------------------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Life Style Types allowed in Minute.fit Ecosystem. 1. SPA 2. GYM cfg_Activity_type; +-------------+---------------------------------------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------------------------------------------+------+-----+-------------------+-----------------------------+ | ActvTypeID | int(11) | NO | PRI | NULL | auto_increment | | ActvTypeUID | int(11) | YES | | NULL | | | Description | enum('Cardio','Strength','Cross Fit','Aerobic','Other') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-------------+---------------------------------------------------------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Activity Types allowed in Minute.fit Ecosystem. 1. Cardio 2. Strength 3. Cross Fit 4. Aerobic 5. Other cfg_asset_type; +-----------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-----------+------+-----+-------------------+-----------------------------+ | CfgassetTypeID | int(11) | NO | PRI | NULL | auto_increment | | CfgassetTypeUID | int(11) | YES | | NULL | | | Description | longtext | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-----------------+-----------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Asset Types allowed in Minute.Fit Ecosystem. 1. Equipment 2. Accessories cfg_possesion_type; +----------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------+------+-----+-------------------+-----------------------------+ | CfgpssnTypeID | int(11) | NO | PRI | NULL | auto_increment | | CfgpssnTypeUID | int(11) | YES | | NULL | | | Description | longtext | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +----------------+-----------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Possesion Types allowed in Minute.fit Ecosystem. 1. Owned 2. Rented 3. Borrowed cfg_employee_type; +-------------+----------------------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------------------------------------+------+-----+-------------------+-----------------------------+ | EmplTypeID | int(11) | NO | PRI | NULL | auto_increment | | EmplTypeUID | int(11) | YES | | NULL | | | Description | enum('Full-Time','Part-Time','Intern') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-------------+----------------------------------------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Employee Types allowed in Minute.fit Ecosystem. 1. Full-Time 2. Part-Time 3. Intern cfg_Business_Day_Type; +---------------+--------------------------------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------------------------------------------+------+-----+-------------------+-----------------------------+ | BizDayTypeID | int(11) | NO | PRI | NULL | auto_increment | | BizDayTypeUID | int(11) | YES | | NULL | | | Description | enum('WeekDay','Weekend','Holiday', 'Exception') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +---------------+--------------------------------------------------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Business Day Types allowed in Minute.fit Ecosystem. 1. WeekDay 2. Weekend 3. Holiday 4. Exception cfg_equipment_category_type; +-----------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-----------+------+-----+-------------------+-----------------------------+ | EquipCatTypeID | int(11) | NO | PRI | NULL | auto_increment | | EquipCatTypeUID | int(11) | YES | | NULL | | | ActvTypeIDs | longtext | YES | | NULL | | | Image | longtext | YES | | NULL | | | Description | longtext | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-----------------+-----------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Equipment Category Types allowed in Minute.fit Ecosystem. 1. TreadMill 2. BenchPress 3. Selectorised upper body 4. Selectorised Lower body 5. Plate Upper body 6. Plate Lower body 7. Exercise bikes cfg_session_type; +--------------+---------------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------------------+------+-----+-------------------+-----------------------------+ | SessnTypeID | int(11) | NO | PRI | NULL | auto_increment | | SessnTypeUID | int(11) | YES | | NULL | | | Description | enum('Equipment','Bay','Class') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +--------------+---------------------------------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Session Types allowed in Minute.fit Ecosystem. 1. Equipment 2. Bay 3. Class cfg_session_slot_schedule_type; +----------------------+-----------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+-----------------------------+------+-----+-------------------+-----------------------------+ | SessnSlotSchdTypeID | int(11) | NO | PRI | NULL | auto_increment | | SessnSlotSchdTypeUID | int(11) | YES | | NULL | | | Description | enum('Prepetual','Planned') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +----------------------+-----------------------------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Session Slot Schedule Types allowed in Minute.fit Ecosystem. 1. Prepetual 2. Planned cfg_session_slot_mapping_type; +---------------------+-----------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-----------------------+------+-----+-------------------+-----------------------------+ | SessnSlotMapTypeID | int(11) | NO | PRI | NULL | auto_increment | | SessnSlotMapTypeUID | int(11) | YES | | NULL | | | Description | enum('None','Direct') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +---------------------+-----------------------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Session Slot Mapping Types allowed in Minute.fit Ecosystem. 1. None 2. Direct cfg_equipment_variant_type; +---------------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-----------+------+-----+-------------------+-----------------------------+ | EquipVariantTypeID | int(11) | NO | PRI | NULL | auto_increment | | EquipVariantTypeUID | int(11) | YES | | NULL | | | EquipCatTypeID | int(11) | YES | MUL | NULL | | | Description | longtext | YES | | NULL | | | Image | longtext | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +---------------------+-----------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Equipment Variant Types allowed in Minute.fit Ecosystem. 1. Upright 2. Recline 3. Spinning 4. Other 5. Standard 6. Full Handle 7. Manual 8. Other cfg_day_type; +------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+-------------------+-----------------------------+ | DayTypeID | int(11) | NO | PRI | NULL | auto_increment | | DayTypeUID | varchar(30) | YES | | NULL | | | DayName | varchar(30) | YES | | NULL | | | DayTag | varchar(30) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +------------+-------------+------+-----+-------------------+-----------------------------+ ** Table sets out the different Day Types allowed in Minute.fit Ecosystem. 1. Monday 2. Tuesday 3. Wednesday 4. Thursday 5. Friday 6. Saturday 7. Sunday cfg_Session_slot_duration_Type; +----------------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+-----------+------+-----+-------------------+-----------------------------+ | SessnSlotDurnTypeID | int(11) | NO | PRI | NULL | auto_increment | | SessnSlotDurnTypeUID | int(11) | YES | | NULL | | | SessnSlotDuration | int(11) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +----------------------+-----------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Possible Session Slot Durations allowed in the Minute.fit Ecosystem 1.15 2.30 3.45 4.60 5.75 6.90 7.105 8.120 cfg_equipment_session_daily_slots; +------------------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------------------+-----------+------+-----+-------------------+-----------------------------+ | EquipSessnDailySlotID | int(11) | NO | PRI | NULL | auto_increment | | EquipSessnDailySlotUID | int(11) | YES | | NULL | | | SessnSlotDurnTypeID | int(11) | YES | | NULL | | | SlotStartTime | int(11) | YES | | NULL | | | SlotEndTime | int(11) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +------------------------+-----------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Equipment Slots (EquipSessnDailySlotIDs)available in a day for each Slot Duration Type (SessnSlotDurnTypeID). Each Equipment Slot has their EquipSessnDailySlotID & EquipSessnDailySlotUID along with the corresponding Session Slot Duration Type (SessnSlotDurnTypeID) 1. EquipSlotID - Auto-generated ID for each Equipment Slot 2. EquipSlotUID - Unique ID for Each Equipment Slot 3. BID - Business Account ID 4. SlotStartTime - Start Time of the Slot 5. SlotEndTime - End Time of the Slot 6. Lmts - Updates the Time when new row inserts in table cfg_client_type; +--------------+----------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------+----------------------------+------+-----+-------------------+-----------------------------+ | MShipTypeID | int(11) | NO | PRI | NULL | auto_increment | | MShipTypeUID | int(11) | YES | | NULL | | | Description | enum('Subscriber','Guest') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +--------------+----------------------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Possible Session Slot Durations allowed in the Minute.fit Ecosystem 1.Subscriber 2.Guest +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ GLB +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ glb_business_accounts; +----------------------+---------------------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------------------------+------+-----+-------------------+-----------------------------+ | XBID | int(11) | NO | PRI | NULL | auto_increment | | XBUID | int(11) | YES | | NULL | | | OXID | int(11) | YES | | NULL | | | Level | longtext | YES | | NULL | | | Class | longtext | YES | | NULL | | | LifeStyleID | int(11) | YES | MUL | NULL | | | BizAccTypeID | int(11) | YES | MUL | NULL | | | Type | longtext | YES | | NULL | | | CreatedDate | longtext | YES | | NULL | | | ClosedDate | longtext | YES | | NULL | | | Status | enum('Active','Inactive','Suspended') | YES | | NULL | | | Rating | int(10) | YES | | NULL | | | IsActivated | tinyint(1) | YES | | NULL | | | IsVerified | tinyint(1) | YES | | NULL | | | IsPremimum | tinyint(1) | YES | | NULL | | | StartDate | date | YES | | NULL | | | EndDate | date | YES | | NULL | | | IsBizHoursCompeleted | tinyint(1) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +----------------------+---------------------------------------+------+-----+-------------------+-----------------------------+ ** Table lists the Business Accounts present in the Minute.fit Ecosystem. Each Business account has its XBID and XBUID along with associated data for that Business Account. 1. XBID - Auto-generated ID for each Business Account 2. XBUID - Unique ID for each Business Account 3. OXID - The XID of the business account owner (Admin of the Business Account) 4. Level - Basic, Hosted (FrontEnd) 5. Class - Independent, Chain, Branch, Franchise, Franchisee (FrontEnd) 6. LifeStyleID - SPA, GYM (FrontEnd) 7. BizAccTypeID - ID of the Business Type (from cfg_business_account_type 1,2,3,4) (FrontEnd) 8. Type - Fitness Center, Fitness Trainer, Fitness Supplier, Fitness Food (FrontEnd) 9. CreatedDate - Created Date of the Business Account 10. ClosedDate - It Refers the closing Date of the Business Account 11. Status - Active, Suspended, Inactive (FrontEnd) 12. Rating - 1 to 5 (Default Value from FrontEnd) 13. IsActivated - True / False 14. IsVerified - True / False 15. IsPremimum - True / False 16. StartDate - Premium Account Start Date 17. EndDate - Premium Account End Date 18. IsBizHoursCompeleted - True / False 19. Lmts - Updates the Time when new row inserts in table glb_affiliation; +------------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-----------+------+-----+-------------------+-----------------------------+ | AflnID | int(11) | NO | PRI | NULL | auto_increment | | UserID | int(11) | YES | MUL | NULL | | | XBID | int(11) | YES | MUL | NULL | | | RoleTypeID | int(11) | YES | MUL | NULL | | | AflnTitle | longtext | YES | | NULL | | | IsSetupCompleted | longtext | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +------------------+-----------+------+-----+-------------------+-----------------------------+ ** Table lists the Affiliation details present in the Minute.fit Ecosystem. For every Affiliation has its AflnID and UserID along with associated data, which is generated for Each Role. 1. AflnID - Unique IDs for the Affiliation Roles 2. UserID - ID of the User 3. XBID - ID of the business account to which the User is Affiliated 4. RoleTypeID - RoleID of the user for the business account (from cfg_role_type 1,2,3,4,5,6) 5. AflnTitle - Title assigned to the user 6. IsSetupCompleted - True / False 7. Lmts - Updates the Time when new row inserts in table glb_business_invite_code; +------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+-------------------+-----------------------------+ | XBID | int(11) | YES | MUL | NULL | | | Role | varchar(30) | YES | | NULL | | | RoleTypeID | int(30) | YES | MUL | NULL | | | Code | varchar(30) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +------------+-------------+------+-----+-------------------+-----------------------------+ ** Table contains the different Invite Codes generated for each Business Account. For every Business Account, there is a separate Code generated for each Role. 1. XBID - Business Account ID 2. Role - Admin, Co-Admin, Staff, Consultant, Contractor 3. RoleTypeID - RoleID of the user for the business account (from cfg_role_type 1,2,3,4,5,6) 4. Code - Auto-Generated Invite Code for the corresponding Role and XBID 5. Lmts - Updates the Time when new row inserts in table glb_user; +----------------+----------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------------------------+------+-----+-------------------+-----------------------------+ | UserID | int(11) | NO | PRI | NULL | auto_increment | | UserUID | char(5) | YES | | NULL | | | UserTypeID | int(11) | YES | MUL | NULL | | | UserName | varchar(30) | YES | | NULL | | | EmailAddress | varchar(50) | YES | | NULL | | | Password | longtext | YES | | NULL | | | DateofBirth | longtext | YES | | NULL | | | PhoneNumber | varchar(30) | YES | | NULL | | | Address | longtext | YES | | NULL | | | City | varchar(30) | YES | | NULL | | | State | varchar(30) | YES | | NULL | | | Country | varchar(30) | YES | | NULL | | | Pincode | varchar(30) | YES | | NULL | | | FirstName | varchar(30) | YES | | NULL | | | MiddleName | varchar(30) | YES | | NULL | | | LastName | varchar(30) | YES | | NULL | | | Gender | varchar(30) | YES | | NULL | | | ProfilePicture | longtext | YES | | NULL | | | JoiningDate | date | YES | | NULL | | | Status | enum('Active','Suspended') | YES | | NULL | | | IsVerified | tinyint(1) | YES | | NULL | | | IsResetPasswd | tinyint(1) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +----------------+----------------------------+------+-----+-------------------+-----------------------------+ ** Table lists the User details present in the Minute.fit Ecosystem. Each User has its UserID and UserUID along with associated data for that User Account. 1. UserID - Auto-generated ID for Each User 2. UserUID - Unique IDs for Each User 3. UserTypeID - UserTypeID (from cfg_user_type 1, 2, 3) 4. UserName - Unique user name Which is given by the User 5. EmailAddress - Unique Mail Address which is given by the user 6. Password - Password which is given the user 7. DateofBirth - DoB of the User 8. PhoneNumber - Unique mobile number of the user 9. Address - Address details entered by the user 10. City - City details entered by the user 11. State - State details entered by the user 12. Country - Country details entered by the user 13. Pincode - Pincode details entered by the user 14. FirstName - User First Name 15. MiddleName - User Middle Name 16. LastName - User Last Name 17. Gender - Male / Female 18. ProfilePicture - User Profile Picture 19. JoiningDate - Joining Date of an User 20. Status - Active / Suspended 21. IsVerified - True / False 22. IsResetPasswd - True / False 23. Lmts - Updates the Time when new row inserts in table glb_forgot_password_otp; +--------------+-------------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------------------+-------------------------------+ | EmailAddress | varchar(30) | YES | | NULL | | | otp | varchar(30) | YES | | NULL | | | Lmts | timestamp | NO | | current_timestamp() | on update current_timestamp() | +--------------+-------------+------+-----+---------------------+-------------------------------+ ** Table contains the different OTP generated for each user's EmailAddress, for those users who initiated forgot password. For every user's EmailAddress, there is a separate OTP generated. 1. EmailAddress - Unique EMail Address of the User 2. otp - Auto-Generated OTP 3. Lmts - Updates the Time when new row inserts in table glb_user_verfication; +-------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------+------+-----+-------------------+-----------------------------+ | XID | int(11) | YES | MUL | NULL | | | OTP | int(11) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-------+-----------+------+-----+-------------------+-----------------------------+ ** Table contains the different OTP generated for each user. For every user, there is a separate OTP generated. 1. XID - UserID of the User 2. otp - Auto-Generated OTP 3. Lmts - Updates the Time when new row inserts in table glb_user_login; +-----------------+-----------+------+-----+---------------------+-------------------------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-----------+------+-----+---------------------+-------------------------------+ | LoginID | int(11) | NO | PRI | NULL | auto_increment | | UserID | int(11) | YES | MUL | NULL | | | Action | ENUM | YES | | NULL | | | DateTime | date | YES | | NULL | | | Lmts | timestamp | NO | | current_timestamp() | on update current_timestamp() | +-----------------+-----------+------+-----+---------------------+-------------------------------+ ** Table contains the each user Login and Logout logs. For every user, there is a separate Logina and Logout logs. 1. LoginID - Auto-generated ID for Each User 2. UserID - ID of the User 3. Action - Action Performed by User (Login, Logout) 4. DateTime - Date and Time of Action Performed by User 5. Lmts - Updates the Time when new row inserts in table glb_business_hours; +-------------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-------------+------+-----+-------------------+-----------------------------+ | BizHrID | int(11) | NO | PRI | NULL | auto_increment | | BizHrUID | varchar(30) | YES | | NULL | | | XBID | int(11) | YES | MUL | NULL | | | DayTypeID | int(11) | YES | MUL | NULL | | | BizDayName | varchar(30) | YES | | NULL | | | BizDayTypeID | int(11) | YES | MUL | NULL | | | is24hrs | varchar(30) | YES | | NULL | | | isClosed | varchar(30) | YES | | NULL | | | BizOpeningTime | varchar(30) | YES | | NULL | | | BizClosingTime | varchar(30) | YES | | NULL | | | isBreak | varchar(30) | YES | | NULL | | | BizBreaKStartTime | varchar(30) | YES | | NULL | | | BIzBreakEndTime | varchar(30) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-------------------+-------------+------+-----+-------------------+-----------------------------+ ** Table lists the Business Hours details present in the Minute.fit Ecosystem. Each Business Hours has its BizHrID and BizHrUID along with the corresponding Business Hours data. 1. BizHrID - Auto-generated ID for Each User 2. BizHrUID - Unique IDs for Each User 3. XBID - Busniess Account ID 4. DayTypeID - DayTypeID from cfg_day_type 5. BizDayName - Business Day Name 6. BizDayTypeID - BizDayTypeID from cfg_Business_Day_Type 7. is24hrs - True / False 8. isClosed - True / False 9. BizOpeningTime - Busniess Opening Time 10. BizClosingTime - Busniess Closing Time 11. isBreak - True / False 12. BizBreaKStartTime - Business Break Start Time 13. BIzBreakEndTime - Business Break End Time 14. Lmts - Updates the Time when new row inserts in table glb_countries; +-------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+-------------------+-----------------------------+ | CountryID | int(11) | NO | PRI | NULL | auto_increment | | CountryUID | varchar(30) | YES | | NULL | | | CountryName | varchar(40) | YES | | NULL | | | CountryTag | varchar(40) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-------------+-------------+------+-----+-------------------+-----------------------------+ ** Table lists the Countries present in the Minute.fit Ecosystem. Each Countries has its CountryID and CountryUID along with the corresponding Countries data. 1. CountryID - Auto-generated ID for Each User 2. CountryUID - Unique IDs for Each User 3. CountryName - Country Name 4. CountryTag - Country Tag 5. Lmts - Updates the Time when new row inserts in table glb_Holidays; +----------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+-------------------+-----------------------------+ | HolidayID | int(11) | NO | PRI | NULL | auto_increment | | HolidayUID | varchar(30) | YES | | NULL | | | BID | int(11) | YES | | NULL | | | Year | varchar(30) | YES | | NULL | | | Date | varchar(30) | YES | | NULL | | | DayTypeID | int(11) | YES | | NULL | | | Description | varchar(30) | YES | | NULL | | | StartTime | varchar(30) | YES | | NULL | | | EndTime | varchar(30) | YES | | NULL | | | isBreak | varchar(30) | YES | | NULL | | | BreaKStartTime | varchar(30) | YES | | NULL | | | BreakEndTime | varchar(30) | YES | | NULL | | | Status | varchar(30) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +----------------+-------------+------+-----+-------------------+-----------------------------+ ** Table lists the Holidays present in the Minute.fit Ecosystem. Each Holidays has its HolidayID and HolidayUID along with the corresponding Holidays data. 1. HolidayID - Auto-generated ID for Each User 2. HolidayUID - Unique IDs for Each User 3. BID - Business Account ID 4. Year - Year of the Holiday 5. Date - Corresponding Date of the Holiday 6. DayTypeID - DayTypeID from cfg_day_type 7. Description - Description of the Holiday 8. StartTime - Start Time 9. EndTime - End Time 10. isBreak - True / False 11. BreaKStartTime - Break Start Time 12. BreakEndTime - Break End Time 13. Status - Open, Closed, Deleted 14. Lmts - Updates the Time when new row inserts in table +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ GYM +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ gym_fitness_center; +------------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+-------------------+-----------------------------+ | GymFcID | int(11) | NO | PRI | NULL | auto_increment | | GymFcUID | char(30) | YES | | NULL | | | XBID | int(30) | YES | MUL | NULL | | | PXBID | varchar(30) | YES | | NULL | | | LifeStyleID | int(11) | YES | MUL | NULL | | | TerritoryID | int(11) | YES | | NULL | | | BizName | longtext | YES | | NULL | | | RegdBizName | varchar(30) | YES | | NULL | | | EmailAddress | varchar(30) | YES | | NULL | | | PhoneNumber | varchar(20) | YES | | NULL | | | Address | longtext | YES | | NULL | | | Country | varchar(50) | YES | | NULL | | | State | varchar(30) | YES | | NULL | | | City | varchar(30) | YES | | NULL | | | Pincode | varchar(30) | YES | | NULL | | | RegdAddress | longtext | YES | | NULL | | | RegdCountry | varchar(50) | YES | | NULL | | | RegdState | varchar(30) | YES | | NULL | | | RegdCity | varchar(30) | YES | | NULL | | | RegdPincode | varchar(30) | YES | | NULL | | | Logo | varchar(80) | YES | | NULL | | | Banner | varchar(80) | YES | | NULL | | | RegdNubmer | varchar(80) | YES | | NULL | | | TaxNumber | varchar(80) | YES | | NULL | | | Website | varchar(80) | YES | | NULL | | | BizHoursTag1 | varchar(80) | YES | | NULL | | | BizTimings1 | varchar(80) | YES | | NULL | | | BizHoursTag2 | varchar(80) | YES | | NULL | | | BizTimings2 | varchar(80) | YES | | NULL | | | BizHoursTag3 | varchar(80) | YES | | NULL | | | BizTimings3 | varchar(80) | YES | | NULL | | | BizHoursTag4 | varchar(80) | YES | | NULL | | | BizTimings4 | varchar(80) | YES | | NULL | | | EmailTag1 | varchar(40) | YES | | NULL | | | Email1 | varchar(40) | YES | | NULL | | | EmailTag2 | varchar(40) | YES | | NULL | | | Email2 | varchar(40) | YES | | NULL | | | EmailTag3 | varchar(40) | YES | | NULL | | | Email3 | varchar(40) | YES | | NULL | | | EmailTag4 | varchar(40) | YES | | NULL | | | Email4 | varchar(40) | YES | | NULL | | | PhoneTag1 | varchar(40) | YES | | NULL | | | Phone1 | varchar(40) | YES | | NULL | | | PhoneTag2 | varchar(40) | YES | | NULL | | | Phone2 | varchar(40) | YES | | NULL | | | PhoneTag3 | varchar(40) | YES | | NULL | | | Phone3 | varchar(40) | YES | | NULL | | | PhoneTag4 | varchar(40) | YES | | NULL | | | Phone4 | varchar(40) | YES | | NULL | | | IsBizProfile | tinyint(1) | YES | | NULL | | | IsStaff | tinyint(1) | YES | | NULL | | | IsEquipment | tinyint(1) | YES | | NULL | | | IsTopology | tinyint(1) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +------------------+-------------+------+-----+-------------------+-----------------------------+ ** Table lists the details about each gym fitness center in the Minute.fit Ecosystem. Each gym fitness center has its GymFcID and GymFcUID along with associated data for that Business Account. 1. GymFcID - Auto-Generated ID for each Fitness Center 2. GymFcUID - Unique ID for for each Fitness Center 3. XBID - Business Account ID of the Fitness Center 4. PXBID - Parent Business Account ('Independent') 5. LifeStyleID - SPA, GYM (FrontEnd) 6. TerritoryID - TerritoryID from Territory Table 7. BizName - Name 8. RegdBizName - Registered Name 9. EmailAddress - Email Address 10. PhoneNumber - Phone Number of the Business Account 11. Address - Address details 12. Country - Country 13. State - State 14. City - City 15. Pincode - Pincode 16. RegdAddress - Registered Address details 17. RegdCountry - Registered Country 18. RegdState - Registered State 19. RegdCity - Registered City 20. RegdPincode - Registered Pincode 21. Logo - Business Logo 22. Banner - Business Banner 23. RegdNubmer - Registered Business Number 24. TaxNumber - Tax Number of Business 25. Website - Business Website 26. BusinessHoursTag1 - Tag describing Business Period 27. BusinessTimings1 - Opening time and Closing time for that business period 28. BusinessHoursTag2 - Tag describing Business Period 29. BusinessTimings2 - Opening time and Closing time for that business period 30. BusinessHoursTag3 - Tag describing Business Period 31. BusinessTimings3 - Opening time and Closing time for that business period 32. BusinessHoursTag4 - Tag describing Business Period 33. BusinessTimings4 - Opening time and Closing time for that business period 34. EmailTag1 - Tag describing Business Email 35. Email1 - Business Email 36. EmailTag2 - Tag describing Business Email 37. Email2 - Business Email 38. EmailTag3 - Tag describing Business Email 39. Email3 - Business Email 40. EmailTagName4 - Tag describing Business Email 41. Email4 - Business Email 42. PhoneTag1 - Tag describing Business Phone Number 43. Phone1 - Business Phone Number 44. PhoneTag2 - Tag describing Business Phone Number 45. Phone2 - Business Phone Number 46. PhoneTag3 - Tag describing Business Phone Number 47. Phone3 - Business Phone Number 48. PhoneTag4 - Tag describing Business Phone Number 49. Phone4 - Business Phone Number 50. IsBizProfile - True / False 51. IsStaff - True / False 52. IsEquipment - True / False 53. IsTopology - True / False 54. Lmts - Updates the Time when new row inserts in table gym_fitness_center_staff; +------------+------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------------+------+-----+-------------------+-----------------------------+ | FcStaffID | int(11) | NO | PRI | NULL | auto_increment | | FcStaffUID | varchar(30) | YES | | NULL | | | FcStaffXID | int(11) | YES | MUL | NULL | | | XBID | int(11) | YES | MUL | NULL | | | FcID | int(11) | YES | MUL | NULL | | | Role | varchar(30) | YES | | NULL | | | Title | varchar(30) | YES | | NULL | | | EmplTypeID | int(11) | YES | MUL | NULL | | | JoinDate | varchar(30) | YES | | NULL | | | XDJoinDate | varchar(30) | YES | | NULL | | | Status | enum('Added','Joined') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +------------+------------------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of staff for gym fitness center's in the minute.fit ecosystem. Each staff has their FcStaffID & FcStaffUID along with the corresponding staff data 1. FcStaffID - Auto-generated ID for each staff 2. FcStaffUID - Unique ID for Each Staff 3. FcStaffXID - UserID of the Staff 4. XBID - Business Account ID to which staff belongs 5. FcID - Fitness CenterID to which staff belongs 6. Role - User Role 7. Title - User Title 8. EmplTypeID - EmplTypeID of the user for the business Account Staff (from cfg_employee_type 1,2,3) 9. JoinDate - Joining Date of an User 10. XDJoinDate - Joining Date of an User in minute.fit ecosystem 11. Status - User joining status (Added or Joined) 12. Lmts - Updates the Time when new row inserts in table gym_assets; +------------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+-------------------+-----------------------------+ | AssetID | int(11) | NO | PRI | NULL | auto_increment | | AssetUID | int(11) | YES | | NULL | | | AssetTag | varchar(15) | YES | | NULL | | | AssetSerailNo | int(11) | YES | | NULL | | | BID | int(11) | YES | MUL | NULL | | | ActivitytypeID | int(11) | YES | MUL | NULL | | | AssetTypeID | int(11) | YES | MUL | NULL | | | PssnTypeID | int(11) | YES | MUL | NULL | | | EquipCatTypeID | int(11) | YES | MUL | NULL | | | EquipGrpID | int(11) | YES | MUL | NULL | | | EquipSrlNum | int(11) | YES | | NULL | | | BrandID | int(11) | YES | MUL | NULL | | | ModelID | int(11) | YES | MUL | NULL | | | AssetName | varchar(30) | YES | | NULL | | | SlotDuration | int(11) | YES | | NULL | | | SlotCapacity | int(11) | YES | | NULL | | | PurchasePrice | varchar(30) | YES | | NULL | | | PurchaseDate | varchar(30) | YES | | NULL | | | RentalPrice | varchar(30) | YES | | NULL | | | RentalStartDate | varchar(30) | YES | | NULL | | | RentalEndDate | varchar(30) | YES | | NULL | | | LeasePrice | varchar(30) | YES | | NULL | | | LeaseStartDate | varchar(30) | YES | | NULL | | | LeaseEndDate | varchar(30) | YES | | NULL | | | RecipetImage | longtext | YES | | NULL | | | AssetImage | longtext | YES | | NULL | | | WarrantyDuration | int(11) | YES | | NULL | | | isActive | tinyint(1) | YES | | NULL | | | isDleted | tinyint(1) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +------------------+-------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Assets for gym fitness center's in the minute.fit ecosystem. Each Assets has their AssetID & AssetUID along with the corresponding Assets data 1. AssetID - Auto-generated ID for each Assets 2. AssetUID - Unique ID for Each Assets 3. AssetTag - Tag For Each Assets 4. AssetSerailNo - Serial NO for Assets 5. BID - Business Account ID 6. ActivitytypeID - ActvTypeID to which Assets for the business Account (from cfg_Activity_type 1,2,3,4,5) 7. AssetTypeID - Fitness CenterID to which Assets for the business Account (from CfgassetTypeID 1,2) 8. PssnTypeID - CfgpssnTypeID to which Assets for the business Account (from cfg_possesion_type 1,2,3) 9. EquipCatTypeID - Equipment Category Type ID to which Assets for the business Account (from cfg_equipment_category_type) 10. EquipGrpID - Equipment ID to which Assets for the business Account (from gym_equipment) 11. EquipSrlNum - Equipment Serial Number to which Assets for the business Account 12. BrandID - BrandID to which Assets for the business Account (from lst_brands) 13. ModelID - ModelID to which Assets for the business Account (from lst_models) 14. AssetName - Assets Name 15. SlotDuration - Slot Duartion for Assets 16. SlotCapacity - Slot Capacity for Assets 17. PurchasePrice - Purchase Price 18. PurchaseDate - Purchase Date 19. RentalPrice - Rental Price 20. RentalStartDate - Rental Start Date 21. RentalEndDate - Rental End Date 22. LeasePrice - Lease Price 23. LeaseStartDate - Lease Start Date 24. LeaseEndDate - Lease End Date 25. RecipetImage - Recipet Image of the Assets 26. AssetImage - Asset Image of the Assets 27. WarrantyDuration - Warranty Duartion 28. isActive - Active Flag 29. isDleted - Deleted Flag 30. Lmts - Updates the Time when new row inserts in table gym_equipment_group; +--------------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-----------+------+-----+-------------------+-----------------------------+ | EquipGrpID | int(11) | NO | PRI | NULL | auto_increment | | EquipGrpUID | int(11) | YES | | NULL | | | BID | int(11) | YES | MUL | NULL | | | EquipCatTypeID | int(11) | YES | MUL | NULL | | | EquipVariantTypeID | int(11) | YES | | NULL | | | BrandID | int(11) | YES | MUL | NULL | | | ModelID | int(11) | YES | MUL | NULL | | | Quantity | int(11) | YES | | NULL | | | EquipSlotDuration | int(11) | YES | | NULL | | | EquipSlotCapacity | int(11) | YES | | NULL | | | ActiveCount | int(11) | YES | | NULL | | | InActiveCount | int(11) | YES | | NULL | | | DeletedCount | int(11) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +--------------------+-----------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Equipment for gym fitness center's in the minute.fit ecosystem. Each Equipment has their EquipGrpID & EquipGrpUID along with the corresponding Equipment data 1. EquipGrpID - Auto-generated ID for each Equipment 2. EquipGrpUID - Unique ID for Each Equipment 3. BID - Business Account ID 4. EquipCatTypeID - Equipment Category Type ID 5. EquipVariantTypeID - Variant ID 6. BrandID - Brand ID 7. ModelID - Model ID 8. Quantity - Quantity of Equipment Users Needs 9. EquipSlotDuration - Equipment Slot Duration 10. EquipSlotCapacity - Equipment Slot Capacity 11. ActiveCount - Active Count for Each Equipment 12. InActiveCount - InActive Count for Each Equipment 13. DeletedCount - Delete Active Count for Each Equipment 14. Lmts - Updates the Time when new row inserts in table gym_equipment_reservation; +----------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+-------------------+-----------------------------+ | EquipResvnID | int(11) | NO | PRI | NULL | auto_increment | | EquipResvnUID | varchar(20) | YES | | NULL | | | BID | int(11) | YES | MUL | NULL | | | ResvnDate | varchar(30) | YES | | NULL | | | EquipCatTypeID | int(11) | YES | MUL | NULL | | | EquipGrpID | int(11) | YES | MUL | NULL | | | AssetID | int(11) | YES | MUL | NULL | | | DayTypeID | int(11) | YES | MUL | NULL | | | BizDayTypeID | int(11) | YES | MUL | NULL | | | NumSlots | int(11) | YES | | NULL | | | EquipSlotIDs | longtext | YES | | NULL | | | UserID | int(11) | YES | MUL | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +----------------+-------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Reservation for gym fitness center's in the minute.fit ecosystem. Each Reservation has their EquipResvnID & EquipResvnUID Based on Busniess Account ID, Equipemnt Group ID, AssetsID, Day Type ID, Biz Day Type ID along with the corresponding Reservation Date 1. EquipResvnID - Auto-generated ID for each Equipment 2. EquipResvnUID - Unique ID for Each Equipment 3. BID - Business Account ID 4. ResvnDate - Date 5. EquipCatTypeID - Equipment Category Type ID 6. EquipGrpID - Equipemnt Group ID 7. AssetID - Assets ID 8. DayTypeID - Day Type ID 9. BizDayTypeID - Busniess Day Type ID 10. NumSlots - Number of Slots User wnat to Reserve 11. EquipSlotIDs - Corresponding Slot ID's 12. UserID - User ID of the user 13. Lmts - Updates the Time when new row inserts in table gym_equipment_reservation_full; +----------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+-------------------+-----------------------------+ | FulyBookedID | int(11) | NO | PRI | NULL | auto_increment | | FulyBookedUID | int(11) | YES | | NULL | | | BID | int(11) | YES | MUL | NULL | | | EquipCatTypeID | int(11) | YES | MUL | NULL | | | Date | varchar(30) | YES | | NULL | | | Status | varchar(30) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +----------------+-------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Reservation for gym fitness center's in the minute.fit ecosystem. Each Reservation has their EquipResvnID & EquipResvnUID Based on Busniess Account ID, Equipemnt Group ID, AssetsID, Day Type ID, Biz Day Type ID along with the corresponding Reservation Date 1. EquipResvnID - Auto-generated ID for each Equipment 2. EquipResvnUID - Unique ID for Each Equipment 3. BID - Business Account ID 4. EquipCatTypeID - Equipment Category Type ID 5. Date - Date of the Reservation Fully Booked 6. Status - Status of the Reservation Full ('Fully Booked', 'cancel') 7. Lmts - Updates the Time when new row inserts in table gym_equipment_category_slot_wise_reservation_count; +-----------------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+-------------+------+-----+-------------------+-----------------------------+ | GymResvnCountID | int(11) | NO | PRI | NULL | auto_increment | | GymResvnCountUID | int(11) | YES | | NULL | | | BID | int(11) | YES | MUL | NULL | | | EquipCatTypeID | int(11) | YES | MUL | NULL | | | Date | varchar(30) | YES | | NULL | | | EquipSessnDailySlotID | int(11) | YES | MUL | NULL | | | TotalResvnCount | int(11) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-----------------------+-------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Reservation for each Category Count Based on Business Account ID for gym fitness center's in the minute.fit ecosystem. Each Reservation Count has their GymResvnCountID & GymResvnCountUID Based on Busniess Account ID, Equipemnt Category Type ID, Slot ID along with the corresponding Reservation Date 1. GymResvnCountID - Auto-generated ID for each Equipment 2. GymResvnCountUID - Unique ID for Each Equipment 3. BID - Business Account ID 4. EquipCatTypeID - Equipment Category Type ID 5. Date - Date of the Reservation 6. EquipSessnDailySlotID - Slot ID 7. TotalResvnCount - ATotal Reservation Count of each Business Account ID, Equipemnt Category Type ID , Date and Slot 8. Lmts - Updates the Time when new row inserts in table gym_fitness_center_member; +----------------+------------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------------+------+-----+-------------------+-----------------------------+ | FcMemberID | int(11) | NO | PRI | NULL | auto_increment | | FcMemberUID | varchar(30) | YES | | NULL | | | FcMemberXID | int(11) | YES | | NULL | | | XBID | int(11) | YES | MUL | NULL | | | FcID | int(11) | YES | MUL | NULL | | | Role | varchar(30) | YES | | NULL | | | MshipPackageID | int(11) | YES | MUL | NULL | | | MShipTypeID | int(11) | YES | MUL | NULL | | | MShipJoinDate | varchar(30) | YES | | NULL | | | XDJoinDate | varchar(30) | YES | | NULL | | | Status | enum('Added','Joined') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +----------------+------------------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Member for gym fitness center's in the minute.fit ecosystem. Each Member has their FcMemberID & FcMemberUID along with the corresponding Member data 1. FcMemberID - Auto-generated ID for each Member 2. FcMemberUID - Unique ID for Each Member 3. FcMemberXID - UserID of the Member 4. XBID - Business Account ID to which Member belongs 5. FcID - Fitness CenterID to which Member belongs 6. Role - User Role 7. MshipPackageID - Member Ship Package ID from gym_fitness_center_membership_packages for Each Business Account 8. MShipTypeID - Member Ship Type ID from cfg_client_type (1, 2) 9. MShipJoinDate - Member Ship Joining Date of an User 10. XDJoinDate - Joining Date of an User in minute.fit ecosystem 11. Status - User joining status (Added or Joined) 12. Lmts - Updates the Time when new row inserts in table gym_fitness_center_membership_packages; +-----------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+-------------------+-----------------------------+ | MshipPackageID | int(11) | NO | PRI | NULL | auto_increment | | MshipPackageUID | varchar(30) | YES | | NULL | | | XBID | int(11) | YES | MUL | NULL | | | FcID | int(11) | YES | MUL | NULL | | | Name | longtext | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-----------------+-------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Member Ship Package for gym fitness center's in the minute.fit ecosystem. Each Member Ship Package has their MshipPackageID & MshipPackageUID along with the corresponding Member Ship Package data 1. MshipPackageID - Auto-generated ID for each Member Ship Package 2. MshipPackageUID - Unique ID for Each Member Ship Package 3. XBID - Business Account ID to which Member Ship Package belongs 4. FcID - Fitness CenterID to which Member Ship Package belongs for each Busniess Account 5. Name - Name of the Member Ship Package for each Business Account (At Present 'Standard' Member Ship Package for All Business Account) 6. Lmts - Updates the Time when new row inserts in table +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ LST +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ lst_brands; +-------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-----------+------+-----+-------------------+-----------------------------+ | LstBrandID | int(11) | NO | PRI | NULL | auto_increment | | LstBrandUID | int(11) | YES | | NULL | | | Logo | longtext | YES | | NULL | | | Description | longtext | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-------------+-----------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Brands for gym fitness center's in the minute.fit ecosystem. Each Brand has their LstBrandID & LstBrandUID along with the corresponding Brand data 1. LstBrandID - Auto-generated ID for each Brand 2. LstBrandUID - Unique ID for Each Brand 3. Logo - Logo for the Brand 4. Description - Description for Each Brand 5. Lmts - Updates the Time when new row inserts in table lst_models; +--------------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------+------+-----+-------------------+-----------------------------+ | LstmodelID | int(11) | NO | PRI | NULL | auto_increment | | LstmodelUID | int(11) | YES | | NULL | | | BrandID | int(11) | YES | MUL | NULL | | | EquipVariantTypeID | int(11) | YES | MUL | NULL | | | EquipCatTypeID | int(11) | YES | MUL | NULL | | | ProductCode | varchar(30) | YES | | NULL | | | Image | longtext | YES | | NULL | | | Description | longtext | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +--------------------+-------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Models for gym fitness center's in the minute.fit ecosystem. Each Model has their LstmodelID & LstmodelUID along with the corresponding Model data 1. LstmodelID - Auto-generated ID for each BranModeld 2. LstmodelUID - Unique ID for Each Model 3. EquipVariantTypeID - Equipment Variant Type ID of which Product for the business Account (from cfg_equipment_variant_type) 4. BrandID - BrandID of which Product for the business Account (from lst_brands) 5. EquipCatTypeID - EquipCatTypeID of which Equipment for the business Account (from cfg_equipment_category_type) 6. ProductCode - Product Code 7. Image - Image of the Model 8. Description - Description for Each Model Number 9. Lmts - Updates the Time when new row inserts in table lst_Business_days; +--------------+-------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+-------------------+-----------------------------+ | BizDayID | int(11) | NO | PRI | NULL | auto_increment | | BizDayUID | varchar(31) | YES | | NULL | | | CountryID | int(11) | YES | | NULL | | | BizDayTypeID | int(11) | YES | | NULL | | | DayNames | longtext | YES | | NULL | | | Year | varchar(30) | YES | | NULL | | | Date | varchar(30) | YES | | NULL | | | HolidayNames | longtext | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +--------------+-------------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Business Days for gym fitness center's in the minute.fit ecosystem. Each Business Days has their BizDayID & BizDayUID along with the corresponding Business Days data 1. BizDayID - Auto-generated ID for each BranModeld 2. BizDayUID - Unique ID for Each Model 3. CountryID - CountryID from glb_countries 4. BizDayTypeID - BizDayTypeID from cfg_Business_Day_Type 5. DayNames - Day Names 6. Year - Year of the Business days (if Holiday) 7. Date - Date of the Business days (if Holiday) 8. HolidayNames - Name of the Corresponding Holiday 9. Lmts - Updates the Time when new row inserts in table Table sets out the weekdays, weekends and Holidays By country. For example, For Country = SAUDI Arabia, this table wil state that: - weekends (BizDayTypeID = 2) are Friday and Saturday, - weekdays (BizDayTypeID = 1) are Mon, Tue, Wed, Thu and Sun - Holidays (BizDayTypeID = 3) are for the given year as per saudi national holiday calendar (either entered manually or imported automatically ) - Note : a. Year is applicable only for Holidays (BizDayTypeID = 3) B. year = NULL for weekdays and Weekends (BizDayTypeID = 1,2) +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DFT +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ dft_session_slot_Parameters; +---------------------+-----------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-----------+------+-----+-------------------+-----------------------------+ | DftSessnSlotID | int(11) | NO | PRI | NULL | auto_increment | | DftSessnSlotUID | int(11) | YES | | NULL | | | BID | int(11) | YES | MUL | NULL | | | SessnTypeID | int(11) | YES | MUL | NULL | | | EquipCatTypeID | int(11) | YES | MUL | NULL | | | SessnSlotDurnTypeID | int(11) | YES | | NULL | | | SessnSlotCapacity | int(11) | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +---------------------+-----------+------+-----+-------------------+-----------------------------+ ** Table contains the list of Default Session Slot parameters for different kind of sessions i.e, SessionTypeIDs (Equipment, Bay & Class) in the minute.fit ecosystem. Each Default Session Slot has their DftSessnSlotID & DftSessnSlotUID along with the corresponding Default Session Slot parameters such as slot duration (SessnSlotDuRnTypeID) and slot capacity (SessnSlotCapacity). This table contains defsult values for all BIDs and thier EquipCatTypeIDs (BID column = NULL, EquipCatTypeID = NULL). Therefore, If any BID wants to change its default values for a particualr SessionType they can do that in settings and it will add an additional row in this table with custom values indexed to that BID and associated SessnTypeID with EquipCatTypeID = NULL. Furthermore, if BID wants to specify Session Slot Paramter values for each Equipment Category (E.g Different slot durantion for Treadmill & Bike), it can do that in the settings by changing default value for that Category and this value will be stored in this table as a new row indexing, EquipCatType ID along with Associated BID and SessnTypeID. At the present, we are only handling Equipment sessions (SessnTypeID = 1). 1. DftSessnSlotID - Auto-generated ID for each Default Session Slot 2. DftSessnSlotUID - Unique ID for Each Default Session Slot 3. SessnTypeID - SessnTypeID (from cfg_session_type) 4. SessnSlotSchdTypeID - SessnSlotSchdTypeID (from cfg_session_slot_schedule_type) 5. SessnSlotMapTypeID - SessnSlotMapTypeID (from cfg_session_slot_mapping_type) 6. DftSessnDuration - Default Session Duration for Equipment 7. DftSessnCapacity - Default Session Capacity for Equipment 6. Lmts - Updates the Time when new row inserts in table