| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| CLASSIFIED_AD_ID | NUMBER(38) | N | ||
| USER_ID | NUMBER(38) | N | ||
| DOMAIN_ID | NUMBER(38) | N | ||
| ORIGINATING_IP | VARCHAR2(16.0) | Y | ||
| POSTED | DATE | N | ||
| EXPIRES | DATE | Y | ||
| WANTED_P | CHAR(1.0) | Y | 'f' | |
| PRIVATE_P | CHAR(1.0) | Y | 't' | |
| REPLY_TO_POSTER_P | CHAR(1.0) | Y | 't' | |
| 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 | 'f' | |
| ONE_LINE | VARCHAR2(150.0) | Y | ||
| FULL_AD | VARCHAR2(3600.0) | Y | ||
| HTML_P | CHAR(1.0) | Y | 'f' | |
| GRAPHIC_URL | VARCHAR2(200.0) | Y | ||
| PRICE | NUMBER(9.0,2.0) | Y | ||
| CURRENCY | VARCHAR2(50.0) | Y | 'US dollars' | |
| AUCTION_P | CHAR(1.0) | Y | 't' | |
| 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 |
| Constraint Name | Columns |
|---|---|
| SYS_C002087584 | CLASSIFIED_AD_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087575 | "USER_ID" IS NOT NULL |
| SYS_C002087576 | "DOMAIN_ID" IS NOT NULL |
| SYS_C002087577 | "POSTED" IS NOT NULL |
| SYS_C002087578 | wanted_p in ('t','f') |
| SYS_C002087579 | private_p in ('t','f') |
| SYS_C002087580 | reply_to_poster_p in ('t','f') |
| SYS_C002087581 | us_citizen_p in ('t','f') |
| SYS_C002087582 | html_p in ('t','f') |
| SYS_C002087583 | auction_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087585 | USER_ID | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002087586 | DOMAIN_ID | AD_DOMAINS | SYS_C002087568 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| CLASSIFIED_ADS_BY_EMAIL | NORMAL | NONUNIQUE | USER_ID |
| CLASSIFIED_ADS_BY_PRIMARY_CAT | NORMAL | NONUNIQUE | PRIMARY_CATEGORY |
| CLASSIFIED_ADS_BY_SUBCAT_1 | NORMAL | NONUNIQUE | SUBCATEGORY_1 |
| SYS_C002087584 | NORMAL | UNIQUE | CLASSIFIED_AD_ID |
| Table | Constraint |
|---|---|
| CLASSIFIED_AUCTION_BIDS | SYS_C002087590 |
| Name: CLASSIFIED_ADS_GC_DELETE |
|---|
CREATE TRIGGER classified_ads_gc_delete
after DELETE
ON classified_ads
FOR each row
REFERENCING NEW AS NEW OLD AS OLD
BEGIN
DELETE FROM general_comments
WHERE on_which_table = 'classified_ads'
AND on_what_id = :old.classified_ad_id;
END;
|
| Name: CLASSIFIED_UPDATE_LAST_MOD |
|---|
CREATE TRIGGER classified_update_last_mod before insert or update on classified_ads for each row REFERENCING NEW AS NEW OLD AS OLD begin :new.last_modified :=SYSDATE; IF inserting and :new.posted is null THEN :new.posted := SYSDATE; END IF; end classified_update_last_mod; |