| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| TASK_ID | NUMBER(38) | N | ||
| TASK_NAME | VARCHAR2(200.0) | N | ||
| BODY | CLOB | N | ||
| NEXT_STEPS | VARCHAR2(1000.0) | Y | ||
| POST_DATE | DATE | Y | ||
| POSTER_ID | NUMBER(38) | Y | ||
| TIME_ID | NUMBER(38) | Y | ||
| ACTIVE_P | CHAR(1.0) | Y | ||
| EXPIRATION_DATE | DATE | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002088527 | TASK_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002088524 | "TASK_NAME" IS NOT NULL |
| SYS_C002088525 | "BODY" IS NOT NULL |
| SYS_C002088526 | active_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002088528 | POSTER_ID | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002088529 | TIME_ID | CATEGORIES | SYS_C002087169 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002088527 | NORMAL | UNIQUE | TASK_ID |
| SYS_IL0001977179C00003$$ | LOB | UNIQUE |