Unanet Data Model

TIME_PERIOD

Column Name Data Type Nulls References
Table
Foreign Key
Name
time_period_key decimal (15,0)   TIME_PERIOD_SETUP fk_time_period1
begin_date datetime      
end_date datetime      
period_number int      

References made to TIME_PERIOD

Table Name Field Name Foreign Key
Name
PERSON_TIME time_period_key fk_person_time4
PERSON_TIME begin_date fk_person_time4

Indexes on TIME_PERIOD

Index Name Column(s)
pk_time_period time_period_key, begin_date


No Views Reference TIME_PERIOD

No Check Constraints on TIME_PERIOD


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