794 rows.
| id | int(10) unsigned | Group ID |
|---|---|---|
| type | char(1) | One of {G,M,O,W}. ??? |
| acRep | int(10) unsigned | One of {0,3,9729}. ??? |
| entityEncoded | varchar(255) | Looks like a long descriptive name. |
| alphaname | varchar(255) | Looks like entityEncoded... |
| category | varchar(100) | Looks like an arbitrary categorization scheme. Is this used??? |
| name | varchar(255) | Looks like alphaname... |
| notes | text | Unused |
| last | timestamp(14) | Timestamp for ??? |
8370 rows.
| id | int(10) unsigned | The User ID. |
|---|---|---|
| family | varchar(255) | Family name |
| given | varchar(255) | Given name |
| prefix | varchar(255) | Prefix (Mr., Mrs., etc.) |
| status | int(10) unsigned | One of {0,32,36}. ??? |
| passwd | varchar(40) | Encrypted password??? |
| mailback | varchar(40) | All NULL. ??? |
| varchar(255) | Email address | |
| emailUrisId | int(10) unsigned | ??? |
| phone | varchar(32) | Phone number |
| position | varchar(255) | User's position in their company. |
| ac | varchar(255) | 618 rows; the company that sponsors them? |
| acEric | int(10) unsigned | ??? |
| url | varchar(255) | A URL that is associated with the user. |
| last | timestamp(14) | Timstamp for ??? |
| cleartxt | varchar(40) | Cleartext password??? |
| notes | text | Notes about the user. |
| phonesId | int(10) unsigned | ??? |