Resource_groups
This table contains data related to resource groups.
This table’s data is only available to accounts with Project Management enabled.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
date_created |
TIMESTAMP |
|
|
|
|
|
Date Created |
date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date Last Modified |
description |
VARCHAR2 |
2000 |
|
|
|
|
Description |
is_inactive |
VARCHAR2 |
3 |
|
|
|
|
Inactive |
resource_group_extid |
VARCHAR2 |
255 |
|
|
|
|
Resource Group ID |
resource_group_id |
NUMBER |
|
39 |
0 |
entity_id
|
Entity
|
Internal Resource Group ID |
resource_group_name |
VARCHAR2 |
83 |
|
|
|
|
Resource Group Name |
Primary key
PK Column Name |
resource_group_id |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
resource_groups_entity_fk |
resource_group_id |
Entity |
entity_id |
1 |
Foreign keys referencing this table
FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
Resource_group_entity_map_resource_groups_fk |
resource_group_id |
Resource_group_entity_map |
group_id |
1 |