GeneX Development Supported By
|
GeneX-2.0 DB: GroupLink Table
|
GeneX-2.0 DB: GroupLink Table
|
| Table Type | Inherits | Comment |
| LINKING | none | 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 Name | Full Name | Data Type | Not NULL | Comment |
| groupname | Group Name | name | true | The group's name in the GroupSec table |
| username | User Name | name | true | The user's name in the pg_user table |
| Primary Key Information |
| Column Name |
| Foreign Key Information |
| Column Name | Foreign Table | Primary Key in Foreign Table | Foreign Key Type |
| groupname | GroupSec | name | LINKING_TABLE |
| username | UserSec | username | LINKING_TABLE |
| Unique Column Information |
| Column Names |
| username groupname |
| Index Information |
| Name | Column Name |
| groupname | grouplink_groupname |
| username | grouplink_username |
|