 CatNames (CNA) |
Contains names for Normal Time etc $
|
|
Keys
|
| Name |
Attributes |
Fields |
| CNA:GuidKey |
Case |
+CNA:Guid |
| CNA:CodeKey |
Primary |
+CNA:CatNamesCode |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| CNA:Guid |
STRING |
@s16 |
Internal System Identifier |
| CNA:CatNamesCode |
SHORT |
@n3 |
|
| CNA:Description |
STRING |
@s20 |
|
| CNA:Color |
LONG |
@n-13 |
|
| CNA:Effect |
STRING |
@s1 |
(on total) +, neutral or - |
| CNA:HoursReport |
BYTE |
@n3 |
|
| CNA:OverTimeReport |
BYTE |
@n3 |
|
| CNA:TotalCat |
SHORT |
@n-7 |
|
| CNA:TotalCatEffect |
STRING |
@s1 |
(on total) +, neutral or - |
| CNA:RunningDaily |
BYTE |
@n3 |
|
| CNA:RunningWeekly |
BYTE |
@n3 |
|
| CNA:ResetRunningDaily |
BYTE |
@n3 |
|
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| WRounding |
1:MANY |
CNA:CodeKey |
WRO:CatKey |
| WBalancing |
1:MANY |
CNA:CodeKey |
WBa:CatKey |
| Balancing |
1:MANY |
CNA:CodeKey |
BAL:CatKey |
| Slot |
1:MANY |
CNA:CodeKey |
SLO:CatKey |
|
