| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| SERVER_PROFILE_ID | NUMBER(38) | N | ||
| NAME_ID | NUMBER(38) | N | ||
| EVR_ID | NUMBER(38) | N | ||
| PACKAGE_ARCH_ID | NUMBER(38) | Y |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| RHN_SPROFILE_EVRID_FK | EVR_ID | RHNPACKAGEEVR | RHN_PE_ID_PK | NO ACTION |
| RHN_SPROFILE_NID_FK | NAME_ID | RHNPACKAGENAME | RHN_PN_ID_PK | NO ACTION |
| RHN_SPROFILE_PACKAGE_FK | PACKAGE_ARCH_ID | RHNPACKAGEARCH | RHN_PARCH_ID_PK | NO ACTION |
| RHN_SPROFILE_SPID_FK | SERVER_PROFILE_ID | RHNSERVERPROFILE | RHN_SERVER_PROFILE_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_SPROF_SP_SNE_IDX | NORMAL | NONUNIQUE | SERVER_PROFILE_ID , NAME_ID , EVR_ID | DDL script |