RHNCHANNELFAMILYOVERVIEW
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ORG_ID | NUMBER(38) | N | YES | YES | YES | |
| ID | NUMBER(38) | N | NO | NO | NO | |
| NAME | VARCHAR2(128) | N | NO | NO | NO | |
| URL | VARCHAR2(128) | N | NO | NO | NO | |
| LABEL | VARCHAR2(128) | N | NO | NO | NO | |
| CURRENT_MEMBERS | NUMBER(38) | Y | NO | NO | NO | |
| MAX_MEMBERS | NUMBER(38) | Y | YES | YES | YES | |
| HAS_SUBSCRIPTION | NUMBER(38) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select pcf.org_id as org_id,
f.id as id,
f.name as name,
f.product_url as url,
f.label as label,
coalesce(pcf.current_members,0) as current_members,
pcf.max_members as max_members,
1 as has_subscription
from rhnChannelFamily f,
rhnPrivateChannelFamily pcf
where pcf.channel_family_id = f.id