| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| GROUP_ID | NUMBER(38) | N | ||
| GROUP_TYPE | VARCHAR2(20.0) | N | ||
| GROUP_NAME | VARCHAR2(100.0) | Y | ||
| SHORT_NAME | VARCHAR2(100.0) | N | ||
| ADMIN_EMAIL | VARCHAR2(100.0) | Y | ||
| REGISTRATION_DATE | DATE | N | sysdate | |
| CREATION_USER | NUMBER(38) | N | ||
| CREATION_IP_ADDRESS | VARCHAR2(50.0) | N | ||
| APPROVED_P | CHAR(1.0) | Y | ||
| ACTIVE_P | CHAR(1.0) | Y | 't' | |
| EXISTENCE_PUBLIC_P | CHAR(1.0) | Y | 't' | |
| NEW_MEMBER_POLICY | VARCHAR2(30.0) | N | 'open' | |
| SPAM_POLICY | VARCHAR2(30.0) | N | 'open' | |
| EMAIL_ALERT_P | CHAR(1.0) | Y | 'f' | |
| MULTI_ROLE_P | CHAR(1.0) | Y | 'f' | |
| GROUP_ADMIN_PERMISSIONS_P | CHAR(1.0) | Y | 'f' | |
| INDEX_PAGE_ENABLED_P | CHAR(1.0) | Y | 'f' | |
| BODY | CLOB | Y | ||
| HTML_P | CHAR(1.0) | Y | 'f' | |
| MODIFICATION_DATE | DATE | Y | ||
| MODIFYING_USER | NUMBER(38) | Y | ||
| PARENT_GROUP_ID | NUMBER(38) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087305 | GROUP_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087289 | "GROUP_TYPE" IS NOT NULL |
| SYS_C002087290 | "SHORT_NAME" IS NOT NULL |
| SYS_C002087291 | "REGISTRATION_DATE" IS NOT NULL |
| SYS_C002087292 | "CREATION_USER" IS NOT NULL |
| SYS_C002087293 | "CREATION_IP_ADDRESS" IS NOT NULL |
| SYS_C002087294 | "NEW_MEMBER_POLICY" IS NOT NULL |
| SYS_C002087295 | "SPAM_POLICY" IS NOT NULL |
| SYS_C002087296 | approved_p in ('t','f') |
| SYS_C002087297 | active_p in ('t','f') |
| SYS_C002087298 | existence_public_p in ('t','f') |
| SYS_C002087300 | email_alert_p in ('t','f') |
| SYS_C002087301 | multi_role_p in ('t','f') |
| SYS_C002087302 | group_admin_permissions_p in ('t','f') |
| SYS_C002087303 | index_page_enabled_p in ('t','f') |
| SYS_C002087304 | html_p in ('t','f') |
| USER_GROUPS_SPAM_POLICY_CHECK | spam_policy in ('open','closed','wait') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087307 | GROUP_TYPE | USER_GROUP_TYPES | SYS_C002087280 | NO ACTION |
| SYS_C002087308 | CREATION_USER | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002087309 | MODIFYING_USER | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002087310 | PARENT_GROUP_ID | USER_GROUPS | SYS_C002087305 | NO ACTION |
| Constraint name | Columns |
|---|---|
| SYS_C002087306 | SHORT_NAME |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087305 | NORMAL | UNIQUE | GROUP_ID |
| SYS_C002087306 | NORMAL | UNIQUE | SHORT_NAME |
| SYS_IL0001976368C00018$$ | LOB | UNIQUE | |
| USER_GROUPS_PARENT_GRP_ID_IDX | NORMAL | NONUNIQUE | PARENT_GROUP_ID |
| Table | Constraint |
|---|---|
| IM_OFFICES | IM_OFFICES_GROUP_ID_FK |
| USER_GROUPS | SYS_C002087310 |
| USER_GROUP_MAP | SYS_C002087317 |
| USER_GROUP_MAP_QUEUE | SYS_C002087321 |
| USER_GROUP_ROLES | SYS_C002087328 |
| USER_GROUP_ACTIONS | SYS_C002087335 |
| USER_GROUP_ACTION_ROLE_MAP | SYS_C002087344 |
| ADMINISTRATION_INFO | SYS_C002087349 |
| USER_GROUP_MEMBER_FIELDS | SYS_C002087359 |
| USER_GROUP_MEMBER_FIELD_MAP | SYS_C002087362 |
| GROUP_MEMBER_EMAIL_PREFERENCES | SYS_C002087373 |
| GROUP_SPAM_HISTORY | SYS_C002087381 |
| CONTENT_SECTIONS | SYS_C002087418 |
| GENERAL_PERMISSIONS | SYS_C002087441 |
| NEWSGROUPS | SYS_C002087448 |
| CALENDAR_CATEGORIES | SYS_C002087469 |
| BBOARD_TOPICS | SYS_C002087517 |
| CSS_SIMPLE | SYS_C002087623 |
| CSS_COMPLETE | SYS_C002087632 |
| PAGE_LOGOS | SYS_C002087642 |
| DOWNLOADS | SYS_C002087654 |
| FAQS | SYS_C002087718 |
| ADDRESS_BOOK | SYS_C002087769 |
| CHAT_ROOMS | SYS_C002087781 |
| CHAT_ROOMS | SYS_C002087782 |
| FS_FILES | SYS_C002087847 |
| GENERAL_COMMENTS | SYS_C002087883 |
| TICKET_PROJECTS | SYS_C002087947 |
| TICKET_DOMAINS | SYS_C002087964 |
| TICKET_DOMAIN_PROJECT_MAP | SYS_C002087972 |
| PORTAL_PAGES | SYS_C002088037 |
| PRESS | SYS_C002088085 |
| AD_PARTNER | SYS_C002088091 |
| AD_PARTNER_GROUP_MAP | SYS_C002088109 |
| WP_PRESENTATIONS | SYS_C002088136 |
| EVENT_INFO | SYS_C002088198 |
| EVENTS_ACTIVITIES | SYS_C002088206 |
| EVENTS_EVENTS | SYS_C002088231 |
| IM_CUSTOMERS | SYS_C002088345 |
| IM_PROJECTS | SYS_C002088364 |
| IM_PARTNERS | SYS_C002088474 |
| IM_EMPLOYEE_PIPELINE | SYS_C002088516 |
| IM_EMPLOYEE_PIPELINE | SYS_C002088517 |
| SURVSIMP_RESPONSES | SYS_C002088588 |
| MANUALS | SYS_C002088623 |
| Name: USER_GROUP_APPROVED_P_TR |
|---|
CREATE TRIGGER user_group_approved_p_tr
before insert on user_groups
for each row
REFERENCING NEW AS NEW OLD AS OLD
declare
group_type_row user_group_types%ROWTYPE;
begin
if :new.approved_p is null then
select * into group_type_row from user_group_types ugt
where ugt.group_type = :new.group_type;
if group_type_row.approval_policy = 'open' then
:new.approved_p := 't';
else
:new.approved_p := 'f';
end if;
end if;
end;
|