RHN_PHYSICAL_LOCATION
Description:
phslc physical location records
DDL scriptColumns
| Name | Type | Nullable | Default value | Comment |
|---|
| RECID | NUMBER(12) | N | | |
| LOCATION_NAME | VARCHAR2(40) | Y | | |
| ADDRESS1 | VARCHAR2(255) | Y | | |
| ADDRESS2 | VARCHAR2(255) | Y | | |
| CITY | VARCHAR2(128) | Y | | |
| STATE | VARCHAR2(128) | Y | | |
| COUNTRY | VARCHAR2(2) | Y | | |
| ZIPCODE | VARCHAR2(10) | Y | | |
| PHONE | VARCHAR2(40) | Y | | |
| DELETED | CHAR(1) | Y | | |
| LAST_UPDATE_USER | VARCHAR2(40) | Y | | |
| LAST_UPDATE_DATE | DATE | Y | | |
| CUSTOMER_ID | NUMBER(12) | N | 999
| |
Primary key:
| Constraint Name | Columns |
|---|
| RHN_PHSLC_RECID_PK | RECID
|
Options:
| Option | Settings |
|---|
| Tablespace | DATA_TBS |
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
Indexes:
| Index Name | Type | Unuqueness | Columns | DDL script |
|---|
| RHN_PHSLC_RECID_PK | NORMAL | UNIQUE | RECID
| DDL script |
Referenced by: