| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| CLASSIFIED_AD_ID | NUMBER(38) | Y | ||
| USER_ID | NUMBER(38) | Y | ||
| DOMAIN_ID | NUMBER(38) | Y | ||
| ORIGINATING_IP | VARCHAR2(16.0) | Y | ||
| POSTED | DATE | Y | ||
| EXPIRES | DATE | Y | ||
| WANTED_P | CHAR(1.0) | Y | ||
| PRIVATE_P | CHAR(1.0) | Y | ||
| REPLY_TO_POSTER_P | CHAR(1.0) | Y | ||
| PRIMARY_CATEGORY | VARCHAR2(100.0) | Y | ||
| SUBCATEGORY_1 | VARCHAR2(100.0) | Y | ||
| SUBCATEGORY_2 | VARCHAR2(100.0) | Y | ||
| MANUFACTURER | VARCHAR2(50.0) | Y | ||
| MODEL | VARCHAR2(50.0) | Y | ||
| DATE_PRODUCED | DATE | Y | ||
| ITEM_SIZE | VARCHAR2(100.0) | Y | ||
| COLOR | VARCHAR2(50.0) | Y | ||
| LOCATION | VARCHAR2(200.0) | Y | ||
| US_CITIZEN_P | CHAR(1.0) | Y | ||
| ONE_LINE | VARCHAR2(150.0) | Y | ||
| FULL_AD | VARCHAR2(3600.0) | Y | ||
| HTML_P | CHAR(1.0) | Y | ||
| GRAPHIC_URL | VARCHAR2(200.0) | Y | ||
| PRICE | NUMBER(9.0,2.0) | Y | ||
| CURRENCY | VARCHAR2(50.0) | Y | ||
| AUCTION_P | CHAR(1.0) | Y | ||
| COUNTRY | VARCHAR2(2.0) | Y | ||
| STATE | VARCHAR2(30.0) | Y | ||
| EMPLOYER | VARCHAR2(100.0) | Y | ||
| SALARY_RANGE | VARCHAR2(200.0) | Y | ||
| LAST_MODIFIED | DATE | Y | ||
| AUDIT_IP | VARCHAR2(16.0) | Y | ||
| DELETED_BY_ADMIN_P | CHAR(1.0) | Y | 'f' |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087592 | deleted_by_admin_p in ('t','f') |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| CLASSIFIED_ADS_AUDIT_IDX | NORMAL | NONUNIQUE | CLASSIFIED_AD_ID |
| CLASSIFIED_ADS_AUDIT_USER_IDX | NORMAL | NONUNIQUE | USER_ID |