Unanet Data Model

MEMBER

Column Name Data Type Nulls References
Table
Foreign Key
Name
person_key decimal (15,0)   PERSON fk_member1
role_key decimal (15,0)   ROLE fk_member2

References made to MEMBER

Table Name Field Name Foreign Key
Name
ALTERNATE person_key fk_alternate2
ALTERNATE role_key fk_alternate2

Dependent Views

View Name
TIMESHEET_STATUS_VIEW

Indexes on MEMBER

Index Name Column(s)
pk_member person_key, role_key


No Check Constraints on MEMBER


Copyright 1998, 1999 Computer Strategies, Inc., All Rights Reserved.
Last revised: May 25, 2000 11:28:08 AM EDT