RHNCHANNELFAMILYSERVERS
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| CUSTOMER_ID | NUMBER(38) | N | NO | NO | NO | |
| CHANNEL_FAMILY_ID | NUMBER(38) | N | NO | NO | NO | |
| SERVER_ID | NUMBER(38) | N | YES | YES | YES | |
| CREATED | DATE | N | YES | YES | YES | |
| MODIFIED | DATE | N | YES | YES | YES | |
Query:
Legend: string keyword reserved word operator
select rs.org_id customer_id,
rcfm.channel_family_id channel_family_id,
rsc.server_id server_id,
rsc.created created,
rsc.modified modified
from rhnChannelFamilyMembers rcfm,
rhnChannelFamily rcf,
rhnServerChannel rsc,
rhnServer rs
where
rcfm.channel_id = rsc.channel_id
and rcfm.channel_family_id = rcf.id
and rsc.server_id = rs.id