item_reas_grp_ent_link
- Last UpdatedNov 20, 2024
- 1 minute read
The item_reas_grp_ent_link table allows many-to-many relationship between groups of reasons and entities. This specifies which reason groups and thus reasons can be assigned to which entities for cases where reasons are machine dependent rather than product dependent.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|
reas_grp_id |
int32 |
Y |
N |
Identify reason group |
|
ent_id |
int32 |
Y |
N |
Which entity applicable to |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 1 |
N |
N |
Unique row identifier, for audit trail |
FK from reas_grp_id to item_reas_grp. (Cascade delete)
FK from ent_id to ent. (Cascade delete)