| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| GROUP_ID | NUMBER(38) | N | ||
| PARENT_ID | NUMBER(38) | Y | ||
| CUSTOMER_ID | NUMBER(38) | Y | ||
| PROJECT_TYPE_ID | NUMBER(38) | N | ||
| PROJECT_STATUS_ID | NUMBER(38) | N | ||
| DESCRIPTION | VARCHAR2(4000.0) | Y | ||
| FEE_SETUP | NUMBER(12.0,2.0) | Y | ||
| FEE_HOSTING_MONTHLY | NUMBER(12.0,2.0) | Y | ||
| FEE_MONTHLY | NUMBER(12.0,2.0) | Y | ||
| BILL_HOURLY_P | CHAR(1.0) | Y | ||
| START_DATE | DATE | Y | ||
| END_DATE | DATE | Y | ||
| NOTE | VARCHAR2(4000.0) | Y | ||
| PROJECT_LEAD_ID | NUMBER(38) | Y | ||
| SUPERVISOR_ID | NUMBER(38) | Y | ||
| TICKET_PROJECT_ID | NUMBER(38) | Y | ||
| REQUIRES_REPORT_P | CHAR(1.0) | Y | ('t') |
| Constraint Name | Columns |
|---|---|
| SYS_C002088363 | GROUP_ID |
| Constraint Name | Check Condition |
|---|---|
| IM_PROJECTS_DATE_CONST | end_date - start_date >= 0 |
| IM_PROJECT_REQUIRES_REPORT_P | requires_report_p in ('t','f') |
| SYS_C002088358 | "PROJECT_TYPE_ID" IS NOT NULL |
| SYS_C002088359 | "PROJECT_STATUS_ID" IS NOT NULL |
| SYS_C002088360 | bill_hourly_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002088364 | GROUP_ID | USER_GROUPS | SYS_C002087305 | NO ACTION |
| SYS_C002088365 | PARENT_ID | IM_PROJECTS | SYS_C002088363 | NO ACTION |
| SYS_C002088366 | CUSTOMER_ID | IM_CUSTOMERS | SYS_C002088344 | NO ACTION |
| SYS_C002088367 | PROJECT_TYPE_ID | CATEGORIES | SYS_C002087169 | NO ACTION |
| SYS_C002088368 | PROJECT_STATUS_ID | CATEGORIES | SYS_C002087169 | NO ACTION |
| SYS_C002088369 | PROJECT_LEAD_ID | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002088370 | SUPERVISOR_ID | USERS | SYS_C002087135 | NO ACTION |
| SYS_C002088371 | TICKET_PROJECT_ID | TICKET_PROJECTS | SYS_C002087945 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| IM_PROJECT_PARENT_ID_IDX | NORMAL | NONUNIQUE | PARENT_ID |
| SYS_C002088363 | NORMAL | UNIQUE | GROUP_ID |
| Table | Constraint |
|---|---|
| IM_PROJECTS | SYS_C002088365 |
| IM_PROJECT_URL_MAP | SYS_C002088375 |
| IM_PROJECT_PAYMENTS | SYS_C002088440 |
| IM_PROJECT_PAYMENTS_AUDIT | SYS_C002088448 |
| IM_ALLOCATIONS | SYS_C002088458 |
| IM_ALLOCATIONS_AUDIT | SYS_C002088468 |