New Rule_Group_Link Table (in FI_Data_2)
- Last UpdatedDec 18, 2018
- 1 minute read
Allows a many-to-many relation between rule groups and control rules.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
rule_group_id |
int32 |
Y |
N |
Identify rule group |
|
rule_id |
int32 |
Y |
N |
Identify rule |
|
last_edit_comment |
string254 |
N |
Y |
Why this record was changed |
|
last_edit_by |
string40 |
N |
N |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 0 |
N |
N |
Unique row identifier |
FK from rule_group_id to rule_group. (Cascade delete)
FK from rule_id to spc_rule. (Cascade delete)
Modify the default data script to populate rule_group with the predefined sets of control rules. The default data will be:
0, 0, NULL, ‘INSTALL’, GETUTCDATE(), 0
0, 1, NULL, ‘INSTALL’, GETUTCDATE(), 1
0, 4, NULL, ‘INSTALL’, GETUTCDATE(), 2
0, 6, NULL, ‘INSTALL’, GETUTCDATE(), 3
1, 0, NULL, ‘INSTALL’, GETUTCDATE(),4
1, 12, NULL, ‘INSTALL’, GETUTCDATE(),5
1, 6, NULL, ‘INSTALL’, GETUTCDATE(),6
2, 0, NULL, ‘INSTALL’, GETUTCDATE(),7
2, 1, NULL, ‘INSTALL’, GETUTCDATE(),8
2, 4, NULL, ‘INSTALL’, GETUTCDATE(),9
2, 7, NULL, ‘INSTALL’, GETUTCDATE(),10
2, 11, NULL, ‘INSTALL’, GETUTCDATE(),11
2, 8, NULL, ‘INSTALL’, GETUTCDATE(),12
3, 0, NULL, ‘INSTALL’, GETUTCDATE(),13
3, 1, NULL, ‘INSTALL’, GETUTCDATE(),14
3, 2, NULL, ‘INSTALL’, GETUTCDATE(),15
3, 3, NULL, ‘INSTALL’, GETUTCDATE(),16
3, 12, NULL, ‘INSTALL’, GETUTCDATE(),17
3, 5, NULL, ‘INSTALL’, GETUTCDATE(),18
3, 9, NULL, ‘INSTALL’, GETUTCDATE(),19
3, 10, NULL, ‘INSTALL’, GETUTCDATE(),20
4, 0, NULL, ‘INSTALL’, GETUTCDATE(),21
4, 1, NULL, ‘INSTALL’, GETUTCDATE(),22
4, 4, NULL, ‘INSTALL’, GETUTCDATE(),23
4, 12, NULL, ‘INSTALL’, GETUTCDATE(),24
4, 6, NULL, ‘INSTALL’, GETUTCDATE(),25
5, 0, NULL, ‘INSTALL’, GETUTCDATE(),26
5, 1, NULL, ‘INSTALL’, GETUTCDATE(),27
5, 4, NULL, ‘INSTALL’, GETUTCDATE(),28
5, 12, NULL, ‘INSTALL’, GETUTCDATE(),29
5, 5, NULL, ‘INSTALL’, GETUTCDATE(),30