GeneX-2.0 DB: GroupLink Table
GeneX-2.0 DB: GroupLink Table
Table TypeInheritsComment
LINKINGnone The GroupLink table creates a many-to-many relationship between pg_user and GroupSec. A user may belong to many groups and a group may contain many users.

Column Information
Column NameFull NameData TypeNot NULLComment
groupnameGroup NamenametrueThe group's name in the GroupSec table
usernameUser NamenametrueThe user's name in the pg_user table

Primary Key Information
Column Name

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
groupnameGroupSecnameLINKING_TABLE
usernameUserSecusernameLINKING_TABLE

Unique Column Information
Column Names
username groupname

Index Information
NameColumn Name
groupnamegrouplink_groupname
usernamegrouplink_username