APP_User_In_Group

This table handles the assignment of users to groups. It works through User_Id and Group_Id references to the User_Id in the APP_User table, where User_Id refers to the individual user who has an Is_Group flag equal to 0, and Group_Id refers to a record where this flag equals 1, which represents the actual group. Essentially, this is a many-to-many relationship table that lets you assign multiple users to multiple groups.

Columns

#	Column	Data Type	Nullable	PK	Identity	Computed	Collation
1	User_In_Group_Id	int	No	Yes	Yes	No
2	User_Id	int	No	No	No	No
3	Group_Id	int	No	No	No	No

Foreign Keys

Column	References
Group_Id	APP_User.User_Id
User_Id	APP_User.User_Id