Woozle: HyperAdmin
This is my attempt to create a general user administration system for use by other web-based applications (mostly mine) which might need one.
Tables
- "K" indicates Primary Key fields
- "#" indicates autonumbered fields
Main data tables
- users -- users with access to the admin system
| #K |
ID |
int(4)
|
|
Name |
varchar(32)
|
|
Pass |
text
|
|
Email |
varchar(128) |
email address for password confirmation and such
|
|
WhenGood |
timestamp |
when user last logged in
|
|
WhenBad |
timestamp |
when user last attempted to log in but failed (bad password)
|
|
QtyFails |
int(4) |
number of failed login attempts since last success
|
- groups -- each group has a role to play, and each role requires a particular set of privileges
| #K |
ID |
int(4)
|
|
Name |
varchar(32)
|
|
Descr |
text |
text describing the purpose of this group
|
- privs -- particular privileges; meaning is defined in code
| #K |
ID |
int(4)
|
|
Name |
varchar(32)
|
|
Descr |
text |
text describing this permission
|
Collection/link tables
- users_x_groups -- users in each group / groups to which each user belongs
| K |
ID_User |
int(4) |
users.ID
|
| K |
ID_Group |
int(4) |
groups.ID
|
- groups_x_privs -- privileges each group has / groups having a particular privilege
| K |
ID_Group |
int(4) |
groups.ID
|
| K |
ID_Priv |
int(4) |
privs.ID
|
Logging tables
- log -- logs of login attempts as well as what users did while logged in
| K# |
ID |
int(4)
|
|
ID_User |
int(4) |
users.ID - which user, if any (NULL = unknown user)
|
|
ID_Session |
int(4) |
sessions.ID - more information in case user is unknown
|
|
When |
timestamp |
when this action was taken
|
|
Seq |
int(4) |
Order in which actions were executed, if done at the same time
|
|
Descr |
text |
description of action taken (should be very specific)
|