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: Audit Table | ||
|---|---|---|
| Table Type | Inherits | Comment |
| DATA | none | The Audit table tracks changes to the individual rows of other tables. |
| Column Information | ||||
|---|---|---|---|---|
| Column Name | Full Name | Data Type | Not NULL | Comment |
| audit_fk | Audit | int | false | 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. |
| audit_pk | Accession Number | serial | false | |
| modification_date | Modification Date | datetime | true | the date when this entry was last modified |
| modified_by | Modified By | name | false | the DB user who made the last modification on this entry |
| Primary Key Information |
|---|
| Column Name |
| audit_pk |
| Foreign Key Information | |||
|---|---|---|---|
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| audit_fk | Audit | audit_pk | ONE_TO_ONE |
| Unique Column Information |
|---|
| Column Names |
| Index Information | |
|---|---|
| Name | Column Name |
genex-dev@lists.sourceforge.net