RHNUSERCHANNELFAMILYPERMS
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| CHANNEL_FAMILY_ID | NUMBER(38) | Y | NO | NO | NO | |
| ORG_ID | NUMBER(38) | Y | NO | NO | NO | |
| USER_ID | NUMBER(38) | Y | NO | NO | NO | |
| MAX_MEMBERS | NUMBER(38) | Y | NO | NO | NO | |
| CURRENT_MEMBERS | NUMBER(38) | Y | NO | NO | NO | |
| CREATED | DATE | Y | NO | NO | NO | |
| MODIFIED | DATE | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select pcf.channel_family_id,
u.org_id org_id,
u.id user_id,
to_number(null) max_members,
0 current_members,
pcf.created,
pcf.modified
from rhnPublicChannelFamily pcf,
web_contact u
union
select pcf.channel_family_id,
u.org_id,
u.id user_id,
pcf.max_members,
pcf.current_members,
pcf.created,
pcf.modified
from rhnPrivateChannelFamily pcf,
web_contact u
where u.org_id = pcf.org_id