Contents Index SYSFOREIGNKEY system table SYSINDEX system table

ASA SQL Reference
  System Tables

SYSGROUP system table


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.


Contents Index SYSFOREIGNKEY system table SYSINDEX system table