GeneX-2.0 DB: GroupSec Table
GeneX-2.0 DB: GroupSec Table
Table TypeInheritsComment
DATAnone The GroupSec table denotes the groups to which users may be assigned and with which certain data items (ExperimentSet, PhysicalBioAssay) may be associated for access and security purposes.

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.
descriptionDescriptionchar128false a meaningful description of the group
nameGroup NamenamefalseThe name of the group used in all other tables
ro_groupnameRead-Only Group NamenamefalseThe group with permission to view this data.
rw_groupnameRead/Write Group NamenamefalseThe group with permission to modify this data.

Primary Key Information
Column Name
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