| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| ADDRESS_BOOK_ID | NUMBER(38) | N | ||
| SCOPE | VARCHAR2(20.0) | N | ||
| USER_ID | NUMBER(38) | Y | ||
| GROUP_ID | NUMBER(38) | Y | ||
| ON_WHICH_TABLE | VARCHAR2(50.0) | Y | ||
| ON_WHAT_ID | NUMBER(38) | Y | ||
| FIRST_NAMES | VARCHAR2(30.0) | Y | ||
| LAST_NAME | VARCHAR2(30.0) | Y | ||
| VARCHAR2(100.0) | Y | |||
| EMAIL2 | VARCHAR2(100.0) | Y | ||
| LINE1 | VARCHAR2(100.0) | Y | ||
| LINE2 | VARCHAR2(100.0) | Y | ||
| CITY | VARCHAR2(100.0) | Y | ||
| USPS_ABBREV | CHAR(2.0) | Y | ||
| ZIP_CODE | VARCHAR2(10.0) | Y | ||
| PHONE_HOME | VARCHAR2(30.0) | Y | ||
| PHONE_WORK | VARCHAR2(30.0) | Y | ||
| PHONE_CELL | VARCHAR2(30.0) | Y | ||
| PHONE_OTHER | VARCHAR2(30.0) | Y | ||
| COUNTRY | VARCHAR2(30.0) | Y | ||
| BIRTHMONTH | CHAR(2.0) | Y | ||
| BIRTHDAY | CHAR(2.0) | Y | ||
| BIRTHYEAR | CHAR(4.0) | Y | ||
| DAYS_IN_ADVANCE_TO_REMIND | NUMBER(38) | Y | ||
| DATE_LAST_REMINDED | DATE | Y | ||
| DAYS_IN_ADVANCE_TO_REMIND_2 | NUMBER(38) | Y | ||
| DATE_LAST_REMINDED_2 | DATE | Y | ||
| NOTES | VARCHAR2(4000.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087767 | ADDRESS_BOOK_ID |
| Constraint Name | Check Condition |
|---|---|
| ADDRESS_BOOK_SCOPE_CHECK | (scope='group' and group_id is not null) or (scope='user' and user_id is not null) or (scope='table' and on_which_table is not null and on_what_id is not null) or (scope='public') |
| SYS_C002087766 | "SCOPE" IS NOT NULL |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087768 | USER_ID | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002087769 | GROUP_ID | USER_GROUPS | SYS_C002087305 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| ADDRESS_BOOK_GROUP_IDX | NORMAL | NONUNIQUE | GROUP_ID |
| ADDRESS_BOOK_IDX | NORMAL | NONUNIQUE | USER_ID |
| SYS_C002087767 | NORMAL | UNIQUE | ADDRESS_BOOK_ID |
| Table | Constraint |
|---|---|
| IM_CUSTOMERS | SYS_C002088348 |
| IM_PARTNERS | SYS_C002088477 |