Constraint Name | Columns |
---|---|
RHN_SERVER_CRASH_FILE_ID_PK | ID |
Constraint Name | Check Condition |
---|---|
RHN_SERVER_CRASH_FILE_UPL_CK | is_uploaded in ('Y', 'N') |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_SERVER_CRASH_FILE_CIS_FK | CRASH_ID | RHNSERVERCRASH | RHN_SERVER_CRASH_ID_PK | CASCADE |
Option | Settings |
---|---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Index Name | Type | Unuqueness | Columns | DDL script |
---|---|---|---|---|
RHN_SCRF_CID_FN | NORMAL | UNIQUE | CRASH_ID , FILENAME | DDL script |
RHN_SERVER_CRASH_FILE_ID_PK | NORMAL | UNIQUE | ID | DDL script |
Legend: comment string keyword reserved word operator
CREATE TRIGGER rhn_server_crash_file_mod_trig before insert or update on rhnServerCrashFile for each row REFERENCING NEW AS NEW OLD AS OLD begin :new.modified := current_timestamp; end;