| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| VACATION_ID | NUMBER(38) | N | ||
| USER_ID | NUMBER(38) | Y | ||
| START_DATE | DATE | N | ||
| END_DATE | DATE | N | ||
| DESCRIPTION | VARCHAR2(4000.0) | Y | ||
| CONTACT_INFO | VARCHAR2(4000.0) | Y | ||
| RECEIVE_EMAIL_P | CHAR(1.0) | Y | 't' | |
| LAST_MODIFIED | DATE | Y | ||
| VACATION_TYPE | VARCHAR2(20.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087145 | VACATION_ID |
| Constraint Name | Check Condition |
|---|---|
| USER_VACATIONS_EMAIL_CONST | receive_email_p in ('t','f') |
| USER_VACATIONS_END_CONST | "END_DATE" IS NOT NULL |
| USER_VACATIONS_START_CONST | "START_DATE" IS NOT NULL |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087146 | USER_ID | USERS | SYS_C002087135 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087145 | NORMAL | UNIQUE | VACATION_ID |
| USER_VACATIONS_DATES_IDX | NORMAL | NONUNIQUE | START_DATE , END_DATE |
| USER_VACATIONS_TYPE_IDX | NORMAL | NONUNIQUE | VACATION_TYPE |
| USER_VACATIONS_USER_ID_IDX | NORMAL | NONUNIQUE | USER_ID |