user_group

27 rows


Description

User Group

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('user_group_id_seq'::regclass)
dashboard.user_id fk_dashboard_user_group_id C
group_permission.group_id fk_group_permission_group_id C
group_permission_override.group_id fk_group_permission_override_group_id C
user_roles.group_id fk_user_roles_group_id C
users.user_group_id fk_users_group R
prop_id int4 10 √ null
property.id fk_user_group_prop_id C
prop_group_id int4 10 √ null
property_group.id fk_user_group_prop_group C
name text 2147483647 √ null
group_type bpchar 1 √ 'Property'::grouptype

S = System Group (Reserve for newsoft only) G = Group Administrator (for Hotel Group) P = Property Administrator U = Normal User D = Default User Group (Same as Normal User, but cannot modify or delete group)
enabled bool 1 √ true
app_code text 2147483647 √ 'pms'::text

Owning app for an app-specific role. NULL is reserved for the three global system roles shared by every app.
is_default bool 1 false

Indexes

Constraint Name Type Sort Column(s)
user_group_pkey Primary key Asc id
idx_user_group_app_prop Performance Asc/Asc app_code + prop_id
unq_user_group_standard Must be unique Asc name

Check Constraints

Constraint Name Constraint
chk_user_group_global_system_role ((app_code IS NOT NULL) OR ((group_type = 'S'::bpchar) AND (prop_id IS NULL) AND (prop_group_id IS NULL) AND (name = ANY (ARRAY['System Administrator'::text, 'System Support'::text, 'Developer'::text]))))

Relationships

Close relationships within degrees of separation