Revision 1420
Added by Jing Tao over 21 years ago
| 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
modify access table.