RHNCPU
DDL scriptColumns
Name | Type | Nullable | Default value | Comment |
---|
ID | NUMBER(38) | N | | |
SERVER_ID | NUMBER(38) | N | | |
CPU_ARCH_ID | NUMBER(38) | N | | |
BOGOMIPS | VARCHAR2(16) | Y | | |
CACHE | VARCHAR2(16) | Y | | |
FAMILY | VARCHAR2(32) | Y | | |
MHZ | VARCHAR2(16) | Y | | |
STEPPING | VARCHAR2(16) | Y | | |
FLAGS | VARCHAR2(2048) | Y | | |
MODEL | VARCHAR2(64) | Y | | |
VERSION | VARCHAR2(32) | Y | | |
VENDOR | VARCHAR2(32) | Y | | |
NRCPU | NUMBER(38) | Y | (1) | |
NRSOCKET | NUMBER(38) | Y | | |
ACPIVERSION | VARCHAR2(64) | Y | | |
APIC | VARCHAR2(32) | Y | | |
APMVERSION | VARCHAR2(32) | Y | | |
CHIPSET | VARCHAR2(64) | Y | | |
CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
Primary key:
Constraint Name | Columns |
---|
RHN_CPU_ID_PK | ID
|
Foreign Keys:
Options:
Option | Settings |
---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Indexes:
Triggers
RHN_CPU_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
rhn_cpu_mod_trig
before insert or update on rhnCpu
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
:new.modified := current_timestamp;
end;