Project

General

Profile

Revision 1420

Added by Jing Tao over 18 years ago

modify access table.

View differences:

src/xmltables.sql
221 221
	begin_time	DATE,		-- the time that permission begins
222 222
	end_time	DATE,		-- the time that permission ends
223 223
	ticket_count	NUMBER(5),	-- ticket counter for that permission
224
  subtreeid VARCHAR2(32), -- sub tree id
225
  startnodeid NUMBER(20), -- start node for sub tree
226
  endnodeid NUMBER(20),    -- end node for sub tree
224 227
   CONSTRAINT xml_access_ck CHECK (begin_time < end_time),
225 228
   CONSTRAINT xml_access_accessfileid_fk 
226 229
		FOREIGN KEY (accessfileid) REFERENCES xml_documents

Also available in: Unified diff