 Visitors (VIS) |
Visitors Information file #
|
|
Keys
|
| Name |
Attributes |
Fields |
| VIS:GuidKey |
Case |
+VIS:Guid |
| VIS:NameKey |
Dup |
+VIS:Surname ,+VIS:FirstName |
| VIS:Key |
Primary |
+VIS:Site ,+VIS:VisNumber |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| VIS:Guid |
STRING |
@s16 |
Internal System Identifier |
| VIS:Site |
STRING |
@s4 |
|
| VIS:VisNumber |
LONG |
@n-14 |
|
| VIS:Surname |
STRING |
@s20 |
|
| VIS:FirstName |
STRING |
@s20 |
|
| VIS:Company |
STRING |
@s30 |
|
| VIS:Telephone |
STRING |
@s20 |
|
| VIS:Contact |
STRING |
@s30 |
|
| VIS:Operator |
STRING |
@s12 |
|
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| System |
MANY:1 |
VIS:Key |
SYS:SiteKey |
| Visits |
1:MANY |
VIS:Key |
VIT:key |
|
