| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| USER_GROUP_TYPES_ID | NUMBER(38) | N | ||
| GROUP_TYPE | VARCHAR2(20.0) | N | ||
| PRETTY_NAME | VARCHAR2(50.0) | N | ||
| PRETTY_PLURAL | VARCHAR2(50.0) | N | ||
| APPROVAL_POLICY | VARCHAR2(30.0) | N | ||
| DEFAULT_NEW_MEMBER_POLICY | VARCHAR2(30.0) | N | 'open' | |
| GROUP_MODULE_ADMINISTRATION | VARCHAR2(20.0) | Y | ||
| HAS_VIRTUAL_DIRECTORY_P | CHAR(1.0) | Y | 'f' | |
| GROUP_TYPE_PUBLIC_DIRECTORY | VARCHAR2(200.0) | Y | ||
| GROUP_TYPE_ADMIN_DIRECTORY | VARCHAR2(200.0) | Y | ||
| GROUP_PUBLIC_DIRECTORY | VARCHAR2(200.0) | Y | ||
| GROUP_ADMIN_DIRECTORY | VARCHAR2(200.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087279 | USER_GROUP_TYPES_ID |
| Constraint Name | Check Condition |
|---|---|
| GROUP_TYPE_MODULE_ADMIN_CHECK | (group_module_administration is not null) and (group_module_administration in ('full', 'enabling', 'none')) |
| SYS_C002087273 | "GROUP_TYPE" IS NOT NULL |
| SYS_C002087274 | "PRETTY_NAME" IS NOT NULL |
| SYS_C002087275 | "PRETTY_PLURAL" IS NOT NULL |
| SYS_C002087276 | "APPROVAL_POLICY" IS NOT NULL |
| SYS_C002087277 | "DEFAULT_NEW_MEMBER_POLICY" IS NOT NULL |
| SYS_C002087278 | has_virtual_directory_p in ('t','f') |
| Constraint name | Columns |
|---|---|
| SYS_C002087280 | GROUP_TYPE |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087279 | NORMAL | UNIQUE | USER_GROUP_TYPES_ID |
| SYS_C002087280 | NORMAL | UNIQUE | GROUP_TYPE |
| Table | Constraint |
|---|---|
| USER_GROUP_TYPE_FIELDS | SYS_C002087288 |
| USER_GROUPS | SYS_C002087307 |
| USER_GROUP_TYPE_MEMBER_FIELDS | SYS_C002087354 |
| USER_GROUP_TYPE_MODULES_MAP | SYS_C002087367 |