Destinations
Download GeneX Software
Development
Required Software
Suggested Software
Documentation & Help
Troubleshooting
Related Resources
GeneX Development Supported By
 Tracker
- Bugs
( 53 open / 229 total )
- Support Requests
( 0 open / 0 total )
- Patches
( 0 open / 0 total )
- Feature Requests
( 8 open / 70 total )  Forums ( 3 messages in 3 forums )
 Doc Manager
 Mailing Lists ( 5 mailing lists )
Screenshots
Task Manager
- SourceForge.net WWW Site - Genex Server - Documentation  CVS Tree ( 2502 commits, 834 adds ) 
 Released Files
|
| GeneX-2.0 DB: UserSec Table | ||
|---|---|---|
| Table Type | Inherits | Comment |
| DATA | none | The UserSec is now a mirror of the system user table (pg_user for Postgres), and mainly exists to store a reference to the contact information for the user. |
| Column Information | ||||
|---|---|---|---|---|
| Column Name | Full Name | Data Type | Not NULL | Comment |
| audit_fk | Audit | int | true | The audit entry when this data was last modified, it will be null if it is the creation event. We set the write_sql attribute to be false so that Postgres doesn't put a constraint on this column. It is automatically set by a trigger. |
| con_fk | Contact Information | int | true | the users contact information |
| ro_groupname | Read-Only Group Name | name | true | The group with permission to view this data. |
| rw_groupname | Read/Write Group Name | name | true | The group with permission to modify this data. |
| username | User Name | name | false | The user's name in the system user table |
| Primary Key Information |
|---|
| Column Name |
| username |
| Foreign Key Information | |||
|---|---|---|---|
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| audit_fk | Audit | audit_pk | ONE_TO_ONE |
| con_fk | Contact | con_pk | MANY_TO_ONE |
| ro_groupname | GroupSec | name | ONE_TO_ONE |
| rw_groupname | GroupSec | name | ONE_TO_ONE |
| Unique Column Information |
|---|
| Column Names |
| username con_fk |
| Index Information | |
|---|---|
| Name | Column Name |
genex-dev@lists.sourceforge.net