GeneX Development Supported By
|
GeneX-2.0 DB: ChangeLog Table
|
GeneX-2.0 DB: ChangeLog Table
|
| Table Type | Inherits | Comment |
| DATA | none | |
| 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. |
| cl_pk | Accession Number | serial | false | |
| description | Description | text | false | |
| version_date | Date of Version Creation | datetime | false | |
| version_number | DB Version | char128 | false | |
| Primary Key Information |
| Column Name |
| cl_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 |
|