Clock_Time
Description:
Name Null? Type
------------------------------- -------- ----
CLOCK_TIME_ID NOT NULL NUMBER
ONE_DAY DATE
START_DATE DATE
END_DATE DATE
- Primary Key:
- Clock_Time_ID
- Foreign Key:
- Clock_Time_ID references
TIME_EXPRESSION(Time_Expression_ID)
This table stores specific times or ranges of times during which a
collecting_event occurred.
If a collecting event occurred on a single day, that date is entered in the
One_Day field (with the year indicated as a four-digit number, avoiding
the problem of figuring out to which century the number 95 refers).
If the collecting event spanned a number of days, then
Start_Date and End_Date are used. Oracle is capable of performing some pretty
amazing date arithmetic that allows you to ask a wide range of questions
with a minimum of fussing about, e.g., how many days are in a month.
The Clock_Time_ID is the same number as the Time_Expression_ID in
Time_Expression.
Last updated: 20 November, 1997 by nfj.