| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| ADV_KEY | VARCHAR2(200.0) | N | ||
| LOCAL_IMAGE_P | CHAR(1.0) | Y | 't' | |
| TRACK_CLICKTHRU_P | CHAR(1.0) | Y | 't' | |
| ADV_FILENAME | VARCHAR2(200.0) | Y | ||
| TARGET_URL | VARCHAR2(4000.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087681 | ADV_KEY |
| Constraint Name | Check Condition |
|---|---|
| ADVS_LOCAL_IMG_P | local_image_p in ('t','f') |
| ADVS_TRK_CLK_P | track_clickthru_p in ('t','f') |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087681 | NORMAL | UNIQUE | ADV_KEY |
| Table | Constraint |
|---|---|
| ADV_LOG | SYS_C002087685 |
| ADV_USER_MAP | SYS_C002087690 |
| ADV_CATEGORIES | SYS_C002087694 |
| ADV_GROUP_MAP | SYS_C002087704 |