ASA SQL Reference
System Tables
Column name | Column type | Column constraint | Table constraints |
---|---|---|---|
group_id | UNSIGNED INT | NOT NULL | Primary key, foreign key references SYSUSERPERM.user_id |
group_member | UNSIGNED INT | NOT NULL | Primary key, foreign key references SYSUSERPERM.user_id |
There is one row in SYSGROUP for every member of every group. This table describes a many-to-many relationship between groups and members. A group may have many members, and a user may be a member of many groups.
group_id The user number of group.
group_member The user number of a member.