Summary of the "people_" fields in ListManager
The people_ table hold server and site administrators, as well as other significant 'peopl'e to the server operation. A person can be listed in this table and not be a server or site admin because they may be a contact person for a list. The sites that an admin has rights over is listed as vertical bar (|) separated list in the WhatSites_ column. If a site admin needs to support more sites than can fit into this column a second people_ table entry should be created, or the person should be elevated to a server admin. This design is likely to change in the future.
Primary key: Name_
|
Comment_ |
Comments about this person (text, NULL) |
|
EmailAddr_ |
Person's email address (varchar(100), NULL) |
|
FaxNum_ |
Person's fax number (varchar(50), NULL) |
|
Name_ |
Unique name of the person (varchar(50), NOT NULL) |
|
Password_ |
Password for this person (not needed if not admin) (varchar(50), NULL) |
|
PostAddr_ |
Person's postal address (varchar(238), NULL) |
|
ServerAdm_ |
Is this person a server admin? (bool) |
|
Site_ |
Name of site this person belongs to. May be 'all', indicating that the sites are stored in WhatSites_. (varchar(50), NOT NULL) |
|
SiteAdmin_ |
Is this person a site administrator? (bool) |
|
TelNum_ |
Person's telephone number (varchar(50), NULL) |
|
WhatSites_ |
What sites can this person administer. Site names in a string separated by | (for site admin only) (varchar(238), NULL) |
|
|