Entity Managed Group

DescriptionAn ad hoc group that is created by a user who owns the group.

For example:
A grouping of diagnosis codes for analysis purposes

Attributes
Group Visibility TypeGroup Visibility Type

Relationship
Managed Group_User_FKManaged Group_User_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Group Visibility Type
DescriptionIndicates the extent to which the group is visible to users other than its owner. For example, the group can be private, visible to the user's group or to everyone.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Managed Group_User_FK
Is Identifying Relationshipfalse
Child TableManaged Group
Child Role Nameis managed by
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableUser
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypeGroup
SubtypeManaged Group
Transform AsTABLE