Perforated_Interval_Id is a foreign key to the interval to which this status belongs. Notice that the End_Date for the status is null and therefore these statuses are the current statuses.
|
ID |
STATUS |
START_DATE |
END_DATE |
PERFORATED_INTERVAL_ID |
|
160155 |
Open |
8/27/2004 0:00 |
|
160154 |
|
160153 |
Open |
8/27/2004 0:00 |
|
160152 |