glb_user; +-------------------+----------------------------------------+------+-----+-------------------+-----------------------------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+----------------------------------------+------+-----+-------------------+-----------------------------------------------+ | XID | int | NO | PRI | NULL | auto_increment | | XUID | char(5) | YES | | NULL | Null values | | UserTypeID | int | YES | MUL | NULL | Null values | | UserName | varchar(30) | YES | | NULL | Not null, And require values | | EmailAddress | varchar(50) | YES | | NULL | Required | | Password | longtext | YES | | NULL | Random 6 digit string/ Number/Alphanumeric | | DateofBirth | longtext | YES | | NULL | Require | | MobileCode | varchar(30) | YES | | NULL | Require | | PhoneNumber | varchar(30) | YES | | NULL | Require | | Address | longtext | YES | | NULL | Required | | City | varchar(30) | YES | | NULL | Required | | State | varchar(30) | YES | | NULL | R | | Country | varchar(30) | YES | | NULL | R | | Pincode | varchar(30) | YES | | NULL | R | | FirstName | varchar(30) | YES | | NULL | R | | MiddleName | varchar(30) | YES | | NULL | R | | LastName | varchar(30) | YES | | NULL | R | | Gender | varchar(30) | YES | | NULL | R | | ProfilePicture | longtext | YES | | NULL | It can be null | | JoiningDate | date | YES | | NULL | null | | OnlineStatus | enum('Active','Inactive','Logged out') | YES | | NULL | null | | Status | enum('Active','Suspended') | YES | | NULL | Empty/null | | IsVerified | tinyint(1) | YES | | NULL | Empty/null | | IsResetPasswd | tinyint(1) | YES | | NULL | Empty/null | | IsWizardCompleted | tinyint(1) | YES | | NULL | Empty/null | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP | +-------------------+----------------------------------------+------+-----+-------------------+-----------------------------------------------+ +---------------------+------------------------+------+-----+-------------------+-----------------------------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+------------------------+------+-----+-------------------+-----------------------------------------------+ | StaffID | int | NO | PRI | NULL | auto_increment | | StaffUID | varchar(30) | YES | | NULL | | | XID | int | YES | MUL | NULL | | | PXBID | int | YES | | NULL | | | XBID | int | YES | MUL | NULL | | | GymID | int | YES | MUL | NULL | | | Role | varchar(30) | YES | | NULL | | | Title | varchar(30) | YES | | NULL | | | EmplTypeID | int | YES | MUL | NULL | | | JoinDate | varchar(30) | YES | | NULL | | | XDJoinDate | varchar(30) | YES | | NULL | | | RolesID | varchar(30) | YES | | NULL | | | AddedDate | varchar(30) | YES | | NULL | | | RegisteredDate | varchar(30) | YES | | NULL | | | Status | enum('Added','Joined') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP | +---------------------+------------------------+------+-----+-------------------+-----------------------------------------------+ +-----------------+------------------------+------+-----+-------------------+-----------------------------------------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+------------------------+------+-----+-------------------+-----------------------------------------------+ | MemberID | int | NO | PRI | NULL | auto_increment | | MemberUID | varchar(30) | YES | | NULL | | | XID | int | YES | | NULL | | | XBID | int | YES | MUL | NULL | | | GymID | int | YES | MUL | NULL | | | Role | varchar(30) | YES | | NULL | | | MShipPlanTypeID | int | YES | MUL | NULL | | | MShipTypeID | int | YES | MUL | NULL | | | XDJoinDate | varchar(30) | YES | | NULL | | | AddedDate | varchar(30) | YES | | NULL | | | RegisteredDate | varchar(30) | YES | | NULL | | | Status | enum('Added','Joined') | YES | | NULL | | | Lmts | timestamp | NO | | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP | +-----------------+------------------------+------+-----+-------------------+-----------------------------------------------+