RHNSERVERINFO
DDL scriptColumns
Name | Type | Nullable | Default value | Comment |
---|
SERVER_ID | NUMBER(38) | N | | |
CHECKIN | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | (current_timestamp) | |
CHECKIN_COUNTER | NUMBER(38) | Y | (0)
| |
Foreign Keys:
Options:
Option | Settings |
---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Indexes:
Index Name | Type | Unuqueness | Columns | DDL script |
---|
RHN_SERVER_INFO_SID_UNQ | NORMAL | UNIQUE | SERVER_ID
| DDL script |
Triggers
RHN_SERVER_INFO_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
rhn_server_info_mod_trig
before insert or update on rhnServerInfo
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
if :new.checkin is NULL
then
:new.checkin := current_timestamp;
end if;
end;