RHNSERVERDMI
DDL scriptColumns
| Name | Type | Nullable | Default value | Comment |
|---|
| ID | NUMBER(38) | N | | |
| SERVER_ID | NUMBER(38) | N | | |
| VENDOR | VARCHAR2(256) | Y | | |
| SYSTEM | VARCHAR2(256) | Y | | |
| PRODUCT | VARCHAR2(256) | Y | | |
| BIOS_VENDOR | VARCHAR2(256) | Y | | |
| BIOS_VERSION | VARCHAR2(256) | Y | | |
| BIOS_RELEASE | VARCHAR2(256) | Y | | |
| ASSET | VARCHAR2(256) | Y | | |
| BOARD | VARCHAR2(256) | Y | | |
| CREATED | DATE | N | (sysdate)
| |
| MODIFIED | DATE | N | (sysdate)
| |
Primary key:
| Constraint Name | Columns |
|---|
| RHN_SERVER_DMI_PK | ID
|
Foreign Keys:
Options:
| Option | Settings |
|---|
| Tablespace | DATA_TBS |
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
Indexes:
Triggers
RHN_SERVER_DMI_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
rhn_server_dmi_mod_trig
before insert or update on rhnServerDMI
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
:new.modified := sysdate;
end;