| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| USER_ID | NUMBER(38) | N | ||
| KILLED_SECTIONS | VARCHAR2(4000.0) | Y | ||
| KILLED_OFFICES | VARCHAR2(4000.0) | Y | ||
| MY_PROJECTS_ONLY_P | CHAR(1.0) | Y | ('f') | |
| MY_CUSTOMERS_ONLY_P | CHAR(1.0) | Y | ('f') |
| Constraint Name | Check Condition |
|---|---|
| ISRP_MY_CUSTOMERS_ONLY_P_CK | my_customers_only_p in ('t','f') |
| ISRP_MY_PROJECTS_ONLY_P_CK | my_projects_only_p in ('t','f') |
| SYS_C002088530 | "USER_ID" IS NOT NULL |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| ISRP_USER_ID_FK | USER_ID | IM_EMPLOYEE_INFO | SYS_C002088395 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |