RHNDEVICE
DDL scriptColumns
| Name | Type | Nullable | Default value | Comment |
|---|
| ID | NUMBER(38) | N | | |
| SERVER_ID | NUMBER(38) | N | | |
| CLASS | VARCHAR2(16) | Y | | |
| BUS | VARCHAR2(16) | Y | | |
| DETACHED | NUMBER(38) | Y | | |
| DEVICE | VARCHAR2(256) | Y | | |
| DRIVER | VARCHAR2(256) | Y | | |
| DESCRIPTION | VARCHAR2(256) | Y | | |
| PCITYPE | NUMBER(38) | Y | (-1) | |
| PROP1 | VARCHAR2(256) | Y | | |
| PROP2 | VARCHAR2(256) | Y | | |
| PROP3 | VARCHAR2(256) | Y | | |
| PROP4 | VARCHAR2(256) | 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_DEVICE_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_DEVICE_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
rhn_device_mod_trig
before insert or update on rhnDevice
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
:new.modified := current_timestamp;
end;