The USERS table stores user ID (a unique name), password (MD5 hash), password expiry date, whether the account is locked or not, and the number of failed login attempts.
The GROUPS table stores group IP (a unique name).
The GROUP_MEMBERSHIP table stores group ID and user ID, where each row represents a membership.