|
Check-in Number:
|
3425 | |
| Date: |
2003-Jun-05 14:43:21 (local)
2003-Jun-05 12:43:21 (UTC) |
| User: | rse |
| Branch: | |
| Comment: |
remember that we use half-open [..[ intervals in data, but closed [...] intervals in query |
| Tickets: |
|
| Inspections: |
|
| Files: |
|
ossp-pkg/as/as-db/bres/bres-history.sql 1.3 -> 1.4
--- bres-history.sql 2003/06/05 12:38:37 1.3
+++ bres-history.sql 2003/06/05 12:43:21 1.4
@@ -25,17 +25,17 @@
DROP TABLE ut CASCADE;
CREATE TABLE ut (
- ut_oid INTEGER, --
- ut_beg INTEGER, --
- ut_end INTEGER, --
- ut_hid INTEGER --
+ ut_oid INTEGER, -- oid
+ ut_beg INTEGER, -- user time begin (inclusive)
+ ut_end INTEGER, -- user time end (exclusive)
+ ut_hid INTEGER -- user time history id (system time when this entry was made)
);
DROP TABLE ut_no CASCADE;
CREATE TABLE ut_no (
ut_oid INTEGER, -- oid
- ut_beg INTEGER, -- user time begin
- ut_end INTEGER, -- user time end
+ ut_beg INTEGER, -- user time begin (inclusive)
+ ut_end INTEGER, -- user time end (exclusive)
ut_hid INTEGER, -- user time history id (system time when this entry was made)
ut_hid_max INTEGER -- user time history id (system time until which this entry is valid)
);
|
|
