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)
);
|
|
