| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| MAP_ID | NUMBER(38) | N | ||
| CATEGORY_ID | NUMBER(38) | N | ||
| ON_WHICH_TABLE | VARCHAR2(30.0) | N | ||
| ON_WHAT_ID | VARCHAR2(500.0) | N | ||
| MAPPING_DATE | DATE | N | ||
| MAPPING_WEIGHT | NUMBER(38) | Y | 5 | |
| ONE_LINE_ITEM_DESC | VARCHAR2(200.0) | N | ||
| MAPPING_COMMENT | VARCHAR2(200.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087179 | MAP_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087173 | "CATEGORY_ID" IS NOT NULL |
| SYS_C002087174 | "ON_WHICH_TABLE" IS NOT NULL |
| SYS_C002087175 | "ON_WHAT_ID" IS NOT NULL |
| SYS_C002087176 | "MAPPING_DATE" IS NOT NULL |
| SYS_C002087177 | "ONE_LINE_ITEM_DESC" IS NOT NULL |
| SYS_C002087178 | mapping_weight between -10 and 10 |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087181 | CATEGORY_ID | CATEGORIES | SYS_C002087169 | NO ACTION |
| Constraint name | Columns |
|---|---|
| SYS_C002087180 | CATEGORY_ID , ON_WHICH_TABLE , ON_WHAT_ID |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SWCM_WHICH_TABLE_WHAT_ID_IDX | NORMAL | NONUNIQUE | ON_WHICH_TABLE , ON_WHAT_ID |
| SYS_C002087179 | NORMAL | UNIQUE | MAP_ID |
| SYS_C002087180 | NORMAL | UNIQUE | CATEGORY_ID , ON_WHICH_TABLE , ON_WHAT_ID |