| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| NEIGHBOR_TO_NEIGHBOR_ID | NUMBER(38) | N | ||
| POSTER_USER_ID | NUMBER(38) | N | ||
| POSTED | DATE | N | ||
| CREATION_IP_ADDRESS | VARCHAR2(50.0) | N | ||
| EXPIRES | DATE | Y | ||
| CATEGORY_ID | NUMBER(38) | N | ||
| SUBCATEGORY_ID | NUMBER(38) | N | ||
| REGION | VARCHAR2(100.0) | Y | ||
| ABOUT | VARCHAR2(200.0) | Y | ||
| TITLE | VARCHAR2(200.0) | N | ||
| BODY | CLOB | N | ||
| HTML_P | CHAR(1.0) | Y | 'f' | |
| APPROVED_P | CHAR(1.0) | Y | 'f' |
| Constraint Name | Columns |
|---|---|
| SYS_C002087760 | NEIGHBOR_TO_NEIGHBOR_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087751 | "POSTER_USER_ID" IS NOT NULL |
| SYS_C002087752 | "POSTED" IS NOT NULL |
| SYS_C002087753 | "CREATION_IP_ADDRESS" IS NOT NULL |
| SYS_C002087754 | "CATEGORY_ID" IS NOT NULL |
| SYS_C002087755 | "SUBCATEGORY_ID" IS NOT NULL |
| SYS_C002087756 | "TITLE" IS NOT NULL |
| SYS_C002087757 | "BODY" IS NOT NULL |
| SYS_C002087758 | html_p in ('t','f') |
| SYS_C002087759 | approved_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087761 | POSTER_USER_ID | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002087762 | CATEGORY_ID | N_TO_N_PRIMARY_CATEGORIES | SYS_C002087744 | NO ACTION |
| SYS_C002087763 | SUBCATEGORY_ID | N_TO_N_SUBCATEGORIES | SYS_C002087749 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| NEIGHBOR_BY_USER | NORMAL | NONUNIQUE | POSTER_USER_ID |
| NEIGHBOR_MAIN_INDEX | NORMAL | NONUNIQUE | CATEGORY_ID , SUBCATEGORY_ID |
| NEIGHBOR_SUBCAT_INDEX | NORMAL | NONUNIQUE | SUBCATEGORY_ID |
| SYS_C002087760 | NORMAL | UNIQUE | NEIGHBOR_TO_NEIGHBOR_ID |
| SYS_IL0001976663C00011$$ | LOB | UNIQUE |
| Name: N_TO_N_GC_DELETE |
|---|
CREATE TRIGGER n_to_n_gc_delete
after DELETE
ON neighbor_to_neighbor
FOR each row
REFERENCING NEW AS NEW OLD AS OLD
BEGIN
DELETE FROM general_comments
WHERE on_which_table = 'neighbor_to_neighbor'
AND on_what_id = :old.neighbor_to_neighbor_id;
END;
|