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: Role Table | ||
|---|---|---|
| Table Type | Inherits | Comment |
| SUBSET | none | Role is a generic association table that enables different DB entries to be assigned Roles. Roles enable applications to filter their actions. Roles can be assigned not only to users, but to DB tables, or data entries such as Contacts. |
| Column Information | ||||
|---|---|---|---|---|
| Column Name | Full Name | Data Type | Not NULL | Comment |
| other_fk | Other Foreign Key | int | true | This fkey points to the DB entry to which this role is assigned. It is not listed as a fkey constraint, because it can point to any table in the DB. |
| role_name | Role Name | char128 | true | A controlled vocabulary |
| table_name | Table Name | char32 | true | The table to which the entry specified by other_fk belongs. |
| Primary Key Information |
|---|
| Column Name |
| Foreign Key Information | |||
|---|---|---|---|
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| Unique Column Information |
|---|
| Column Names |
| other_fk role_name |
| Index Information | |
|---|---|
| Name | Column Name |
genex-dev@lists.sourceforge.net