 Access (ACC) |
Which Emps access which areas #
|
|
Keys
|
| Name |
Attributes |
Fields |
| ACC:GuidKey |
Case |
+ACC:Guid |
| ACC:Key |
Primary |
+ACC:Site ,+ACC:EmpNumber ,+ACC:Area |
| ACC:AreaKey |
Dup |
+ACC:Site ,+ACC:Area ,+ACC:EmpNumber |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| ACC:Guid |
STRING |
@s16 |
Internal System Identifier |
| ACC:Site |
STRING |
@s4 |
|
| ACC:EmpNumber |
STRING |
@s10 |
|
| ACC:Area |
SHORT |
@n-7 |
|
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| System |
MANY:1 |
ACC:Key |
SYS:SiteKey |
| Employee |
MANY:1 |
ACC:Key |
EMP:Key |
| Areas |
MANY:1 |
ACC:AreaKey |
ARE:key |
|
