GeneX-2.0 DB: Securable Table
GeneX-2.0 DB: Securable Table
Table TypeInheritsComment
DATAnone The Securable table is an abstract table that provides security information, and audit tracking information

Column Information
Column NameFull NameData TypeNot NULLComment
audit_fkAuditinttrueThe 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.
ro_groupnameRead-Only Group NamenametrueThe group with permission to view this data
rw_groupnameRead/Write Group NamenametrueThe group with permission to modify this data

Primary Key Information
Column Name

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
audit_fkAuditaudit_pkONE_TO_ONE
ro_groupnameGroupSecnameONE_TO_ONE
rw_groupnameGroupSecnameONE_TO_ONE

Unique Column Information
Column Names

Index Information
NameColumn Name